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