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); }