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