public PartialViewResult DistributorIndexgrid(string WhiteLevel = "", string SuperId = "", string Distributor = "", string Status = "")
{
if (WhiteLevel == "" && SuperId == "" && Status == "" && Distributor == "")
{
var Adminrequisition = PowerAdminRquisitionReportModel.GetAllDistributorRequisitionReport("0", Status);
return(PartialView("DistributorIndexgrid", Adminrequisition));
}
else if (WhiteLevel == "" && SuperId == "" && Status != "" && Distributor == "")
{
var Adminrequisition = PowerAdminRquisitionReportModel.GetAllDistributorRequisitionReport("0", Status);
return(PartialView("DistributorIndexgrid", Adminrequisition));
}
else if (Status == "" && Distributor == "" && WhiteLevel != "" && SuperId == "")
{
var Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Distributor, Status);
return(PartialView("DistributorIndexgrid", Adminrequisition));
}
else if (Status != "" && Distributor != "" && WhiteLevel != "" && SuperId != "")
{
var Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Distributor, Status);
return(PartialView("DistributorIndexgrid", Adminrequisition));
}
else if (WhiteLevel != "" && SuperId != "" && Status == "" && Distributor != "")
{
var Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Distributor, Status);
return(PartialView("DistributorIndexgrid", Adminrequisition));
}
else if (WhiteLevel != "" && SuperId != "" && Status == "" && Distributor == "")
{
var Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Distributor, Status);
return(PartialView("DistributorIndexgrid", Adminrequisition));
}
return(PartialView("DistributorIndexgrid", ""));
}
private IGrid <TBL_BALANCE_TRANSFER_LOGS> CreateExportdDistributorGrid(string WhiteLevel, string SuperId, string Disid, string statusval)
{
var db = new DBContext();
var Adminrequisition = new List <TBL_BALANCE_TRANSFER_LOGS>();
if (WhiteLevel == "" && SuperId == "" && Disid == "" && statusval == "")
{
Adminrequisition = PowerAdminRquisitionReportModel.GetAllDistributorRequisitionReport("0", statusval);
}
else if (WhiteLevel == "" && SuperId == "" && Disid == "" && statusval != "")
{
Adminrequisition = PowerAdminRquisitionReportModel.GetAllDistributorRequisitionReport("0", statusval);
}
else if (statusval == "" && Disid == "" && WhiteLevel != "" && SuperId == "")
{
Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Disid, statusval);
}
else if (statusval != "" && Disid != "" && WhiteLevel != "" && SuperId != "")
{
Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Disid, statusval);
}
else if (WhiteLevel != "" && SuperId != "" && statusval == "" && Disid != "")
{
Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Disid, statusval);
}
else if (WhiteLevel != "" && SuperId != "" && statusval == "" && Disid == "")
{
Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(WhiteLevel, SuperId, Disid, statusval);
}
//else if (Disid != "" && statusval == "")
//{
// Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(Disid, statusval);
//}
//else if (Disid != "" && statusval != "")
//{
// Adminrequisition = PowerAdminRquisitionReportModel.GetDistributorRequisitionReport(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.REQUEST_TIME).Titled("Req Time").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);
}