private IGrid <TBL_BALANCE_TRANSFER_LOGS> CreateExportMerchantReqGrid(string statusval) { var db = new DBContext(); var transactionlistvalue = MerchantRequisitionReportViewModel.GetMerchantAllRequisitionReport(CurrentMerchant.MEM_ID.ToString(), statusval); IGrid <TBL_BALANCE_TRANSFER_LOGS> grid = new Grid <TBL_BALANCE_TRANSFER_LOGS>(transactionlistvalue); grid.ViewContext = new ViewContext { HttpContext = HttpContext }; grid.Query = Request.QueryString; grid.Columns.Add(model => model.Serial_No).Titled("Se Id"); //grid.Columns.Add(model => model.ToUser).Titled("To User"); grid.Columns.Add(model => model.FromUser).Titled("User Name"); grid.Columns.Add(model => model.REQUEST_DATE).Titled("Req Date").Formatted("{0:d}").MultiFilterable(true); grid.Columns.Add(model => model.REQUEST_TIME).Titled("Req Date").Formatted("{0:T}").MultiFilterable(true); grid.Columns.Add(model => model.AMOUNT).Titled("Amount"); grid.Columns.Add(model => model.BANK_ACCOUNT).Titled("Bank Acnt"); grid.Columns.Add(model => model.TRANSACTION_DETAILS).Titled("Pay Method"); grid.Columns.Add(model => model.STATUS).Titled("STATUS"); grid.Columns.Add(model => model.APPROVAL_DATE).Titled("Apprv/Decline Date").Formatted("{0:d}").MultiFilterable(true); grid.Columns.Add(model => model.APPROVED_BY).Titled("Apprv By"); grid.Pager = new GridPager <TBL_BALANCE_TRANSFER_LOGS>(grid); grid.Processors.Add(grid.Pager); grid.Pager.RowsPerPage = 6; foreach (IGridColumn column in grid.Columns) { column.Filter.IsEnabled = true; column.Sort.IsEnabled = true; } return(grid); }
public PartialViewResult IndexGrid(string search = "") { var db = new DBContext(); if (search == "") { var transactionlistvalue = MerchantRequisitionReportViewModel.GetMerchantAllRequisitionReport(CurrentMerchant.MEM_ID.ToString(), search); return(PartialView("IndexGrid", transactionlistvalue)); } else { //var transactionlistvalue = (from x in db.TBL_BALANCE_TRANSFER_LOGS // join y in db.TBL_MASTER_MEMBER on x.FROM_MEMBER equals y.MEM_ID // where x.FROM_MEMBER == CurrentMerchant.MEM_ID && x.STATUS==search // select new // { // Touser = "******", // transid = x.TransactionID, // FromUser = y.UName, // REQUEST_DATE = x.REQUEST_DATE, // AMOUNT = x.AMOUNT, // BANK_ACCOUNT = x.BANK_ACCOUNT, // TRANSACTION_DETAILS = x.TRANSACTION_DETAILS, // STATUS = x.STATUS, // APPROVED_BY = x.APPROVED_BY, // APPROVAL_DATE = x.APPROVAL_DATE, // SLN = x.SLN // }).AsEnumerable().Select((z, index) => new TBL_BALANCE_TRANSFER_LOGS // { // Serial_No = index + 1, // ToUser = z.Touser, // TransactionID = z.transid, // FromUser = z.FromUser, // AMOUNT = z.AMOUNT, // REQUEST_DATE = z.REQUEST_DATE, // BANK_ACCOUNT = z.BANK_ACCOUNT, // TRANSACTION_DETAILS = z.TRANSACTION_DETAILS, // STATUS = z.STATUS, // APPROVED_BY = z.APPROVED_BY, // APPROVAL_DATE = z.APPROVAL_DATE, // SLN = z.SLN // }).ToList(); var transactionlistvalue = MerchantRequisitionReportViewModel.GetMerchantAllRequisitionReport(CurrentMerchant.MEM_ID.ToString(), search); return(PartialView("IndexGrid", transactionlistvalue)); } }