private void buttonDeleteByIdExpensesStore_Click(object sender, EventArgs e)
{
if (expenses_Store.Count != 0)
{
var index = dataGridViewEncasesStore.CurrentRow.Index;
int Id = expenses_Store[index].Id;
DialogResult result = MessageBox.Show("Удалить?", "Удаление", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
bool delete = Expenses_StoreModel.Delete(Id);
if (delete)
{
ShowExpensesStore();
}
else
{
MessageBox.Show("ошибка");
}
}
}
else
{
MessageBox.Show("Таблица пустая");
}
}
private void buttonAddGood_Click(object sender, EventArgs e)
{
if (numericUpDownAmount.Value != 0)
{
expenses_Store = Expenses_StoreModel.SelectAll();
int goodId = comboBoxNameGood.SelectedIndex + 1;
var hour = DateTime.Now.Hour;
var day = DateTime.Now.Day;
var month = DateTime.Now.Month;
var year = DateTime.Now.Year;
if (hour >= 9 && hour <= 23)
{
var date = new DateTime(year, month, day, hour, dateTimePicker1.Value.Minute, dateTimePicker1.Value.Second);
dateTimePicker1.Value = date;
}
else if (hour >= 0 && hour <= 6)
{
var date = new DateTime(year, month, day - 1, hour, dateTimePicker1.Value.Minute, dateTimePicker1.Value.Second);
dateTimePicker1.Value = date;
}
Expenses_StoreModel expenses = new Expenses_StoreModel();
expenses.Name = Store[goodId - 1].Name;
expenses.Price = Store[goodId - 1].Price * Convert.ToInt32(numericUpDownAmount.Value);
expenses.Date = dateTimePicker1.Value.ToString("dd-MM-yyyy HH:mm");
expenses.Amount = Convert.ToInt32(numericUpDownAmount.Value);
int lastId = Expenses_StoreModel.Insert(expenses);
if (lastId > 0)
{
int Id = comboBoxNameGood.SelectedIndex + 1;
StoreModel stores = new StoreModel();
stores.Id = Id;
stores.Name = Store[Id - 1].Name;
stores.Price = Store[Id - 1].Price;
stores.Amount = Convert.ToInt32(numericUpDownAmount.Value);
bool isUpdate = StoreModel.UpdateGood(stores);
if (isUpdate)
{
ShowExpenses_Store();
numericUpDownAmount.Value = 0;
}
else
{
MessageBox.Show("Ошибка при заказа");
}
}
else
{
MessageBox.Show("Error");
}
}
else
{
MessageBox.Show("Количество не выбрано");
}
}
private void ShowExpenses_Store()
{
expenses_Store = Expenses_StoreModel.SelectAll();
dataGridViewExpenses_Store.DataSource = expenses_Store;
}
public static int Insert(Expenses_StoreModel expenses_store)
{
return(DBManager.InsertExpenses_Store(expenses_store));
}
