public string AddAjax(string processor, string ram, string hdd)
{
int ramN = 0;
int hddN = 0;
if (!(Int32.TryParse(ram, out ramN) && Int32.TryParse(hdd, out hddN)) || processor == null)
{
return(null);
}
computer_parameters computerParameters = new computer_parameters();
computerParameters.hdd = hddN;
computerParameters.ram = ramN;
computerParameters.processor = processor;
if (!Validator.validParameters(computerParameters))
{
return(null);
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.computer_parameters.Add(computerParameters);
Logger.logParameters(computerParameters, "Add", User);
entities.SaveChanges();
}
return("{\"msg\":\"success\"}");
}
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 SaveReset(registered_user user, string password1, string password2)
{
if (!password1.Equals(password2))
{
ModelState.AddModelError("same", "Passwords must be same.");
return(View("ResetPassword", user));
}
if (password1.Length < 4)
{
ModelState.AddModelError("same", "Minimum password length is 4 characters.");
return(View("ResetPassword", user));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
registered_user u =
entities.registered_user.FirstOrDefault(e => e.login.Equals(user.login));
u.password = EncryptHelper.encryptPassword(password1);
Logger.logToDB("Reset password to user " + u.login, entities, User.Identity.Name);
entities.SaveChanges();
TempData["notifi"] = "true";
return(RedirectToAction("Index"));
}
}
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 static void logToDB(string message, string userName)
{
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
logToDB(message, entities, userName);
entities.SaveChanges();
}
}
public ActionResult Discard(computer computerIn)
{
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
var comp = entities.computers.FirstOrDefault(c => c.idcomputer == computerIn.idcomputer);
comp.discardedDate = DateTime.Now;
entities.SaveChanges();
Logger.logComputer(comp, "Discard", User);
return(RedirectToAction("Index", "ComputerDetail", comp));
}
}
public ActionResult Delete(computer computerIn)
{
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
var comp = entities.computers.FirstOrDefault(c => c.idcomputer == computerIn.idcomputer);
entities.computers.Remove(comp);
entities.SaveChanges();
Logger.logComputer(comp, "Delete", User);
return(RedirectToAction("Index", "AllComputer", comp));
}
}
public ActionResult DeleteType(computer_type computerType)
{
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
computer_type type =
entities.computer_type.FirstOrDefault(t => t.idcomputer_type == computerType.idcomputer_type);
entities.computer_type.Remove(type);
Logger.logComputerType(type, "Delete", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerType"));
}
}
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 ActionResult Delete(o oIn)
{
if (oIn == null)
{
return(RedirectToAction("Index", "ComputerOS"));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.os.Remove(entities.os.FirstOrDefault(e => e.idos == oIn.idos));
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerOS"));
}
}
public ActionResult SaveAdd(computer_brand brand)
{
if (!Validator.validModel(brand))
{
ModelState.AddModelError("exist", "Computer model is invalid or inuse.");
return(View("AddModel", brand));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.computer_brand.Add(brand);
Logger.logModel(brand, "Add", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerModel"));
}
}
public ActionResult Delete(computer_brand brand)
{
if (brand == null)
{
return(RedirectToAction("Index"));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
computer_brand b =
entities.computer_brand.FirstOrDefault(e => e.idcumputer_brand == brand.idcumputer_brand);
entities.computer_brand.Remove(b);
Logger.logModel(b, "Delete", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerModel"));
}
}
public ActionResult SaceAdd(o oIn)
{
if (!Validator.validOS(oIn))
{
ModelState.AddModelError("exist", "Operation system is invalid or in use.");
return(View("AddOS", oIn));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.os.Add(oIn);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerOS"));
}
}
public ActionResult SaveAdd(computer_type computerType)
{
if (!Validator.validType(computerType))
{
ModelState.AddModelError("exist", "Computer type is invalid or in use.");
return(View("AddComputerType", computerType));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.computer_type.Add(computerType);
Logger.logComputerType(computerType, "Add", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerType"));
}
}
public ActionResult Delete(registered_user user)
{
if (user == null)
{
return(RedirectToAction("Index"));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
registered_user u =
entities.registered_user.FirstOrDefault(e => e.idregistered_user == user.idregistered_user);
entities.registered_user.Remove(u);
entities.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Delete(computer_parameters parameters)
{
if (parameters == null)
{
return(View("AddComputerParameters"));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
computer_parameters par = entities.computer_parameters.FirstOrDefault(p =>
p.idcomputer_parameters == parameters.idcomputer_parameters);
entities.computer_parameters.Remove(par);
Logger.logParameters(par, "Delete", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerParameters"));
}
}
public ActionResult SaveEdit(computer_brand brand)
{
if (!Validator.validModel(brand))
{
ModelState.AddModelError("exist", "Computer model is invalid or inuse.");
return(View("EditModel", brand));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
computer_brand b =
entities.computer_brand.FirstOrDefault(e => e.idcumputer_brand == brand.idcumputer_brand);
b.maker = brand.maker;
b.model = brand.model;
Logger.logModel(brand, "Edit", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerModel"));
}
}
public ActionResult SaveAdd(computer_parameters parameters)
{
if (!Validator.validParameters(parameters))
{
ModelState.AddModelError("exist", "Computer parameters is invalid or in use.");
return(View("AddComputerParameters", parameters));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.computer_parameters.Add(parameters);
Logger.logParameters(parameters, "Add", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerParameters"));
}
}
public ActionResult SaveEdit(o oIn)
{
if (!Validator.validOS(oIn))
{
ModelState.AddModelError("exist", "Operation system is invalid or in use.");
return(View("EditOS", oIn));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
o oO = entities.os.FirstOrDefault(e => e.idos == oIn.idos);
oO.name = oIn.name;
oO.version = oIn.version;
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerOS"));
}
}
public string AddAjax(string model, string maker)
{
computer_brand c = new computer_brand();
c.maker = maker;
c.model = model;
if (!Validator.validModel(c))
{
return(null);
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.computer_brand.Add(c);
Logger.logModel(c, "Add", User);
entities.SaveChanges();
return("{\"msg\":\"success\"}");
}
}
public ActionResult EditSave(computer_type computerType)
{
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
if (!Validator.validType(computerType))
{
ModelState.AddModelError("exist", "Computer type is invalid or in use.");
return(View("EditComputerType", computerType));
}
computer_type type =
entities.computer_type.FirstOrDefault(t => t.idcomputer_type == computerType.idcomputer_type);
type.name = computerType.name;
Logger.logComputerType(type, "Edit", User);
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerType"));
}
}
public string addJax(string name)
{
computer_type computerType = new computer_type();
computerType.name = name;
if (!Validator.validType(computerType))
{
return(null);
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
entities.computer_type.Add(computerType);
Logger.logComputerType(computerType, "Edit", User);
entities.SaveChanges();
}
return("{\"msg\":\"success\"}");
}
public string AddAjax(string name, string version)
{
int versionN = 0;
if (!(Int32.TryParse(version, out versionN) || name == null))
{
return(null);
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
o os = new o();
os.name = name;
os.version = versionN;
entities.os.Add(os);
entities.SaveChanges();
}
return("{\"msg\":\"success\"}");
}
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 SaveEdit(computer_parameters parameters)
{
if (!Validator.validParameters(parameters))
{
ModelState.AddModelError("exist", "Computer parameters is invalid or in use.");
return(View("EditParameters", parameters));
}
using (frycz_pcdbEntities entities = new frycz_pcdbEntities())
{
computer_parameters p = entities.computer_parameters.FirstOrDefault(e =>
e.idcomputer_parameters == parameters.idcomputer_parameters);
p.hdd = parameters.hdd;
p.processor = parameters.processor;
p.ram = parameters.ram;
entities.SaveChanges();
return(RedirectToAction("Index", "ComputerParameters"));
}
}
public ActionResult Singin(String login, String password, String remember)
{
bool remem = remember != null;
if (new Frycz_pcdb_MemberShipProvider().ValidateUser(login, EncryptHelper.encryptPassword(password)))
{
using (var dc = new frycz_pcdbEntities())
{
registered_user user = dc.registered_user.FirstOrDefault(u => u.login.Equals(login));
// var myCookie = new HttpCookie("myCookie");
user.last_login = DateTime.Now;
dc.SaveChanges();
/* myCookie.Values.Add("id", user.idregistered_user.ToString());
* Response.Cookies.Add(myCookie);
*/FormsAuthentication.SetAuthCookie(login, remem);
Session["user"] = user.login;
}
return(RedirectToAction("Index", "Home"));
}
TempData["error"] = "Login or password is invalid";
return(RedirectToAction("Index", "Login"));
}
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"));
}
