public int Delete(OverTimes OverTime, int UserIdentity)
{
try
{
using (var db = new HCMEntities())
{
OverTimes OverTimeObj = db.OverTimes.SingleOrDefault(x => x.OverTimeID.Equals(OverTime.OverTimeID));
OverTimeObj.OverTimesDetails.ToList().ForEach(d => db.OverTimesDetails.Remove(d));
db.OverTimes.Remove(OverTimeObj);
return(db.SaveChanges(UserIdentity));
}
}
catch
{
throw;
}
}
public int Approve(OverTimes OverTime)
{
try
{
using (var db = new HCMEntities())
{
OverTimes OverTimeObj = db.OverTimes.SingleOrDefault(x => x.OverTimeID.Equals(OverTime.OverTimeID));
OverTimeObj.ApprovedBy = OverTime.ApprovedBy;
OverTimeObj.ApprovedDate = OverTime.ApprovedDate;
OverTimeObj.IsApproved = OverTime.IsApproved;
OverTimeObj.LastUpdatedBy = OverTime.LastUpdatedBy;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int Update(OverTimes OverTime)
{
try
{
using (var db = new HCMEntities())
{
OverTimes OverTimeObj = db.OverTimes.SingleOrDefault(x => x.OverTimeID.Equals(OverTime.OverTimeID));
OverTimeObj.OverTimeID = OverTime.OverTimeID;
OverTimeObj.Tasks = OverTime.Tasks;
OverTimeObj.WeekWorkHoursAvg = OverTime.WeekWorkHoursAvg;
OverTimeObj.FridayHoursAvg = OverTime.FridayHoursAvg;
OverTimeObj.SaturdayHoursAvg = OverTime.SaturdayHoursAvg;
OverTimeObj.LastUpdatedDate = OverTime.LastUpdatedDate;
OverTimeObj.LastUpdatedBy = OverTime.LastUpdatedBy;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int Insert(OverTimes OverTime)
{
try
{
using (var db = new HCMEntities())
{
db.OverTimes.Add(OverTime);
db.SaveChanges();
return(OverTime.OverTimeID);
}
}
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;
}
}