public void AddItem(AbonementIncome elem) { string sql = "INSERT INTO AbonementIncome([Date], Summ) VALUES (@Date, @Summ)"; SqlCommand cmd = new SqlCommand(sql); cmd.Parameters.Add("@Date", elem.Date.ToString("yyyy-MM-dd")); cmd.Parameters.Add("@Summ", elem.Summ); _connRepos.Execute(cmd); }
public void EditItem(int id, AbonementIncome elem) { string sql = "UPDATE AbonementIncome SET Summ = @Summ, Date = @Date " + "where Id = " + id; SqlCommand cmd = new SqlCommand(sql); cmd.Parameters.Add("@Date", elem.Date.ToString("yyyy-MM-dd")); cmd.Parameters.Add("@Summ", elem.Summ); _connRepos.Execute(cmd); }
public ActionResult Delete(AbonementIncome elem) { try { _abonementIncomeService.Delete(elem.Id); return(RedirectToAction("Index")); } catch { return(View()); } }
public void Edit(int id, AbonementIncome elem) { _abonementIncomeRepository.EditItem(id, elem); }
public void Create(AbonementIncome elem) { _abonementIncomeRepository.AddItem(elem); }
public ActionResult Edit(int id, AbonementIncome elem) { _abonementIncomeService.Edit(id, elem); return(RedirectToAction("Index")); }
public ActionResult Create(AbonementIncome elem) { _abonementIncomeService.Create(elem); return(RedirectToAction("Index")); }