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 AddItem(Charge elem) { string sql = "INSERT INTO Charges([Date], Summ, Name) VALUES (@Date, @Summ, @Name)"; SqlCommand cmd = new SqlCommand(sql); cmd.Parameters.Add("@Date", elem.Date.ToString("yyyy-MM-dd")); cmd.Parameters.Add("@Summ", elem.Summ); cmd.Parameters.Add("@Name", elem.Name); _connRepos.Execute(cmd); }