private void buttonUpdate_Click(object sender, EventArgs e) { if (temp != null) { temp.RoomName = textBoxRoomName.Text; temp.Name = textBoxName.Text; temp.Price = int.Parse(textBoxPrice.Text); temp.Amount = Convert.ToInt32(numericUpDownAmount.Value); temp.DateOrder = dateTimePicker1.Value.ToString("dd-MM-yyyy HH:mm"); bool IsUpdate = TempOutcomesModel.Update(temp); if (IsUpdate) { if (Amount > 0) { store.Id = Id; store.Name = temp.Name; store.Price = temp.Price; store.Amount = Amount; Total += store.Price * store.Amount; bool isReset = StoreModel.ResetGoodsForName(store); if (isReset) { } else { MessageBox.Show("Ошибка"); } } else if (Amount < 0) { Amount *= (-1); store.Id = Id; store.Name = temp.Name; store.Price = temp.Price; store.Amount = Amount; Total += store.Price * store.Amount; bool isUpdate = StoreModel.UpdateGoodForName(store); if (isUpdate) { } else { MessageBox.Show("Error"); } } Close(); } else { MessageBox.Show("Ошибка при изменение"); } } else { MessageBox.Show("Заполните поля"); } }
private void UserContrElems_Load(object sender, EventArgs e) { temp = TempOutcomesModel.SelectAll(); ShowComboBox(); ShowPriceTime(); ShowTempOutcomes(); buttonTimeCount.Visible = false; buttonTimerCountStop.Visible = false; labelTimerCount.Visible = false; labelTimeName.Visible = false; textBoxTime.Visible = false; buttonTimerCountStop.Enabled = false; buttonTimeCount.Enabled = false; }
private int InsertOutcomes() { temp = TempOutcomesModel.SelectAll(); int count = temp.Count; int lastId = -1; for (int i = 1; i <= count; i++) { string query = "INSERT INTO Outcomes(RoomId, NameGoods, PriceGoods, AmountGoods, DateOrder) VALUES((SELECT Name FROM Rooms WHERE Id=@roomId), (SELECT Name FROM TempOutcomes WHERE RoomName IN (SELECT Name FROM Rooms WHERE Id=@roomId) AND Id=@id), (SELECT Price FROM TempOutcomes WHERE RoomName IN (SELECT Name FROM Rooms WHERE Id=@roomId) AND Id=@id), (SELECT Amount FROM TempOutcomes WHERE RoomName IN (SELECT Name FROM Rooms WHERE Id=@roomId) AND Id=@id), @dateOrder)"; 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; } else { MessageBox.Show("Работа завершена"); } try { connection.Open(); command = new SQLiteCommand(query, connection); command.Parameters.AddWithValue("Id", i); command.Parameters.AddWithValue("@roomId", RoomId); command.Parameters.AddWithValue("@dateOrder", dateTimePicker1.Value.ToString("dd-MM-yyyy HH:mm")); int rowInserted = command.ExecuteNonQuery(); if (rowInserted > 0) { command.CommandText = "select last_insert_rowid()"; lastId = Convert.ToInt32(command.ExecuteScalar()); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } } return(lastId); }
private void buttonUpdate_Click(object sender, EventArgs e) { temp = TempOutcomesModel.SelectAll(); if (temp.Count != 0) { var index = dataGridViewTempOutcomes.CurrentRow.Index; UpdateTempOutcomesForm update = new UpdateTempOutcomesForm(); update.temp = temp[index]; update.Id = comboBoxNameGoods.SelectedIndex + 1; update.ShowDialog(); TotalSum -= update.Total; ShowTempOutcomes(); Show(); } else { MessageBox.Show("Заказ пустой"); } }
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("Заказ пустой"); } }
public static bool Update(TempOutcomesModel temp) { return(DBManager.UpdateTempOutcomes(temp)); }
public static int Insert(TempOutcomesModel temp) { return(DBManager.InsertTempOutcomes(temp)); }
private void UserControlBarTable_Load(object sender, EventArgs e) { temp = TempOutcomesModel.SelectAll(); ShowStore(); ShowTempOutcomes(); }