//----TCS User Unlock-End
//-----TCS Cancel/Expire Policies
public DataTable SelectCancelExpirePolicies(string PolicyNo)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_POLYCY_NO", PolicyNo);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.IT_SelectCancelExpirePolicies, inputParameter);
return(a);
}
//----TCS User Unlock
//----Select TCS Locked Users
public DataTable SelectTCSLockedUsers(string UserCode)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_USERCODE", UserCode);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.IT_SelectLockedUser, inputParameter);
return(a);
}
public DataTable SelectImages(string JobNo, string DocType)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_JOB_NO", JobNo);
inputParameter.Add("@V_TYPE", DocType);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.IT_SelectImages, inputParameter);
return(a);
}
public DataTable SelectDataCRCNonMotor(string policy, string proposal, string insured,string nic)
{
Dictionary<string, object> inputParameter = new Dictionary<string, object>();
inputParameter.Add("@V_POLICY_NO", policy);
inputParameter.Add("@V_PROPOSAL_NO", proposal);
inputParameter.Add("@V_INSURED", insured);
inputParameter.Add("@V_NIC", nic);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.SelectDataCRCNonMotor, inputParameter);
return a;
}
//Reports Table
public DataTable GetData(string type)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
Dictionary <string, object> outputParameter = new Dictionary <string, object>();
Dictionary <string, object> outputParameterValues = new Dictionary <string, object>();
inputParameter.Add("V_TYPE", type);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.CM_SelectTotalRecords_ForChart, inputParameter);
return(a);
}
public DataTable SelectReferanceData(string RefType, string par1, string par2)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_TYPE", RefType);
inputParameter.Add("@PAR1", par1);
inputParameter.Add("@PAR2", par2);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.CM_SelectRefData, inputParameter);
return(a);
}
public DataTable SelectDataCommentAIS(string Par1, string Par2, string Par3)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_PAR1", Par1);
inputParameter.Add("@V_PAR2", Par2);
inputParameter.Add("@V_PAR3", Par3);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.SelectDataCommentAIS, inputParameter);
return(a);
}
public DataTable SelectJobFromRegister(string Case, string Par1, string Par2, string Par3, DateTime?Date)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_CASE_NO", Case);
inputParameter.Add("@V_PAR1", Par1);
inputParameter.Add("@V_PAR2", Par2);
inputParameter.Add("@V_PAR3", Par3);
inputParameter.Add("@V_DATE", Date);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.IT_SelectJobFromRegister, inputParameter);
return(a);
}
public DataTable SelectDataCRCMotorBiS(string policy, string vehicleno, string proposal, string engine, string chassi, string contact, string insured)
{
Dictionary<string, object> inputParameter = new Dictionary<string, object>();
inputParameter.Add("@V_POLICY_NO", policy);
inputParameter.Add("@V_VEHICLE_NO", vehicleno);
inputParameter.Add("@V_PROPOSAL_NO", proposal);
inputParameter.Add("@V_ENGINE_NO", engine);
inputParameter.Add("@V_CHASSI_NO", chassi);
inputParameter.Add("@V_CONTACT_NO", contact);
inputParameter.Add("@V_INSURED", insured);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.SelectDataCRCMotorBiS, inputParameter);
return a;
}
public DataTable CM_SelectTotalRecords(DateTime StartDate, DateTime EndDate, string Branch, string SystemType, string status, string company)
{
Dictionary <string, object> inputParameter = new Dictionary <string, object>();
inputParameter.Add("@V_STATRDATE", StartDate);
inputParameter.Add("@V_ENDDATE", EndDate);
inputParameter.Add("@V_BRANCH", Branch);
inputParameter.Add("@V_SYSTEM_TYPE", SystemType);
inputParameter.Add("@V_STATUS", status);
inputParameter.Add("@V_COMPANY", company);
DataTable a = DatabaseUtility.SelectDataWithInputParameters(GenericStoredProcedure.CM_SelectTotalRecords, inputParameter);
return(a);
}
