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));
}
public PartialViewResult IndexGrid(string search = "", string Status = "")
{
initpage();
var db = new DBContext();
if (search == "" && Status == "")
{
var transactionlistvalue = DistributorTransactionReportModel.GetDistributorUnderAllRetailerCommission(MemberCurrentUser.MEM_ID.ToString(), Status);
return(PartialView("IndexGrid", transactionlistvalue));
}
else if (search == "" && Status != "")
{
var transactionlistvalue = DistributorTransactionReportModel.GetDistributorUnderAllRetailerCommission(MemberCurrentUser.MEM_ID.ToString(), Status);
return(PartialView("IndexGrid", transactionlistvalue));
}
else if (search != "" && Status != "")
{
var transactionlistvalue = DistributorTransactionReportModel.GetDistributorUnderRetailerCommission(search, Status);
return(PartialView("IndexGrid", transactionlistvalue));
}
else if (search != "" && Status == "")
{
var transactionlistvalue = DistributorTransactionReportModel.GetDistributorUnderRetailerCommission(search, Status);
return(PartialView("IndexGrid", transactionlistvalue));
}
else
{
return(PartialView("IndexGrid", ""));
}
//if (search != "")
//{
// if (Status == "Requisition") //Mobile Recharge, DMR
// {
// Status = "";
// }
// else
// {
// Status = Status;
// }
// long Mer_id = long.Parse(search.ToString());
// long SerialNo = 0;
// if (Status == "Mobile Recharge" || Status == "DMR")
// {
// var transactionlistvalue = (from x in db.TBL_ACCOUNTS
// join y in db.TBL_MASTER_MEMBER on x.MEM_ID equals y.MEM_ID
// where y.INTRODUCER == MemberCurrentUser.MEM_ID && (x.MEM_ID == Mer_id && x.TRANSACTION_TYPE == Status) || (x.MEM_ID == MemberCurrentUser.MEM_ID && x.TRANSACTION_TYPE == Status)
// select new
// {
// SLN = x.ACC_NO,
// MerchantName = y.UName,
// MemberType = x.MEMBER_TYPE,
// Trans_Type = x.TRANSACTION_TYPE,
// Trans_Date = x.TRANSACTION_DATE,
// DR_CR = x.DR_CR,
// Amount = x.AMOUNT,
// Narration = x.NARRATION,
// OpeningAmt = x.OPENING,
// Closing = x.CLOSING,
// CommissionAmt = x.COMM_AMT
// }).AsEnumerable().Select((z, index) => new TBL_ACCOUNTS
// {
// SerialNo = index + 1,
// ACC_NO = z.SLN,
// UserName = z.MerchantName,
// MEMBER_TYPE = z.MemberType,
// TRANSACTION_TYPE = z.Trans_Type,
// TRANSACTION_DATE = z.Trans_Date,
// DR_CR = z.DR_CR,
// AMOUNT = z.Amount,
// NARRATION = z.Narration,
// OPENING = z.OpeningAmt,
// CLOSING = z.Closing,
// COMM_AMT = z.CommissionAmt
// }).ToList();
// return PartialView("IndexGrid", transactionlistvalue);
// }
// else if (Status == "Requisition")
// {
// var transactionlistvalue = (from x in db.TBL_ACCOUNTS
// join y in db.TBL_MASTER_MEMBER on x.MEM_ID equals y.MEM_ID
// where y.INTRODUCER == MemberCurrentUser.MEM_ID && (x.MEM_ID == Mer_id && x.TRANSACTION_TYPE != "DMR" && x.TRANSACTION_TYPE != "Mobile Recharge") || (x.MEM_ID == MemberCurrentUser.MEM_ID && x.TRANSACTION_TYPE != "DMR" && x.TRANSACTION_TYPE != "Mobile Recharge")
// select new
// {
// SLN = x.ACC_NO,
// MerchantName = y.UName,
// MemberType = x.MEMBER_TYPE,
// Trans_Type = x.TRANSACTION_TYPE,
// Trans_Date = x.TRANSACTION_DATE,
// DR_CR = x.DR_CR,
// Amount = x.AMOUNT,
// Narration = x.NARRATION,
// OpeningAmt = x.OPENING,
// Closing = x.CLOSING,
// CommissionAmt = x.COMM_AMT
// }).AsEnumerable().Select((z, index) => new TBL_ACCOUNTS
// {
// SerialNo = index + 1,
// ACC_NO = z.SLN,
// UserName = z.MerchantName,
// MEMBER_TYPE = z.MemberType,
// TRANSACTION_TYPE = z.Trans_Type,
// TRANSACTION_DATE = z.Trans_Date,
// DR_CR = z.DR_CR,
// AMOUNT = z.Amount,
// NARRATION = z.Narration,
// OPENING = z.OpeningAmt,
// CLOSING = z.Closing,
// COMM_AMT = z.CommissionAmt
// }).ToList();
// return PartialView("IndexGrid", transactionlistvalue);
// }
// else
// {
// var transactionlistvalue = (from x in db.TBL_ACCOUNTS
// join y in db.TBL_MASTER_MEMBER on x.MEM_ID equals y.MEM_ID
// where y.INTRODUCER == MemberCurrentUser.MEM_ID && (x.MEM_ID == Mer_id) || (x.MEM_ID == MemberCurrentUser.MEM_ID)
// select new
// {
// SLN = x.ACC_NO,
// MerchantName = y.UName,
// MemberType = x.MEMBER_TYPE,
// Trans_Type = x.TRANSACTION_TYPE,
// Trans_Date = x.TRANSACTION_DATE,
// DR_CR = x.DR_CR,
// Amount = x.AMOUNT,
// Narration = x.NARRATION,
// OpeningAmt = x.OPENING,
// Closing = x.CLOSING,
// CommissionAmt = x.COMM_AMT
// }).AsEnumerable().Select((z, index) => new TBL_ACCOUNTS
// {
// SerialNo = index + 1,
// ACC_NO = z.SLN,
// UserName = z.MerchantName,
// MEMBER_TYPE = z.MemberType,
// TRANSACTION_TYPE = z.Trans_Type,
// TRANSACTION_DATE = z.Trans_Date,
// DR_CR = z.DR_CR,
// AMOUNT = z.Amount,
// NARRATION = z.Narration,
// OPENING = z.OpeningAmt,
// CLOSING = z.Closing,
// COMM_AMT = z.CommissionAmt
// }).ToList();
// return PartialView("IndexGrid", transactionlistvalue);
// }
//}
//else
//{
// if (Status == "Mobile Recharge" || Status == "DMR")
// {
// var transactionlistvalue = (from x in db.TBL_ACCOUNTS
// join y in db.TBL_MASTER_MEMBER on x.MEM_ID equals y.MEM_ID
// where y.INTRODUCER == MemberCurrentUser.MEM_ID && x.TRANSACTION_TYPE == Status
// select new
// {
// SLN = x.ACC_NO,
// MerchantName = y.UName,
// MemberType = x.MEMBER_TYPE,
// Trans_Type = x.TRANSACTION_TYPE,
// Trans_Date = x.TRANSACTION_DATE,
// DR_CR = x.DR_CR,
// Amount = x.AMOUNT,
// Narration = x.NARRATION,
// OpeningAmt = x.OPENING,
// Closing = x.CLOSING,
// CommissionAmt = x.COMM_AMT
// }).AsEnumerable().Select((z, index) => new TBL_ACCOUNTS
// {
// SerialNo = index + 1,
// ACC_NO = z.SLN,
// UserName = z.MerchantName,
// MEMBER_TYPE = z.MemberType,
// TRANSACTION_TYPE = z.Trans_Type,
// TRANSACTION_DATE = z.Trans_Date,
// DR_CR = z.DR_CR,
// AMOUNT = z.Amount,
// NARRATION = z.Narration,
// OPENING = z.OpeningAmt,
// CLOSING = z.Closing,
// COMM_AMT = z.CommissionAmt
// }).ToList();
// return PartialView("IndexGrid", transactionlistvalue);
// }
// else if (Status == "Requisition")
// {
// var transactionlistvalue = (from x in db.TBL_ACCOUNTS
// join y in db.TBL_MASTER_MEMBER on x.MEM_ID equals y.MEM_ID
// where y.INTRODUCER == MemberCurrentUser.MEM_ID && x.TRANSACTION_TYPE != "DMR" && x.TRANSACTION_TYPE != "Mobile Recharge"
// select new
// {
// SLN = x.ACC_NO,
// MerchantName = y.UName,
// MemberType = x.MEMBER_TYPE,
// Trans_Type = x.TRANSACTION_TYPE,
// Trans_Date = x.TRANSACTION_DATE,
// DR_CR = x.DR_CR,
// Amount = x.AMOUNT,
// Narration = x.NARRATION,
// OpeningAmt = x.OPENING,
// Closing = x.CLOSING,
// CommissionAmt = x.COMM_AMT
// }).AsEnumerable().Select((z, index) => new TBL_ACCOUNTS
// {
// SerialNo = index + 1,
// ACC_NO = z.SLN,
// UserName = z.MerchantName,
// MEMBER_TYPE = z.MemberType,
// TRANSACTION_TYPE = z.Trans_Type,
// TRANSACTION_DATE = z.Trans_Date,
// DR_CR = z.DR_CR,
// AMOUNT = z.Amount,
// NARRATION = z.Narration,
// OPENING = z.OpeningAmt,
// CLOSING = z.Closing,
// COMM_AMT = z.CommissionAmt
// }).ToList();
// return PartialView("IndexGrid", transactionlistvalue);
// }
// else
// {
// var transactionlistvalue = (from x in db.TBL_ACCOUNTS
// join y in db.TBL_MASTER_MEMBER on x.MEM_ID equals y.MEM_ID
// where y.INTRODUCER == MemberCurrentUser.MEM_ID || (x.MEM_ID == MemberCurrentUser.MEM_ID)
// select new
// {
// SLN = x.ACC_NO,
// MerchantName = y.UName,
// MemberType = x.MEMBER_TYPE,
// Trans_Type = x.TRANSACTION_TYPE,
// Trans_Date = x.TRANSACTION_DATE,
// DR_CR = x.DR_CR,
// Amount = x.AMOUNT,
// Narration = x.NARRATION,
// OpeningAmt = x.OPENING,
// Closing = x.CLOSING,
// CommissionAmt = x.COMM_AMT
// }).AsEnumerable().Select((z, index) => new TBL_ACCOUNTS
// {
// SerialNo = index + 1,
// ACC_NO = z.SLN,
// UserName = z.MerchantName,
// MEMBER_TYPE = z.MemberType,
// TRANSACTION_TYPE = z.Trans_Type,
// TRANSACTION_DATE = z.Trans_Date,
// DR_CR = z.DR_CR,
// AMOUNT = z.Amount,
// NARRATION = z.Narration,
// OPENING = z.OpeningAmt,
// CLOSING = z.Closing,
// COMM_AMT = z.CommissionAmt
// }).ToList();
// return PartialView("IndexGrid", transactionlistvalue);
// }
//}
//var transactionlistvalue = null;
}
