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