public int Delete(int EmployeeOldJobID, int UserIdentity) { try { using (var db = new HCMEntities()) { EmployeesOldJobs EmployeesOldJobObj = db.EmployeesOldJobs.SingleOrDefault(x => x.EmployeeOldJobID.Equals(EmployeeOldJobID)); db.EmployeesOldJobs.Remove(EmployeesOldJobObj); return(db.SaveChanges(UserIdentity)); } } catch { throw; } }
public int Insert(EmployeesOldJobs EmployeesOldJob) { try { using (var db = new HCMEntities()) { db.EmployeesOldJobs.Add(EmployeesOldJob); db.SaveChanges(); return(EmployeesOldJob.EmployeeOldJobID); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public int Update(EmployeesOldJobs EmployeesOldJob) { try { using (var db = new HCMEntities()) { EmployeesOldJobs EmployeesOldJobObj = db.EmployeesOldJobs.SingleOrDefault(x => x.EmployeeOldJobID.Equals(EmployeesOldJob.EmployeeOldJobID)); EmployeesOldJobObj.EmployeeCodeID = EmployeesOldJob.EmployeeCodeID; EmployeesOldJobObj.JobName = EmployeesOldJob.JobName; EmployeesOldJobObj.OrganizationName = EmployeesOldJob.OrganizationName; EmployeesOldJobObj.RankName = EmployeesOldJob.RankName; EmployeesOldJobObj.CareerDegreeName = EmployeesOldJob.CareerDegreeName; EmployeesOldJobObj.EmployeeOldJobStartDate = EmployeesOldJob.EmployeeOldJobStartDate; EmployeesOldJobObj.EmployeeOldJobEndDate = EmployeesOldJob.EmployeeOldJobEndDate; EmployeesOldJobObj.LastUpdatedBy = EmployeesOldJob.LastUpdatedBy; EmployeesOldJobObj.LastUpdatedDate = DateTime.Now; return(db.SaveChanges()); } } catch { throw; } }