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);
}
}
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);
}
}
public SalaryInfoViewModel(HotelUser worker, vwWorker userWorker, SalariInfoView salariInfoViewOpen)
{
this.worker = worker;
this.userWorker = userWorker;
salariInfoView = salariInfoViewOpen;
ManagerInput = Salary.CalculateManagerInput(userWorker.Salary, userWorker.WorkExperience, userWorker.QualificationLevelId, userWorker.GenderId);
}
public RequestViewModel(HotelUser worker, vwWorker hotelWorker, RequestView requestViewViewOpen)
{
this.worker = worker;
this.hotelWorker = hotelWorker;
requestViewView = requestViewViewOpen;
Request = new Request();
}
public EditWorkerViewModel(EditWorker editWorkerOpen, vwWorker workerEdit)
{
_editWorker = editWorkerOpen;
_worker = workerEdit;
_location = new vwLocation();
_gender = new tblGender();
_sector = new tblSector();
_manager = new vwManager();
LocationList = _dbService.GetAllLocations();
WorkerList = _dbService.GetAllWorkerRecords();
GenderList = _dbService.GetAllGenders();
SectorList = _dbService.GetAllSectors();
ManagerList = new List <vwManager>();
foreach (var item in _dbService.GetAllManagers())
{
if (item.WorkerID != _worker.WorkerID)
{
ManagerList.Add(item);
}
}
FirstNameBeforeEdit = _worker.FirstName;
LastNameBeforeEdit = _worker.LastName;
JMBGBeforeEdit = _worker.JMBG;
actionEventObject = new ActionEvent();
actionEventObject.ActionPerformed += ActionPerformed;
}
public RequestView(HotelUser worker, vwWorker hotelUser)
{
InitializeComponent();
RequestViewModel requestViewModel = new RequestViewModel(worker, hotelUser, this);
this.DataContext = requestViewModel;
this.requestViewModel = requestViewModel;
}
public SalariInfoView(HotelUser user, vwWorker worker)
{
InitializeComponent();
SalaryInfoViewModel salaryInfoViewModel = new SalaryInfoViewModel(user, worker, this);
this.DataContext = salaryInfoViewModel;
this.salaryInfoViewModel = salaryInfoViewModel;
}
public AddWorkerViewModel(AddWorker addEmployeeOpen)
{
_addWorker = addEmployeeOpen;
_worker = new vwWorker();
_location = new vwLocation();
LocationList = _dbService.GetAllLocations();
WorkerList = _dbService.GetAllWorkerRecords();
GenderList = _dbService.GetAllGenders();
SectorList = _dbService.GetAllSectors();
ManagerList = _dbService.GetAllManagers();
actionEventObject = new ActionEvent();
actionEventObject.ActionPerformed += ActionPerformed;
}
public vwWorker FindEmployee(string username)
{
try
{
using (CompanyDBEntities context = new CompanyDBEntities())
{
vwWorker employee = (from e in context.vwWorkers where e.Username == username select e).First();
return(employee);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public vwWorker GetWorkerDetailsById(int userId)
{
try
{
using (HotelPremierEntities context = new HotelPremierEntities())
{
vwWorker worker = (from p in context.vwWorkers where p.HotelUserId == userId select p).FirstOrDefault();
return(worker);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exeption" + ex.Message.ToString());
return(null);
}
}
// 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());
}
}
// Methot to check if Employee username exists in database
public bool IsUser(string username)
{
try
{
using (CompanyDBEntities context = new CompanyDBEntities())
{
vwWorker employee = (from e in context.vwWorkers where e.Username == username select e).First();
if (employee == null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public EditWorker(vwWorker editWorker)
{
InitializeComponent();
this.DataContext = new EditWorkerViewModel(this, editWorker);
}
