public PartialViewResult SuperIndexgrid(string WhiteLevel = "", string Super = "", string Status = "")
        {
            if (WhiteLevel == "" && Status == "" && Super == "")
            {
                var Adminrequisition = PowerAdminRquisitionReportModel.GetAllSuperRequisitionReport("0", Status);
                return(PartialView("SuperIndexgrid", Adminrequisition));
            }
            else if (WhiteLevel == "" && Status != "" && Super == "")
            {
                var Adminrequisition = PowerAdminRquisitionReportModel.GetAllSuperRequisitionReport("0", Status);
                return(PartialView("SuperIndexgrid", Adminrequisition));
            }
            else if (WhiteLevel != "" && Status == "" && Super != "")
            {
                var Adminrequisition = PowerAdminRquisitionReportModel.GetSuperRequisitionReport(WhiteLevel, Super, Status);
                return(PartialView("SuperIndexgrid", Adminrequisition));
            }
            else if (WhiteLevel != "" && Status != "" && Super != "")
            {
                var Adminrequisition = PowerAdminRquisitionReportModel.GetSuperRequisitionReport(WhiteLevel, Super, Status);
                return(PartialView("SuperIndexgrid", Adminrequisition));
            }
            else if (WhiteLevel != "" && Status == "" && Super == "")
            {
                var Adminrequisition = PowerAdminRquisitionReportModel.GetSuperRequisitionReport(WhiteLevel, Super, Status);
                return(PartialView("SuperIndexgrid", Adminrequisition));
            }
            else if (WhiteLevel != "" && Status != "" && Super == "")
            {
                var Adminrequisition = PowerAdminRquisitionReportModel.GetSuperRequisitionReport(WhiteLevel, Super, Status);
                return(PartialView("SuperIndexgrid", Adminrequisition));
            }

            return(PartialView("SuperIndexgrid", ""));
        }
 public PartialViewResult MerchantIndexgrid(string WhiteLevel = "", string SuperId = "", string Distributor = "", string Merchant = "", string Status = "")
 {
     if (WhiteLevel == "" && SuperId == "" && Status == "" && Merchant == "" && Distributor == "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetAllMerchantRequisitionReport("0", Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status != "" && WhiteLevel == "" && SuperId == "" && Distributor == "" && Merchant == "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetAllMerchantRequisitionReport("0", Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status != "" && WhiteLevel != "" && SuperId == "" && Distributor == "" && Merchant == "")
     {
         //var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(Merchant, Status);
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status == "" && WhiteLevel != "" && SuperId == "" && Distributor == "" && Merchant == "")
     {
         //var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(Merchant, Status);
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status == "" && WhiteLevel != "" && SuperId != "" && Distributor == "" && Merchant == "")
     {
         //var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(Merchant, Status);
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status != "" && WhiteLevel != "" && SuperId != "" && Distributor == "" && Merchant == "")
     {
         //var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(Merchant, Status);
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status != "" && WhiteLevel != "" && SuperId != "" && Distributor != "" && Merchant == "")
     {
         //var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(Merchant, Status);
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (Status == "" && WhiteLevel != "" && SuperId != "" && Distributor != "" && Merchant == "")
     {
         //var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(Merchant, Status);
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (WhiteLevel != "" && SuperId != "" && Distributor != "" && Status != "" && Merchant != "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     else if (WhiteLevel != "" && SuperId != "" && Distributor != "" && Status == "" && Merchant != "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetMerchantRequisitionReport(WhiteLevel, SuperId, Distributor, Merchant, Status);
         return(PartialView("MerchantIndexgrid", Adminrequisition));
     }
     return(PartialView("MerchantIndexgrid", ""));
 }
        private IGrid <TBL_BALANCE_TRANSFER_LOGS> CreateExporWhiteLevelGrid(string Disid, string statusval)
        {
            var db = new DBContext();
            var Adminrequisition = new List <TBL_BALANCE_TRANSFER_LOGS>();

            if (Disid == "" && statusval == "")
            {
                Adminrequisition = PowerAdminRquisitionReportModel.GetAllAdminRequisitionReport("0", statusval);
            }
            else if (Disid == "" && statusval != "")
            {
                Adminrequisition = PowerAdminRquisitionReportModel.GetAllAdminRequisitionReport("0", statusval);
            }
            else if (Disid != "" && statusval == "")
            {
                Adminrequisition = PowerAdminRquisitionReportModel.GetAdminRequisitionReport(Disid, statusval);
            }
            else if (Disid != "" && statusval != "")
            {
                Adminrequisition = PowerAdminRquisitionReportModel.GetAdminRequisitionReport(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("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.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 = "", string Status = "")
 {
     if (Status == "" && search == "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetAllAdminRequisitionReport("0", Status);
         return(PartialView("Indexgrid", Adminrequisition));
     }
     else if (Status != "" && search == "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetAllAdminRequisitionReport("0", Status);
         return(PartialView("Indexgrid", Adminrequisition));
     }
     else if (Status == "" && search != "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetAdminRequisitionReport(search, Status);
         return(PartialView("Indexgrid", Adminrequisition));
     }
     else if (Status != "" && search != "")
     {
         var Adminrequisition = PowerAdminRquisitionReportModel.GetAdminRequisitionReport(search, Status);
         return(PartialView("Indexgrid", Adminrequisition));
     }
     return(PartialView("Indexgrid", ""));
 }