[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"));
}
}
