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