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);
        }
示例#2
0
        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);
        }