public int servicedeleteDAL(string id)
{
int val;
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[2];
paras[0] = new SqlParameter("@Service_Id", id);
paras[1] = new SqlParameter("@Event", "delete");
val = ExecuteNonQueryResult(db, "Sp_ServiceDetails", paras);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(val);
}
public int SuperAdminUpdateServiceDAL(RTOService servObj1)
{
int NonQueryResult = 0;
string centreModifyTime = System.DateTime.Now.ToString();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[5];
paras[0] = new SqlParameter("@Event", "Update");
paras[1] = new SqlParameter("@ServiceID_INT", servObj1.ServiceID_INT);
paras[2] = new SqlParameter("@ServiceName_VCR", servObj1.ServiceName_VCR);
paras[3] = new SqlParameter("@ServiceShortName_VCR", servObj1.ServiceShortName_VCR);
paras[4] = new SqlParameter("@ServiceType_VCR", servObj1.ServiceType_VCR);
NonQueryResult = ExecuteSPNonQuery(db, "RTO_spServiceDetails", paras);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(NonQueryResult);
}
public int SuperAdminAddServiceDAL(RTOService servObj1)
{
int NonQueryResult = 0;
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[4];
paras[0] = new SqlParameter("@Event", "Add");
paras[1] = new SqlParameter("@ServiceName_VCR", servObj1.ServiceName_VCR);
paras[2] = new SqlParameter("@ServiceShortName_VCR", servObj1.ServiceShortName_VCR);
paras[3] = new SqlParameter("@ServiceType_VCR", servObj1.ServiceType_VCR);
NonQueryResult = ExecuteSPNonQuery(db, "RTO_spServiceDetails", paras);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
if (NonQueryResult != 0)
{
return(1);
}
else
{
return(0);
}
}
public RTOService InsertLLExamTokenDAL(string txtfromno, string txttono, string datenow, string timenow)
{
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[5];
paras[0] = new SqlParameter("@from_token", txtfromno);
paras[1] = new SqlParameter("@to_token", txttono);
paras[2] = new SqlParameter("@date", datenow);
paras[3] = new SqlParameter("@time", timenow);
paras[4] = new SqlParameter("@Event", "Insert");
using (IDataReader reader = ExecuteSPReader(db, "RTO_spLLCallNextToken", paras))
{
while (reader.Read())
{
entObj1.llfromtoken = reader[1].ToString();
entObj1.lltotoken = reader[2].ToString();
entObj1.lldate = reader[3].ToString();
entObj1.lltime = reader[4].ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(entObj1);
}
public RTOService TokenLLUpdateDAL(string datenow)
{
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[2];
paras[0] = new SqlParameter("@date", datenow);
paras[1] = new SqlParameter("@Event", "Update");
using (IDataReader reader = ExecuteSPReader(db, "RTO_spLLCallNextToken", paras))
{
while (reader.Read())
{
entObj1.lldate = reader[1].ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(entObj1);
}
public RTOService TokenUpdateDAL(string services, string counterid, string staffcode)
{
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[4];
paras[0] = new SqlParameter("@CurrTokenState_VCR", services);
paras[1] = new SqlParameter("@CurrCounterCode_VCR", counterid);
paras[2] = new SqlParameter("@CurrStaffCode_VCR", staffcode);
paras[3] = new SqlParameter("@Event", "Update");
using (IDataReader reader = ExecuteSPReader(db, "RTO_spCallNextToken", paras))
{
while (reader.Read())
{
entObj1.CurrServiceName_VCR = reader[1].ToString();
entObj1.CurrCounterCode_VCR = reader[2].ToString();
entObj1.CurrStaffCode_VCR = reader[3].ToString();
}
}
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(entObj1);
}
public int servicedeleteDAL(Int16 id, string CentreCode)
{
int val;
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@ChooseServiceID_INT", id);
paras[1] = new SqlParameter("@CentreCode_VCR", CentreCode);
paras[2] = new SqlParameter("@Event", "Delete");
val = ExecuteSPNonQuery(db, "RTO_spAdminChooseService", paras);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(val);
}
public int AssignDAL(int ServiceId, int Staffid, int counterid, string centerCode)
{
int val;
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[6];
paras[0] = new SqlParameter("@ServiceID_INT", ServiceId);
paras[1] = new SqlParameter("@StaffID_INT", Staffid);
paras[2] = new SqlParameter("@CounterID_INT", counterid);
paras[3] = new SqlParameter("@CentreCode_VCR", centerCode);
paras[4] = new SqlParameter("@AssignActiveStatus_INT", 1);
paras[5] = new SqlParameter("@Event", "Add");
val = ExecuteSPNonQuery(db, "RTO_spAssignMapping", paras);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(val);
}
public int AddserviceDAL(string ServiceName, string ServiceShortName, string date, string btnval)
{
int val;
RTOService entObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
if (btnval == "Add Service")
{
SqlParameter[] paras = new SqlParameter[6];
paras[0] = new SqlParameter("@Service_Name", ServiceName);
paras[1] = new SqlParameter("@Service_Short_Name", ServiceShortName);
paras[2] = new SqlParameter("@Create_date", date);
paras[3] = new SqlParameter("@Modify_date", null);
paras[4] = new SqlParameter("@Service_Status", 1);
paras[5] = new SqlParameter("@Event", "Add");
val = ExecuteNonQueryResult(db, "Sp_ServiceDetails", paras);
}
else
{
SqlParameter[] paras = new SqlParameter[6];
paras[0] = new SqlParameter("@Service_Name", ServiceName);
paras[1] = new SqlParameter("@Service_Short_Name", ServiceShortName);
paras[2] = new SqlParameter("@Modify_date", date);
paras[3] = new SqlParameter("@Service_Status", 1);
paras[3] = new SqlParameter("@Service_Id", 1);
paras[4] = new SqlParameter("@Event", "Update");
val = ExecuteNonQueryResult(db, "Sp_ServiceDetails", paras);
}
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(val);
}
public DataTable SuperAdminGetAllServicesDAL()
{
DataTable dt1;
RTOService servObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter para1;
para1 = new SqlParameter("@Event", "Select");
dt1 = ExecuteSPDataTable(db, "RTO_spServiceDetails", para1);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(dt1);
}
public DataTable SuperAdminEditServiceDAL(string getid)
{
DataTable dt1;
RTOService servObj1 = new RTOService();
try
{
using (IDbConnection db = GetConnection())
{
SqlParameter[] paras = new SqlParameter[2];
paras[0] = new SqlParameter("@Event", "Edit");
paras[1] = new SqlParameter("@ServiceID_INT", getid);
dt1 = ExecuteSPDataTable(db, "RTO_spServiceDetails", paras);
}
}
catch (Exception ex)
{
throw new Exception("Unable to verify credentials" + ex);
}
return(dt1);
}
