private void buttonAccept_Click(object sender, EventArgs e) { int user_id = UserSingleton.Instance.userId; var login = textBoxLogin.Text; var pass = textBoxPassword.Text; var newPass1 = textBoxNewPassword1.Text; var newPass2 = textBoxNewPassword2.Text; if (newPass1 == newPass2) { var dbModel = new DatabaseModel(); var result = dbModel.user_data.Find(user_id); if (result != null) { if (login == result.login && pass == result.password) { result.password = newPass1; dbModel.SaveChanges(); this.Close(); } else { MessageBox.Show("Nieprawidłowy login i/lub hasło.\nOsoba zalogowana może zmienić hasło tylko sobie."); } } else { MessageBox.Show("Sprawdź połaczenie z internetem."); } } else { MessageBox.Show("Nowe hasło w obu polach musi być jednakowe."); } }
private void buttonCancel_Click(object sender, EventArgs e) { if(row != null){ var dbModel = new DatabaseModel(); var reservation = dbModel.reservation.Find((int)row.Cells["idDataGridViewTextBoxColumn"].Value); dbModel.reservation.Remove(reservation); dbModel.SaveChanges(); this.buttonFilter_Click(new object(), new EventArgs()); } }
private void buttonHire_Click(object sender, EventArgs e) { if (row != null) { var id = row.Cells["idDataGridViewTextBoxColumn"].Value.ToString(); var dbModel = new DatabaseModel(); var user = dbModel.user_data.Find(Int32.Parse(id)); user.is_active = 1; dbModel.SaveChanges(); this.buttonFilter_Click(new object(), new EventArgs()); } }
private void buttonAccept_Click(object sender, EventArgs e) { var dbModel = new DatabaseModel(); var result = dbModel.client.Find(clientId); if (result != null) { result.first_name = this.textBoxName.Text; result.last_name = this.textBoxSurname.Text; result.address = this.textBoxAddress.Text; result.phone = this.textBoxTelephoneNum.Text; result.email = this.textBoxEmail.Text; dbModel.SaveChanges(); this.Close(); } }
private void buttonAccept_Click(object sender, EventArgs e) { if (this.client != null && this.car != null) { var dbModel = new DatabaseModel(); var newReservation = new reservation(); newReservation.date_reservation = this.dateTimePickerPurchaseDate.Value; newReservation.date_reservation_expired = this.dateTimePickerPurchaseDate.Value.AddDays(14); newReservation.id_user = UserSingleton.Instance.userId; newReservation.id_client = (int)this.client.Cells["idDataGridViewTextBoxColumn"].Value; newReservation.id_car = (int)this.car.Cells["idDataGridViewTextBoxColumn"].Value; dbModel.reservation.Add(newReservation); dbModel.SaveChanges(); } else { MessageBox.Show("Musisz najpierw wybrać klienta oraz samochód."); } }
private void buttonAccept_Click(object sender, EventArgs e) { var dbModel = new DatabaseModel(); foreach (var service in this.selectedServices) { var order = new client_order(); var serv = dbModel.dict_service.SqlQuery("SELECT * FROM dict_service WHERE name like '" + service.ToString() + "';").ToList(); order.date_order = this.dateTimePickerPurchaseDate.Value; order.date_done = this.dateTimePickerPurchaseDate.Value; order.id_client = (int)this.client.Cells["idDataGridViewTextBoxColumn"].Value; order.id_service = (int)serv[0].id; order.id_user = UserSingleton.Instance.userId; order.cost = Decimal.Parse(serv[0].cost); order.comment = this.textBoxComment.Text; order.id_car_shop = dbModel.user_data.Find(UserSingleton.Instance.userId).id_car_shop; order.is_done = 1; dbModel.client_order.Add(order); dbModel.SaveChanges(); } this.Close(); }
private void buttonRealize_Click(object sender, EventArgs e) { if(row != null){ var dbModel = new DatabaseModel(); var reservation = dbModel.reservation.Find((int)row.Cells["idDataGridViewTextBoxColumn"].Value); var carSell = new car_sell(); carSell.id_car = reservation.id_car; carSell.id_client = reservation.id_client; carSell.id_user = UserSingleton.Instance.userId; carSell.sell_date = DateTime.Now; carSell.cost = Decimal.Parse(dbModel.car.Find(carSell.id_car).cost); dbModel.car_sell.Add(carSell); dbModel.reservation.Remove(reservation); dbModel.SaveChanges(); this.buttonFilter_Click(new object(), new EventArgs()); } }