public static GetMandateDataResponseData PhysicalSearchData(GetMandateData objectname) { try { QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities(); GetMandateDataResponseData res = new GetMandateDataResponseData(); List <GridData> GridDatalist = new List <GridData>(); List <Count> MandateCountlist = new List <Count>(); var Result = dbcontext.MultipleResults("[dbo].[sp_MandateAnalysis]").With <GridData>().With <Count>(). Execute("@QueryType", "@Month", "@Year", "@topVal", "GetMandateData_Physical", objectname.Month, objectname.Year, objectname.Total); res.GridDatalist = Result[0].Cast <GridData>().ToList(); res.MandateCountlist = Result[1].Cast <Count>().ToList(); return(res); } catch (Exception ex) { throw ex; } }
public static GetMandateDataResponseData SetData() { try { QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities(); GetMandateDataResponseData res = new GetMandateDataResponseData(); List <GetMonth> GetMonthlist = new List <GetMonth>(); List <GetYear> GetYearlist = new List <GetYear>(); var Result = dbcontext.MultipleResults("[dbo].[sp_MandateAnalysis]").With <GetMonth>().With <GetYear>(). Execute("@QueryType", "GetMonthAndYear"); res.GetMonthlist = Result[0].Cast <GetMonth>().ToList(); res.GetYearlist = Result[1].Cast <GetYear>().ToList(); return(res); } catch (Exception ex) { //return null; throw ex; } }