public PurchaseRequisitionSummary GetAllRequisitionstoSummary(string companyCode, string currentregionCode, string mode, string code, string startDate, string endDate)
{
PurchaseRequisitionSummary ObjSumm = null;
try
{
ObjSumm = ObjPR.GetAllRequisitionstoSummary(companyCode, currentregionCode, code, mode, startDate, endDate);
}
catch (Exception ex)
{
throw;
}
return(ObjSumm);
}
public JsonResult GetAllRequisitionstoSummary(string Code, string mode, string startDate, string endDate)
{
PurchaseRequisitionSummary ObjSumm = null;
string companyCode = null;
string currentregionCode = null;
try
{
companyCode = ObjCurrInfo.GetCompanyCode();
currentregionCode = ObjCurrInfo.GetRegionCode();
ObjSumm = ObjPR.GetAllRequisitionstoSummary(companyCode, currentregionCode, Code, mode, startDate, endDate);
return(Json(ObjSumm, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw;
}
}
public PurchaseRequisitionSummary GetAllRequisitionstoSummary(string companyCode, string currentregionCode, string mode, string code, string startDate, string endDate)
{
PurchaseRequisitionSummary ObjSumm = null;
try
{
List <RequisitionSummaryModel> lstsumm = null;
List <PurchaseProductModel> lstalerts = null;
List <PurchaseProductModel> lstprod = null;
using (IDbConnection connection = IDbOpenConnection())
{
var p = new DynamicParameters();
p.Add("@CompanyCode", companyCode);
p.Add("@Code", code);
p.Add("@RegionCode", currentregionCode);
p.Add("@Start_Date", startDate);
p.Add("@End_Date", endDate);
p.Add("@Mode", mode);
using (var multiselect = connection.QueryMultiple(SP_HD_PRM_GETALLPURCHASEREQUISITIONSFORSUMMARY, p, commandType: CommandType.StoredProcedure))
{
lstsumm = multiselect.Read <RequisitionSummaryModel>().ToList();
lstalerts = multiselect.Read <PurchaseProductModel>().ToList();
lstprod = multiselect.Read <PurchaseProductModel>().ToList();
}
connection.Close();
}
ObjSumm = new PurchaseRequisitionSummary();
ObjSumm.lstSummary = lstsumm;
ObjSumm.lstAlert = lstalerts;
ObjSumm.lstProducts = lstprod;
}
catch (Exception ex)
{
throw;
}
return(ObjSumm);
}
