public int Delete(int EmployeeOldJobID, int UserIdentity)
{
try
{
using (var db = new HCMEntities())
{
EmployeesOldJobs EmployeesOldJobObj = db.EmployeesOldJobs.SingleOrDefault(x => x.EmployeeOldJobID.Equals(EmployeeOldJobID));
db.EmployeesOldJobs.Remove(EmployeesOldJobObj);
return(db.SaveChanges(UserIdentity));
}
}
catch
{
throw;
}
}
public int Insert(EmployeesOldJobs EmployeesOldJob)
{
try
{
using (var db = new HCMEntities())
{
db.EmployeesOldJobs.Add(EmployeesOldJob);
db.SaveChanges();
return(EmployeesOldJob.EmployeeOldJobID);
}
}
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;
}
}
public int Update(EmployeesOldJobs EmployeesOldJob)
{
try
{
using (var db = new HCMEntities())
{
EmployeesOldJobs EmployeesOldJobObj = db.EmployeesOldJobs.SingleOrDefault(x => x.EmployeeOldJobID.Equals(EmployeesOldJob.EmployeeOldJobID));
EmployeesOldJobObj.EmployeeCodeID = EmployeesOldJob.EmployeeCodeID;
EmployeesOldJobObj.JobName = EmployeesOldJob.JobName;
EmployeesOldJobObj.OrganizationName = EmployeesOldJob.OrganizationName;
EmployeesOldJobObj.RankName = EmployeesOldJob.RankName;
EmployeesOldJobObj.CareerDegreeName = EmployeesOldJob.CareerDegreeName;
EmployeesOldJobObj.EmployeeOldJobStartDate = EmployeesOldJob.EmployeeOldJobStartDate;
EmployeesOldJobObj.EmployeeOldJobEndDate = EmployeesOldJob.EmployeeOldJobEndDate;
EmployeesOldJobObj.LastUpdatedBy = EmployeesOldJob.LastUpdatedBy;
EmployeesOldJobObj.LastUpdatedDate = DateTime.Now;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
