public int AddBudGet(t_EE_Budget model) { string sql = $@"insert into t_EE_Budget(YearID,MonthBudget,Month) values({model.YearID},{model.MonthBudget},{model.Month})"; return(ExecuteSqlCommand(sql)); }
public t_EE_Budget GetMonthBudgetByID(int id) { t_EE_Budget data = new t_EE_Budget(); try { data = _dbFactory.budget.GetMonthBudgetByID(id); } catch (Exception ex) { throw ex; } return(data); }
public int UpdateBudGet(t_EE_Budget model) { int n = 0; try { n = _dbFactory.budget.UpdateBudGet(model); } catch (Exception ex) { throw ex; } return(n); }
public int UpdateBudGet(t_EE_Budget model) { string sql = $@"update t_EE_Budget set YearID={model.YearID},MonthBudget={model.MonthBudget},Month={model.Month} where ID={model.ID}"; return(ExecuteSqlCommand(sql)); }