public static bool CreateEmployee(EvolutionRepository.Models.Employee CreateEmp) { var Result = false; try { using (var ctx = new EvolutionRepository.Models.EvolutionDBContext()) { if (Object.Equals(null, ctx.Employees.FirstOrDefault(x => x.EmployeeID == CreateEmp.EmployeeID))) { ctx.Employees.Add(CreateEmp); ctx.SaveChanges(); } Result = true; } } catch (DbEntityValidationException ex) { // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(ErrorHandler.BuildDbEntityValidationErrorMessage(ex), ex.EntityValidationErrors); } catch (Exception ex) { Result = false; throw ex; } return(Result); }
public static bool UpdateEmployee(EvolutionRepository.Models.Employee UpdateEmp) { var Result = false; try { using (var ctx = new EvolutionRepository.Models.EvolutionDBContext()) { var DBEmp = ctx.Employees.FirstOrDefault(x => x.EmployeeID == UpdateEmp.EmployeeID); //DBEmp.BankAccountID = UpdateEmp.BankAccountID; //DBEmp.CompanyNumber = UpdateEmp.CompanyNumber; //DBEmp.ContactName = UpdateEmp.ContactName; //DBEmp.EmailAddress = UpdateEmp.EmailAddress; //DBEmp.FaxCode = UpdateEmp.FaxCode; //DBEmp.FaxNumber = UpdateEmp.FaxNumber; //DBEmp.JurisdictionID = UpdateEmp.JurisdictionID; //DBEmp.Latitude = UpdateEmp.Latitude; //DBEmp.Longitude = UpdateEmp.Longitude; //DBEmp.MaximumMachines = UpdateEmp.MaximumMachines; //DBEmp.EmployeeName = UpdateEmp.EmployeeName; //DBEmp.EmployeeStatusID = UpdateEmp.EmployeeStatusID; //DBEmp.EmployeeSubTypeID = UpdateEmp.EmployeeSubTypeID; //DBEmp.EmployeeTypeID = UpdateEmp.EmployeeTypeID; //DBEmp.ParentID = UpdateEmp.ParentID; //DBEmp.TaxNumber = UpdateEmp.TaxNumber; //DBEmp.TelephoneCode = UpdateEmp.TelephoneCode; //DBEmp.TelephoneNumber = UpdateEmp.TelephoneNumber; //DBEmp.Timestamp = System.Text.ASCIIEncoding.Unicode.GetBytes(DateTime.Now.ToString()); //DBEmp.WebSiteURL = UpdateEmp.WebSiteURL; ctx.SaveChanges(); Result = true; } } catch (Exception ex) { Result = false; throw ex; } return(Result); }