private void ShowPriceTime()
{
price = PriceTimeModel.SelectAll();
comboBoxPriceTime.DisplayMember = "Name";
comboBoxPriceTime.ValueMember = "Id";
comboBoxPriceTime.DataSource = price;
}
private void buttonDeletePriceTime_Click(object sender, EventArgs e)
{
if (priceTime.Count != 0)
{
var index = dataGridViewPriceTime.CurrentRow.Index;
int Id = priceTime[index].Id;
DialogResult result = MessageBox.Show("Удалить?", "Удаление", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
bool isDelete = PriceTimeModel.Delete(Id);
if (isDelete)
{
ShowPriceTime();
}
else
{
MessageBox.Show("Ошибка при удаления");
}
}
}
else
{
MessageBox.Show("Таблица пустая");
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (price == null)
{
price = new PriceTimeModel();
if (textBoxTypeTime.Text != "" && textBoxPriceTime.Text != "")
{
price.Name = textBoxTypeTime.Text;
price.Price = int.Parse(textBoxPriceTime.Text);
int lastId = PriceTimeModel.Insert(price);
if (lastId > 0)
{
Close();
}
else
{
MessageBox.Show("Ошибка при добавления");
}
}
else
{
MessageBox.Show("Заполните поля");
}
}
else
{
price.Name = textBoxTypeTime.Text;
price.Price = int.Parse(textBoxPriceTime.Text);
bool isUpdate = PriceTimeModel.Update(price);
if (isUpdate)
{
Close();
}
else
{
MessageBox.Show("Ошибка");
}
}
}
public static bool Update(PriceTimeModel priceTime)
{
return(DBManager.UpdatePriceTime(priceTime));
}
public static int Insert(PriceTimeModel price)
{
return(DBManager.InsertPriceTime(price));
}
private void ShowPriceTime()
{
priceTime = PriceTimeModel.SelectAll();
dataGridViewPriceTime.DataSource = priceTime;
}
