private void RefreshDiscont() { groupBoxDiscontId.Enabled = false; groupBoxDiscontId.Text = "Скидка"; labelDiscont.Text = ""; comboBoxDiscont.Items.Clear(); discontsId = dB.getDiscontId(); disconts = new List <Discont>(); dataGridViewDiscont.Rows.Clear(); dataGridViewDiscont.Columns.Clear(); dataGridViewDiscont.Columns.Add("id", "Номер"); dataGridViewDiscont.Columns.Add("Name", "Название"); dataGridViewDiscont.Columns.Add("Description", "Описание"); dataGridViewDiscont.Columns.Add("Percent", "Скидка в процентах"); foreach (int id in discontsId) { comboBoxDiscont.Items.Add(id); Discont discont = dB.getDiscont(id); disconts.Add(discont); dataGridViewDiscont.Rows.Add(discont.id, discont.Name, discont.Description, discont.Percent); } }
public int deleteDiscont(Discont discont) { connection.Open(); SQLiteCommand command = new SQLiteCommand(discont.SQLDelete(), connection); int result = command.ExecuteNonQuery(); connection.Close(); return(result); }
public FormDiscont() { InitializeComponent(); buttonSave.DialogResult = DialogResult.OK; buttonCancel.DialogResult = DialogResult.Cancel; discont = new Discont(); this.Text = "Создание скидку"; buttonSave.Text = "Создать"; }
public List <int> getDiscontId() { connection.Open(); SQLiteCommand command = new SQLiteCommand(Discont.SQLSelectId(), connection); SQLiteDataReader reader = command.ExecuteReader(); List <int> list = new List <int>(); foreach (DbDataRecord record in reader) { list.Add(Convert.ToInt32(record["id"].ToString())); } connection.Close(); return(list); }
public FormDiscont(Discont discont) { InitializeComponent(); textBoxName.Text = discont.Name; textBoxDescription.Text = discont.Description; numericUpDownPercent.Value = Convert.ToDecimal(discont.Percent); buttonSave.DialogResult = DialogResult.OK; buttonCancel.DialogResult = DialogResult.Cancel; this.discont = discont; this.Text = "Скидка №" + discont.id; buttonSave.Text = "Изменить"; }
public Discont getDiscont(int id) { connection.Open(); SQLiteCommand command = new SQLiteCommand(Discont.SQLSelect(id), connection); SQLiteDataReader reader = command.ExecuteReader(); Discont discont = new Discont(); foreach (DbDataRecord record in reader) { //объект на самом деле только один, потому что ищется по первичному ключу //но я не нашла синтаксис для взятия этой строки discont = new Discont(record); } connection.Close(); return(discont); }