public string CallIndividualObjectApproval(GeneralWaitingForApproval objIGeneralWaitingForApproval, SqlConnection objConnection, SqlTransaction objTransaction)
{
string vMSG = string.Empty;
int vApprovalAction = 0;
bool vIsApproved = false;
vApprovalAction = objIGeneralWaitingForApproval.ApprovalStatus_VW;
string object_id = string.Empty;
if (objIGeneralWaitingForApproval.ApprovalStatus_VW == 1 && objIGeneralWaitingForApproval.IsFinalLevel == 1)
{
vIsApproved = true;
}
if (objIGeneralWaitingForApproval.AppModuleObjID == Convert.ToInt32(EnumModuleObjectId.SupplierProfile))
{
SupplierInfo objSupplierInfo = new SupplierInfo();
objSupplierInfo = _supplierRepository.GetSupplierInfo(objIGeneralWaitingForApproval.ObjPKValue);
object_id = objSupplierInfo.SupplierID;
vMSG = _supplierRepository.ApproveActionUpdate(objIGeneralWaitingForApproval.ObjPKValue, vApprovalAction, vIsApproved, objConnection, objTransaction);
}
if (objIGeneralWaitingForApproval.AppModuleObjID == Convert.ToInt32(EnumModuleObjectId.SupplierDocuments))
{
vMSG = _uploadedFileRepository.ApproveActionUpdate(objIGeneralWaitingForApproval.ObjPKValue, vApprovalAction, vIsApproved, objConnection, objTransaction);
}
if (objIGeneralWaitingForApproval.AppModuleObjID == Convert.ToInt32(EnumModuleObjectId.RFPProcess))
{
vMSG = _purchaseRequsitionRepository.ApproveActionUpdate(objIGeneralWaitingForApproval.ObjPKValue, vApprovalAction, vIsApproved, objConnection, objTransaction);
}
return(object_id);
}
public List <GeneralWaitingForApproval> GetDashBoardData(string pUserId)
{
List <GeneralWaitingForApproval> objIGeneralWaitingForApprovalList = new List <GeneralWaitingForApproval>();
string vComTxt = @"SELECT count(A.ModuleObjMapCode) NoOfOjectToApprove
,A.ModuleObjMapCode
,B.DashBoardCaption--,dbo.fxn_WorkingUnitByCode(A.CompanyCode) AS Company
FROM General_WaitingForApproval A
inner join LS_AppObjectInfoMap B on A.ModuleObjMapCode=B.ModuleObjMapCode And A.CompanyCode = B.CompanyCode
where B.Active=1 AND AppUserCode='" + pUserId + @"'
and ResponseStatus=0
and A.ActionType <> 'Delete'
group by A.ModuleObjMapCode,B.DashBoardCaption,A.CompanyCode ";
SqlConnection connection = _supplierDbContext.GetConn();
connection.Open();
SqlDataReader dr;
SqlCommand objDbCommand = new SqlCommand(vComTxt, connection);
dr = objDbCommand.ExecuteReader();
try
{
while (dr.Read())
{
GeneralWaitingForApproval objIGeneralWaitingForApproval = new GeneralWaitingForApproval();
objIGeneralWaitingForApproval.ModuleObjMapCode = dr["ModuleObjMapCode"].ToString();
objIGeneralWaitingForApproval.NoOfObjectToApprove_VW = Convert.ToInt32(dr["NoOfOjectToApprove"]);
objIGeneralWaitingForApproval.DashBoardCaption_VW = dr["DashBoardCaption"].ToString();
//objIGeneralWaitingForApproval.CompanyName_VW = dr["Company"].ToString();
objIGeneralWaitingForApprovalList.Add(objIGeneralWaitingForApproval);
}
}
catch (DbException ex)
{
throw ex;
}
finally
{
}
return(objIGeneralWaitingForApprovalList);
}
