internal List <vwEmployee> GetAllEmployees()
{
try
{
using (HotelServiceEntities context = new HotelServiceEntities())
{
List <vwEmployee> list = new List <vwEmployee>();
list = (from x in context.vwEmployees select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
internal vwEmployee FindEmployeeCredentials(string userName, string password)
{
try
{
using (HotelServiceEntities context = new HotelServiceEntities())
{
string encryptedPassword = EncryptionHelper.Encrypt(password);
vwEmployee adminToFind = (from e in context.vwEmployees where e.UserName == userName && e.Password == encryptedPassword select e).First();
return(adminToFind);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Employee not found." + ex.Message.ToString());
return(null);
}
}
internal vwManager FindManagerCredentials(string userName, string password)
{
try
{
using (HotelServiceEntities context = new HotelServiceEntities())
{
string encryptedPassword = EncryptionHelper.Encrypt(password);
vwManager managerToFind = (from m in context.vwManagers where m.UserName == userName && m.Password == encryptedPassword select m).First();
return(managerToFind);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Manager not found." + ex.Message.ToString());
return(null);
}
}
internal vwEmployee EditEmployeeSalary(vwEmployee employee)
{
try
{
using (HotelServiceEntities context = new HotelServiceEntities())
{
tblEmployee employeeSalaryToEdit = (from e in context.tblEmployees where e.EmployeeID == employee.EmployeeID select e).First();
employeeSalaryToEdit.Salary = employee.Salary;
context.SaveChanges();
return(employee);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
internal vwEmployee AddEmployee(vwEmployee employee)
{
try
{
using (HotelServiceEntities context = new HotelServiceEntities())
{
tblUser newUser = new tblUser
{
FullName = employee.FullName,
DateOfBirth = employee.DateOfBirth,
Email = employee.Email,
UserName = employee.UserName,
Password = employee.Password
};
context.tblUsers.Add(newUser);
context.SaveChanges();
employee.UserID = newUser.UserID;
tblEmployee newEmployee = new tblEmployee
{
FloorNumber = employee.FloorNumber,
Gender = employee.Gender,
Citizenship = employee.Citizenship,
WorkType = employee.WorkType,
UserID = employee.UserID
};
context.tblEmployees.Add(newEmployee);
context.SaveChanges();
employee.EmployeeID = newEmployee.EmployeeID;
return(employee);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
internal vwManager AddManager(vwManager manager)
{
try
{
using (HotelServiceEntities context = new HotelServiceEntities())
{
tblUser newUser = new tblUser
{
FullName = manager.FullName,
DateOfBirth = manager.DateOfBirth,
Email = manager.Email,
UserName = manager.UserName,
Password = manager.Password
};
context.tblUsers.Add(newUser);
context.SaveChanges();
manager.UserID = newUser.UserID;
tblManager newManager = new tblManager
{
FloorNumber = manager.FloorNumber,
WorkExperience = manager.WorkExperience,
LevelOfEducation = manager.LevelOfEducation,
UserID = manager.UserID
};
context.tblManagers.Add(newManager);
context.SaveChanges();
manager.ManagerID = newManager.ManagerID;
return(manager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
