public int Insert(EmployeesVacationsOpeningBalances EmployeeVacationOpeningBalance)
{
try
{
using (var db = new HCMEntities())
{
db.EmployeesVacationsOpeningBalances.Add(EmployeeVacationOpeningBalance);
db.SaveChanges();
return(EmployeeVacationOpeningBalance.EmployeeVacationOpeningBalanceID);
}
}
//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
{
throw;
}
}
public int Update(EmployeesVacationsOpeningBalances EmployeeVacationOpeningBalance)
{
try
{
using (var db = new HCMEntities())
{
EmployeesVacationsOpeningBalances EmployeesVacationsOpeningBalancesObj = db.EmployeesVacationsOpeningBalances.SingleOrDefault(x => x.EmployeeVacationOpeningBalanceID.Equals(EmployeeVacationOpeningBalance.EmployeeVacationOpeningBalanceID));
EmployeesVacationsOpeningBalancesObj.OpeningBalance = EmployeeVacationOpeningBalance.OpeningBalance;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}