public void insertNewReservation() { int servicesID = -1; int clientID = -1; if (ckbNewClient.Checked) { clientID = insertObjectToDB.GetClientIdAndInsertToDB(txbClientName.Text, txbClientSName.Text, txbClientPhone.Text, txbClientDescription.Text); } else { if (cmbClientList.SelectedIndex == 0) { MessageBox.Show("Wybierz klienta"); return; } clientID = cmbClientList.SelectedIndex; } if (ckbNewServices.Checked) { servicesID = insertObjectToDB.GetServicesIdAndInsertDB(txbNewServices.Text); } else { if (cmbListServices.SelectedIndex == 0) { MessageBox.Show("Wybierz usługę"); return; } servicesID = cmbListServices.SelectedIndex; } if (tscmbEmployee.ComboBox.SelectedIndex == 0) { MessageBox.Show("Wybierz pracownika"); return; } if (!insertObjectToDB.GetReservationIdAndInsertToDB(dtpReservationDate.Value, Convert.ToInt32(nudHour.Value), Convert.ToInt32(nudMinute.Value), clientID, servicesID, tscmbEmployee.SelectedIndex)) { MessageBox.Show("Nie można dodać reserwacji w tym terminie. Jest on zajęty"); return; } GridBuilder.FillTheGrid(getVReservation.GetVReservations(), dgvVReservation); ComboBoxSetData.SetDataToCmbClient(cmbClientList); ComboBoxSetData.SetDataToCmbServices(cmbListServices); FillClientControls(null, true); }
public ActionResult AddReservation(Reservation reservation, string findClient) { int clientId = reservation.client_id; if (!String.IsNullOrEmpty(findClient)) { var clientList = selectClient.GetRowsForTable(SGetAllRowsFromSpecificTable.ClientSelectAllRowsQuery()) .Select(x => new { desccription = x.client_name + " " + x.client_sname + " " + x.client_phone + " " + x.client_description, clientId = x.client_id }).ToList(); clientId = clientList.Where(x => x.desccription.Contains(findClient)).First().clientId; } insertObjectToDB.GetReservationIdAndInsertToDB(reservation.reservation_date, reservation.reservation_time.Hours, reservation.reservation_time.Minutes, clientId, reservation.services_id, reservation.employee_id); return(RedirectToAction("Index", "Reservation", new { visibleTrue = false })); }