public int Insert(EVacationsRequests EVacationRequest) { try { using (var db = new HCMEntities()) { db.EVacationsRequests.Add(EVacationRequest); db.SaveChanges(); return(EVacationRequest.EVacationRequestID); } } 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 (Exception ex) { throw ex; } }
public int Delete(int EVacationRequestID, int UserIdentity) { try { using (var db = new HCMEntities()) { EVacationsRequests EVacationRequestObj = db.EVacationsRequests.FirstOrDefault(x => x.EVacationRequestID.Equals(EVacationRequestID)); db.EVacationsRequests.Remove(EVacationRequestObj); return(db.SaveChanges(UserIdentity)); } } catch { throw; } }
public int UpdateStatus(EVacationsRequests EVacationRequest) { try { using (var db = new HCMEntities()) { EVacationsRequests EVacationRequestObj = db.EVacationsRequests.FirstOrDefault(x => x.EVacationRequestID.Equals(EVacationRequest.EVacationRequestID)); EVacationRequestObj.EVacationRequestStatusID = EVacationRequest.EVacationRequestStatusID; EVacationRequestObj.CancellationReasonByHR = EVacationRequest.CancellationReasonByHR; EVacationRequestObj.LastUpdatedDate = EVacationRequest.LastUpdatedDate; EVacationRequestObj.LastUpdatedBy = EVacationRequest.LastUpdatedBy; return(db.SaveChanges()); } } catch { throw; } }
public int Update(EVacationsRequests EVacationRequest) { try { using (var db = new HCMEntities()) { EVacationsRequests EVacationRequestObj = db.EVacationsRequests.FirstOrDefault(x => x.EVacationRequestID.Equals(EVacationRequest.EVacationRequestID)); EVacationRequestObj.EVacationRequestStatusID = EVacationRequest.EVacationRequestStatusID; EVacationRequestObj.ApprovedBy = EVacationRequest.ApprovedBy; EVacationRequestObj.ApprovalDateTime = EVacationRequest.ApprovalDateTime; EVacationRequestObj.ApproverNotes = EVacationRequest.ApproverNotes; EVacationRequestObj.LastUpdatedDate = DateTime.Now; EVacationRequestObj.LastUpdatedBy = EVacationRequest.LastUpdatedBy; return(db.SaveChanges()); } } catch { throw; } }