public ActionResult Save(Frycz_pcdb.user userIn) { if (!Validator.validUser(userIn)) { ModelState.AddModelError("valid", "Firstname or lastname is invalid."); return(View("EditUser", userIn)); } if (ModelState.IsValid) { if (Validator.checkExistUser(userIn)) { ModelState.AddModelError("exist", "User is already exist."); return(View("EditUser", userIn)); } using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { Frycz_pcdb.user user = entities.users.FirstOrDefault(u => u.iduser == userIn.iduser); user.lastname = userIn.lastname; user.firstname = userIn.firstname; Logger.logUser(user, "Edit", User); entities.SaveChanges(); return(RedirectToAction("Index", "UserDetail", user)); } } return(View("EditUser", userIn)); }
public ActionResult Save(Frycz_pcdb.user userIn) { if (!Validator.validUser(userIn)) { ModelState.AddModelError("valid", "Firstname or lastname is invalid."); return(View("AddUser", userIn)); } if (ModelState.IsValid) { if (Validator.checkExistUser(userIn)) { ModelState.AddModelError("exist", "User is already exist."); return(View("AddUser", userIn)); } using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { entities.users.Add(userIn); Logger.logUser(userIn, "Add", User); entities.SaveChanges(); return(RedirectToAction("Index", "AllUsers")); } } return(View("AddUser", userIn)); }
public ActionResult Index(Frycz_pcdb.user user) { Frycz_pcdb.user userIn = null; using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { entities.Configuration.LazyLoadingEnabled = false; if (user != null) { userIn = entities.users.Include(e => e.computers).FirstOrDefault(e => e.iduser == user.iduser); } return(View("UserDetail", userIn)); } }
public ActionResult Delete(Frycz_pcdb.user userIn) { if (userIn != null) { using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { Frycz_pcdb.user userdelete = entities.users.FirstOrDefault(u => u.iduser == userIn.iduser); entities.users.Remove(userdelete); entities.SaveChanges(); return(RedirectToAction("Index", "AllUsers")); } } return(null); }
public string addJax(string firstname, string lastname) { if (!Validator.validUser(firstname, lastname)) { return(null); } if (Validator.checkExistUser(firstname, lastname)) { return(null); } Frycz_pcdb.user u = new Frycz_pcdb.user(); u.lastname = lastname; u.firstname = firstname; using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { entities.users.Add(u); Logger.logUser(u, "Add", User); entities.SaveChanges(); return("{\"msg\":\"success\"}"); } }
public ActionResult Save(computer computerIn, string userInput, Nullable <int> idcomputer_parameters, Nullable <int> idcomputerBrand, Nullable <int> idcomputerType) { string userErrorMessage = "User name not found."; string computerErrorMessage = "Computer name is invalid or in use."; using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { if (!Validator.validComputerName(computerIn.name)) { ModelState.AddModelError("computerName", computerErrorMessage); entities.Configuration.LazyLoadingEnabled = false; var co = entities.computers.Where(c => c.idcomputer == computerIn.idcomputer) .Include(c => c.user).Include(c => c.computer_parameters).Include(c => c.o) .Include(c => c.computer_type).Include(c => c.computer_brand) .FirstOrDefault(); makeViewBag(entities, co); return(View("EditComputer", co)); } entities.Configuration.LazyLoadingEnabled = false; computer comp = entities.computers.FirstOrDefault(c => c.idcomputer == computerIn.idcomputer); try { Frycz_pcdb.user u = Validator.findUser(userInput); comp.iduser = u.iduser; } catch { var co = entities.computers.Where(c => c.idcomputer == computerIn.idcomputer) .Include(c => c.user).Include(c => c.computer_parameters).Include(c => c.o) .Include(c => c.computer_type).Include(c => c.computer_brand) .FirstOrDefault(); makeViewBag(entities, co); ModelState.AddModelError("userNotFound", userErrorMessage); return(View("EditComputer", co)); } // update computers comp.bpcs_sessions = computerIn.bpcs_sessions; comp.mac_address = computerIn.mac_address; comp.serial_number = computerIn.serial_number; comp.idos = computerIn.idos; comp.comment = computerIn.comment; comp.inventory_number = computerIn.inventory_number; if (idcomputer_parameters == null) { comp.idcomputer_parameters = null; } else { comp.computer_parameters = entities.computer_parameters.FirstOrDefault(e => e.idcomputer_parameters == idcomputer_parameters); } if (idcomputerBrand == null) { comp.idcomputer_brand = null; } else { comp.computer_brand = entities.computer_brand.FirstOrDefault(e => e.idcumputer_brand == idcomputerBrand); } comp.idcomputer_type = idcomputerType; comp.name = computerIn.name.ToUpper(); comp.guarantee = computerIn.guarantee; comp.last_update_time = DateTime.Now; entities.SaveChanges(); return(RedirectToAction("Index", "ComputerDetail", comp)); } }
public ActionResult save(FormCollection formCollection, int count, computer computerIn, string userInput, Nullable <int> idcomputer_parameters, Nullable <int> idcomputerBrand, Nullable <int> idcomputerType, string guar) { //check if all input computer`s names are not same. List <computer> computers = new List <computer>(); for (int i = 1; i <= count; i++) { computer comp = new computer(); string pcname = formCollection[i.ToString()]; comp.name = pcname; foreach (computer computer in computers) { if (computer.name.Equals(pcname)) { ModelState.AddModelError("eqcomp", "Computer's names can not be same."); return(returnValidationMessage(computerIn, count, formCollection)); } } computers.Add(comp); } using (frycz_pcdbEntities entities = new frycz_pcdbEntities()) { for (int i = 1; i <= count; i++) { computer comp = new computer(); string pcname = formCollection[i.ToString()]; if (!Validator.validComputerName(pcname)) { ModelState.AddModelError("eqcomp", "Some computer name is not valid"); return(returnValidationMessage(computerIn, count, formCollection)); } if (Validator.checkExistComputer(pcname, entities)) { ModelState.AddModelError("eqcomp", "Some computer name is already exist."); return(returnValidationMessage(computerIn, count, formCollection)); } try { Frycz_pcdb.user user = Validator.findUser(userInput); comp.iduser = user.iduser; } catch { ModelState.AddModelError("userNotFound", "User not found. "); return(returnValidationMessage(computerIn, count, formCollection)); } comp.bpcs_sessions = computerIn.bpcs_sessions; comp.mac_address = computerIn.mac_address; comp.serial_number = computerIn.serial_number; comp.idos = computerIn.idos; comp.comment = computerIn.comment; comp.inventory_number = computerIn.inventory_number; if (idcomputer_parameters == null) { comp.idcomputer_parameters = null; } else { comp.computer_parameters = entities.computer_parameters.FirstOrDefault(e => e.idcomputer_parameters == idcomputer_parameters); } if (idcomputerBrand == null) { comp.idcomputer_brand = null; } else { comp.computer_brand = entities.computer_brand.FirstOrDefault(e => e.idcumputer_brand == idcomputerBrand); } comp.idcomputer_type = idcomputerType; comp.name = pcname.ToUpper(); comp.guarantee = computerIn.guarantee; comp.create_time = DateTime.Now; comp.last_update_time = DateTime.Now; entities.computers.Add(comp); Logger.logComputer(comp, "Add", User, entities); } entities.SaveChanges(); } return(RedirectToAction("Index", "AllComputer")); }
public ActionResult Index(Frycz_pcdb.user userIn) { return(View("EditUser", userIn)); }