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 { }
}
