private void SaveExecute() { try { User.Gender = Gender.ToString(); User.MarriageStatus = Status; using (CompanyDBEntities db = new CompanyDBEntities()) { db.tblUsers.Add(User); db.SaveChanges(); int id = db.tblUsers.Where(u => u.JMBG == User.JMBG).FirstOrDefault().UserID; Admin.ExpirationDate = DateTime.Now.AddDays(7); Admin.AdminType = Type; Admin.UserID = id; db.tblAdmins.Add(Admin); db.SaveChanges(); } MessageBox.Show("Administrator Created Successfully!"); main.Close(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } }
// Method that add Admin to database public void AddAdmin(vwAdmin admin) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); tblAdmin newAdmin = new tblAdmin(); newUser.FirstName = admin.FirstName; newUser.LastName = admin.LastName; newUser.JMBG = admin.JMBG; newUser.Gender = admin.Gender; newUser.Residence = admin.Residence; newUser.MarriageStatus = admin.MarriageStatus; newUser.Username = admin.Username; newUser.UserPassword = SecurePasswordHasher.Hash(admin.UserPassword); context.tblUsers.Add(newUser); context.SaveChanges(); admin.UserID = newUser.UserID; newAdmin.UserID = admin.UserID; newAdmin.ExpirationDate = DateTime.Now.AddDays(7); newAdmin.AdminType = admin.AdminType; context.tblAdmins.Add(newAdmin); context.SaveChanges(); admin.AdminID = newAdmin.AdminID; } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
private void SaveExecute() { try { using (CompanyDBEntities db = new CompanyDBEntities()) { User.Gender = Gender.ToString(); User.MarriageStatus = Status; db.tblUsers.Add(User); db.SaveChanges(); Worker.UserID = User.UserID; Worker.YearsOfService = 0; Worker.EducationDegree = Degree; db.tblWorkers.Add(Worker); db.SaveChanges(); } MessageBox.Show("Worker Created Successfully!"); main.Close(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } }
private void SaveExecute() { try { using (CompanyDBEntities db = new CompanyDBEntities()) { User.Gender = Gender.ToString(); User.MarriageStatus = Status; db.tblUsers.Add(User); db.SaveChanges(); Manager.UserID = User.UserID; Manager.ReservedPassword = Manager.ReservedPassword + "WPF"; db.tblManagers.Add(Manager); db.SaveChanges(); } MessageBox.Show("Manager Created Successfully!"); main.Close(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } }
// POST /api/customer public void Post(CustomerModel customer) { context.AddToCustomers(new Customer { Id = customer.Id, Name = customer.Name, Salary = customer.Salary }); context.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave); }
public ActionResult Create([Bind(Include = "EmpID,Ename,JOB,Salary,DeptID")] EMP eMP) { if (ModelState.IsValid) { db.EMPs.Add(eMP); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DeptID = new SelectList(db.DEPTs, "DeptID", "Dname", eMP.DeptID); return(View(eMP)); }
protected void GVEmployee_RowInsert(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.Equals("AddNew")) { if (sqlNative) { using (SqlConnection sqlcon = new SqlConnection()) { string insrtquery = "Insert into Employees (nom_emp,prenom_emp,Salaire_emp,date_recrute_emp,tele_emp,id_dep) Values(@nom_emp,@prenom_emp,@Salaire_emp,@date_recrute_emp,@tele_emp,@id_dep)"; SqlCommand slqcmd = new SqlCommand(insrtquery, sqlcon); //Text.trim() : removes all leading and trailing whitespace from text value slqcmd.Parameters.AddWithValue("@nom_emp", (GVEmployee.FooterRow.FindControl("txt_nom_emp_footer") as TextBox).Text.Trim()); slqcmd.Parameters.AddWithValue("@prenom_emp", (GVEmployee.FooterRow.FindControl("txt_prenom_emp_footer") as TextBox).Text.Trim()); slqcmd.Parameters.AddWithValue("@Salaire_emp", (GVEmployee.FooterRow.FindControl("txt_Salaire_emp_footer") as TextBox).Text.Trim()); slqcmd.Parameters.AddWithValue("@date_recrute_emp", (GVEmployee.FooterRow.FindControl("txt_date_recrute_emp_footer") as TextBox).Text.Trim()); slqcmd.Parameters.AddWithValue("@tele_emp", (GVEmployee.FooterRow.FindControl("txt_tele_emp_footer") as TextBox).Text.Trim()); DropDownList dddeprt = (DropDownList)GVEmployee.FooterRow.FindControl("dddeprt_footer"); slqcmd.Parameters.AddWithValue("@id_dep", dddeprt.SelectedValue); slqcmd.ExecuteNonQuery(); FillGridViewWithNativeSql(); lblSuccessMessage.Text = "New Record Added"; lblEroorMessage.Text = ""; } } else { DropDownList dddeprt = (DropDownList)GVEmployee.FooterRow.FindControl("dddeprt_footer"); contxt.Employees.Add(new Employee { nom_emp = (GVEmployee.FooterRow.FindControl("txt_nom_emp_footer") as TextBox).Text.Trim(), prenom_emp = (GVEmployee.FooterRow.FindControl("txt_prenom_emp_footer") as TextBox).Text.Trim(), Salaire_emp = Convert.ToDouble((GVEmployee.FooterRow.FindControl("txt_Salaire_emp_footer") as TextBox).Text.Trim()), date_recrute_emp = Convert.ToDateTime((GVEmployee.FooterRow.FindControl("txt_date_recrute_emp_footer") as TextBox).Text.Trim()), tele_emp = Convert.ToDouble((GVEmployee.FooterRow.FindControl("txt_tele_emp_footer") as TextBox).Text.Trim()), id_dep = Convert.ToInt32(dddeprt.SelectedValue.Trim()) }); contxt.SaveChanges(); FillGridViewWithEntityFramework(); lblSuccessMessage.Text = "New Record Added"; lblEroorMessage.Text = ""; } } } catch (Exception ex) { lblSuccessMessage.Text = ""; lblEroorMessage.Text = ex.Message; } }
public virtual IActionResult AddCar([FromBody] Car car) { (string, UserType)sender; try { sender = Security.SolveGUID(_context, Request.Headers["Guid"]); } catch (Exception e) { return(StatusCode(401, e.Message)); } if (!String.IsNullOrEmpty(car.Username) && (!car.Username.Equals(sender.Item1) && sender.Item2 != UserType.WORKSHOP_EMPLOYEE)) { return(StatusCode(403)); } if (String.IsNullOrEmpty(car.Username)) { car.Username = sender.Item1; } try { Validator.Validate(_context, car); } catch (ValidationException e) { return(StatusCode(400, e.Message)); } car.Owner = _context.Users.FirstOrDefault(x => x.Username.Equals(car.Username)); DiagnosticProfile diagnosticProfile = new DiagnosticProfile { LicensePlate = car.LicensePlate }; car.DiagnosticProfile = diagnosticProfile; diagnosticProfile.Car = car; car.Insurances = new List <Insurance>(); _context.Add(car); _context.Add(diagnosticProfile); try { _context.SaveChanges(); } catch (DbUpdateException e) { return(StatusCode(400, e.Message + " -> " + e.InnerException.Message)); } return(new ObjectResult(car)); }
public virtual IActionResult AddUser([FromBody] User body) { body.Guid = Guid.NewGuid().ToString(); _context.Users.Add(body); try { _context.SaveChanges(); } catch (DbUpdateException) { return(StatusCode(400)); } return(StatusCode(200, body)); }
private void SaveExecute() { try { using (CompanyDBEntities db = new CompanyDBEntities()) { tblUser user = db.tblUsers.Where(u => u.UserID == Admin.UserID).FirstOrDefault(); user.FirstName = Admin.FirstName; user.LastName = Admin.LastName; user.JMBG = Admin.JMBG; user.Gender = Gender.ToString(); user.Residence = Admin.Residence; user.MarriageStatus = Status; user.Username = Admin.Username; user.UserPassword = Admin.UserPassword; tblAdmin admin = db.tblAdmins.Where(a => a.AdminID == Admin.AdminID).FirstOrDefault(); admin.ExpirationDate = Admin.ExpirationDate; admin.AdminType = Type; db.SaveChanges(); } MessageBox.Show("Admin Updated Successfully!"); main.Close(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } }
public T Add(T model) { T newModel = dbSet.Add(model); context.SaveChanges(); return(newModel); }
/// <summary> /// method for deleting the project /// </summary> private void DeleteProjectExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { int id = project.ProjectID; // checking the action MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure you want to delete the project?", "Delete Confirmation", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { tblProject projectToDelete = (from x in context.tblProjects where x.ProjectID == id select x).First(); // deleting the project context.tblProjects.Remove(projectToDelete); context.SaveChanges(); // updating the list ProjectList = GetAllProjects().ToList(); MessageBox.Show("The project deleted successfully."); // logging the action FileActions.FileActions.Instance.Deleting(FileActions.FileActions.path, FileActions.FileActions.actions, "project", projectToDelete.ProjectName); } } } catch (Exception) { MessageBox.Show("The project can not be deleted, please try again."); } }
/// <summary> /// method for saving data to the database /// </summary> private void SaveExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblPosition newPosition = new tblPosition(); newPosition.PositionName = position.PositionName; newPosition.PositionDescription = position.PositionDescription; newPosition.PositionID = position.PositionID; // saving data context.tblPositions.Add(newPosition); context.SaveChanges(); MessageBox.Show("The position created successfully."); // logging the action FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "position", newPosition.PositionName); } addPosition.Close(); } catch (Exception) { MessageBox.Show("Wrong inputs. Please try again."); } }
/// <summary> /// Creates or edits an sector /// </summary> /// <param name="sector">the sector that is being added</param> /// <returns>a new or edited sector</returns> public tblSector AddSector(tblSector sector) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { if (sector.SectorID == 0) { tblSector newSector = new tblSector { SectorName = sector.SectorName, SectorDescription = sector.SectorDescription }; context.tblSectors.Add(newSector); context.SaveChanges(); sector.SectorID = newSector.SectorID; return(sector); } else { tblSector sectorToEdit = (from ss in context.tblSectors where ss.SectorID == sector.SectorID select ss).First(); sectorToEdit.SectorName = sector.SectorName; sectorToEdit.SectorName = sector.SectorName; sectorToEdit.SectorID = sector.SectorID; context.SaveChanges(); return(sector); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// Method that add Manager to database public void AddManager(vwManager manager) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); tblManager newManager = new tblManager(); newUser.FirstName = manager.FirstName; newUser.LastName = manager.LastName; newUser.JMBG = manager.JMBG; newUser.Gender = manager.Gender; newUser.Residence = manager.Residence; newUser.MarriageStatus = manager.MarriageStatus; newUser.Username = manager.Username; newUser.UserPassword = SecurePasswordHasher.Hash(manager.UserPassword); context.tblUsers.Add(newUser); context.SaveChanges(); manager.UserID = newUser.UserID; newManager.UserID = manager.UserID; newManager.Email = manager.Email; newManager.ReservedPassword = manager.ReservedPassword + "WPF"; newManager.LevelOfResponsibility = manager.LevelOfResponsibility; newManager.SuccessfulProjects = manager.SuccessfulProjects; newManager.Salary = "1200"; newManager.OfficeNumber = manager.OfficeNumber; context.tblManagers.Add(newManager); context.SaveChanges(); manager.ManagerID = newManager.ManagerID; } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
// Method that add Employee to database public void AddEmployee(vwWorker employee) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); tblWorker newEmployee = new tblWorker(); newUser.FirstName = employee.FirstName; newUser.LastName = employee.LastName; newUser.JMBG = employee.JMBG; newUser.Gender = employee.Gender; newUser.Residence = employee.Residence; newUser.MarriageStatus = employee.MarriageStatus; newUser.Username = employee.Username; newUser.UserPassword = SecurePasswordHasher.Hash(employee.UserPassword); context.tblUsers.Add(newUser); context.SaveChanges(); employee.UserID = newUser.UserID; newEmployee.UserID = employee.UserID; newEmployee.YearsOfService = employee.YearsOfService; newEmployee.EducationDegree = employee.EducationDegree; newEmployee.SectorID = 1; newEmployee.PositionID = employee.PositionID; newEmployee.Salary = "1200"; context.tblWorkers.Add(newEmployee); context.SaveChanges(); employee.WorkerID = newEmployee.WorkerID; } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
/// <summary> /// Creates or edits an employee /// </summary> /// <param name="employee">the employee that is being added</param> /// <returns>a new or edited employee</returns> public vwEmployee AddEmployee(vwEmployee employee) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { if (employee.UserID == 0) { tblUser newUser = new tblUser { FirstName = employee.FirstName, LastName = employee.LastName, JMBG = employee.JMBG, Gender = employee.Gender, Residence = employee.Residence, MarriageStatus = employee.MarriageStatus, Username = employee.Username, UserPassword = PasswordHasher.Hash(employee.UserPassword) }; context.tblUsers.Add(newUser); context.SaveChanges(); employee.UserID = newUser.UserID; //TODO remove when method to create sectors is made if (employee.SectorID == 0) { if (GetAllSectors().Count == 0) { tblSector sec = new tblSector { SectorName = "Default", SectorDescription = "Default" }; AddSector(sec); employee.SectorID = sec.SectorID; } else { employee.SectorID = GetAllSectors()[0].SectorID; } } tblEmployee newEmployee = new tblEmployee { YearsOfService = employee.YearsOfService, Salary = employee.Salary, EducationDegree = employee.EducationDegree, SectorID = employee.SectorID, ManagerID = employee.ManagerID, PositionID = employee.PositionID, UserID = employee.UserID }; context.tblEmployees.Add(newEmployee); context.SaveChanges(); employee.EmployeeID = newEmployee.EmployeeID; return(employee); } else { tblUser userToEdit = (from ss in context.tblUsers where ss.UserID == employee.UserID select ss).First(); userToEdit.FirstName = employee.FirstName; userToEdit.LastName = employee.LastName; userToEdit.JMBG = employee.JMBG; userToEdit.Gender = employee.Gender; userToEdit.Residence = employee.Residence; userToEdit.MarriageStatus = employee.MarriageStatus; userToEdit.Username = employee.Username; // Save only if password changed if (userToEdit.UserPassword != employee.UserPassword) { userToEdit.UserPassword = PasswordHasher.Hash(employee.UserPassword); } userToEdit.UserID = employee.UserID; tblUser userEdit = (from ss in context.tblUsers where ss.UserID == employee.UserID select ss).First(); context.SaveChanges(); tblEmployee employeeToEdit = (from ss in context.tblEmployees where ss.UserID == employee.UserID select ss).First(); employeeToEdit.YearsOfService = employee.YearsOfService; employeeToEdit.Salary = employee.Salary; employeeToEdit.EducationDegree = employee.EducationDegree; employeeToEdit.SectorID = employee.SectorID; employeeToEdit.ManagerID = employee.ManagerID; employeeToEdit.PositionID = employee.PositionID; employeeToEdit.UserID = employee.UserID; employeeToEdit.EmployeeID = employee.EmployeeID; tblEmployee employeeEdit = (from ss in context.tblEmployees where ss.EmployeeID == employee.EmployeeID select ss).First(); context.SaveChanges(); return(employee); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// method for saving data to the database /// </summary> private void SaveExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); tblAdmin newAdmin = new tblAdmin(); // inputs and validations if (user.FirstName.All(Char.IsLetter)) { newUser.FirstName = user.FirstName; } else { MessageBox.Show("Wrong First Name input, please try again."); } if (user.LastName.All(Char.IsLetter)) { newUser.LastName = user.LastName; } else { MessageBox.Show("Wrong Last Name input, please try again."); } newUser.JMBG = user.JMBG; // JMBG validation if (JmbgInputValidation(newUser.JMBG) == false) { MessageBox.Show("Wrong input, please check your JMBG (13 characters)."); } string sex = user.Gender.ToUpper(); // gender validation if ((sex == "M" || sex == "Z" || sex == "X" || sex == "N")) { newUser.Gender = sex; } else { MessageBox.Show("Wrong Gender input, please enter M, Z, X or N."); } user.UserID = newUser.UserID; newUser.Residence = user.Residence; string marriage = user.MarriageStatus.ToUpper(); if ((marriage == "MARRIED" || marriage == "UNMARRIED" || marriage == "DIVORCED")) { newUser.MarriageStatus = marriage; } else { MessageBox.Show("Wrong Marriage status input. Please try again.\n (Married/Unmarried/Divorced)"); } newUser.Username = user.Username; newUser.UserPassword = user.UserPassword; string adminType = admin.AdminType.ToUpper(); if ((adminType == "TEAM" || adminType == "SYSTEM" || adminType == "LOCAL")) { newAdmin.AdminType = adminType; } else { MessageBox.Show("Wrong Admin type input. Please try again.\n (Team/System/Local)"); } newAdmin.AdminID = admin.AdminID; newAdmin.ExpirationDate = DateTime.Now.AddDays(7); newAdmin.UserID = newUser.UserID; // saving data to the database context.tblUsers.Add(newUser); context.tblAdmins.Add(newAdmin); context.SaveChanges(); MessageBox.Show("The admin created successfully."); // logging the action FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "user", newUser.FirstName + " " + newUser.LastName); FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "admin", newUser.FirstName + " " + newUser.LastName); } masterView.Close(); } catch (Exception) { MessageBox.Show("Wrong inputs, please check your inputs or try again."); } }
/// <summary> /// method for saving the data to the database /// </summary> private void SaveExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblProject newProject = new tblProject(); // inputs and validations newProject.ProjectName = project.ProjectName; newProject.ProjectDescription = project.ProjectDescription; if (project.ClientName.All(Char.IsLetter)) { newProject.ClientName = project.ClientName; } else { MessageBox.Show("Wrong Client Name input, please try again."); } newProject.ContractDate = DateTime.Now; if (project.ContractManager.All(Char.IsLetter)) { newProject.ContractManager = project.ContractManager; } else { MessageBox.Show("Wrong Contract Manager input, please try again."); } newProject.ProjectStartDate = DateTime.Now.AddDays(7); newProject.ProjectDeadline = DateTime.Now.AddDays(30); newProject.HourlyRate = project.HourlyRate; string a = project.Realisation; if (a == "1" || a == "2" || a == "0") { newProject.Realisation = project.Realisation; } else { MessageBox.Show("Wrong Realisation input, please try again. \n(0/1/2)"); } // getting the ManagerID for the project tblManager viaManager = (from x in context.tblManagers where x.ManagerID == manager.ManagerID select x).FirstOrDefault(); newProject.ManagerID = viaManager.ManagerID; newProject.ProjectID = project.ProjectID; // saving data context.tblProjects.Add(newProject); context.SaveChanges(); MessageBox.Show("The project created successfully."); // logging action FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "project", newProject.ProjectName); // updating the project list view IsUpdateProject = true; } addProject.Close(); } catch (Exception) { MessageBox.Show("Wrong inputs. Please try again."); } }
/// <summary> /// method for saving data to the database /// </summary> private void SaveExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); tblManager newManager = new tblManager(); // inputs and validations if (user.FirstName.All(Char.IsLetter)) { newUser.FirstName = user.FirstName; } else { MessageBox.Show("Wrong First Name input, please try again."); } if (user.LastName.All(Char.IsLetter)) { newUser.LastName = user.LastName; } else { MessageBox.Show("Wrong Last Name input, please try again."); } newUser.JMBG = user.JMBG; // JMBG validation if (JmbgInputValidation(newUser.JMBG) == false) { MessageBox.Show("Wrong input, please check your JMBG (13 characters)."); } string sex = user.Gender.ToUpper(); // gender validation if ((sex == "M" || sex == "Z" || sex == "X" || sex == "N")) { newUser.Gender = sex; } else { MessageBox.Show("Wrong Gender input, please enter M, Z, X or N."); } user.UserID = newUser.UserID; newUser.Residence = user.Residence; string marriage = user.MarriageStatus.ToUpper(); if ((marriage == "MARRIED" || marriage == "UNMARRIED" || marriage == "DIVORCED")) { newUser.MarriageStatus = marriage; } else { MessageBox.Show("Wrong Marriage status input. Please try again.\n (Married/Unmarried/Divorced)"); } newUser.Username = user.Username; newUser.UserPassword = user.UserPassword; newManager.Email = manager.Email; string reservedPassword = manager.ReservedPassword; if (reservedPassword.Length >= 5) { newManager.ReservedPassword = reservedPassword + "WPF"; } else { MessageBox.Show("Wrong Reserved Password input. Please try again.\n (Minimum 5 characters)"); } newManager.SuccessfulProjects = manager.SuccessfulProjects; newManager.OfficeNumber = manager.OfficeNumber; newManager.ManagerID = manager.ManagerID; newManager.UserID = newUser.UserID; // saving data context.tblUsers.Add(newUser); context.tblManagers.Add(newManager); context.SaveChanges(); MessageBox.Show("The manager created successfully."); // logging actions FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "user", newUser.FirstName + " " + newUser.LastName); FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "manager", newUser.FirstName + " " + newUser.LastName); } createManagerView.Close(); } catch (Exception) { MessageBox.Show("Wrong inputs, please check your inputs or try again."); } }
public void Ajouter <T>(T entity) where T : class { context.Set <T>().Add(entity); context.SaveChanges(); }
/// <summary> /// Creates or edits a admin /// </summary> /// <param name="admin">the admin that is esing added</param> /// <returns>a new or edited admin</returns> public vwAdmin AddAdmin(vwAdmin admin) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { if (admin.UserID == 0) { tblUser newUser = new tblUser { FirstName = admin.FirstName, LastName = admin.LastName, JMBG = admin.JMBG, Gender = admin.Gender, Residence = admin.Residence, MarriageStatus = admin.MarriageStatus, Username = admin.Username, UserPassword = PasswordHasher.Hash(admin.UserPassword) }; context.tblUsers.Add(newUser); context.SaveChanges(); admin.UserID = newUser.UserID; tblAdmin newAdmin = new tblAdmin { ExpirationDate = DateTime.Now.AddDays(7), AdminType = admin.AdminType, UserID = admin.UserID }; context.tblAdmins.Add(newAdmin); context.SaveChanges(); admin.AdminID = newAdmin.AdminID; return(admin); } else { tblUser userToEdit = (from ss in context.tblUsers where ss.UserID == admin.UserID select ss).First(); userToEdit.FirstName = admin.FirstName; userToEdit.LastName = admin.LastName; userToEdit.JMBG = admin.JMBG; userToEdit.Gender = admin.Gender; userToEdit.Residence = admin.Residence; userToEdit.MarriageStatus = admin.MarriageStatus; userToEdit.Username = admin.Username; // Save only if password changed if (userToEdit.UserPassword != admin.UserPassword) { userToEdit.UserPassword = PasswordHasher.Hash(admin.UserPassword); } userToEdit.UserID = admin.UserID; tblUser userEdit = (from ss in context.tblUsers where ss.UserID == admin.UserID select ss).First(); context.SaveChanges(); tblAdmin adminToEdit = (from ss in context.tblAdmins where ss.UserID == admin.UserID select ss).First(); adminToEdit.ExpirationDate = admin.ExpirationDate; adminToEdit.AdminType = admin.AdminType; adminToEdit.UserID = admin.UserID; adminToEdit.AdminID = admin.AdminID; context.SaveChanges(); return(admin); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Creates or edits a manager /// </summary> /// <param name="manager">the manager that is esing added</param> /// <returns>a new or edited manager</returns> public vwManager AddManager(vwManager manager) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { if (manager.UserID == 0) { tblUser newUser = new tblUser { FirstName = manager.FirstName, LastName = manager.LastName, JMBG = manager.JMBG, Gender = manager.Gender, Residence = manager.Residence, MarriageStatus = manager.MarriageStatus, Username = manager.Username, UserPassword = PasswordHasher.Hash(manager.UserPassword) }; context.tblUsers.Add(newUser); context.SaveChanges(); manager.UserID = newUser.UserID; tblManager newManager = new tblManager { Email = manager.Email, ReservedPassword = manager.ReservedPassword + "WPF", LevelOfResponsibility = manager.LevelOfResponsibility, SuccessfulProjects = manager.SuccessfulProjects, Salary = manager.Salary, OfficeNumber = manager.OfficeNumber, UserID = manager.UserID }; context.tblManagers.Add(newManager); context.SaveChanges(); manager.ManagerID = newManager.ManagerID; return(manager); } else { tblUser userToEdit = (from ss in context.tblUsers where ss.UserID == manager.UserID select ss).First(); userToEdit.FirstName = manager.FirstName; userToEdit.LastName = manager.LastName; userToEdit.JMBG = manager.JMBG; userToEdit.Gender = manager.Gender; userToEdit.Residence = manager.Residence; userToEdit.MarriageStatus = manager.MarriageStatus; userToEdit.Username = manager.Username; userToEdit.UserID = manager.UserID; tblUser userEdit = (from ss in context.tblUsers where ss.UserID == manager.UserID select ss).First(); context.SaveChanges(); tblManager managerToEdit = (from ss in context.tblManagers where ss.UserID == manager.UserID select ss).First(); managerToEdit.Email = manager.Email; managerToEdit.ReservedPassword = manager.ReservedPassword; managerToEdit.LevelOfResponsibility = manager.LevelOfResponsibility; managerToEdit.SuccessfulProjects = manager.SuccessfulProjects; managerToEdit.Salary = manager.Salary; managerToEdit.OfficeNumber = manager.OfficeNumber; managerToEdit.UserID = manager.UserID; managerToEdit.ManagerID = manager.ManagerID; tblManager managerEdit = (from ss in context.tblManagers where ss.ManagerID == manager.ManagerID select ss).First(); context.SaveChanges(); return(manager); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public virtual IActionResult AddVisit([FromBody] Body3 body) { (string, UserType)sender; try { sender = Security.SolveGUID(_context, Request.Headers["Guid"]); } catch (Exception e) { return(StatusCode(401, e.Message)); } var car = _context.Cars.FirstOrDefault(x => x.LicensePlate.Equals(body.LicensePlate)); if (car is null) { return(StatusCode(404)); } var client = _context.Users.FirstOrDefault(x => x.Username == car.Username); if (client is null) { return(StatusCode(400)); } var employees = _context.Users .Include(x => x.AssignedVisits); var min = employees.Where(x => x.UserType == UserType.WORKSHOP_EMPLOYEE) .Min(x => x.AssignedVisits.Count); var employee = employees.FirstOrDefault(x => x.AssignedVisits.Count == min && x.UserType == UserType.WORKSHOP_EMPLOYEE); if (employee is null) { return(StatusCode(400)); } var visit = new Visit { Date = body.Date, Car = car, LicensePlate = body.LicensePlate, RequiredActions = body.RequiredActions, Type = body.Type, Priority = body.Priority, Status = 0, CarOwnerUsername = client.Username, }; var ev = new EmployeeVisit { VisitId = _context.Visits.Max(x => x.VisitId) + 1, Username = employee.Username }; _context.Visits.Add(visit); _context.EmployeesVisits.Add(ev); try { _context.SaveChanges(); } catch (DbUpdateException) { return(StatusCode(400)); } return(new ObjectResult(visit)); }
public void CompleteSync() { context.SaveChanges(); }
/// <summary> /// method for saving data to the database /// </summary> private void SaveExecute() { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); tblWorker newWorker = new tblWorker(); // inputs and validations if (user.FirstName.All(Char.IsLetter)) { newUser.FirstName = user.FirstName; } else { MessageBox.Show("Wrong First Name input, please try again."); } if (user.LastName.All(Char.IsLetter)) { newUser.LastName = user.LastName; } else { MessageBox.Show("Wrong Last Name input, please try again."); } newUser.JMBG = user.JMBG; if (JmbgInputValidation(newUser.JMBG) == false) { MessageBox.Show("Wrong input, please check your JMBG (13 characters)."); } string sex = user.Gender.ToUpper(); // gender validation if ((sex == "M" || sex == "Z" || sex == "X" || sex == "N")) { newUser.Gender = sex; } else { MessageBox.Show("Wrong Gender input, please enter M, Z, X or N."); } user.UserID = newUser.UserID; newUser.Residence = user.Residence; string marriage = user.MarriageStatus.ToUpper(); if ((marriage == "MARRIED" || marriage == "UNMARRIED" || marriage == "DIVORCED")) { newUser.MarriageStatus = marriage; } else { MessageBox.Show("Wrong Marriage status input. Please try again.\n (Married/Unmarried/Divorced)"); } newUser.Username = user.Username; newUser.UserPassword = user.UserPassword; newWorker.YearsOfService = worker.YearsOfService; string education = worker.EducationDegree; if (education == "I" || education == "II" || education == "III" || education == "IV" || education == "V" || education == "VI" || education == "VII") { newWorker.EducationDegree = education; } else { MessageBox.Show("Wrong Education degree input. Please try again.\n (I - VII)"); } newWorker.WorkerID = worker.WorkerID; newWorker.UserID = newUser.UserID; newWorker.SectorID = Sector.SectorID; newWorker.PositionID = Position.PositionID; // saving the data context.tblUsers.Add(newUser); context.tblWorkers.Add(newWorker); context.SaveChanges(); MessageBox.Show("The employee created successfully."); // logging actions FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "user", newUser.FirstName + " " + newUser.LastName); FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "employee", newUser.FirstName + " " + newUser.LastName); } createEmployeeView.Close(); } catch (Exception) { MessageBox.Show("Wrong inputs, please check your inputs or try again."); } }
public ActionResult Create(EMP obj) { _dbContext.EMPs.Add(obj); _dbContext.SaveChanges(); return(RedirectToAction("Index")); }