public IActionResult ListPlans() { using (var db = new MotiveOfficeDBContext()) { db.PhonePlans.Load(); return(View(db.PhonePlans.ToArray())); } }
public IActionResult Registration(DbUser u) { using (var db = new MotiveOfficeDBContext()) { db.Users.Add(u); db.SaveChanges(); } return(View("Index")); }
public IActionResult ShowPlan() { using (var db = new MotiveOfficeDBContext()) { db.Users.Load(); db.PhonePlans.Load(); var user = db.Users.Find(getId()); return(View(user.Plan)); } }
public IActionResult ReplenishmentCosts() { if (HttpContext.Session.Get("id") == null) { return(View(new List <Transaction>())); } using (var db = new MotiveOfficeDBContext()) { var user = db.Users.Find(getId()); db.Transactions.Load(); return(View(user.Transactions)); } }
public IActionResult ChangeTarif(int id) { using (var db = new MotiveOfficeDBContext()) { db.Users.Load(); db.PhonePlans.Load(); var user = db.Users.Find(getId()); user.PlanCode = id; user.Plan = db.PhonePlans.Find(id); db.SaveChanges(); return(View("logged", user)); } }
public IActionResult UserServices() { if (HttpContext.Session.Get("id") == null) { return(View(Tuple.Create(new Service[0], new DbService[0]))); } using (var db = new MotiveOfficeDBContext()) { var user = db.Users.Find(getId()); db.DbServices.Load(); db.Services.Load(); return(View(Tuple.Create(db.Services.ToArray(), user.Services?.ToArray() ?? new DbService[0]))); } }
public IActionResult Index() { if (HttpContext.Session.Get("id") == null) //return View(Tuple.Create(new Service[0], new DbService[0])); { return(View("Login")); } else { using (var db = new MotiveOfficeDBContext()) { db.PhonePlans.Load(); return(View("logged", db.Users.Find(getId()))); } }//return View("logged", ) }
public IActionResult AskQuestion(string answ, string passwordHash, int id) { using (var db = new MotiveOfficeDBContext()) { db.Users.Load(); var user = db.Users.Find(id); if (user.SecretAnswer == answ) { user.PasswordHash = passwordHash; db.SaveChanges(); return(View("index")); } return(View("BadLogin")); } }
public IActionResult Question(string forgottenPhone) { using (var db = new MotiveOfficeDBContext()) { db.Users.Load(); DbUser user; try { user = db.Users.First(u => u.PhoneNumber == forgottenPhone); } catch { return(View("BadLogin")); } return(View("QuestionDropPassword", user)); } }
public HomeController(ILogger <HomeController> logger) { _logger = logger; using (var db = new MotiveOfficeDBContext()) { //db.Users.Load(); /*var tr = new Transaction(DateTime.Now, 20, "") {UserId = 1}; * * db.PhonePlans.Add(new PhonePlan("190", 0, null, 1.8, null, 1.8, 0, 1.8, null, 6, 190, 200)); * * var dbUser = db.Users.Find(1); * db.Transactions.Add(tr); * dbUser.Transactions.Add(tr); * db.SaveChanges();*/ } }
public IActionResult Login(string phone, string passwordHash) { using (var db = new MotiveOfficeDBContext()) { db.Users.Load(); db.PhonePlans.Load(); DbUser user; try { user = db.Users.First(u => u.PhoneNumber == phone && u.PasswordHash == passwordHash); } catch { return(View("BadLogin")); } HttpContext.Session.Set("name", Encoding.Default.GetBytes(user.Name)); db.Transactions.Load(); setId(user.Id); return(View("logged", user)); } }
public IActionResult UpdateServices(int[] service) { using (var db = new MotiveOfficeDBContext()) { db.Users.Load(); db.DbServices.Load(); var i = 0; DbUser user; try { user = db.Users.Find(getId()); var list = new List <DbService>(); if (user.Services != null) { user.Services.Clear(); db.SaveChanges(); } foreach (var e in service) { db.DbServices.Add(new DbService() { UserId = user.Id, Id = ++i, ServiceId = e }); //list.Add(new DbService() {UserId = user.Id, ServiceId = e }); //user.Services.Append(new DbService() {UserId = user.Id, ServiceId = e }); } //else user.Services = new System.Collections.ObjectModel.Collection<DbService>(list); db.SaveChanges(); } catch (Exception e) { return(View("BadLogin")); } return(View("index")); } }