public static tblEmployee GetEmployeeByUsernameAndPsw(string username, string password)
{
try
{
using (DataRecordsEntities1 context = new DataRecordsEntities1())
{
tblEmployee result = (from x in context.tblEmployees where x.username == username && x.password == password select x).FirstOrDefault();
return result;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return null;
}
}
public static bool isManager(tblEmployee e)
{
try
{
using (DataRecordsEntities1 context = new DataRecordsEntities1())
{
tblManager result = (from x in context.tblManagers where x.employeeId == e.employeeId select x).FirstOrDefault();
if (result != null)
{
return true;
}
else
{
return false;
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return false;
}
}
public static void DeleteEmployee(tblEmployee emp)
{
try
{
using (DataRecordsEntities1 context = new DataRecordsEntities1())
{
if (isManager(emp))
{
tblManager managerToDelete = (from u in context.tblManagers where u.employeeId == emp.employeeId select u).First();
context.tblManagers.Remove(managerToDelete);
context.SaveChanges();
}
tblEmployee userToDelete = (from u in context.tblEmployees where u.employeeId == emp.employeeId select u).First();
context.tblEmployees.Remove(userToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// Add new employee or manager to db.
/// </summary>
/// <param name="employee">Add this employee to db</param>
/// <param name="manager">true if this employee is also and manager</param>
public static tblEmployee AddNewEmployeeOrManager(tblEmployee employee, bool manager)
{
try
{
using (DataRecordsEntities1 context = new DataRecordsEntities1())
{
if (employee.employeeId == 0)
{
//add into tblEmployee
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.mail = employee.mail;
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 (manager)
{
//add into tblManager
tblManager newManager = new tblManager();
newManager.employeeId = employee.employeeId;
newManager.sector = employee.sector;
newManager.access = employee.access;
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.mail = employee.mail;
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;
}
}