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