protected void txtsearchqr_TextChanged(object sender, EventArgs e) { try { string URL = HttpContext.Current.Request.Url.AbsoluteUri; string centercode = ""; if (URL.Contains('-')) { string[] URLCCode = URL.Split('-'); centercode = URLCCode[1]; if (centercode != string.Empty) { string[] ap = txtsearchqr.Text.Split('|'); string applno = ap[0]; DateTime date = Convert.ToDateTime(ap[1]); string service = ap[2]; BusinessLayer.Display.EntranceManager accMgr = new BusinessLayer.Display.EntranceManager(); Entities.Display entObj = new Entities.Display(); //string centercode = "OD33"; string ServiceType = ""; DataTable dt = new DataTable(); dt = accMgr.GetQRDisplayTimeBLL(centercode); string DisplayCenterTime = dt.Rows[0]["CentreTimeSet_INT"].ToString(); //30 min DataTable dt1 = new DataTable(); dt1 = accMgr.GetQRSlotDetailsBLL(centercode, applno, date, service); if (dt1.Rows.Count > 0) { string slottime = dt1.Rows[0]["TokenSlotTime_VCR"].ToString(); string[] slottime1 = slottime.Split('-'); //8.30-9.30 int setmins = Convert.ToInt32(DisplayCenterTime); DateTime convtslottime = DateTime.ParseExact(slottime1[0].ToString(), "HH.mm", System.Globalization.CultureInfo.CurrentCulture); DateTime displayslottime = convtslottime.AddMinutes(-setmins); string Reqslottime = displayslottime.ToString("hh.mm tt"); string displaytime = Reqslottime; //8.00 AM DateTime convtnextslottime = DateTime.ParseExact(slottime1[1].ToString(), "HH.mm", System.Globalization.CultureInfo.CurrentCulture); DateTime displaynextslottime = convtnextslottime.AddMinutes(-setmins); //9.00 DateTime Time = DateTime.Now; if (Time >= displayslottime && Time <= displaynextslottime) { DataTable DLslotdata = accMgr.GetQRTokenDetailsBLL(centercode, applno, date, service); ServiceType = DLslotdata.Rows[0]["ApplicantBookedService_VCR"].ToString(); if (ServiceType != "") { DateTime time = DateTime.Now; string Intime = time.ToString("hh.mm tt").ToString(); string currentStatus = "Entrance"; int P = accMgr.QRUpdatesTokenDetailsBLL(applno, centercode, currentStatus); if (P != 0) { Lblapplname.Text = DLslotdata.Rows[0]["ApplicantName_VCR"].ToString(); lblapplno.Text = DLslotdata.Rows[0]["ApplicationNo_VCR"].ToString(); lbltokenno.Text = DLslotdata.Rows[0]["TokenNo_INT"].ToString(); lblsrvcname.Text = DLslotdata.Rows[0]["ApplicantBookedService_VCR"].ToString(); txtsearchqr.Text = ""; txtsearchqr.Focus(); } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Slot Time Not Available In This Time');", true); txtsearchqr.Text = ""; txtsearchqr.Focus(); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Slot Time Not Available In This Time');", true); txtsearchqr.Text = ""; txtsearchqr.Focus(); } } } //else //{ // ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Enter Correst URL Address !!!');", true); // txtsearchqr.Text = ""; // txtsearchqr.Focus(); //} } catch { } }
public void showslottime() { try { string URL = HttpContext.Current.Request.Url.AbsoluteUri; string centercode = ""; if (URL.Contains('-')) { string[] URLCCode = URL.Split('-'); centercode = URLCCode[1]; if (centercode != string.Empty) { BusinessLayer.Display.EntranceManager accMgr = new BusinessLayer.Display.EntranceManager(); Entities.Display entObj = new Entities.Display(); string ServiceType = ""; DataTable dt = new DataTable(); dt = accMgr.GetDisplayTimeBLL(centercode); string DisplayCenterTime = dt.Rows[0]["CentreTimeSet_INT"].ToString(); //30 min DataTable dt1 = new DataTable(); dt1 = accMgr.GetSlotDetailsBLL(centercode); if (dt1.Rows.Count > 0) { string slottime = dt1.Rows[0]["TokenSlotTime_VCR"].ToString(); string[] slottime1 = slottime.Split('-'); //8.30-9.30 int setmins = Convert.ToInt32(DisplayCenterTime); DateTime convtslottime = DateTime.ParseExact(slottime1[0].ToString(), "HH.mm", System.Globalization.CultureInfo.CurrentCulture); DateTime displayslottime = convtslottime.AddMinutes(-setmins); string Reqslottime = displayslottime.ToString("hh.mm tt"); string displaytime = Reqslottime; //8.00 AM DateTime convtnextslottime = DateTime.ParseExact(slottime1[1].ToString(), "HH.mm", System.Globalization.CultureInfo.CurrentCulture); DateTime displaynextslottime = convtnextslottime.AddMinutes(-setmins); //9.00 DateTime Time = DateTime.Now; DataTable SWslotdata = accMgr.GetSWSlotDetailsBLL(slottime, centercode); int NoOfService = SWslotdata.Rows.Count; for (int i = 0; NoOfService > i; i++) { ServiceType = SWslotdata.Rows[i]["ApplicantBookedService_VCR"].ToString(); DataTable DLslotdata = accMgr.GetTokenDetailsBLL(ServiceType, slottime, centercode); if (Time >= displayslottime && Time <= displaynextslottime) { if (ServiceType == "DL") { if (DLslotdata.Rows.Count > 0) { int k = DLslotdata.Rows.Count; string start = DLslotdata.Rows[0]["TokenNo_INT"].ToString(); string end = DLslotdata.Rows[k - 1]["TokenNo_INT"].ToString(); string series = start + "-" + end; dllbltoken.Text = series; } else { dllbltoken.Text = "NA"; } } if (ServiceType == "LL") { if (DLslotdata.Rows.Count > 0) { int k = DLslotdata.Rows.Count; string start = DLslotdata.Rows[0]["TokenNo_INT"].ToString(); string end = DLslotdata.Rows[k - 1]["TokenNo_INT"].ToString(); string series = start + "-" + end; lllbltoken.Text = series; } else { lllbltoken.Text = "NA"; } } } } if (Time >= displaynextslottime) { int P = accMgr.UpdateslotStatusBLL(slottime, ServiceType, centercode); } } else { dllbltoken.Text = "NA"; } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Enter Correst URL Address !!!');", true); } } catch { } }