public int Delete(int EndOfServiceVacationID, int UserIdentity) { try { using (var db = new HCMEntities()) { EndOfServicesVacations EndOfServiceVacation = db.EndOfServicesVacations.SingleOrDefault(x => x.EndOfServiceVacationID.Equals(EndOfServiceVacationID)); db.EndOfServicesVacations.Remove(EndOfServiceVacation); return(db.SaveChanges(UserIdentity)); } } catch { throw; } }
public int Update(EndOfServicesVacations EndOfServiceVacation) { try { using (var db = new HCMEntities()) { EndOfServicesVacations EndOfServiceVacationObj = db.EndOfServicesVacations.SingleOrDefault(x => x.EndOfServiceVacationID.Equals(EndOfServiceVacation.EndOfServiceVacationID)); EndOfServiceVacationObj.EndOfServiceVacationID = EndOfServiceVacation.EndOfServiceVacationID; EndOfServiceVacationObj.EndOfServiceID = EndOfServiceVacation.EndOfServiceID; EndOfServiceVacationObj.VacationTypeID = EndOfServiceVacation.VacationTypeID; EndOfServiceVacationObj.LastUpdatedDate = DateTime.Now; EndOfServiceVacationObj.LastUpdatedBy = EndOfServiceVacation.LastUpdatedBy; EndOfServiceVacationObj.VacationStartDate = EndOfServiceVacation.VacationStartDate; EndOfServiceVacationObj.VacationEndDate = EndOfServiceVacation.VacationEndDate; return(db.SaveChanges()); } } catch { throw; } }
public int Insert(EndOfServicesVacations EndOfServiceVacation) { try { using (var db = new HCMEntities()) { db.EndOfServicesVacations.Add(EndOfServiceVacation); db.SaveChanges(); return(EndOfServiceVacation.EndOfServiceVacationID); } } 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; } }