private void UpdateTempOutcomesForm_Load(object sender, EventArgs e) { storeModel = StoreModel.SelectAll(); numericUpDownAmount.Maximum = storeModel[Id - 1].Amount; if (temp != null) { textBoxRoomName.Text = temp.RoomName; textBoxName.Text = temp.Name; textBoxPrice.Text = Convert.ToString(temp.Price); numericUpDownAmount.Value = temp.Amount; } }
private void WorkerForm_Load(object sender, EventArgs e) { buttonAddEncash.Enabled = false; ComboBoxRooms(); ShowRooms(); ShowBarTable(); ShowExpenses(); ShowComboBox(); ShowExpenses_Store(); ShowEncash(); Store = StoreModel.SelectAll(); var index = comboBoxNameGood.SelectedIndex; if (Store.Count != 0) { numericUpDownAmount.Maximum = Store[index].Amount; } else { numericUpDownAmount.Maximum = 0; } }
private void buttonSelect_Click(object sender, EventArgs e) { if (timer.Enabled == true || timerCount.Enabled == true) { store = StoreModel.SelectAll(); StoreModel storeModel = new StoreModel(); int Id = comboBoxGoods.SelectedIndex + 1; storeModel.Id = Id; storeModel.Amount = int.Parse(textBoxAmountGoods.Text); storeModel.Name = store[Id - 1].Name; storeModel.Price = store[Id - 1].Price; TotalSum += storeModel.Amount * storeModel.Price; bool isUpdate = StoreModel.UpdateGood(storeModel); if (isUpdate) { if (InsertTempOutcomes2() > 0) { textBoxAmountGoods.Text = ""; ShowTempOutcomes(); } else { MessageBox.Show("Ошибка при заказа"); } } else { MessageBox.Show("В складе не осталось продуктов"); textBoxAmountGoods.Text = ""; } } else { MessageBox.Show("Запустите таймер"); textBoxAmountGoods.Text = ""; } }
private void buttonDelete_Click(object sender, EventArgs e) { temp = TempOutcomesModel.SelectAll(); store = StoreModel.SelectAll(); if (temp.Count != 0) { storeModel = new StoreModel(); var index = dataGridViewTempOutcomes.CurrentRow.Index; int Id = temp[index].Id; DialogResult result = MessageBox.Show("Отменить Заказ?", "Отмена заказа", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { int storeId = comboBoxGoods.SelectedIndex + 1; storeModel.Id = storeId; storeModel.Name = temp[index].Name; storeModel.Price = temp[index].Price; storeModel.Amount = temp[index].Amount; TotalSum -= storeModel.Price * storeModel.Amount; bool isReset = StoreModel.ResetGoodsForName(storeModel); if (isReset) { bool isDelete = TempOutcomesModel.Delete(Id); if (isDelete) { ShowTempOutcomes(); } else { MessageBox.Show("Ошибка при удаление"); } } } } else { MessageBox.Show("Заказ пустой"); } }
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("Заполните поля"); } } }