private void Button_Click(object sender, RoutedEventArgs e)
{
errorText.Text = "";
var db = new computerEntities();
if (clientSelect.SelectedValue == null)
{
errorText.Text = "Wybierz klienta.";
return;
}
if (computerSelect.SelectedValue == null)
{
errorText.Text = "Wybierz komputer.";
return;
}
var computers = db.Computers.ToList();
var computer = computers.First(c => c.ComputerID == int.Parse(computerSelect.SelectedValue.ToString()));
var newSale = new Sales()
{
ClientID = int.Parse(clientSelect.SelectedValue.ToString()),
ComputerID = int.Parse(computerSelect.SelectedValue.ToString()),
PriceToPay = decimal.Parse(summaryPriceInput.Text),
};
db.Sales.Add(newSale);
computer.ComputerAmount--;
db.SaveChanges();
}
private void showPrice()
{
var db = new computerEntities();
var reservationID = int.Parse(reservationSelect.SelectedValue.ToString());
var reservation = db.Sales.First(r => r.ReservationID == reservationID);
reservationPriceInput.Text = reservation.PriceToPay.ToString();
}
private void calculatePrice()
{
var db = new computerEntities();
var computers = db.Computers.ToList();
var computer = computers.First(c => c.ComputerID == int.Parse(computerSelect.SelectedValue.ToString()));
if (computer != null)
{
reservationPriceInput.Text = computer.ComputerReservationPrice.ToString();
summaryPriceInput.Text = (computer.ComputerPrice + computer.ComputerReservationPrice).ToString();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var db = new computerEntities();
var reservationID = int.Parse(reservationSelect.SelectedValue.ToString());
var reservation = db.Sales.First(r => r.ReservationID == reservationID);
if (reservation != null)
{
reservation.Payed = true;
db.SaveChanges();
}
}
private void fillComputerModels()
{
computerModelSelect.Items.Clear();
computerModelSelect.DisplayMemberPath = "Text";
computerModelSelect.SelectedValuePath = "Value";
if (computerTypeSelect.SelectedValue != null)
{
var selectedType = computerTypeSelect.SelectedValue.ToString();
var db = new computerEntities();
var computerModels = db.Models.ToList();
foreach (var computerModel in computerModels)
{
computerModelSelect.Items.Add(new { Text = computerModel.ModelName, Value = computerModel.ModelID });
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
errorText.Text = "";
var db = new computerEntities();
if (clientNameInput.Text == "")
{
errorText.Text = "Podaj imię i nazwisko.";
return;
}
if (clientEmailInput.Text == "")
{
errorText.Text = "Podaj e-mail.";
return;
}
if (clientPhoneInput.Text == "")
{
errorText.Text = "Podaj numer telefonu.";
return;
}
if (clientGenderSelect.SelectedItem == null)
{
errorText.Text = "Wybierz płeć.";
return;
}
var clientName = clientNameInput.Text;
var clientEmail = clientEmailInput.Text;
var clientPhone = clientPhoneInput.Text;
var clientGender = clientGenderSelect.SelectedItem.ToString();
var newClient = new Clients()
{
ClientName = clientName,
ClientEmail = clientEmail,
ClientPhone = clientPhone,
ClientGender = clientGender
};
db.Clients.Add(newClient);
db.SaveChanges();
}
private void fillReservationsSelect()
{
reservationSelect.Items.Clear();
reservationSelect.DisplayMemberPath = "Text";
reservationSelect.SelectedValuePath = "Value";
var db = new computerEntities();
var reservations = db.Sales.Join(db.Clients, ep => ep.ClientID, e => e.ClientID, (ep, e) => new { ep, e }).Join(db.Computers, ep => ep.ep.ComputerID, e => e.ComputerID, (ep, e) => new { ep, e }).Where(r => r.ep.ep.Payed == null).ToList();
foreach (var reservation in reservations)
{
reservationSelect.Items.Add(
new
{
Value = reservation.ep.ep.ReservationID,
Text = $"{reservation.ep.e.ClientName} - {reservation.e.ComputerName} [{reservation.e.ComputerType}] ({reservation.e.ComputerPrice} PLN)",
}
);
}
}
private void fillComputersSelect()
{
var db = new computerEntities();
var computers = db.Computers.ToList();
computerSelect.Items.Clear();
computerSelect.DisplayMemberPath = "Text";
computerSelect.SelectedValuePath = "Value";
foreach (var computer in computers)
{
computerSelect.Items.Add(
new
{
Text = $"{computer.ComputerName} [{computer.ComputerType}] ({computer.ComputerReservationPrice} PLN / {computer.ComputerPrice} PLN)",
Value = computer.ComputerID
}
);
}
}
private void fillClientsSelect()
{
var db = new computerEntities();
var clients = db.Clients.ToList();
clientSelect.Items.Clear();
clientSelect.DisplayMemberPath = "Text";
clientSelect.SelectedValuePath = "Value";
foreach (var client in clients)
{
clientSelect.Items.Add(
new
{
Text = $"{client.ClientName} [{client.ClientGender}] ({client.ClientEmail} | {client.ClientPhone})",
Value = client.ClientID
}
);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
errorText.Text = "";
if (modelNameInput.Text == "")
{
errorText.Text = "Podaj nazwę modelu.";
return;
}
var db = new computerEntities();
var modelName = modelNameInput.Text;
var newModel = new Models()
{
ModelName = modelName
};
db.Models.Add(newModel);
db.SaveChanges();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
errorText.Text = "";
var db = new computerEntities();
if (computerNameInput.Text == "")
{
errorText.Text = "Wprowadź nazwę komputera.";
return;
}
if (computerTypeSelect.SelectedValue == null)
{
errorText.Text = "Wybierz typ komputera.";
return;
}
if (computerModelSelect.SelectedValue == null)
{
errorText.Text = "Wybierz model komputera.";
return;
}
try
{
var computerReservationPriceTest = decimal.Parse(computerReservationPriceInput.Text);
}
catch
{
errorText.Text = "Wprowadź poprawną cenę rezerwacji komptera.";
return;
}
try
{
var computerPriceTest = decimal.Parse(computerPriceInput.Text);
} catch
{
errorText.Text = "Wprowadź poprawną cenę komptera.";
return;
}
try
{
var computerAmountTest = int.Parse(computerAmountInput.Text);
} catch
{
errorText.Text = "Wprowadź poprawną ilość komputerów.";
return;
}
var computerModelId = int.Parse(computerModelSelect.SelectedValue.ToString());
var computerType = computerTypeSelect.SelectedValue.ToString();
var computerPrice = decimal.Parse(computerPriceInput.Text);
var computerReservationPrice = decimal.Parse(computerReservationPriceInput.Text);
var computerName = computerNameInput.Text;
var computerAmount = int.Parse(computerAmountInput.Text);
var newComputer = new Computers()
{
ComputerModelId = computerModelId,
ComputerName = computerName,
ComputerReservationPrice = computerReservationPrice,
ComputerPrice = computerPrice,
ComputerType = computerType,
ComputerAmount = computerAmount
};
db.Computers.Add(newComputer);
db.SaveChanges();
}
private void fillComputersList()
{
var db = new computerEntities();
salesDataGrid.ItemsSource = db.Sales.ToList();
}
private void fillModelsList()
{
var db = new computerEntities();
modelsDataGrid.ItemsSource = db.Models.ToList();
}
private void fillClientsList()
{
var db = new computerEntities();
clientsDataGrid.ItemsSource = db.Clients.ToList();
}
