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; }