public tblEmployee AddEmployee(tblEmployee employee)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
if (employee.EmployeeID == 0)
{
tblEmployee newEmployee = new tblEmployee
{
EmployeeID = employee.EmployeeID,
EmployeeName = employee.EmployeeName,
EmployeeSurname = employee.EmployeeSurname,
EMail = employee.EMail,
JMBG = employee.JMBG,
DateOfBirthday = employee.DateOfBirthday,
AccountNumber = employee.AccountNumber,
UsernameLogin = employee.UsernameLogin,
PasswordLogin = employee.PasswordLogin,
Position = employee.Position,
Salary = employee.Salary,
AccessLevel = employee.AccessLevel,
SectorName = employee.SectorName
};
context.tblEmployees.Add(newEmployee);
context.SaveChanges();
employee.EmployeeID = newEmployee.EmployeeID;
return(employee);
}
else
{
tblEmployee employeeToEdit = (from r in context.tblEmployees where r.EmployeeID == employee.EmployeeID select r).First();
employeeToEdit.EmployeeName = employee.EmployeeName;
employeeToEdit.EmployeeSurname = employee.EmployeeSurname;
employeeToEdit.EMail = employee.EMail;
employeeToEdit.JMBG = employee.JMBG;
employeeToEdit.DateOfBirthday = employee.DateOfBirthday;
employeeToEdit.AccountNumber = employee.AccountNumber;
employeeToEdit.UsernameLogin = employee.UsernameLogin;
employeeToEdit.PasswordLogin = employee.PasswordLogin;
employeeToEdit.Position = employee.Position;
employeeToEdit.Salary = employee.Salary;
employeeToEdit.AccessLevel = employee.AccessLevel;
employeeToEdit.SectorName = employee.SectorName;
employeeToEdit.EmployeeID = employee.EmployeeID;
context.SaveChanges();
return(employee);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public void DeleteResult(int employeeID)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
tblEmployee employeeToDelete = (from r in context.tblEmployees where r.EmployeeID == employeeID select r).First();
context.tblEmployees.Remove(employeeToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
}
}
public void DeleteReportvw(int reportID)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
vwReportEmployee reportToDelete = (from r in context.vwReportEmployees where r.ReportID == reportID select r).First();
context.vwReportEmployees.Remove(reportToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
}
}
public List <tblReport> GetAllReportIDtbl(int ID)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
List <tblReport> list = new List <tblReport>();
list = (from x in context.tblReports where x.Employee == ID select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public List <vwReportEmployee> GetAllReport()
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
List <vwReportEmployee> list = new List <vwReportEmployee>();
list = (from x in context.vwReportEmployees select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public List <tblAccessLevel> GetAllAccessLevel()
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
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 <tblEmployee> GetResultsDetail(string jmbg)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
List <tblEmployee> list = new List <tblEmployee>();
list = (from x in context.tblEmployees where x.JMBG == jmbg select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public tblEmployee GetUsernamePassword(string username, string password)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
tblEmployee emoloyee = (from e in context.tblEmployees where e.UsernameLogin.Equals(username) where e.PasswordLogin.Equals(password) select e).First();
return(emoloyee);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblEmployee GetEmployeeEmail(string email)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
tblEmployee emoloyee = (from e in context.tblEmployees where e.EMail.Equals(email) select e).First();
return(emoloyee);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblReport AddReport(tblReport report)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
if (report.ReportID == 0)
{
tblReport newProducts = new tblReport
{
CurrentDate = report.CurrentDate,
ProjectName = report.ProjectName,
WorkHour = report.WorkHour,
Employee = report.Employee,
Position = report.Position
};
context.tblReports.Add(newProducts);
context.SaveChanges();
report.ReportID = newProducts.ReportID;
return(report);
}
else
{
tblReport reportToEdit = (from ss in context.tblReports where ss.ReportID == report.ReportID select ss).First();
reportToEdit.CurrentDate = report.CurrentDate;
reportToEdit.ProjectName = report.ProjectName;
reportToEdit.WorkHour = report.WorkHour;
reportToEdit.Employee = report.Employee;
reportToEdit.Position = report.Position;
reportToEdit.ReportID = report.ReportID;
context.SaveChanges();
return(report);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public bool IsReportIDvw(int reportID)
{
try
{
using (ManagerAppEntities context = new ManagerAppEntities())
{
int result = (from x in context.vwReportEmployees where x.ReportID == reportID select x.ReportID).FirstOrDefault();
if (result != 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(false);
}
}
