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 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 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());
}
}