// Method that add Manager to database
public void AddManager(vwManager manager)
{
try
{
using (HotelDBEntities context = new HotelDBEntities())
{
tblUser newUser = new tblUser();
tblManager newManager = new tblManager();
newUser.Name = manager.Name;
newUser.Surname = manager.Surname;
newUser.DateOfBirth = manager.DateOfBirth;
newUser.Email = manager.Email;
newUser.Username = manager.Username;
newUser.Password = SecurePasswordHasher.Hash(manager.Password);
context.tblUsers.Add(newUser);
context.SaveChanges();
manager.UserId = newUser.UserId;
newManager.UserId = manager.UserId;
newManager.Floor = manager.Floor;
newManager.Experience = manager.Experience;
newManager.Qualifications = manager.Qualifications;
context.tblManagers.Add(newManager);
context.SaveChanges();
manager.ManagerID = newManager.ManagerID;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// Adds new account to tblAccount and adds an employee with the acount AccountID to database.
/// </summary>
/// <param name="account"></param>
/// <param name="sector"></param>
/// <param name="position"></param>
/// <param name="experience"></param>
/// <param name="qualification"></param>
internal void AddManager(tblManager manager, tblAccount account)
{
using (CompanyEntities context = new CompanyEntities())
{
tblAccount newAccount = new tblAccount();
newAccount.FirstName = account.FirstName;
newAccount.LastName = account.LastName;
newAccount.JMBG = account.JMBG;
newAccount.Gender = account.Gender.ToUpper();
newAccount.City = account.City;
newAccount.MarrigeStatusID = account.MarrigeStatusID;
newAccount.UserName = account.UserName;
newAccount.Pass = account.Pass;
context.tblAccounts.Add(newAccount);
context.SaveChanges();
tblManager newManager = new tblManager();
newManager.AccountID = newAccount.AccountID;
newManager.Email = manager.Email;
newManager.SparePass = manager.SparePass + "WPF";
newManager.OfficeNumber = manager.OfficeNumber;
context.tblManagers.Add(newManager);
context.SaveChanges();
}
}
/// <summary>
/// Checks if manager with the username and pass exists in tblManager in the database.
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
internal bool IsManager(string userName, string password)
{
try
{
tblAccount account = new tblAccount();
tblManager manager = new tblManager();
using (CompanyEntities context = new CompanyEntities())
{
try
{
account = GetAccount(userName, password);
}
catch
{
account = (from a in context.tblAccounts where a.UserName == userName select a).First();
manager = (from e in context.tblManagers where e.SparePass == password select e).First();
}
manager = (from e in context.tblManagers where e.AccountID == account.AccountID select e).First();
return(true);
}
}
catch
{
return(false);
}
}
public tblManager AddManager(tblManager manager)
{
try
{
using (HotelDataBaseEntities context = new HotelDataBaseEntities())
{
tblManager newManager = new tblManager();
newManager.HotelFloor = manager.HotelFloor;
newManager.Experience = manager.Experience;
newManager.QualificationsLevel = manager.QualificationsLevel;
newManager.UserId = manager.UserId;
context.tblManagers.Add(newManager);
context.SaveChanges();
return(newManager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public vwManager SetResponsibility(vwManager manager)
{
try
{
using (MyCompanyDBEntities context = new MyCompanyDBEntities())
{
tblManager managerToEdit = (from u in context.tblManagers
where u.ManagerID == manager.ManagerID
select u).First();
managerToEdit.ResponsibilityLevel = manager.ResponsibilityLevel;
context.SaveChanges();
return(manager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void DeleteManager(int managerId)
{
try
{
using (MyCompanyDBEntities context = new MyCompanyDBEntities())
{
tblManager managerToDelete = (from u in context.tblManagers
where u.ManagerID == managerId
select u).First();
tblUser userToDelete = (from u in context.tblUsers
where u.UserID == managerToDelete.UserID
select u).First();
context.tblManagers.Remove(managerToDelete);
context.tblUsers.Remove(userToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public tblManager AddManager(tblManager manager)
{
try
{
using (MyCompanyDBEntities context = new MyCompanyDBEntities())
{
tblManager newManager = new tblManager();
newManager.UserID = manager.UserID;
newManager.Email = manager.Email;
newManager.ReservePassword = manager.ReservePassword;
newManager.NumberOfSuccesfullProjects = manager.NumberOfSuccesfullProjects;
newManager.OfficeNumber = manager.OfficeNumber;
context.tblManagers.Add(newManager);
context.SaveChanges();
return(newManager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public bool TryUpdateManager(int managerID, tblManager manager)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var managerToUpdate = conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerID);
if (managerToUpdate != null)
{
managerToUpdate.LevelOfResponsibility = manager.LevelOfResponsibility;
managerToUpdate.OfficeNumber = manager.OfficeNumber;
managerToUpdate.PasswordHint = manager.PasswordHint;
managerToUpdate.ProjectsCount = manager.ProjectsCount;
managerToUpdate.Salary = manager.Salary;
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
private void LoginExecute(object obj)
{
currentEmployee.password = (obj as PasswordBox).Password;
try
{
switch (currentEmployee.role)
{
case "admin":
AdminMenu adminMenu = new AdminMenu();
authentication.Close();
adminMenu.ShowDialog();
break;
case "employee":
DAN_XLIII.View.Employee e = new DAN_XLIII.View.Employee(currentEmployee.id);
authentication.Close();
e.ShowDialog();
break;
case "manager":
tblManager m = Service.Service.GetManagerById(currentEmployee.id);
ManagerModify managerModify = new ManagerModify(currentEmployee.id);
authentication.Close();
managerModify.ShowDialog();
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public AddManagerViewModel(AddManager addManagerOpen)
{
manager = new tblManager();
account = new tblAccount();
addManager = addManagerOpen;
qualificationsList = service.FillQualificationsList();
}
/// <summary>
/// Method for adding new employee or manager in database or editing existing one
/// </summary>
/// <param name="employee">employee to db</param>
/// <param name="manager">boolean value to check if employee is manager</param>
public tblEmployee AddEditEmployeeOrManager(tblEmployee employee, bool manager)
{
try
{
using (EmployeeManagementEntities context = new EmployeeManagementEntities())
{
if (employee.EmployeeId == 0)
{
tblEmployee newEmployee = new tblEmployee();
newEmployee.FirstName = employee.FirstName;
newEmployee.LastName = employee.LastName;
newEmployee.DateOfBirth = employee.DateOfBirth;
newEmployee.JMBG = employee.JMBG;
newEmployee.AccountNumber = employee.AccountNumber;
newEmployee.Email = employee.Email;
newEmployee.Salary = employee.Salary;
newEmployee.Position = employee.Position;
newEmployee.Username = employee.Username;
newEmployee.Password = employee.Password;
context.tblEmployees.Add(newEmployee);
context.SaveChanges();
employee.EmployeeId = newEmployee.EmployeeId;
//if employee is manager add him in tblManager
if (manager == true)
{
tblManager newManager = new tblManager();
newManager.EmployeeId = employee.EmployeeId;
newManager.Sector = employee.Sector;
newManager.AccessLevel = employee.AccessLevel;
context.tblManagers.Add(newManager);
context.SaveChanges();
}
return(employee);
}
else
{
tblEmployee employeeToEdit = (from x in context.tblEmployees where x.EmployeeId == employee.EmployeeId select x).FirstOrDefault();
employeeToEdit.FirstName = employee.FirstName;
employeeToEdit.LastName = employee.LastName;
employeeToEdit.DateOfBirth = employee.DateOfBirth;
employeeToEdit.JMBG = employee.JMBG;
employeeToEdit.AccountNumber = employee.AccountNumber;
employeeToEdit.Email = employee.Email;
employeeToEdit.Salary = employee.Salary;
employeeToEdit.Position = employee.Position;
employeeToEdit.Username = employee.Username;
employeeToEdit.Password = employee.Password;
context.SaveChanges();
return(employee);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public RegisterManagerViewModel(RegisterManagerView mainOpen)
{
main = mainOpen;
User = new tblUser();
Manager = new tblManager();
Genders = GetAllGenders();
MarriageStatuses = GetMariageStatuses();
}
public AddNewManagerViewModel(AddNewManagerView addNewManagerView, IValidatedUserData userData)
{
this.addNewManagerView = addNewManagerView;
ProfessionalQualificationsLevel = string.Empty;
FloorNumber = string.Empty;
WorkExperience = string.Empty;
manager = new tblManager();
this.userData = userData;
}
public AddManagerViewModel(AddManager employeeOpen)
{
view = employeeOpen;
service = new HotelService();
FloorsList = floors;
LevelList = qualificationLevels;
User = new tblUser();
Manager = new tblManager();
}
internal tblManager GetManager(string userName)
{
using (HotelEntities1 context = new HotelEntities1())
{
tblAccount account = (from a in context.tblAccounts where a.UserName == userName select a).First();
tblManager manager = (from m in context.tblManagers where m.AccountID == account.AccountID select m).First();
return(manager);
}
}
/// <summary>
/// Creates manager and validates input
/// </summary>
private void CreateManagerExecute()
{
try
{
using (Entity context = new Entity())
{
CreateManager cm = new CreateManager();
tblAll newAll = new tblAll();
newAll.FirstName = Name;
newAll.Surname = Surname;
newAll.Email = Mail;
newAll.Username = Username;
newAll.Pasword = Password;
newAll.DateOfBirth = All.DateOfBirth;
if (CheckMail(newAll.Email) == false)
{
MessageBox.Show("E-mail already exists");
}
else if (CheckCredentials(newAll.Username) == false)
{
MessageBox.Show("Username already exists");
}
else if (CheckCredentials(newAll.Username) == true && newAll.DateOfBirth < DateTime.Now.AddYears(-18) && CheckMail(newAll.Email) == true)
{
context.tblAlls.Add(newAll);
context.SaveChanges();
tblManager newManager = new tblManager();
newManager.AllIDman = newAll.All_ID;
newManager.Experience = Experience;
newManager.SSS = Sss.name;
newManager.ManagerFlor = Floor;
context.tblManagers.Add(newManager);
context.SaveChanges();
MessageBox.Show("Manager is created");
Name = "";
Surname = "";
Mail = "";
Username = "";
Password = "";
Experience = 0;
Floor = 0;
}
else if (newAll.DateOfBirth > DateTime.Now.AddYears(-18))
{
MessageBox.Show("Manager must be at least 18 years old");
}
else
{
MessageBox.Show("Make sure that every field is populated, especially date of birth.");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public AdminViewModel(Admin adminOpen)
{
employee = new tblEmployee();
manager = new tblManager();
admin = adminOpen;
SectorList = service.GetAllSectors();
AccessLevelList = service.GetAllAccesLevels();
}
public AddManagerViewModel(AddManager addManagerOpen, tblAccount acountAdd)
{
account = acountAdd;
manager = new tblManager();
responsibilityLevelList = new List <int> {
1, 2, 3
};
addManager = addManagerOpen;
}
internal tblManager GetManager(string userName)
{
using (CompanyEntities context = new CompanyEntities())
{
tblAccount account = (from a in context.tblAccounts where a.UserName == userName select a).First();
tblManager manager = (from e in context.tblManagers where e.AccountID == account.AccountID select e).First();
return(manager);
}
}
public ManagerRegisterViewModel(ManagerRegisterView managerRegisterView)
{
view = managerRegisterView;
userService = new UserService();
managerService = new ManagerService();
User = new tblUser();
Manager = new tblManager();
}
public AddSalaryViewModel(AddSalary open, List <vwStaff> allEmp, tblManager manager)
{
calculateAll = true;
addWindow = open;
man = manager;
allEmployees = allEmp;
//adding method to DoWork event
backgroundWorker.DoWork += BW_DoWork;
//adding method to ProgressChanged event
backgroundWorker.ProgressChanged += BW_ProgressChanged;
//adding method to RunWorkerCompleted event
backgroundWorker.RunWorkerCompleted += BW_RunWorkerCompleted;
}
private void SaveExecute()
{
try
{
tblEmploye newEmploye = new tblEmploye();
newEmploye.FirstName = Employe.FirstName;
newEmploye.Surname = Employe.Surname;
newEmploye.JMBG = Employe.JMBG;
newEmploye.Salary = Convert.ToInt32(Employe.Salary);
newEmploye.Account = Employe.Account;
newEmploye.Pasword = Employe.Pasword;
newEmploye.Username = Employe.Username;
newEmploye.Position = Employe.Position;
newEmploye.Email = Employe.Email;
string birthdate = CalculateBirth(Employe.JMBG);
newEmploye.DateOfBirth = DateTime.ParseExact(CalculateBirth(Employe.JMBG), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture);
context.tblEmployes.Add(newEmploye);
context.SaveChanges();
tblManager newManager = new tblManager();
newManager.EmployeID = newEmploye.EmployeID;
newManager.SectorID = Sector.SectorID;
newManager.LevelID = Level.LevelID;
context.tblManagers.Add(newManager);
context.SaveChanges();
MessageBox.Show("Manager is created.");
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
MessageBox.Show(message);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public OwnerViewModel(Owner openOwner)
{
owner = openOwner;
newEmployee = new tblUser();
newManager = new tblManager();
newStaff = new tblStaff();
qualification = new tblProfessionalQualification();
engagement = new tblEngagement();
gender = new tblGender();
engagementList = Service.Service.GetEngagementList();
qualificationList = Service.Service.GetQualificationList();
genderList = Service.Service.GetGenderList();
}
/// <summary>
/// Creates a manager
/// </summary>
/// <param name="manager">manager to add</param>
/// <returns>a new manager</returns>
public vwManager AddManager(vwManager manager)
{
if (v.ValidManagerInput(manager))
{
try
{
using (HotelDBEntities context = new HotelDBEntities())
{
manager.DateOfBirth = manager.DateOfBirth;
//user
tblUser newManager = new tblUser();
newManager.Name = manager.Name;
newManager.DateOfBirth = manager.DateOfBirth;
newManager.Email = manager.Email;
newManager.Username = manager.Username;
newManager.Password = manager.Password;
context.tblUsers.Add(newManager);
context.SaveChanges();
//manager
int id = getUserId(manager.Username);
tblManager man = new tblManager();
man.Floor = manager.Floor;
man.Experience = manager.Experience;
man.QualificationsLevel = manager.QualificationsLevel;
man.UserID = id;
context.tblManagers.Add(man);
context.SaveChanges();
manager.UserID = newManager.UserID;
return(manager);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
else
{
MessageBox.Show("Wrong data input. Please provide valid data to add new manager.");
return(null);
}
}
protected void btn_login_Click(object sender, EventArgs e)
{
tblManager memberlist = tblManager.logincheck(txt_email.Text, txt_password.Text);
if (memberlist == null)
{
lbl_status.Visible = true;
}
else
{
Session["tblManager"] = memberlist;
Response.Redirect("cp/main.aspx");
}
}
public EditManagerViewModel(EditManager editManagerView, tblManager managerLogedIn)
{
view = editManagerView;
userService = new UserService();
managerService = new ManagerService();
User = new tblUser();
Manager = managerLogedIn;
ManagerToEdit = managerService.GetvwManager(Manager.ManagerID);
oldMail = ManagerToEdit.Email;
oldJMBG = ManagerToEdit.JMBG;
oldUserName = ManagerToEdit.Username;
}
/// <summary>
/// method for checking username and password and opening the windows
/// </summary>
private void SaveExecute()
{
string adminType = AdminType(Username, UserPassword);
if (username == "WPFMaster" && userPassword == "WPFAccess")
{
MasterView master = new MasterView();
master.ShowDialog();
}
else if (adminType == "TEAM")
{
TeamAdminView team = new TeamAdminView();
team.ShowDialog();
}
else if (adminType == "SYSTEM")
{
SystemAdminView system = new SystemAdminView();
system.ShowDialog();
}
else if (adminType == "LOCAL")
{
LocalAdminView local = new LocalAdminView();
local.ShowDialog();
}
else if (IsManager(username, userPassword))
{
try
{
using (CompanyDBEntities context = new CompanyDBEntities())
{
// getting the manager for later actions with projects
tblUser user = (from x in context.tblUsers where x.Username == username select x).First();
manager = (from y in context.tblManagers where y.UserID == user.UserID select y).First();
ManagerView managerView = new ManagerView(manager);
managerView.ShowDialog();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
else
{
MessageBox.Show("Wrong username or password, please try again.");
}
}
public static tblManager GetManagerById(int id)
{
try
{
using (DAN_XLIIIEntities1 context = new DAN_XLIIIEntities1())
{
tblManager manager = (from x in context.tblManagers where x.ManagerID == id select x).FirstOrDefault();
return(manager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public ShowEmployeesViewModel(ShowEmployees employeeView, tblManager managerLogedIn)
{
view = employeeView;
managerService = new ManagerService();
userService = new UserService();
employeeService = new EmployeeService();
Manager = managerLogedIn;
Employee = new vwEmployee2();
EmployeeList = managerService.GetEmployeesOfManager(Manager.ManagerID);
//EmployeeList = FilterEmployeesOfManager(EmployeeList);
}
internal bool IsManager(string userName, string password)
{
try
{
using (HotelEntities context = new HotelEntities())
{
tblAccount account = (from a in context.tblAccounts where a.UserName == userName && a.Pass == password select a).First();
tblManager manager = (from m in context.tblManagers where m.AccountID == account.AccountID select m).First();
}
return(true);
}
catch
{
return(false);
}
}
