private IGrid <TBL_ACCOUNTS> CreateExportOnlyDistributorTableGrid(string statusval)
{
var db = new DBContext();
//var MerchantList = new List<TBL_ACCOUNTS>();
var MerchantList = DistributorTransactionReportModel.GetDistributorCommission(MemberCurrentUser.MEM_ID.ToString(), statusval);
IGrid <TBL_ACCOUNTS> grid = new Grid <TBL_ACCOUNTS>(MerchantList);
grid.ViewContext = new ViewContext {
HttpContext = HttpContext
};
grid.Query = Request.QueryString;
grid.Columns.Add(model => model.SerialNo).Titled("Sln No.");
grid.Columns.Add(model => model.UserName).Titled("User Name");
//grid.Columns.Add(model => model.MEMBER_TYPE).Titled("Merchant Type");
grid.Columns.Add(model => model.TRANSACTION_TYPE).Titled("Transaction Type");
grid.Columns.Add(model => model.TRANSACTION_DATE).Titled("Transaction Date").Formatted("{0:d}");
grid.Columns.Add(model => model.DR_CR).Titled("DR/CR");
grid.Columns.Add(model => model.AMOUNT).Titled("Amount");
//grid.Columns.Add(model => model.NARRATION).Titled("Narration");
grid.Columns.Add(model => model.OPENING).Titled("Opening");
grid.Columns.Add(model => model.CLOSING).Titled("Closing");
grid.Columns.Add(model => model.COMM_AMT).Titled("Commission Amt.");
grid.Pager = new GridPager <TBL_ACCOUNTS>(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 DistributorCommissionGrid(string search = "", string Status = "")
{
var transactionlistvalue = DistributorTransactionReportModel.GetDistributorCommission(MemberCurrentUser.MEM_ID.ToString(), Status);
return(PartialView("DistributorCommissionGrid", transactionlistvalue));
}
