public Startup(IConfiguration configuration) { Configuration = configuration; using (var client = new PlanContext()) { client.Database.EnsureCreated(); try { Rodzaj_uzytkownika rodzaj_Uzytkownika = new Rodzaj_uzytkownika(); rodzaj_Uzytkownika.rodzajuzytkownikaId = 1; rodzaj_Uzytkownika.rodzajuzytkownika = "Admin"; client.Rodzaj_uzytkownika.Add(rodzaj_Uzytkownika); client.SaveChanges(); Uzytkownik uzytkownik = new Uzytkownik(); uzytkownik.rodzajuzytkownikaId = 1; uzytkownik.login = "******"; uzytkownik.haslo = "1234"; uzytkownik.rodzajuzytkownikaId = 1; client.Uzytkownik.Add(uzytkownik); client.SaveChanges(); } catch (Exception) { } } }
public ActionResult Create(Plan plan) { if (ModelState.IsValid) { db.Plans.Add(plan); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(plan)); }
public ActionResult Create([Bind(Include = "Id,Note,Date")] Plan plan) { if (ModelState.IsValid) { db.Plans.Add(plan); db.SaveChanges(); return(RedirectToAction("AllNote")); } return(View(plan)); }
public ActionResult Create(Plan model) { Plan plan = new Plan { Title = model.Title, Description = model.Description, Date = model.Date, Img = model.Img, IsPriority = false }; _context.Plans.Add(plan); _context.SaveChanges(); return(RedirectToAction("ListPlans")); }
public IActionResult RegisterUser(RegUser newRegUser) { if (ModelState.IsValid) { User current = _context.Users.SingleOrDefault(e => e.Email == newRegUser.Email); if (current != null) { ModelState.AddModelError("Email", "Email already exists!"); return(View("Index")); } else { PasswordHasher <RegUser> Hasher = new PasswordHasher <RegUser>(); string hashed = Hasher.HashPassword(newRegUser, newRegUser.Password); User user = new User // Creating a new User using the info provided by the user via the form { FirstName = newRegUser.FirstName, LastName = newRegUser.LastName, Email = newRegUser.Email, Password = hashed, }; _context.Add(user); _context.SaveChanges(); User sessionuser = _context.Users.Where(u => u.Email == newRegUser.Email).SingleOrDefault(); HttpContext.Session.SetInt32("userID", sessionuser.UserId); HttpContext.Session.SetString("firstname", sessionuser.FirstName); return(RedirectToAction("Dash")); } } else { return(View("Index")); } }
public IActionResult RegisterUser(RegUser newRegUser) // This Method takes in a parameter of newRegUser { if (ModelState.IsValid) // There are NO errors { User current = _context.Users.SingleOrDefault(e => e.Email == newRegUser.Email); // Query to check if there is an existing email if (current != null) // If the results come up with something... { ModelState.AddModelError("Email", "Email already exists!"); // ...An email exists and renders the Index View // This is an example of another way to add errors without using ViewBag // The parameters: ModelState.AddModelError("The attribute NAME on the form where you want to put it", "Error Message"); return(View("Index")); } else // If email does not exist in the database yet... { PasswordHasher <RegUser> Hasher = new PasswordHasher <RegUser>(); // This will hash the password string hashed = Hasher.HashPassword(newRegUser, newRegUser.Password); // This will take in the user's given password and hash it User user = new User // Creating a new User using the info provided by the user via the form { FirstName = newRegUser.FirstName, LastName = newRegUser.LastName, Email = newRegUser.Email, Password = hashed, }; _context.Add(user); // Instant Query to ADD! _context.SaveChanges(); // Query to Save Changes User sessionuser = _context.Users.Where(u => u.Email == newRegUser.Email).SingleOrDefault(); // Model User has a variable sessionuser that contains the query of getting the new user's email to gain access to their other info HttpContext.Session.SetInt32("userID", sessionuser.UserId); // Setting userID to hold onto the user's UserId while in session HttpContext.Session.SetString("firstname", sessionuser.FirstName); // Setting firstname to hold th user's FirstName while in session return(RedirectToAction("Dash")); // Goes to the Method named Dash } } else // If there ARE errors present... { return(View("Index")); // ...Go back to the Index view // When you want to show errors, DO NOT Redirect! } }
public PlanViewModels(PlanType type, List <DateTime> dates) { if (dates == null) { return; } this.type = type; this.dates = dates; db = new PlanContext(); switch (type) { case PlanType.ГГПЗ: db.PlanGGPZ.Load(); { List <PlanGGPZ> planDatas = db.PlanGGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanGGPZ.Add(new PlanGGPZ() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanGGPZ = db.PlanGGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.НГП: db.PlanNGP.Load(); { List <PlanNGP> planDatas = db.PlanNGP.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanNGP.Add(new PlanNGP() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanNGP = db.PlanNGP.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.ЮПГПЗ: db.PlanYPGPZ.Load(); { List <PlanYPGPZ> planDatas = db.PlanYPGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanYPGPZ.Add(new PlanYPGPZ() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanYPGPZ = db.PlanYPGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.ЮБГПЗ: db.PlanYBGPZ.Load(); { List <PlanYBGPZ> planDatas = db.PlanYBGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanYBGPZ.Add(new PlanYBGPZ() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanYBGPZ = db.PlanYBGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.МГПЗ: db.PlanMGPZ.Load(); { List <PlanMGPZ> planDatas = db.PlanMGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanMGPZ.Add(new PlanMGPZ() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanMGPZ = db.PlanMGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.ВГПЗ: db.PlanVGPZ.Load(); { List <PlanVGPZ> planDatas = db.PlanVGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanVGPZ.Add(new PlanVGPZ() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanVGPZ = db.PlanVGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.НВГПК: db.PlanNVGPK.Load(); { List <PlanNVGPK> planDatas = db.PlanNVGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanNVGPK.Add(new PlanNVGPK() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanNVGPK = db.PlanNVGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; case PlanType.БГПК: db.PlanBGPK.Load(); { List <PlanBGPK> planDatas = db.PlanBGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); foreach (DateTime dateTime in dates) { if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime)) { db.PlanBGPK.Add(new PlanBGPK() { Date = dateTime.ToLongDateString() }); } } } db.SaveChanges(); PlanBGPK = db.PlanBGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList(); break; } }