private void buttonUpdate_Click(object sender, EventArgs e)
{
if (store != null)
{
store.Name = textBoxName.Text;
store.Price = Convert.ToInt32(textBoxPrice.Text);
store.Amount = Convert.ToInt32(textBoxAmount.Text);
store.Type = textBoxType.Text;
bool isUpdate = StoreModel.Update2(store);
if (isUpdate)
{
StoreReportModel report = new StoreReportModel();
report.Name = textBoxName.Text;
report.Amount = Convert.ToInt32(textBoxAmount.Text);
report.Date = dateTimePicker1.Value.ToString("dd-MM-yyyy");
report.Type = store.Type;
int Id = StoreReportModel.Insert(report);
if (Id >= 0)
{
Close();
}
else
{
MessageBox.Show("Ошибки");
}
}
else
{
MessageBox.Show("ошибка");
}
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
var index = dataGridView1.CurrentRow.Index;
int Id = storeReport[index].Id;
DialogResult result = MessageBox.Show("Удалить?", "Удаление", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
bool delete = StoreReportModel.Delete(Id);
if (delete)
{
ShowStoreReport();
}
else
{
MessageBox.Show("Ошибка");
}
}
}
public static int Insert(StoreReportModel Store)
{
return(DBManager.InsertStoreReport(Store));
}
private void buttonInsert_Click(object sender, EventArgs e)
{
if (store == null)
{
stores = StoreModel.SelectAll();
store = new StoreModel();
if (textBoxName.Text != "" && textBoxPrice.Text != "" && textBoxAmount.Text != "")
{
InsertGoods();
if (radioButtonDrink.Checked == true)
{
store.Type = textBoxDrink.Text;
}
else if (radioButtonGoods.Checked == true)
{
store.Type = textBoxGoods.Text;
}
for (int i = 0; i < stores.Count; i++)
{
if (store.Name == stores[i].Name)
{
MessageBox.Show("Товар с таким названием уже есть");
textBoxName.Text = null;
textBoxAmount.Text = null;
textBoxPrice.Text = null;
store = null;
return;
}
}
int lastId = StoreModel.Insert(store);
if (lastId >= 0)
{
StoreReportModel report = new StoreReportModel();
report.Name = textBoxName.Text;
report.Amount = Convert.ToInt32(textBoxAmount.Text);
report.Date = dateTimePicker1.Value.ToString("dd-MM-yyyy");
report.Type = store.Type;
int Id = StoreReportModel.Insert(report);
if (Id >= 0)
{
Close();
}
else
{
MessageBox.Show("ошибки");
}
}
else
{
MessageBox.Show("Ошибка");
}
}
else
{
MessageBox.Show("Заполните поля");
}
}
else
{
if (textBoxName.Text != "" && ((textBoxPrice.Text != "" && textBoxAmount.Text != "") || (textBoxPrice.Text != "" || textBoxAmount.Text != "")))
{
InsertGoods();
StoreReportModel report = new StoreReportModel();
if (radioButtonDrink.Checked == true)
{
store.Type = textBoxDrink.Text;
}
else if (radioButtonGoods.Checked == true)
{
store.Type = textBoxGoods.Text;
}
bool isUpdated = StoreModel.Update(store);
if (isUpdated)
{
stores = StoreModel.SelectAll();
for (int i = 0; i < stores.Count; i++)
{
if (stores[i].Id == store.Id)
{
var numb = i;
report.Amount = stores[numb].Amount;
}
}
report.Name = textBoxName.Text;
report.Date = dateTimePicker1.Value.ToString("dd-MM-yyyy");
report.Type = store.Type;
int Id = StoreReportModel.Insert(report);
if (Id >= 0)
{
Close();
}
else
{
MessageBox.Show("Ошибки");
}
}
else
{
MessageBox.Show("ошибка изменения");
}
}
else
{
MessageBox.Show("Заполните поля");
}
}
}
private void ShowStoreReport()
{
storeReport = StoreReportModel.SelectAll();
dataGridView1.DataSource = storeReport;
}