public int Update(StopWorks StopWork)
{
try
{
using (var db = new HCMEntities())
{
StopWorks StopWorkObj = db.StopWorks.SingleOrDefault(x => x.StopWorkID.Equals(StopWork.StopWorkID));
StopWorkObj.StopWorkTypeID = StopWork.StopWorkTypeID;
StopWorkObj.StopWorkStartDate = StopWork.StopWorkStartDate;
StopWorkObj.StopWorkEndDate = StopWork.StopWorkEndDate;
StopWorkObj.StartStopWorkDecisionNumber = StopWork.StartStopWorkDecisionNumber;
StopWorkObj.StartStopWorkDecisionDate = StopWork.StartStopWorkDecisionDate;
StopWorkObj.EndStopWorkDecisionNumber = StopWork.EndStopWorkDecisionNumber;
StopWorkObj.EndStopWorkDecisionDate = StopWork.EndStopWorkDecisionDate;
StopWorkObj.StopPoint = StopWork.StopPoint;
StopWorkObj.IsConvicted = StopWork.IsConvicted;
StopWorkObj.Note = StopWork.Note;
StopWorkObj.LastUpdatedBy = StopWork.LastUpdatedBy;
StopWorkObj.LastUpdatedDate = StopWork.LastUpdatedDate;
StopWorkObj.EmployeeCareerHistoryID = StopWork.EmployeeCareerHistoryID;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int Delete(int StopWorkID)
{
try
{
using (var db = new HCMEntities())
{
StopWorks StopWorkObj = db.StopWorks.FirstOrDefault(x => x.StopWorkID.Equals(StopWorkID));
db.StopWorks.Remove(StopWorkObj);
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int Insert(StopWorks StopWork)
{
try
{
using (var db = new HCMEntities())
{
db.StopWorks.Add(StopWork);
db.SaveChanges();
return(StopWork.StopWorkID);
}
}
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;
}
}
