internal vwWorker EditWorker(vwWorker worker) { try { using (WorkerDatabaseEntities context = new WorkerDatabaseEntities()) { tblWorker workerToEdit = (from w in context.tblWorkers where w.WorkerID == worker.WorkerID select w).First(); workerToEdit.FirstName = worker.FirstName; workerToEdit.LastName = worker.LastName; workerToEdit.DateOfBirth = worker.DateOfBirth; workerToEdit.PersonalIDNumber = worker.PersonalIDNumber; workerToEdit.JMBG = worker.JMBG; workerToEdit.GenderID = worker.GenderID; workerToEdit.PhoneNumber = worker.PhoneNumber; workerToEdit.SectorID = worker.SectorID; workerToEdit.LocationID = worker.LocationID; workerToEdit.ManagerID = worker.ManagerID; context.SaveChanges(); return(worker); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal vwWorker AddWorker(vwWorker worker) { try { using (WorkerDatabaseEntities context = new WorkerDatabaseEntities()) { tblWorker newWorker = new tblWorker(); newWorker.FirstName = worker.FirstName; newWorker.LastName = worker.LastName; newWorker.DateOfBirth = worker.DateOfBirth; newWorker.PersonalIDNumber = worker.PersonalIDNumber; newWorker.JMBG = worker.JMBG; newWorker.GenderID = worker.GenderID; newWorker.PhoneNumber = worker.PhoneNumber; newWorker.SectorID = worker.SectorID; newWorker.LocationID = worker.LocationID; newWorker.ManagerID = worker.ManagerID; context.tblWorkers.Add(newWorker); context.SaveChanges(); worker.WorkerID = newWorker.WorkerID; return(worker); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
// constructor public CreateEmployeeViewModel(CreateEmployeeView employeeOpen) { user = new tblUser(); worker = new tblWorker(); createEmployeeView = employeeOpen; SectorList = GetAllSector(); PositionList = GetAllPosition(); }
public RegisterWorkerViewModel(RegisterWorkerView mainOpen) { main = mainOpen; User = new tblUser(); Worker = new tblWorker(); Genders = GetAllGenders(); MarriageStatuses = GetMariageStatuses(); Degrees = GetAllDegreesTypes(); }
public AddNewWorkerViewModel(AddNewWorker workerViewOpen) { Worker = new tblWorker(); addNewWorker = workerViewOpen; NewSector = new tblSector(); NewLocation = new tblLocation(); Genders = GetAllGenders(); Locations = GetAllLocations(); addNewWorker = workerViewOpen; }
public void Update(Interface.Iworker worker) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblWorker updateWorker = dbContext.tblWorkers.SingleOrDefault( x => x.workNo == worker.WorkNo); updateWorker.active = worker.Active; updateWorker.altPhoneNo = worker.AltPhoneNo; if (worker.Email != string.Empty) { updateWorker.email = worker.Email; } if (worker.Email != string.Empty) { updateWorker.homeAddress = worker.Address; } if (worker.Name != string.Empty) { updateWorker.name = worker.Name; } if (worker.PhoneNo != string.Empty) { updateWorker.phoneNo = worker.PhoneNo; } if (worker.PhoneNo != null) { updateWorker.postNo = worker.PostNo.Id; } if (worker.Surname != string.Empty) { updateWorker.surname = worker.Surname; } if (worker.WorkerStatus != null) { updateWorker.workerStatus = worker.WorkerStatus.StautsNo; } dbContext.SubmitChanges(); } }
internal void DeleteWorker(int workerID) { try { using (WorkerDatabaseEntities context = new WorkerDatabaseEntities()) { tblWorker workerToDelete = (from w in context.tblWorkers where w.WorkerID == workerID select w).First(); context.tblWorkers.Remove(workerToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
/// <summary> /// Find Worker thats being updated /// </summary> /// <returns>Worker thats being updated</returns> private tblWorker FindWorker() { try { tblWorker worker = new tblWorker(); using (WorkersDbEntities db = new WorkersDbEntities()) { worker = db.tblWorkers.Where(x => x.Id == ViewWorker.Id).FirstOrDefault(); return(worker); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message.ToString()); return(null); } }
/// <summary> /// Deletes Worker from database /// </summary> private void WorkerDelete(object sender, DoWorkEventArgs e) { try { using (WorkersDbEntities db = new WorkersDbEntities()) { Thread.Sleep(2000); tblWorker worker = db.tblWorkers.Where(x => x.Id == viewWorker.Id).FirstOrDefault(); db.tblWorkers.Remove(worker); db.SaveChanges(); AllInfoAboutWorker = GetAllInfoAboutWorkers(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message.ToString()); } }
public void Delete(int WorkNumber) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { tblWorker workerItem = dbContext.tblWorkers.SingleOrDefault(x => x.workNo == WorkNumber); var workerDelete = new StringBuilder(); workerDelete.Append("[tblWorkers] { "); workerDelete.Append("workNo = " + workerItem.workNo.ToString() + ", "); workerDelete.Append("name = " + workerItem.name + ", "); workerDelete.Append("surname = " + workerItem.surname + ", "); workerDelete.Append("workerStatus = " + workerItem.workerStatus.ToString() + ", "); workerDelete.Append("phoneNo = " + workerItem.phoneNo + ", "); workerDelete.Append("altPhoneNo = " + workerItem.altPhoneNo + ", "); workerDelete.Append("homeAddress = " + workerItem.homeAddress + ", "); workerDelete.Append("postNo = " + workerItem.postNo.ToString() + ", "); workerDelete.Append("email = " + workerItem.email + ", "); workerDelete.Append("active = "); if (workerItem.active == true) { workerDelete.Append("1"); } else { workerDelete.Append("0"); } workerDelete.Append(" }"); var newDeleteItem = new tblDeleteItem() { deleteDate = DateTime.Now, itemInfo = workerDelete.ToString(), restored = false }; workerItem.active = false; dbContext.tblDeleteItems.InsertOnSubmit(newDeleteItem); dbContext.SubmitChanges(); } }
public void Add(Interface.Iworker worker) { using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString)) { var newWorker = new tblWorker() { active = worker.Active, altPhoneNo = worker.AltPhoneNo, email = worker.Email, homeAddress = worker.Address, name = worker.Name, phoneNo = worker.PhoneNo, postNo = worker.PostNo.Id, surname = worker.Surname, workerStatus = worker.WorkerStatus.StautsNo, }; dbContext.tblWorkers.InsertOnSubmit(newWorker); dbContext.SubmitChanges(); } }
// 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> /// 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 UpdateCurrentWorker(tblWorker worker) { InitializeComponent(); this.DataContext = new UpdateCurrentWorkerViewModel(this, worker); }
public UpdateCurrentWorkerViewModel(UpdateCurrentWorker updateWorkerViewOpen, tblWorker worker) { updateWorkerView = updateWorkerViewOpen; Worker = worker; }