public int Insert(EmployeesNormalVacationsBalances arg)
{
try
{
using (var db = new HCMEntities())
{
arg.LastUpdatedDate = DateTime.Now;
db.EmployeesNormalVacationsBalances.Add(arg);
db.SaveChanges();
return(arg.EmployeeNormalVacationBalanceID);
}
}
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(EmployeesNormalVacationsBalances arg)
{
try
{
using (var db = new HCMEntities())
{
EmployeesNormalVacationsBalances Obj = db.EmployeesNormalVacationsBalances.FirstOrDefault(x => x.EmployeeCodeID == arg.EmployeeCodeID);
Obj.ConsumedCurrentBalance = arg.ConsumedCurrentBalance;
Obj.ConsumedOldBalance = arg.ConsumedOldBalance;
Obj.DeservedCurrentBalance = arg.DeservedCurrentBalance;
Obj.DeservedOldBalance = arg.DeservedOldBalance;
Obj.ExpiredCurrentBalance = arg.ExpiredCurrentBalance;
Obj.InAdvanceBalance = arg.InAdvanceBalance;
Obj.InAdvConsumed = arg.InAdvConsumed;
Obj.RemainingCurrentBalance = arg.RemainingCurrentBalance;
Obj.RemainingOldBalance = arg.RemainingOldBalance;
Obj.TotalAvailableVacationBalance = arg.TotalAvailableVacationBalance;
Obj.TotalConsumedBalance = arg.TotalConsumedBalance;
Obj.TotalDeservedBalance = arg.TotalDeservedBalance;
Obj.TotalRemainingBalance = arg.TotalRemainingBalance;
Obj.LastUpdatedDate = DateTime.Now;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public bool InsertUpdate(EmployeesNormalVacationsBalances arg)
{
try
{
using (var db = new HCMEntities())
{
EmployeesNormalVacationsBalances Obj = db.EmployeesNormalVacationsBalances.FirstOrDefault(x => x.EmployeeCodeID == arg.EmployeeCodeID);
if (Obj != null && Obj.EmployeeNormalVacationBalanceID > 0)
{
Update(arg);
}
else
{
Insert(arg);
}
return(true);
}
}
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;
}
}