public Payroll_Monthly_Deduction_Transaction findByMonthlyDeductionId(int deductionId)
{
Payroll_Monthly_Deduction_Transaction deduction = null;
try
{
using (var db = new PayrollModel())
{
deduction = db.Payroll_Monthly_Deduction_Transaction.Find(deductionId);
}
}
catch (Exception ex)
{
Console.WriteLine("find monthly Payroll_Monthly_Deduction_Transaction error" + ex.InnerException);
}
return(deduction);
}
public Boolean addMonthlyDeduction(Payroll_Monthly_Deduction_Transaction deduction)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
db.Payroll_Monthly_Deduction_Transaction.Add(deduction);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Payroll_Monthly_Deduction_Transaction add error " + ex.InnerException);
}
return(status);
}
public Boolean updateMonthlyDeduction(Payroll_Monthly_Deduction_Transaction deduction)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
Console.WriteLine("payroll monthly deduction updated");
db.Payroll_Monthly_Deduction_Transaction.AddOrUpdate(deduction);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Update payroll Payroll_Monthly_Deduction_Transaction problem " + ex.InnerException);
}
return(status);
}
public Boolean deleteAllowancebyId(int id)
{
Boolean status = false;
try
{
using (var db = new PayrollModel())
{
Payroll_Monthly_Deduction_Transaction deduction = db.Payroll_Monthly_Deduction_Transaction.First(b => b.DeductionTran_ID == id);
db.Payroll_Monthly_Deduction_Transaction.Remove(deduction);
db.SaveChanges();
status = true;
}
}
catch (Exception ex)
{
Console.WriteLine("delete monthly Payroll_Monthly_Deduction_Transaction error " + ex.InnerException);
}
return(status);
}
