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;
}
}
