public static FamilyExpenseUpdateViewModel GetFamilyExpenseById(int id)
{
Entities entities = new Entities();
Expenses familyExpense = entities.Expenses.Where(x => x.Id == id).FirstOrDefault();
FamilyExpenseUpdateViewModel model = new FamilyExpenseUpdateViewModel
{
Id = familyExpense.Id,
Expense = familyExpense.Value,
ExpenseDay = familyExpense.ExpenseDay,
Note = familyExpense.Note,
Source = familyExpense.Name
};
return(model);
}
public static int UpdateFamilyExpense(FamilyExpenseUpdateViewModel model)
{
Entities entities = new Entities();
DateTime current = DateTime.Now;
Expenses familyExpense = entities.Expenses.Where(x => x.Id == model.Id).FirstOrDefault();
familyExpense.Name = model.Source;
familyExpense.ExpenseDay = model.ExpenseDay.Value;
familyExpense.Value = model.Expense.Value;
familyExpense.Note = model.Note;
entities.Expenses.Attach(familyExpense);
entities.Entry(familyExpense).State = System.Data.Entity.EntityState.Modified;
return(entities.SaveChanges());
}
public ActionResult _FamilyExpenseUpdateForm(FamilyExpenseUpdateViewModel model)
{
if (ModelState.IsValid)
{
int result = FamilyExpenseQueries.UpdateFamilyExpense(model);
if (result > 0)
{
return(Content("success"));
}
else
{
return(Content("failed"));
}
}
else
{
return(PartialView(model));
}
}
public ActionResult _FamilyExpenseUpdateForm(int id)
{
FamilyExpenseUpdateViewModel model = FamilyExpenseQueries.GetFamilyExpenseById(id);
return(PartialView(model));
}
