/// <summary>
/// This method adds managers to DbSet and then save changes to database.
/// </summary>
/// <param name="managerToAdd">Employee.</param>
public void AddManager(vwManager managerToAdd)
{
try
{
using (Data_RecordsEntities context = new Data_RecordsEntities())
{
tblEmployee employee = new tblEmployee
{
Name = managerToAdd.Name,
Surname = managerToAdd.Surname,
DateOfBirth = managerToAdd.DateOfBirth,
JMBG = managerToAdd.JMBG,
BankAccountNumber = managerToAdd.BankAccountNumber,
Email = managerToAdd.Email,
Salary = managerToAdd.Salary,
Position = managerToAdd.Position,
Username = managerToAdd.Username,
Password = managerToAdd.Password,
Sector = managerToAdd.Sector,
AccessLevel = managerToAdd.AccessLevel
};
context.tblEmployees.Add(employee);
context.SaveChanges();
managerToAdd.EmployeeID = employee.EmployeeID;
LogAction("Manager " + managerToAdd.Name + " " + managerToAdd.Surname + " created. Date of birth: " + managerToAdd.DateOfBirth + ", Position: " + managerToAdd.Position + ", Email: " + managerToAdd.Email
+ ", Sector: " + managerToAdd.Sector);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// This method creates a list of employees of forwarded manager.
/// </summary>
/// <param name="manager">manager.</param>
/// <returns>List of employees.</returns>
public List <vwEmployee> GetEmployees(vwManager manager)
{
try
{
using (HotelEntities context = new HotelEntities())
{
return(context.vwEmployees.Where(x => x.HotelFloor == manager.HotelFloor).ToList());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// This method adds managers to DbSet and then save changes to database.
/// </summary>
/// <param name="managerToAdd">Manager.</param>
/// <returns>True if added, false if not.</returns>
public bool AddManager(vwManager managerToAdd)
{
try
{
using (HotelEntities context = new HotelEntities())
{
tblUser user = new tblUser
{
DateOfBirth = managerToAdd.DateOfBirth,
Email = managerToAdd.Email,
Name = managerToAdd.Name,
Password = managerToAdd.Password,
Surname = managerToAdd.Surname,
Username = managerToAdd.Username
};
context.tblUsers.Add(user);
context.SaveChanges();
managerToAdd.UserId = user.UserId;
tblManager manager = new tblManager
{
UserId = managerToAdd.UserId,
ExperienceWorkingInHotels = managerToAdd.ExperienceWorkingInHotels,
HotelFloor = managerToAdd.HotelFloor,
ProfessionalQualifications = managerToAdd.ProfessionalQualifications
};
context.tblManagers.Add(manager);
context.SaveChanges();
managerToAdd.ManagerId = manager.ManagerId;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
