public JsonResult QueryConnectCareSponsors() { string draw = CurrentRequestData.CurrentContext.Request["draw"]; string echo = CurrentRequestData.CurrentContext.Request["sEcho"]; string displayLength = CurrentRequestData.CurrentContext.Request["iDisplayLength"]; string displayStart = CurrentRequestData.CurrentContext.Request["iDisplayStart"]; string scrPolicynumber = CurrentRequestData.CurrentContext.Request["src_policynumber"]; string fullname = CurrentRequestData.CurrentContext.Request["scr_fullname"]; string senttomatontine = CurrentRequestData.CurrentContext.Request["scr_senttomatontine"]; string scruseDate = CurrentRequestData.CurrentContext.Request["scr_useDate"]; string scrFromDate = CurrentRequestData.CurrentContext.Request["datepicker"]; string scrToDate = CurrentRequestData.CurrentContext.Request["datepicker2"]; string search = CurrentRequestData.CurrentContext.Request["sSearch"]; string displayLength2 = CurrentRequestData.CurrentContext.Request["iDisplayLength2"]; int toltareccount = 0; int totalinresult = 0; DateTime fromdate = CurrentRequestData.Now; DateTime todate = CurrentRequestData.Now; bool usedate = false; int senttotine = -1; int.TryParse(senttomatontine, out senttotine); IList <ConnectCareSponsor> queryresult = _helperSvc.QueryConnectCareSponsor(out toltareccount, out totalinresult, search, Convert.ToInt32(displayStart), Convert.ToInt32(displayLength), fullname, scrPolicynumber, senttotine, usedate, fromdate, todate); List <connectCareSponsorResponse> output = new List <connectCareSponsorResponse>(); foreach (ConnectCareSponsor item in queryresult) { connectCareSponsorResponse obbb = new connectCareSponsorResponse(); obbb.Sponsor = item; obbb.beneficiaries = _helperSvc.GetBeneficiariesBySponsorID(item.Id); obbb.benecount = obbb.beneficiaries.Count(); output.Add(obbb); } JsonResult response = Json(output, JsonRequestBehavior.AllowGet); return(Json(new { sEcho = echo.ToString(), recordsTotal = toltareccount.ToString(), recordsFiltered = toltareccount.ToString(), iTotalRecords = toltareccount.ToString(), iTotalDisplayRecords = totalinresult.ToString(), aaData = response.Data })); }
public ActionResult ExpandSponsor(int Id, ExpandSponsorPage page) { ConnectCareSponsor sponsor = _helperSvc.GetSponsor(Id); IList <ConnectCareBeneficiary> beneficiary = _helperSvc.GetBeneficiariesBySponsorID(Id); if (sponsor != null) { connectCareSponsorResponse shii = new connectCareSponsorResponse() { Sponsor = sponsor, beneficiaries = beneficiary, benecount = beneficiary.Count() }; ViewBag.sponsor = shii; } return(View(page)); }