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); }