public JsonResult GetPaidListByBillID(string _search, long?UserId, long?locationId, int?rows = 20, int?page = 1, int?TotalRecords = 10, string sord = null, string txtSearch = null, string sidx = null, string UserType = null) { eTracLoginModel ObjLoginModel = null; long MISNumber = 0; if (Session["eTrac"] != null) { ObjLoginModel = (eTracLoginModel)(Session["eTrac"]); if (locationId == null) { locationId = ObjLoginModel.LocationID; } UserId = ObjLoginModel.UserId; } JQGridResults result = new JQGridResults(); List <JQGridRow> rowss = new List <JQGridRow>(); sord = string.IsNullOrEmpty(sord) ? "desc" : sord; sidx = string.IsNullOrEmpty(sidx) ? "UserEmail" : sidx; txtSearch = string.IsNullOrEmpty(txtSearch) ? "" : txtSearch; //UserType = Convert.ToInt64(Helper.UserType.ITAdministrator); try { locationId = 0;//Need to fetch all data var paymentList = _IPaymentManager.GetListPaidtByLocationId(UserId, locationId, rows, TotalRecords, sidx, sord, locationId, txtSearch, UserType); foreach (var payment in paymentList.rows) { if (payment.BillNo != null) { JQGridRow row = new JQGridRow(); row.id = Cryptography.GetEncryptedData(Convert.ToString(payment.BillNo), true); row.cell = new string[13]; row.cell[0] = payment.BillNo.ToString(); row.cell[1] = payment.LocationName == null ? "N/A" : payment.LocationName;; row.cell[2] = payment.VendorName == null ? "N/A" : payment.VendorName; row.cell[3] = payment.OperatingCompany == null ? "N/A" : payment.OperatingCompany; row.cell[4] = payment.BillType == null ? "N/A" : payment.BillType; row.cell[5] = payment.BillAmount.ToString(); row.cell[6] = payment.BillDate.ToString(); row.cell[7] = payment.GracePeriod == null ? "N/A" : payment.GracePeriod.ToString(); row.cell[8] = (payment.PaymentMode == null && payment.BillType == "MIS") ? "MISC" : (payment.PaymentMode == null && payment.BillType == "ManualBill") ? "ManualBill" : payment.PaymentMode.ToString(); row.cell[9] = payment.Description == null ? "N/A" : payment.Description; row.cell[10] = payment.Status == "P" ? "Paid" : "Cancel"; row.cell[11] = payment.OperatingCompanyId > 0 ? payment.OperatingCompanyId.ToString() : "0"; row.cell[12] = payment.LocationId > 0 ? payment.LocationId.ToString() : "0"; rowss.Add(row); } } result.rows = rowss.ToArray(); result.page = Convert.ToInt32(page); result.total = (int)Math.Ceiling((decimal)Convert.ToInt32(TotalRecords.Value) / rows.Value); result.records = Convert.ToInt32(TotalRecords.Value); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } return(Json(result, JsonRequestBehavior.AllowGet)); }