public ActionResult AdminResellers()
{
using (eponym_app_licenseEntities db = new eponym_app_licenseEntities())
{
var users = db.UserDetails.Where(x => x.UserRole == "reseller").ToList();
var settings = db.AppSettings.ToList();
var algo = db.AlgoExpiries.ToList();
List <ResellerViewModel> lst = new List <ResellerViewModel>();
foreach (var item in users)
{
var auser = algo.Where(x => x.CustomerID == item.Id).FirstOrDefault();
var amount = settings.Where(x => x.ResellerId == item.Id).FirstOrDefault();
ResellerViewModel obj = new ResellerViewModel();
if (amount != null)
{
obj.CustomerID = item.Id;
obj.AppName = auser != null ? auser.AppName : "N/A";
obj.emailid = item.emailid;
obj.DateExpiry = auser != null ? auser.DateExpiry : "N/A";
obj.DeviceID = auser != null ? auser.DeviceID : "N/A";
obj.CustomerName = item.Name;
obj.City = item.City;
obj.Password = item.Password;
obj.State = item.State;
obj.Mobile = item.Mobile;
obj.ResellerAmount = amount.Amount;
}
lst.Add(obj);
}
ViewBag.lstResellers = lst;
}
return(View());
}
public JsonResult UpdateReseller(ResellerViewModel categoryVM)
{
try
{
if (categoryVM != null)
{
if (!string.IsNullOrEmpty(categoryVM.emailid))
{
if (IsUserExists(categoryVM.emailid, categoryVM.CustomerID))
{
return(Json(new { data = false, status = "Duplicate" }, JsonRequestBehavior.AllowGet));
}
else
{
using (eponym_app_licenseEntities db = new eponym_app_licenseEntities())
{
var user = db.UserDetails.Find(categoryVM.CustomerID);
user.City = categoryVM.City;
user.Password = categoryVM.Password;
user.State = categoryVM.State;
user.emailid = categoryVM.emailid;
user.Mobile = categoryVM.Mobile;
user.Name = categoryVM.CustomerName;
user.ResellerId = categoryVM.CustomerID;
var algo = db.AlgoExpiries.Where(x => x.CustomerID == categoryVM.CustomerID).FirstOrDefault();
if (algo != null)
{
DateTime date = DateTime.ParseExact(categoryVM.DateExpiry.Replace("-", "/"), "dd/MM/yyyy", CultureInfo.InvariantCulture);
algo.DateExpiry = date.ToString("dd-MM-yyyy");
algo.DeviceID = categoryVM.DeviceID;
}
var setting = db.AppSettings.Where(x => x.ResellerId == categoryVM.CustomerID).FirstOrDefault();
if (setting != null)
{
setting.Amount = categoryVM.ResellerAmount;
}
db.SaveChanges();
}
}
}
}
return(Json(new { data = true, status = "Success", error = "An Error Occurred" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = false, status = "Failed", error = ex.Message.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditReseller(int id)
{
try
{
ResellerViewModel obj = new ResellerViewModel();
if (id > 0)
{
using (eponym_app_licenseEntities db = new eponym_app_licenseEntities())
{
var users = db.UserDetails.Where(x => x.Id == id).FirstOrDefault();
var algo = db.AlgoExpiries.ToList();
var amount = db.AppSettings.FirstOrDefault(x => x.ResellerId == id).Amount;
if (users != null)
{
var pay = algo.Where(x => x.CustomerID == users.Id).FirstOrDefault();
obj.CustomerID = users.Id;
obj.AppName = pay != null ? pay.AppName : "";
obj.DateExpiry = pay != null ? pay.DateExpiry : "";
obj.DeviceID = pay != null ? pay.DeviceID : "";
obj.MaxUser = pay != null ? pay.MaxUser : "";
obj.CustomerName = users.Name;
obj.emailid = users.emailid;
obj.City = users.City;
obj.Password = users.Password;
obj.State = users.State;
obj.ResellerAmount = amount;
obj.Mobile = users.Mobile;
}
}
}
return(View(obj));
}
catch (Exception ex)
{
}
return(View());
}
