public void CreateExpensePlan(ExpensePlanModel ep) { db.EXPENSE_PLAN.Add(new EXPENSE_PLAN() { plan_expense_user_FK = ep.plan_expense_user_FK, plan_expense_type_Fk = ep.plan_expense_type_Fk, plan_expense_date = ep.plan_expense_date, plan_expense_size = ep.plan_expense_size }); Save(); }
public void UpdateExpensePlan(ExpensePlanModel epm) { var u = db.USER.ToList().Where(i => i.id == epm.plan_expense_user_FK).FirstOrDefault(); EXPENSE_PLAN e_p = u.EXPENSE_PLAN.ToList().Where(i => ((DateTime)i.plan_expense_date).Date == epm.plan_expense_date.Date).FirstOrDefault(); if (e_p == null) { CreateExpensePlan(epm); } else { e_p.plan_expense_user_FK = epm.plan_expense_user_FK; e_p.plan_expense_type_Fk = epm.plan_expense_type_Fk; e_p.plan_expense_date = epm.plan_expense_date; e_p.plan_expense_size = epm.plan_expense_size; Save(); } }