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