public Payroll_Monthly_Allowances_Transaction findByMonthlyAllowanceId(int allowanceId)
{
Payroll_Monthly_Allowances_Transaction allowance = null;
try
{
using (var db = new PayrollModel())
{
allowance = db.Payroll_Monthly_Allowances_Transaction.Find(allowanceId);
}
}
catch (Exception ex)
{
Console.WriteLine("find monthly allowance error" + ex.InnerException);
}
return(allowance);
}
public Boolean addMonthlyAllowance(Payroll_Monthly_Allowances_Transaction allowance)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
db.Payroll_Monthly_Allowances_Transaction.Add(allowance);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Allowance add error " + ex.InnerException);
}
return(status);
}
public Boolean updateMonthlyAllowance(Payroll_Monthly_Allowances_Transaction allowance)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
Console.WriteLine("payroll monthly allowances updated");
db.Payroll_Monthly_Allowances_Transaction.AddOrUpdate(allowance);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Update payroll monthly allowance problem " + ex.InnerException);
}
return(status);
}
public Boolean deleteAllowancebyId(int id)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
Payroll_Monthly_Allowances_Transaction allowance = db.Payroll_Monthly_Allowances_Transaction.First(b => b.Allowance_ID == id);
db.Payroll_Monthly_Allowances_Transaction.Remove(allowance);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("delete monthly allowance error " + ex.InnerException);
}
return(status);
}
