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