public Entities.RTOService UpdateLLExamTokenBLL(string datenow) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); entObj1 = accDAO1.TokenLLUpdateDAL(datenow); return(entObj1); }
public Entities.RTOService UpdateTokenBLL(string services, string counterid, string staffcode) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); entObj1 = accDAO1.TokenUpdateDAL(services, counterid, staffcode); return(entObj1); }
protected void btnEdit_Click(object sender, EventArgs e) { try { btnSubmit.Text = "Update"; BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); DataTable dt = new DataTable(); string centercode = Session["CenterCode"].ToString(); dt = accMgr.displayserviceBLL(centercode); foreach (ListItem item in ServiceCheckBoxList.Items) { string values = item.Text.ToString(); foreach (DataRow row in dt.Rows) { string id = row["ServiceName_VCR"].ToString(); if (values == id) { item.Selected = true; } } } } catch { } }
protected void btnnext_Click(object sender, EventArgs e) { try { string datenow = DateTime.Now.ToString("dd/MM/yyyy"); string timenow = DateTime.Now.ToString("HH:mm ss"); BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); DataTable dt = new DataTable(); dt = accMgr.getLLTokenNumberCompleted(datenow); if (dt.Rows.Count > 0) { entObj = accMgr.UpdateLLExamTokenBLL(datenow); insertLLToken(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Called Successfully');", true); txtfromno.Text = ""; txttono.Text = ""; } else { insertLLToken(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Called Successfully');", true); txtfromno.Text = ""; txttono.Text = ""; } } catch { } }
public static string getAllService() { Entities.RTOService servObj = new Entities.RTOService(); BusinessLayer.SuperAdmin.SuperAdminServiceManager servMgr = new BusinessLayer.SuperAdmin.SuperAdminServiceManager(); DataTable dt = new DataTable(); try { //dt = da.sgetdataTable("select * from Tbl_Service where Service_Status='1' order by Service_Name asc"); dt = servMgr.SuperAdminGetAllServicesBLL(); dt.Columns[0].ColumnName = "col0"; //sl dt.Columns[1].ColumnName = "col1"; //nam dt.Columns[2].ColumnName = "col2"; //shnam dt.Columns[3].ColumnName = "col3"; //cr dt dt.Columns[4].ColumnName = "col4"; //mod dt dt.Columns[5].ColumnName = "col5"; //act stats //dt = servObj..sgetdataTable("select * from Tbl_Service where Service_Status='1' order by Service_Name asc"); } catch (Exception e) { } string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(dt); return(JSONString); }
public Entities.RTOService InsertLLExamTokenBLL(string txtfromno, string txttono, string datenow, string timenow) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj = new Entities.RTOService(); entObj = accDAO1.InsertLLExamTokenDAL(txtfromno, txttono, datenow, timenow); return(entObj); }
//Check Services assign for staff public void bindservies() { try { if (HttpContext.Current.Session["LoginCode_VCR"] != null) { string STR = ""; BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); string centercode = Session["LoginCode_VCR"].ToString(); DataTable dt = new DataTable(); dt = accMgr.getServicesOfparticularStaff(centercode); lblstaffname.Text = dt.Rows[0]["StaffName_VCR"].ToString(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { STR += "<div class=\"demandBox\"><h2>" + dt.Rows[i]["ServiceName_VCR"].ToString() + "</h2></div>"; } litservices.Text = STR; } else { } } } catch { } }
public System.Data.DataTable GetStaffAssignedServicesCounterBLL(string staffcode) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); System.Data.DataTable dt = new System.Data.DataTable(); dt = accDAO1.GetStaffAssignedServicesCounterDAL(staffcode); return(dt); }
public System.Data.DataTable getServicesOfparticularStaff(string centercode) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1 = accDAO1.getstaffservices(centercode); return(dt1); }
public System.Data.DataTable EditAssignedBLL(int id, string centercode) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1 = accDAO1.EditAssignedDAL(id, centercode); return(dt1); }
public System.Data.DataTable FillserviceBLL() { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1 = accDAO1.FillserviceDAL(); return(dt1); }
public int SuperAdminAddServiceBLL(string serviceName, string serviceShortName, string ServiceType) { Entities.RTOService servObj = new Entities.RTOService(); servObj.ServiceName_VCR = serviceName; servObj.ServiceShortName_VCR = serviceShortName; servObj.ServiceType_VCR = ServiceType; return(servDAO.SuperAdminAddServiceDAL(servObj)); }
public System.Data.DataTable serviceupdateBLL(string id) { DataAccessLayer.SuperAdmin.RTOServiceDAO accDAO1 = new DataAccessLayer.SuperAdmin.RTOServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); //entObj1 = accDAO1.FillserviceDAL(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1 = accDAO1.serviceupdateDAL(id); return(dt1); }
public System.Data.DataTable displayserviceBLL() { DataAccessLayer.SuperAdmin.RTOServiceDAO accDAO1 = new DataAccessLayer.SuperAdmin.RTOServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); //entObj1 = accDAO1.FillserviceDAL(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1 = accDAO1.displayserviceDAL(); return(dt1); }
public System.Data.DataTable serviceupdateBLL(Int16 id, string CentreCode) { DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO accDAO1 = new DataAccessLayer.RTOAdmin.RTOCounterStaffServiceDAO(); Entities.RTOService entObj1 = new Entities.RTOService(); //entObj1 = accDAO1.FillserviceDAL(); System.Data.DataTable dt1 = new System.Data.DataTable(); dt1 = accDAO1.serviceupdateDAL(id, CentreCode); return(dt1); }
public int SuperAdminUpdateServiceBLL(string id, string serviceName, string serviceShortName, string ServiceType) { Entities.RTOService servObj = new Entities.RTOService(); servObj.ServiceID_INT = Convert.ToInt32(id); servObj.ServiceName_VCR = serviceName; servObj.ServiceShortName_VCR = serviceShortName; servObj.ServiceType_VCR = ServiceType; return(servDAO.SuperAdminUpdateServiceDAL(servObj)); }
public void insertLLToken() { try { string datenow = DateTime.Now.ToString("dd/MM/yyyy"); string timenow = DateTime.Now.ToString("HH:mm ss"); BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); entObj = accMgr.InsertLLExamTokenBLL(txtfromno.Text, txttono.Text, datenow, timenow); } catch { } }
public static string displayselectedService() { BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); string centercode = HttpContext.Current.Session["CenterCode"].ToString(); DataTable dt = new DataTable(); dt = accMgr.displayserviceBLL(centercode); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(dt); return(JSONString); }
public static string updatetbldata(int id) { BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); DataTable dt = new DataTable(); string centercode = HttpContext.Current.Session["CenterCode"].ToString(); dt = accMgr.EditAssignedBLL(id, centercode); DataSet ds = new DataSet(); ds.Tables.Add(dt); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(ds); return(JSONString); }
public void ChooseServise() { try { BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); DataTable dt = new DataTable(); dt = accMgr.FillserviceBLL(); if (dt.Rows.Count > 0) { ServiceCheckBoxList.DataSource = dt; ServiceCheckBoxList.DataTextField = "ServiceName_VCR"; ServiceCheckBoxList.DataValueField = "ServiceID_INT"; ServiceCheckBoxList.DataBind(); } } catch { } }
public static string deltetabledata(string id) { DataSet ds = new DataSet(); BusinessLayer.SuperAdmin.SuperAdminServiceManager servMgr = new BusinessLayer.SuperAdmin.SuperAdminServiceManager(); Entities.RTOService centObj = new Entities.RTOService(); DataTable dt = new DataTable(); string msg = ""; try { string getid = id; //dt = da.sgetdataTable("select * from centerdetails_db where Cid='" + getid + "' and ActiveStatus='1'"); //dt = centMgr.SuperAdminUpdateCentreBLL(getid); dt = servMgr.SuperAdminEditServiceBLL(getid); //int retn = da.sExecuteNonQuery("update centerdetails_db set ActiveStatus='0' where Cid='" + getid + "' and ActiveStatus='1'"); int retn = servMgr.SuperAdminDeleteServiceBLL(getid); ds.Tables.Add(dt); //string sts=dt.Rows[0]["status"].ToString(); //int retn = da.sExecuteNonQuery("update Tbl_Service set Service_Status='" + 0 + "' where Service_Id='" + getid + "'"); if (retn > 0) { msg = "success"; } else { msg = "Fail"; } } catch (Exception e) { } string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(msg); return(JSONString); }
protected void btnnext_Click(object sender, EventArgs e) { try { BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager accMgr = new BusinessLayer.RTOAdmin.RTOCounterStaffServiceManager(); Entities.RTOService entObj = new Entities.RTOService(); if (HttpContext.Current.Session["LoginCode_VCR"] != null) { DataTable dt = new DataTable(); string staffcode = Session["LoginCode_VCR"].ToString(); string[] cencode = staffcode.Split('_'); string c_code = cencode[0].ToString(); dt = accMgr.GetStaffAssignedServicesCounterBLL(staffcode); string services = ""; string counterid = dt.Rows[0]["CounterCode_VCR"].ToString(); for (int i = 0; i < dt.Rows.Count; i++) { string serv = dt.Rows[i]["ServiceName_VCR"].ToString(); services = services + "," + serv; } services = services.TrimStart(',').TrimEnd(','); entObj = accMgr.UpdateTokenBLL(services, counterid, staffcode); bindservies(); bindCurrentTokenNo(); bindtotalServedTokenNo(); } else { } } catch { } }