public tblReport AddReport(vwReport report)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblReport newReport = new tblReport();
newReport.EmployeeID = report.EmployeeID;
newReport.DateOfReport = DateTime.Today;
newReport.Position = report.Position;
newReport.Project = report.Project;
context.tblReports.Add(newReport);
context.SaveChanges();
report.ReportID = newReport.ReportID;
return(newReport);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblEmployee EditEmployee(tblEmployee employee)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblEmployee employeeToEdit = (from u in context.tblEmployees
where u.EmployeeID == employee.EmployeeID
select u).First();
employeeToEdit.FirstName = employee.FirstName;
employeeToEdit.LastName = employee.LastName;
employeeToEdit.JMBG = employee.JMBG;
employeeToEdit.Email = employee.Email;
employeeToEdit.DateOfBirth = employee.DateOfBirth;
employeeToEdit.IsMenager = false;
employeeToEdit.Position = employee.Position;
employeeToEdit.Salary = employee.Salary;
employeeToEdit.AccountNumber = employee.AccountNumber;
employeeToEdit.Username = employee.Username;
employeeToEdit.Passwd = employee.Passwd;
context.SaveChanges();
return(employee);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <tblEmployee> GetAllNonMenagerEmployees()
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
List <tblEmployee> list = new List <tblEmployee>();
list = (from x in context.tblEmployees where x.IsMenager == false select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <tblAccessLevel> GetAllAccessLevels()
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
List <tblAccessLevel> list = new List <tblAccessLevel>();
list = (from x in context.tblAccessLevels select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwReport> GetAllReportsOfEmployee(tblEmployee employee)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
List <vwReport> list = new List <vwReport>();
list = (from x in context.vwReports
where x.EmployeeID == employee.EmployeeID
select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblAccessLevel GetAccessLevelByID(int accesLevelId)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblAccessLevel accLevelFromDB = (from r in context.tblAccessLevels
where r.ID == accesLevelId
select r).First();
return(accLevelFromDB);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblEmployee GetEmployeeByUsername(string username)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblEmployee managerFromDb = (from r in context.tblEmployees
where r.Username == username && r.IsMenager == true
select r).First();
return(managerFromDb);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblEmployee GetEmployeeByUsername(string username)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblEmployee currentUser = (from e in context.tblEmployees where e.Username == username select e).First();
return(currentUser);
//FileLoging fileLog = FileLoging.Instance();
//fileLog.LogDeleteUserToFile(userToDelete);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblRole GetRoleByID(int roleId)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblRole roleFromDB = (from r in context.tblRoles where r.RoleID == roleId select r).First();
return(roleFromDB);
//FileLoging fileLog = FileLoging.Instance();
//fileLog.LogDeleteUserToFile(userToDelete);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void DeleteReport(int id)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblReport reportToDelete = (from u in context.tblReports
where u.ReportID == id
select u).First();
context.tblReports.Remove(reportToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public void DeleteEmployee(int employeeID)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblEmployee employeeToDelete = (from u in context.tblEmployees
where u.EmployeeID == employeeID
select u).First();
context.tblEmployees.Remove(employeeToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public tblEmployee AddMenager(tblEmployee menager)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblEmployee newMenager = new tblEmployee();
newMenager.FirstName = menager.LastName;
newMenager.LastName = menager.LastName;
newMenager.JMBG = menager.JMBG;
newMenager.Email = menager.Email;
newMenager.DateOfBirth = menager.DateOfBirth;
newMenager.IsMenager = true;
newMenager.Position = menager.Position;
newMenager.Salary = menager.Salary;
newMenager.AccountNumber = menager.AccountNumber;
newMenager.Username = menager.Username;
newMenager.Passwd = menager.Passwd;
newMenager.RoleID = menager.RoleID;
newMenager.SectorID = menager.SectorID;
context.tblEmployees.Add(newMenager);
context.SaveChanges();
menager.EmployeeID = newMenager.EmployeeID;
return(menager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblEmployee AddEmployee(tblEmployee employee)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblEmployee newEmployee = new tblEmployee();
newEmployee.FirstName = employee.FirstName;
newEmployee.LastName = employee.LastName;
newEmployee.JMBG = employee.JMBG;
newEmployee.Email = employee.Email;
newEmployee.DateOfBirth = employee.DateOfBirth;
newEmployee.IsMenager = false;
newEmployee.Position = employee.Position;
newEmployee.Salary = employee.Salary;
newEmployee.AccountNumber = employee.AccountNumber;
newEmployee.Username = employee.Username;
newEmployee.Passwd = employee.Passwd;
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);
}
}
public tblReport EditReport(vwReport report)
{
try
{
using (WorkingHoursDBEntities context = new WorkingHoursDBEntities())
{
tblReport reportToEdit = (from u in context.tblReports
where u.ReportID == report.ReportID select u).First();
reportToEdit.Position = report.Position;
reportToEdit.Project = report.Project;
reportToEdit.NumberOfHours = report.NumberOfHours;
context.SaveChanges();
return(reportToEdit);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}