public JsonResult GetServiceProvider(string NewListId) { try { var db = new DBContext(); //var OperatorList = db.TBL_SERVICE_PROVIDERS.Where(x => x.TYPE.Contains(NewListId)); //return Json(""); string operatortype = string.Empty; string operatortype1 = string.Empty; string DTH = string.Empty; if (NewListId == "MOBILE RECHARGE") { NewListId = "MOBILE RECHARGE"; operatortype = "PREPAID"; operatortype1 = "POSTPAID"; DTH = "DTH"; var listinfo = db.TBL_SERVICE_PROVIDERS.Where(x => x.TYPE.StartsWith(operatortype) || x.TYPE.StartsWith(operatortype1) || x.TYPE.StartsWith(DTH)).ToList(); var OperatorList = (from x in db.TBL_SERVICE_PROVIDERS where x.TYPE == operatortype || x.TYPE == operatortype1 select new { ID = x.ID, SERVICE_NAME = x.SERVICE_NAME, TYPE = x.TYPE, SERVICE_KEY = x.SERVICE_KEY, BILLING_MODEL = x.BILLING_MODEL, HSN_SAC = x.HSN_SAC, TDS = x.TDS }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = z.SERVICE_NAME, TYPE = z.TYPE, SERVICE_KEY = z.SERVICE_KEY, BILLING_MODEL = z.BILLING_MODEL, HSN_SAC = z.HSN_SAC, TDS = z.TDS }).ToList(); CommissoinManagmentmodel objmodel = new CommissoinManagmentmodel(); objmodel.OperatorDetails = OperatorList.ToList(); return(Json(OperatorList, JsonRequestBehavior.AllowGet)); } else if (NewListId == "UTILITY SERVICES") { string Electricity = "ELECTRICITY"; string Broadband = "BROADBAND"; string GAS = "GAS"; string Landline = "LANDLINE"; string Dth = "DTH"; var OperatorList = (from x in db.TBL_SERVICE_PROVIDERS where x.TYPE.Contains(Dth) //where x.TYPE.Contains(Electricity) || x.TYPE.StartsWith(Broadband) || x.TYPE.StartsWith(GAS) || x.TYPE.StartsWith(Landline) || x.TYPE.StartsWith(Dth) select new { ID = x.ID, SERVICE_NAME = x.SERVICE_NAME, TYPE = x.TYPE, SERVICE_KEY = x.SERVICE_KEY, BILLING_MODEL = x.BILLING_MODEL, HSN_SAC = x.HSN_SAC, TDS = x.TDS }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = z.SERVICE_NAME, TYPE = z.TYPE, SERVICE_KEY = z.SERVICE_KEY, BILLING_MODEL = z.BILLING_MODEL, HSN_SAC = z.HSN_SAC, TDS = z.TDS }).ToList(); CommissoinManagmentmodel objmodel = new CommissoinManagmentmodel(); objmodel.OperatorDetails = OperatorList.ToList(); return(Json(OperatorList, JsonRequestBehavior.AllowGet)); } else if (NewListId == "DMR") { string Landline = "REMITTANCE"; var OperatorList = (from x in db.TBL_SERVICE_PROVIDERS where x.TYPE.Contains(Landline) && x.SERVICE_NAME == "Money Transfer (Domestic)" || x.SERVICE_NAME == "Money Transfer (Nepal)" select new { ID = x.ID, SERVICE_NAME = x.SERVICE_NAME, TYPE = x.TYPE, SERVICE_KEY = x.SERVICE_KEY, BILLING_MODEL = x.BILLING_MODEL, HSN_SAC = x.HSN_SAC, TDS = x.TDS }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = z.SERVICE_NAME, TYPE = z.TYPE, SERVICE_KEY = z.SERVICE_KEY, BILLING_MODEL = z.BILLING_MODEL, HSN_SAC = z.HSN_SAC, TDS = z.TDS }).ToList(); CommissoinManagmentmodel objmodel = new CommissoinManagmentmodel(); objmodel.OperatorDetails = OperatorList.ToList(); return(Json(OperatorList, JsonRequestBehavior.AllowGet)); } //else //{ //var OperatorList = (from x in db.TBL_SERVICE_PROVIDERS // where x.TYPE.Contains(NewListId) // select new // { // ID = x.ID, // SERVICE_NAME = x.SERVICE_NAME, // TYPE = x.TYPE, // SERVICE_KEY = x.SERVICE_KEY, // BILLING_MODEL = x.BILLING_MODEL, // HSN_SAC = x.HSN_SAC, // TDS = x.TDS // }).AsEnumerable().Select(z => new CommissionListView // { // ID = z.ID, // SERVICE_NAME = z.SERVICE_NAME, // TYPE = z.TYPE, // SERVICE_KEY = z.SERVICE_KEY, // BILLING_MODEL = z.BILLING_MODEL, // HSN_SAC = z.HSN_SAC, // TDS = z.TDS // }).ToList(); //CommissoinManagmentmodel objmodel = new CommissoinManagmentmodel(); //objmodel.OperatorDetails = OperatorList.ToList(); return(Json("")); //} } catch (Exception ex) { Logger.Error("Controller:- PowerAdminCommissionSlab(PowerAdmin), method:- GetServiceProvider (GET) Line No:- 825", ex); throw ex; } }
public async Task <JsonResult> FetchData(long idval) { try { var db = new DBContext(); if (Session["IDval"] != null && Session["IDval"] != "") { idval = long.Parse(Session["IDval"].ToString()); } else { idval = 0; } string slabtypename = string.Empty; var slabtype = await db.TBL_WHITE_LEVEL_COMMISSION_SLAB.Where(x => x.SLN == idval).FirstOrDefaultAsync(); if (slabtype != null) { if (slabtype.SLAB_TYPE == 1) { slabtypename = "MOBILE RECHARGE"; var valuelist = (from slabmaster in db.TBL_WHITE_LEVEL_COMMISSION_SLAB where slabmaster.SLN == idval select new { SLN = slabmaster.SLN, SLAB_NAME = slabmaster.SLAB_NAME, SLAB_DETAILS = slabmaster.SLAB_DETAILS, SLAB_TYPE = slabmaster.SLAB_TYPE, //Slab_TypeName = slabmaster.Slab_TypeName, SLAB_STATUS = slabmaster.SLAB_STATUS, OperatorDetails = (from slablist in db.TBL_COMM_SLAB_MOBILE_RECHARGE where slablist.SLAB_ID == idval select new { ID = slablist.SLN, SERVICE_NAME = slablist.OPERATOR_NAME, TYPE = slablist.OPERATOR_TYPE, SERVICE_KEY = slablist.OPERATOR_CODE, CommissionPercentage = slablist.COMM_PERCENTAGE }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = z.SERVICE_NAME, TYPE = z.TYPE, SERVICE_KEY = z.SERVICE_KEY, CommissionPercentage = z.CommissionPercentage.ToString() }).ToList() }).AsEnumerable().Select(d => new CommissoinManagmentmodel { SLN = d.SLN, SLAB_NAME = d.SLAB_NAME, SLAB_DETAILS = d.SLAB_DETAILS, Slab_TypeName = slabtypename, SLAB_STATUS = d.SLAB_STATUS, SLAB_TYPE = d.SLAB_TYPE, OperatorDetails = d.OperatorDetails }); return(Json(valuelist, JsonRequestBehavior.AllowGet)); } else if (slabtype.SLAB_TYPE == 2) { slabtypename = "UTILITY SERVICES"; var valuelist = (from slabmaster in db.TBL_WHITE_LEVEL_COMMISSION_SLAB where slabmaster.SLN == idval select new { SLN = slabmaster.SLN, SLAB_NAME = slabmaster.SLAB_NAME, SLAB_DETAILS = slabmaster.SLAB_DETAILS, SLAB_TYPE = slabmaster.SLAB_TYPE, //Slab_TypeName = slabmaster.Slab_TypeName, SLAB_STATUS = slabmaster.SLAB_STATUS, OperatorDetails = (from slablist in db.TBL_COMM_SLAB_UTILITY_RECHARGE where slablist.SLAB_ID == idval select new { ID = slablist.SLN, SERVICE_NAME = slablist.OPERATOR_NAME, TYPE = slablist.OPERATOR_TYPE, SERVICE_KEY = slablist.OPERATOR_CODE, CommissionPercentage = slablist.COMM_PERCENTAGE }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = z.SERVICE_NAME, TYPE = z.TYPE, SERVICE_KEY = z.SERVICE_KEY, CommissionPercentage = z.CommissionPercentage.ToString() }).ToList() }).AsEnumerable().Select(d => new CommissoinManagmentmodel { SLN = d.SLN, SLAB_NAME = d.SLAB_NAME, SLAB_DETAILS = d.SLAB_DETAILS, Slab_TypeName = slabtypename, SLAB_STATUS = d.SLAB_STATUS, SLAB_TYPE = d.SLAB_TYPE, OperatorDetails = d.OperatorDetails }); return(Json(valuelist, JsonRequestBehavior.AllowGet)); } else if (slabtype.SLAB_TYPE == 3) { slabtypename = "DMR"; var valuelist = (from slabmaster in db.TBL_WHITE_LEVEL_COMMISSION_SLAB where slabmaster.SLN == idval select new { SLN = slabmaster.SLN, SLAB_NAME = slabmaster.SLAB_NAME, SLAB_DETAILS = slabmaster.SLAB_DETAILS, SLAB_TYPE = slabmaster.SLAB_TYPE, //Slab_TypeName = slabmaster.Slab_TypeName, SLAB_STATUS = slabmaster.SLAB_STATUS, OperatorDetails = (from slablist in db.TBL_COMM_SLAB_DMR_PAYMENT where slablist.SLAB_ID == idval && slablist.DMT_TYPE == "DOMESTIC" select new { ID = slablist.SLN, SERVICE_NAME = "Money Transfer (Domestic)", TYPE = "REMITTANCE", DMRFrom = slablist.SLAB_FROM, DMRTo = slablist.SLAB_TO, SERVICE_KEY = "DMI", COMM_TYPE = slablist.COMM_TYPE, CommissionPercentage = slablist.COMM_PERCENTAGE }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = "Money Transfer (Domestic)", TYPE = "REMITTANCE", DMRFrom = z.DMRFrom, DMRTo = z.DMRTo, SERVICE_KEY = "DMI", COMM_TYPE = z.COMM_TYPE, CommissionPercentage = z.CommissionPercentage.ToString() }).ToList(), ServiceInformationDMR = (from slablist in db.TBL_COMM_SLAB_DMR_PAYMENT where slablist.SLAB_ID == idval && slablist.DMT_TYPE == "FOREIGN" select new { ID = slablist.SLN, SERVICE_NAME = "Money Transfer (Nepal)", TYPE = "REMITTANCE", DMRFrom = slablist.SLAB_FROM, DMRTo = slablist.SLAB_TO, SERVICE_KEY = "PMT", COMM_TYPE = slablist.COMM_TYPE, CommissionPercentage = slablist.COMM_PERCENTAGE }).AsEnumerable().Select(z => new CommissionListView { ID = z.ID, SERVICE_NAME = "Money Transfer (Nepal)", TYPE = "REMITTANCE", DMRFrom = z.DMRFrom, DMRTo = z.DMRTo, SERVICE_KEY = "PMT", COMM_TYPE = z.COMM_TYPE, CommissionPercentage = z.CommissionPercentage.ToString() }).ToList() }).AsEnumerable().Select(d => new CommissoinManagmentmodel { SLN = d.SLN, SLAB_NAME = d.SLAB_NAME, SLAB_DETAILS = d.SLAB_DETAILS, Slab_TypeName = slabtypename, SLAB_STATUS = d.SLAB_STATUS, SLAB_TYPE = d.SLAB_TYPE, OperatorDetails = d.OperatorDetails, ServiceInformationDMR = d.ServiceInformationDMR }); return(Json(valuelist, JsonRequestBehavior.AllowGet)); } } else { CommissoinManagmentmodel objmodel = new CommissoinManagmentmodel(); return(Json(objmodel, JsonRequestBehavior.AllowGet)); } return(Json("")); } catch (Exception ex) { Logger.Error("Controller:- PowerAdminCommissionSlab(PowerAdmin), method:- FetchData (GET) Line No:- 393", ex); throw; } }
//public ActionResult AddCommissionSlab(TBL_WHITE_LEVEL_COMMISSION_SLAB objval) public async Task <JsonResult> AddCommissionSlab(CommissoinManagmentmodel objval) { var db = new DBContext(); using (System.Data.Entity.DbContextTransaction ContextTransaction = db.Database.BeginTransaction()) { string OperatorName = Request.Form["singleSelectName"]; string operatorId = Request.Form["singleSelect"]; try { long slnid = 0; if (Session["IDval"] != null) { slnid = long.Parse(Session["IDval"].ToString()); Session["IDval"] = null; Session["IDval"] = ""; Session.Remove("IDval"); //Session.Abandon(); } else { slnid = 0; } //string OperatorName = Request.Form["OperatorName"]; //string ServiceId = Request.Form["ServiceTypeId"]; //long Serv_ID = long.Parse(ServiceId); var checkid = await db.TBL_WHITE_LEVEL_COMMISSION_SLAB.Where(x => x.SLN == slnid).FirstOrDefaultAsync(); if (checkid != null) { checkid.SLAB_NAME = objval.SLAB_NAME; checkid.SLAB_DETAILS = objval.SLAB_DETAILS; checkid.SLAB_STATUS = objval.SLAB_STATUS; db.Entry(checkid).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); ContextTransaction.Commit(); if (objval.Slab_TypeName == "MOBILE RECHARGE") { foreach (var moblist in objval.OperatorDetails) { var mob = await db.TBL_COMM_SLAB_MOBILE_RECHARGE.Where(x => x.SLN == moblist.ID).FirstOrDefaultAsync(); if (mob != null) { mob.COMM_PERCENTAGE = Convert.ToDecimal(moblist.CommissionPercentage); db.Entry(mob).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } } } else if (objval.Slab_TypeName == "UTILITY SERVICES") { foreach (var moblist in objval.OperatorDetails) { var mob = await db.TBL_COMM_SLAB_UTILITY_RECHARGE.Where(x => x.SLN == moblist.ID).FirstOrDefaultAsync(); if (mob != null) { mob.COMM_PERCENTAGE = Convert.ToDecimal(moblist.CommissionPercentage); db.Entry(mob).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } } } else if (objval.Slab_TypeName == "DMR") { foreach (var item in objval.OperatorDetails) { var DMRDomestic = await db.TBL_COMM_SLAB_DMR_PAYMENT.Where(x => x.SLN == item.ID).FirstOrDefaultAsync(); if (DMRDomestic != null) { DMRDomestic.SLAB_FROM = item.DMRFrom; DMRDomestic.SLAB_TO = item.DMRTo; DMRDomestic.COMM_PERCENTAGE = Convert.ToDecimal(item.CommissionPercentage); db.Entry(DMRDomestic).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } } if (objval.ServiceInformationDMR != null) { foreach (var item in objval.ServiceInformationDMR) { if (item.DMRTo > 0) { var DMRForeign = await db.TBL_COMM_SLAB_DMR_PAYMENT.Where(x => x.SLN == item.ID).FirstOrDefaultAsync(); if (DMRForeign != null) { DMRForeign.SLAB_FROM = item.DMRFrom; DMRForeign.SLAB_TO = item.DMRTo; DMRForeign.COMM_PERCENTAGE = Convert.ToDecimal(item.CommissionPercentage); db.Entry(DMRForeign).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } } } } } ViewBag.msg = "One Record Updated..."; Session["IDval"] = null; Session["IDval"] = ""; Session.Remove("IDval"); //Session.Abandon(); return(Json(new { Result = "Updated" })); } else { TBL_WHITE_LEVEL_COMMISSION_SLAB objslabmaster = new TBL_WHITE_LEVEL_COMMISSION_SLAB() { SLAB_NAME = objval.SLAB_NAME, SLAB_DETAILS = objval.SLAB_DETAILS, SLAB_STATUS = objval.SLAB_STATUS, SLAB_TYPE = objval.SLAB_TYPE, DATE_CREATED = DateTime.Now, MEM_ID = 0 }; db.TBL_WHITE_LEVEL_COMMISSION_SLAB.Add(objslabmaster); await db.SaveChangesAsync(); if (objval.Slab_TypeName == "MOBILE RECHARGE") { foreach (var item in objval.OperatorDetails) { TBL_COMM_SLAB_MOBILE_RECHARGE objcommobile = new TBL_COMM_SLAB_MOBILE_RECHARGE() { SLAB_ID = objslabmaster.SLN, MEM_ID = 0, OPERATOR_CODE = item.SERVICE_KEY, OPERATOR_NAME = item.SERVICE_NAME, OPERATOR_TYPE = item.TYPE, COMM_TYPE = "PERCENTAGE", COMM_PERCENTAGE = Convert.ToDecimal(item.CommissionPercentage), COMM_STATUS = true, CREATED_DATE = DateTime.Now }; db.TBL_COMM_SLAB_MOBILE_RECHARGE.Add(objcommobile); await db.SaveChangesAsync(); } } else if (objval.Slab_TypeName == "UTILITY SERVICES") { foreach (var item in objval.OperatorDetails) { TBL_COMM_SLAB_UTILITY_RECHARGE objcomutility = new TBL_COMM_SLAB_UTILITY_RECHARGE() { SLAB_ID = objslabmaster.SLN, MEM_ID = 0, OPERATOR_CODE = item.SERVICE_KEY, OPERATOR_NAME = item.SERVICE_NAME, OPERATOR_TYPE = item.TYPE, COMM_TYPE = "PERCENTAGE", COMM_PERCENTAGE = Convert.ToDecimal(item.CommissionPercentage), COMM_STATUS = true, CREATED_DATE = DateTime.Now }; db.TBL_COMM_SLAB_UTILITY_RECHARGE.Add(objcomutility); await db.SaveChangesAsync(); } } else if (objval.Slab_TypeName == "DMR") { foreach (var item in objval.OperatorDetails) { TBL_COMM_SLAB_DMR_PAYMENT objcomDMR = new TBL_COMM_SLAB_DMR_PAYMENT() { SLAB_ID = objslabmaster.SLN, MEM_ID = 0, SLAB_FROM = item.DMRFrom, SLAB_TO = item.DMRTo, COMM_TYPE = item.COMM_TYPE, COMM_PERCENTAGE = Convert.ToDecimal(item.CommissionPercentage), COMM_STATUS = true, DMT_TYPE = "DOMESTIC", CREATED_DATE = DateTime.Now }; db.TBL_COMM_SLAB_DMR_PAYMENT.Add(objcomDMR); await db.SaveChangesAsync(); } if (objval.ServiceInformationDMR != null) { foreach (var item in objval.ServiceInformationDMR) { if (item.DMRTo > 0) { TBL_COMM_SLAB_DMR_PAYMENT objcomDMRInter = new TBL_COMM_SLAB_DMR_PAYMENT() { SLAB_ID = objslabmaster.SLN, MEM_ID = 0, SLAB_FROM = item.DMRFrom, SLAB_TO = item.DMRTo, COMM_TYPE = item.COMM_TYPE, COMM_PERCENTAGE = Convert.ToDecimal(item.CommissionPercentage), COMM_STATUS = true, DMT_TYPE = "FOREIGN", CREATED_DATE = DateTime.Now }; db.TBL_COMM_SLAB_DMR_PAYMENT.Add(objcomDMRInter); await db.SaveChangesAsync(); } } } } ContextTransaction.Commit(); //ViewBag.msg = "One Record Inserted..."; Session["IDval"] = null; Session["IDval"] = ""; Session.Remove("IDval"); //Session.Abandon(); return(Json(new { Result = "Success" })); } } catch (Exception ex) { Logger.Error("Controller:- PowerAdminCommissionSlab(PowerAdmin), method:- AddCommissionSlab (GET) Line No:- 641", ex); ContextTransaction.Rollback(); throw ex; } } }
public ActionResult AddCommissionSlab(string SlabId = "") { initpage(); if (Session["PowerAdminUserId"] != null) { try { if (Request.QueryString["Operatortype"] != null) { } if (SlabId != "") { string decriptval = Decrypt.DecryptMe(SlabId.ToString()); long SlabIdVal = long.Parse(decriptval); Session["IDval"] = SlabIdVal; var db = new DBContext(); ////var listSlab = db.TBL_WHITE_LEVEL_COMMISSION_SLAB.FirstOrDefault(x => x.SLN == SlabIdVal); //var listSlab = (from x in db.TBL_WHITE_LEVEL_COMMISSION_SLAB // join y in db.TBL_SETTINGS_SERVICES_MASTER on x.SLAB_TYPE equals y.SLN // where x.SLN == SlabIdVal // select new // { // SLAB_NAME = x.SLAB_NAME, // SLAB_DETAILS=x.SLAB_DETAILS, // Slab_TypeName=y.SERVICE_NAME, // SLAB_STATUS=x.SLAB_STATUS, // SLAB_TYPE=x.SLAB_TYPE, // }).AsEnumerable().Select(z=> new TBL_WHITE_LEVEL_COMMISSION_SLAB // { // SLAB_NAME=z.SLAB_NAME, // SLAB_DETAILS=z.SLAB_DETAILS, // Slab_TypeName=z.Slab_TypeName, // SLAB_STATUS=z.SLAB_STATUS, // SLAB_TYPE=z.SLAB_TYPE // }).FirstOrDefault(); //ViewBag.checkStatus = "1"; //var memberService = (from x in db.TBL_SETTINGS_SERVICES_MASTER // select new // { // MEM_ID = x.SLN, // UName = x.SERVICE_NAME // }).AsEnumerable().Select(z => new MemberView // { // IDValue = Encrypt.EncryptMe(z.MEM_ID.ToString()), // TextValue = z.UName // }).ToList().Distinct(); //return View(listSlab); return(View()); } else { CommissoinManagmentmodel objmodel = new CommissoinManagmentmodel(); objmodel.OperatorDetails = null; Session["IDval"] = null; Session["IDval"] = null; Session.Remove("IDval"); Session.Remove("IDval"); ViewBag.checkStatus = "0"; return(View()); } } catch (Exception ex) { Logger.Error("Controller:- PowerAdminCommissionSlab(PowerAdmin), method:- AddCommissionSlab (GET) Line No:- 210", ex); return(RedirectToAction("Exception", "ErrorHandler", new { area = "" })); throw ex; } } else { Session["PowerAdminUserId"] = null; Session["PowerAdminUserName"] = null; Session["UserType"] = null; Session.Remove("PowerAdminUserId"); Session.Remove("PowerAdminUserName"); Session.Remove("UserType"); Response.Redirect(Url.Action("Index", "PowerAdminLogin", new { area = "PowerAdmin" })); return(View()); } }