private IGrid <TBL_BALANCE_TRANSFER_LOGS> CreateExporWhiteLevelGrid(string statusval, string DateFrom = "", string Date_To = "") { var db = new DBContext(); var Adminrequisition = MemberRequisitionReportModel.GetAdminRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), statusval, DateFrom, Date_To); IGrid <TBL_BALANCE_TRANSFER_LOGS> grid = new Grid <TBL_BALANCE_TRANSFER_LOGS>(Adminrequisition); 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:yyyy-MM-dd}").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:yyyy-MM-dd}").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 = 10000000; foreach (IGridColumn column in grid.Columns) { column.Filter.IsEnabled = true; column.Sort.IsEnabled = true; } return(grid); }
public PartialViewResult DistributorReqGrid(string Super = "", string search = "", string Status = "", string DateFrom = "", string Date_To = "") { if (Super == "" && search == "" && Status == "") { var distributorlist = MemberRequisitionReportModel.GetAllDistributorRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), Status, DateFrom, Date_To); return(PartialView("DistributorReqGrid", distributorlist)); } else if (Super == "" && search == "" && Status == "") { var distributorlist = MemberRequisitionReportModel.GetAllDistributorRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), Status, DateFrom, Date_To); return(PartialView("DistributorReqGrid", distributorlist)); } else if (Super != "" && search != "" && Status != "") { var distributorlist = MemberRequisitionReportModel.GetDistributorRequisitionReport(Super, search.ToString(), Status, DateFrom, Date_To); return(PartialView("DistributorReqGrid", distributorlist)); } else if (Super != "" && search != "" && Status == "") { var distributorlist = MemberRequisitionReportModel.GetDistributorRequisitionReport(Super, search.ToString(), Status, DateFrom, Date_To); return(PartialView("DistributorReqGrid", distributorlist)); } else if (Super != "" && search == "" && Status != "") { var distributorlist = MemberRequisitionReportModel.GetDistributorRequisitionReport(Super, search.ToString(), Status, DateFrom, Date_To); return(PartialView("DistributorReqGrid", distributorlist)); } else if (Super != "" && search == "" && Status == "") { var distributorlist = MemberRequisitionReportModel.GetDistributorRequisitionReport(Super, search.ToString(), Status, DateFrom, Date_To); return(PartialView("DistributorReqGrid", distributorlist)); } return(PartialView()); }
public PartialViewResult SuperRequisitonGrid(string search = "", string Status = "") { if (Status == "" && search == "") { var Adminrequisition = MemberRequisitionReportModel.GetAllSuperRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), Status); return(PartialView("SuperRequisitonGrid", Adminrequisition)); } else if (Status != "" && search == "") { var Adminrequisition = MemberRequisitionReportModel.GetAllSuperRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), Status); return(PartialView("SuperRequisitonGrid", Adminrequisition)); } else if (Status == "" && search != "") { var Adminrequisition = MemberRequisitionReportModel.GetSuperRequisitionReport(search, Status); return(PartialView("SuperRequisitonGrid", Adminrequisition)); } else if (Status != "" && search != "") { var Adminrequisition = MemberRequisitionReportModel.GetSuperRequisitionReport(search, Status); return(PartialView("SuperRequisitonGrid", Adminrequisition)); } return(PartialView()); }
public PartialViewResult MercantRequisitionGrid(string Super = "", string Distributor = "", string search = "", string Status = "") { if (string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(search) && string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetAllMerchantRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(search) && !string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetAllMerchantRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && !string.IsNullOrEmpty(search) && string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, search, Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && !string.IsNullOrEmpty(search) && !string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, search, Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(search) && string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, search, Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(search) && !string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, search, Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (!string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(search) && string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, search, Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } else if (!string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(search) && !string.IsNullOrEmpty(Status)) { var MerchantList = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, search, Status); return(PartialView("MercantRequisitionGrid", MerchantList)); } return(PartialView()); }
public PartialViewResult IndexGrid(string search = "", string DateFrom = "", string Date_To = "") { var Adminrequisition = MemberRequisitionReportModel.GetAdminRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), search, DateFrom, Date_To); return(PartialView("IndexGrid", Adminrequisition)); }
private IGrid <TBL_BALANCE_TRANSFER_LOGS> CreateExportMerchantGrid(string Super, string Distributor, string Disid, string statusval) { var db = new DBContext(); var Adminrequisition = new List <TBL_BALANCE_TRANSFER_LOGS>(); if (string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(Disid) && string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetAllMerchantRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), statusval); } else if (string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(Disid) && !string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetAllMerchantRequisitionReport(MemberCurrentUser.MEM_ID.ToString(), statusval); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && !string.IsNullOrEmpty(Disid) && string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, Disid, statusval); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && !string.IsNullOrEmpty(Disid) && !string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, Disid, statusval); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(Disid) && string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, Disid, statusval); } else if (!string.IsNullOrEmpty(Super) && !string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(Disid) && !string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, Disid, statusval); } else if (!string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(Disid) && string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, Disid, statusval); } else if (!string.IsNullOrEmpty(Super) && string.IsNullOrEmpty(Distributor) && string.IsNullOrEmpty(Disid) && !string.IsNullOrEmpty(statusval)) { Adminrequisition = MemberRequisitionReportModel.GetMerchantRequisitionReport(Super, Distributor, Disid, statusval); } IGrid <TBL_BALANCE_TRANSFER_LOGS> grid = new Grid <TBL_BALANCE_TRANSFER_LOGS>(Adminrequisition); grid.ViewContext = new ViewContext { HttpContext = HttpContext }; grid.Query = Request.QueryString; grid.Columns.Add(model => model.Serial_No).Titled("Sr 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.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); }