I'm currently facing an issue with my code. It seems to be functioning correctly, but only for the first iteration. Let me explain further.
If I select a date and time that is already in the database, it correctly displays "date unavailable". Likewise, if I select a date that is not in the database, it shows "date available". So far, so good.
However, after these labels have been displayed once, if I select an unavailable date for the third time, the code doesn't execute again. It simply remains on the previously shown label. Is there a way to create a loop for this?
The front end code:
<form id="form1" runat="server">
<asp:ScriptManager ID="scriptmanager1" runat="server">
</asp:ScriptManager>
<script type="text/javascript" language="javascript">
Sys.Application.add_load(jJavaScript);
</script>
<div id="dvRecWed" style="display: none">
<asp:UpdatePanel ID="PnlUsrDetails" runat="server">
<ContentTemplate>
<asp:TextBox ID="txtReceptionDate" class="form-control" autocomplete="off" CssClass="datepicker" placeholder="mm/dd/yy" AutoPostBack="true" OnTextChanged="reset_ddl" runat="server"></asp:TextBox>
<asp:DropDownList AutoPostBack="true" ID="ddlReceptionTime" runat="server" OnSelectedIndexChanged="txtUsername_TextChanged">
<asp:ListItem Value="-1">--Select--</asp:ListItem>
<asp:ListItem Value="Forenoon">Forenoon</asp:ListItem>
<asp:ListItem Value="Afternoon">Afternoon</asp:ListItem>
<asp:ListItem Value="FullDay">Full Day</asp:ListItem>
</asp:DropDownList>
<div id="checkdate" class="checkdate" runat="server" visible="false">
<asp:Image ID="imgstatus" runat="server" Width="17px" Height="17px" />
<asp:Label ID="lblStatus" runat="server"></asp:Label>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
Back end code:
protected void txtUsername_TextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ddlReceptionTime.Text))
{
string connString = ConfigurationManager.ConnectionStrings["MandapamDatabase"].ConnectionString;
OleDbConnection connection = new OleDbConnection(connString);
// SqlCommand cmd = new SqlCommand("select * from UserInformation where UserName=@Name", con);
string selectQuery = "SELECT FunctionTime FROM function WHERE FunctionDate=@FunctionDate AND FunctionTime='FullDay'";
connection.Open();
OleDbCommand command = new OleDbCommand(selectQuery, connection);
command.Connection = connection;
command.CommandText = selectQuery;
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@FunctionDate", txtReceptionDate.Text);
command.Parameters.AddWithValue("@FunctionTime", ddlReceptionTime.Text);
OleDbDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
checkdate.Visible = true;
imgstatus.ImageUrl = "~/img/cross.png";
lblStatus.Text = "Date Unavailable";
lblStatus.ForeColor = System.Drawing.Color.Red;
}
else
{
checkdate.Visible = true;
imgstatus.ImageUrl = "~/img/check.png";
lblStatus.Text = "Date available";
}
}
else if (!string.IsNullOrEmpty(ddlReceptionTime.Text))
{
string connString = ConfigurationManager.ConnectionStrings["MandapamDatabase"].ConnectionString;
OleDbConnection connection = new OleDbConnection(connString);
// SqlCommand cmd = new SqlCommand("select * from UserInformation where UserName=@Name", con);
string selectQuery = "SELECT FunctionTime FROM function WHERE FunctionDate=@FunctionDate AND FunctionTime=@FunctionTime";
connection.Open();
OleDbCommand command = new OleDbCommand(selectQuery, connection);
command.Connection = connection;
command.CommandText = selectQuery;
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@FunctionDate", txtReceptionDate.Text);
command.Parameters.AddWithValue("@FunctionTime", ddlReceptionTime.Text);
OleDbDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
checkdate.Visible = true;
imgstatus.ImageUrl = "~/img/cross.png";
lblStatus.Text = "Date Unavailable";
lblStatus.ForeColor= System.Drawing.Color.Red;
}
else
{
checkdate.Visible = true;
imgstatus.ImageUrl = "~/img/check.png";
lblStatus.Text = "Date Available";
}
}
else
{
checkdate.Visible = false;
}
}
protected void reset_ddl(object sender, EventArgs e)
{
ddlReceptionTime.SelectedValue = "-1";
}