public int Insert(EndOfServices EndOfService) { try { using (var db = new HCMEntities()) { db.EndOfServices.Add(EndOfService); db.SaveChanges(); return(EndOfService.EndOfServiceID); } } 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; } catch { throw; } }
public int Delete(int EndOfServiceID, int UserIdentity) { try { using (var db = new HCMEntities()) { EndOfServices EndOfServiceObj = db.EndOfServices.SingleOrDefault(x => x.EndOfServiceID.Equals(EndOfServiceID)); db.EndOfServices.Remove(EndOfServiceObj); return(db.SaveChanges(UserIdentity)); } } catch { throw; } }
public int UpdateIsProcess(EndOfServices EOS) { try { using (var db = new HCMEntities()) { EndOfServices Obj = db.EndOfServices.FirstOrDefault(x => x.EndOfServiceID.Equals(EOS.EndOfServiceID)); Obj.isProcessed = EOS.isProcessed; Obj.LastUpdatedDate = EOS.LastUpdatedDate; Obj.LastUpdatedBy = EOS.LastUpdatedBy; return(db.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public int Update(EndOfServices EndOfService) { try { using (var db = new HCMEntities()) { EndOfServices EndOfServiceObj = db.EndOfServices.SingleOrDefault(x => x.EndOfServiceID.Equals(EndOfService.EndOfServiceID)); EndOfServiceObj.EmployeeCareerHistoryID = EndOfService.EmployeeCareerHistoryID; EndOfServiceObj.EndOfServiceDate = EndOfService.EndOfServiceDate; EndOfServiceObj.EndOfServiceDecisionNo = EndOfService.EndOfServiceDecisionNo; EndOfServiceObj.EndOfServiceDecisionDate = EndOfService.EndOfServiceDecisionDate; EndOfServiceObj.EndOfServiceReasonID = EndOfService.EndOfServiceReasonID; EndOfServiceObj.LastUpdatedDate = DateTime.Now; EndOfServiceObj.LastUpdatedBy = EndOfService.LastUpdatedBy; return(db.SaveChanges()); } } catch { throw; } }