[ValidateAntiForgeryToken] // การป้องกัน Hacker Post ข้อมูลเปลี่ยนแปลงข้อมูล Model public IActionResult Create(AccountClass ac) { _cc.Add(ac); _cc.SaveChanges(); ViewBag.message = "The record " + ac.acc_firstname + " is saved Successfully!"; return(View()); }
public IActionResult Create(EmpClass ec) { _cc.Add(ec); _cc.SaveChanges(); // ViewBag.message = "REcord" + ec.Name + "Is sucess"; return(View()); }
public IActionResult Create(CarsClass sc) { _cc.Add(sc); _cc.SaveChanges(); ViewBag.message = "Order for " + sc.CarMake + " " + sc.CarModel + " has been placed"; return(View()); }
public IActionResult Create(SurveyClass sc) { _cc.Add(sc); _cc.SaveChanges(); ViewBag.message = "The Record is saved successfully"; return(View()); }
public IActionResult Create(EmpClass ec) { _cc.Add(ec); _cc.SaveChanges(); ViewBag.message = "The record" + ec.EmpName + "is saved"; return(View()); }
public IActionResult Save(Employee employee, int ID) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("ToLogin", "Account")); } if (User.IsInRole("Administrator")) { Employee ep = _cc.Employee.Find(ID) != null?_cc.Employee.Find(ID) : employee; PropertyInfo[] props = typeof(Employee).GetProperties(); var subgroup = props.Where(p => !p.Name.Contains("EmployeeKey") && !p.Name.Contains("SupervisorKey") && p.CanWrite); foreach (PropertyInfo property in subgroup) { property.SetValue(ep, property.GetValue(employee) != null ? property.GetValue(employee) : ""); } if (_cc.Supervisor.Any(s => s.SupervisorID == ep.SupervisorID)) { ep.SupervisorKey = _cc.Supervisor.Where(s => s.SupervisorID == ep.SupervisorID).First().SupervisorKey; } else { ModelState.AddModelError(string.Empty, $"No supervisor found for {ep.SupervisorID} Supervisor ID."); } if (_cc.Employee.Any(e => e.EmployeeID == ep.EmployeeID && e.EmployeeKey != ep.EmployeeKey)) { ModelState.AddModelError(string.Empty, $"Another employee already exists for {ep.EmployeeID} Employee ID."); } if (ModelState.IsValid == true) { if (_cc.Employee.Find(ID) == null) { _cc.Employee.Add(ep); } _cc.SaveChanges(); return(RedirectToAction("Index", "Employees")); } return(View("New", ep)); } else { return(RedirectToAction("Index", "Home")); } }
public IActionResult Create(EmpClass ec) { conn.Add(ec); // bug here inner bug conn.SaveChanges(); ViewBag.message = ec.fname + " Has been successsfully Added"; return(View(ec)); }
public IActionResult Create(EmpClass ec) { //_cc.Add(ec); _cc.Machines.Add(ec); _cc.SaveChanges(); ViewBag.message = "Rekord " + ec.MachineName + " został zapisany pomyślnie...!"; return(View()); }
public IActionResult Create(Department dept) { if (ModelState.IsValid) { _bb.Departments.Add(dept); int n = _bb.SaveChanges(); if (n > 0) { return(RedirectToAction("Index")); } else { return(NotFound()); } } return(BadRequest()); }
public IActionResult Edit(int id, ArhivaNatjecajViewModel avm) { var arhiva = _context.ArhivaNatjecaj.Find(id); arhiva.Pobjednik = avm.Pobjednik; arhiva.Zakljucak = avm.Zakljucak; _context.ArhivaNatjecaj.Update(arhiva); _context.SaveChanges(); return(RedirectToAction("Index", "ArhivaNatjecaji")); }
public IActionResult Create(Empty e) { _cc.Add(e); _cc.SaveChanges(); ViewBag.message = "The event " + e.EventID + " is saved"; return(View()); }
public IActionResult Create(Student stud) { if (ModelState.IsValid) { if (stud == null) { return(NotFound()); } _sd.Students.Add(stud); int n = _sd.SaveChanges(); if (n > 0) { return(RedirectToAction("Index")); } else { return(BadRequest()); } } return(BadRequest()); }
public async Task <IActionResult> Save(NewSupervisor newSupervisor, int ID) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("ToLogin", "Account")); } if (User.IsInRole("Administrator")) { Supervisor supervisor = new Supervisor(newSupervisor.SupervisorID, newSupervisor.Deleted, newSupervisor.FirstName, newSupervisor.LastName); Supervisor sv = _cc.Supervisor.Find(ID) != null?_cc.Supervisor.Find(ID) : supervisor; PropertyInfo[] props = typeof(Supervisor).GetProperties(); var subgroup = props.Where(p => !p.Name.Contains("SupervisorKey") && p.CanWrite); foreach (PropertyInfo property in subgroup) { property.SetValue(sv, property.GetValue(supervisor) != null ? property.GetValue(supervisor) : ""); } if (_cc.Supervisor.Any(s => s.SupervisorID == sv.SupervisorID && s.SupervisorKey != sv.SupervisorKey)) { ModelState.AddModelError(string.Empty, $"Another supervisor already exists for {sv.SupervisorID} Supervisor ID."); } if (newSupervisor.Edit == false) { AppUser user = await UserManager.FindByEmailAsync(newSupervisor.Email); if (user != null) { ModelState.AddModelError(string.Empty, $"An account already exists with this email."); } else { user = new AppUser(); user.UserName = newSupervisor.Email; user.Email = newSupervisor.Email; user.PasswordChanged = false; user.Deleted = false; } if (ModelState.IsValid == true) { if (_cc.Supervisor.Find(ID) == null) { _cc.Supervisor.Add(sv); } _cc.SaveChanges(); var SupKey = (from s in _cc.Supervisor where s.SupervisorID == newSupervisor.SupervisorID select s.SupervisorKey).Single(); user.SupervisorKey = SupKey; IdentityResult result = await UserManager.CreateAsync(user, "Test123!"); if (result.Succeeded) { var roleResult = await UserManager.AddToRoleAsync(user, "Supervisor"); } return(RedirectToAction("Index", "Supervisors")); } } else { sv.FirstName = supervisor.FirstName; sv.LastName = supervisor.LastName; sv.SupervisorID = supervisor.SupervisorID; _cc.SaveChanges(); return(RedirectToAction("Index", "Supervisors")); } return(View("New", newSupervisor)); } else { return(RedirectToAction("Index", "Home")); } }
public IActionResult Create(NatjecajViewModel NVM, NatjecajClass natjecaji, ArhivaNatjecajClass arhiva, NatjecajToZanimanje NZ, NatjecajToOprema UP, ZanimanjeClass ZC) { List <NatjecajToZanimanje> utz = new List <NatjecajToZanimanje>(); List <NatjecajToOprema> utp = new List <NatjecajToOprema>(); List <ArhivaNatjecajToZanimanje> atz = new List <ArhivaNatjecajToZanimanje>(); List <ArhivaNatjecajToOprema> atp = new List <ArhivaNatjecajToOprema>(); natjecaji.Naziv = NVM.Naziv; natjecaji.Cijena = NVM.Cijena; natjecaji.Opis = NVM.Opis; natjecaji.Lokacija = NVM.Lokacija; _context.Natjecaj.Add(natjecaji); _context.SaveChanges(); arhiva.Naziv = NVM.Naziv; arhiva.Cijena = NVM.Cijena; arhiva.Opis = NVM.Opis; arhiva.Lokacija = NVM.Lokacija; arhiva.NatjecajClassID = natjecaji.NatjecajClassID; _context.ArhivaNatjecaj.Add(arhiva); _context.SaveChanges(); int natjecajid = natjecaji.NatjecajClassID; int arhivaid = arhiva.ArhivaNatjecajClassID; foreach (var item in NVM.Zanimanja) { var oduzmi = _context.Zanimanje.Where(x => item.ID == x.ZanimanjeClassID).ToList(); foreach (var stock in oduzmi) { stock.Kolicina = stock.Kolicina - item.Kolicina; } if (item.Kolicina > 0) { utz.Add(new NatjecajToZanimanje() { NatjecajClassID = natjecajid, ZanimanjeClassID = item.ID, Kolicina = item.Kolicina, Naziv = item.Ime }); atz.Add(new ArhivaNatjecajToZanimanje() { ArhivaNatjecajClassID = arhivaid, ZanimanjeClassID = item.ID, Kolicina = item.Kolicina, Naziv = item.Ime }); } } foreach (var item in utz) { _context.NatjecajToZanimanjes.Add(item); } foreach (var item in atz) { _context.ArhivaNatjecajToZanimanjes.Add(item); } foreach (var item2 in NVM.Oprema) { var oduzmi = _context.Oprema.Where(x => item2.ID == x.OpremaClassID).ToList(); foreach (var stock in oduzmi) { stock.Kolicina = stock.Kolicina - item2.Kolicina; } if (item2.Kolicina > 0) { utp.Add(new NatjecajToOprema() { NatjecajClassID = natjecajid, OpremaClassID = item2.ID, Kolicina = item2.Kolicina, Naziv = item2.Ime }); atp.Add(new ArhivaNatjecajToOprema() { ArhivaNatjecajClassID = arhivaid, OpremaClassID = item2.ID, Kolicina = item2.Kolicina, Naziv = item2.Ime }); } } foreach (var item2 in utp) { _context.NatjecajToOpremas.Add(item2); } foreach (var item2 in atp) { _context.ArhivaNatjecajToOpremas.Add(item2); } _context.SaveChanges(); return(RedirectToAction("Index", "Natjecaj")); }
public IActionResult Create(UslugaViewModel UVM, PosaoClass posao, UslugaClass usluge, UslugaToZanimanje UZ, UslugaToOprema UP, ZanimanjeClass ZC) { List <UslugaToZanimanje> utz = new List <UslugaToZanimanje>(); List <UslugaToOprema> utp = new List <UslugaToOprema>(); List <PosaoTozanimanje> ptz = new List <PosaoTozanimanje>(); List <PosaoToOprema> ptp = new List <PosaoToOprema>(); usluge.Naziv = UVM.Naziv; usluge.Cijena = UVM.Cijena; usluge.Opis = UVM.Opis; usluge.Lokacija = UVM.Lokacija; _context.UslugaClass.Add(usluge); _context.SaveChanges(); posao.Naziv = UVM.Naziv; posao.Cijena = UVM.Cijena; posao.Opis = UVM.Opis; posao.Lokacija = UVM.Lokacija; posao.Datum_pocetak = DateTime.Now; posao.UslugaClassID = usluge.UslugaClassID; _context.Posao.Add(posao); _context.SaveChanges(); int uslugaid = usluge.UslugaClassID; int posaoid = posao.PosaoClassID; foreach (var item in UVM.Zanimanja) { var oduzmi = _context.Zanimanje.Where(x => item.ID == x.ZanimanjeClassID).ToList(); foreach (var stock in oduzmi) { stock.Kolicina = stock.Kolicina - item.Kolicina; } if (item.Kolicina > 0) { utz.Add(new UslugaToZanimanje() { UslugaClassID = uslugaid, ZanimanjeClassID = item.ID, Kolicina = item.Kolicina, Naziv = item.Ime }); ptz.Add(new PosaoTozanimanje() { PosaoClassID = posaoid, ZanimanjeClassID = item.ID, Kolicina = item.Kolicina, Naziv = item.Ime }); } } foreach (var item in utz) { _context.UslugaToZanimanjes.Add(item); } foreach (var item in ptz) { _context.PosaoToZanimanjes.Add(item); } foreach (var item2 in UVM.Oprema) { var oduzmi = _context.Oprema.Where(x => item2.ID == x.OpremaClassID).ToList(); foreach (var stock in oduzmi) { stock.Kolicina = stock.Kolicina - item2.Kolicina; } if (item2.Kolicina > 0) { utp.Add(new UslugaToOprema() { UslugaClassID = uslugaid, OpremaClassID = item2.ID, Kolicina = item2.Kolicina, Naziv = item2.Ime }); ptp.Add(new PosaoToOprema() { PosaoClassID = posaoid, OpremaClassID = item2.ID, Kolicina = item2.Kolicina, Naziv = item2.Ime }); } } foreach (var item2 in utp) { _context.UslugaToOpremas.Add(item2); } foreach (var item2 in ptp) { _context.PosaoToOpremas.Add(item2); } _context.SaveChanges(); return(RedirectToAction("Index", "Usluga")); }
public IActionResult Save(Form edits, int ID) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("ToLogin", "Account")); } if (User.IsInRole("Supervisor")) { Form form = _cc.Form.Find(ID) ?? edits; PropertyInfo[] props = typeof(Form).GetProperties(); var subgroup = props.Where(p => !p.Name.Contains("FormID") && !p.Name.Equals("CreatedBy") && p.CanWrite); foreach (PropertyInfo property in subgroup) { property.SetValue(form, property.GetValue(edits) != null ? property.GetValue(edits) : ""); } if (_cc.Supervisor.Any(s => s.SupervisorID == edits.CreatedByID)) { form.CreatedBy = _cc.Supervisor.Where(s => s.SupervisorID == edits.CreatedByID).First().SupervisorKey; } else { ModelState.AddModelError(string.Empty, $"No supervisor found for {edits.CreatedByID} Supervisor ID."); } if (_cc.Employee.Any(e => e.EmployeeID == edits.EmployeeID)) { form.Employee = _cc.Employee.Where(e => e.EmployeeID == edits.EmployeeID).First().EmployeeKey; } else { ModelState.AddModelError(string.Empty, $"No employee found for {edits.EmployeeID} Employee ID."); } if (_cc.Form.Any(u => u.Employee == edits.Employee && u.FormID != form.FormID)) { ModelState.AddModelError(string.Empty, $"Another form already exists for {edits.Employee} Employee ID."); } form.Complete = evaluateComplete(form); if (form.Complete == true) { string[] groups = { "Communication", "Appreciation", "Development", "Teamwork" }; foreach (string group in groups) { var property = props.Where(p => p.Name.Contains(group) && p.PropertyType == typeof(decimal)).FirstOrDefault(); property.SetValue(form, getAvgProperties(group, form)); } } if (ModelState.IsValid == true) { if (_cc.Form.Find(ID) == null) { _cc.Form.Add(form); } _cc.SaveChanges(); return(RedirectToAction("Index", "Forms")); } return(View("New", form)); } else { return(RedirectToAction("Index", "Home")); } }