public static DataTable getCPARRequestFrom(string CACIId, string CAStage)
{
IQISSDBManager dbManager = new QISSDBManager();
DataTable dt = new DataTable();
try
{
dbManager.Open();
IDbDataParameter[] param = QISSDBManagerFactory.GetParameters(dbManager.ProviderType, 2);
param[0] = dbManager.getparam("@CACIId", CACIId.ToString());
param[1] = dbManager.getparam("@CAStage", CAStage.ToString());
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "usp_CPARInfo_getCPARRequestFrom", param);
dt = dbManager.GetDataTable(cmd);
return(dt);
}
catch (Exception ex)
{
return(dt);
}
finally
{
dt.Dispose();
dbManager.Dispose();
}
}
public static DataTable getAssignedWorkInformation(string CIId)
{
IQISSDBManager dbManager = new QISSDBManager();
DataTable dt = new DataTable();
try
{
dbManager.Open();
IDbDataParameter[] param = QISSDBManagerFactory.GetParameters(dbManager.ProviderType, 1);
param[0] = dbManager.getparam("@CIId", CIId.ToString());
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "usp_CPARAction_get_AssignedWork", param);
dt = dbManager.GetDataTable(cmd);
return(dt);
}
catch (Exception ex)
{
return(dt);
}
finally
{
dt.Dispose();
dbManager.Dispose();
}
}
} //---END ADD---
public static DataTable getAppReqCompStepCPAR(string CAAssignedTo, string CIBranchId, clsBOLGetAllCPARInformation obj)
{
IQISSDBManager dbManager = new QISSDBManager();
DataTable dt = new DataTable();
try
{
dbManager.Open();
IDbDataParameter[] param = QISSDBManagerFactory.GetParameters(dbManager.ProviderType, 6);
param[0] = dbManager.getparam("@CAAssignedTo", CAAssignedTo.ToString());
param[1] = dbManager.getparam("@CIBranchId", CIBranchId.ToString());
param[2] = dbManager.getparam("@CICPARNo", obj.CICPARNo);
param[3] = dbManager.getparam("@CIInitiator", obj.CIInitiator);
param[4] = dbManager.getparam("@CIInitiateDate_start", obj.CIInitiateDate_start);
param[5] = dbManager.getparam("@CIInitiateDate_end", obj.CIInitiateDate_end);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "usp_CPARAction_APPRequest_CompStep", param);
dt = dbManager.GetDataTable(cmd);
return(dt);
}
catch (Exception ex)
{
return(dt);
}
finally
{
dbManager.Dispose();
dt.Dispose();
}
}