private void AddNewClient(object sender, EventArgs e)
{
using (var ctx = new PetRentalContext()) {
if (ClientName.Text.Length > 15 || ClientSurname.Text.Length > 20)
{
MessageBox.Show("Name or Surname is too long !");
}
else
{
var date = ClientDateOfBirth.SelectedDate;
var newClient = new Client()
{
Name = ClientName.Text.Trim(),
Surname = ClientSurname.Text.Trim(),
DateOfBirth = DateTime.Parse(date.Value.ToString()),
RegistrationDate = DateTime.Now
};
ctx.Clients.Add(newClient);
int result = ctx.SaveChanges();
if (result == 1)
{
MessageBox.Show("Client added !");
}
}
}
}
private void ChangeValue(object sender, RoutedEventArgs e)
{
string inputClientId = ClientIdInput.Text.Trim();
int id;
var value = ValueToChange.SelectedValue as ListBoxItem;
string selectedValue = value.Content as string;
if (int.TryParse(inputClientId, out id))
{
using (var ctx = new PetRentalContext()) {
var client = ctx.Clients
.Where(a => a.Id == id)
.ToList();
if (client.Count == 0)
{
MessageBox.Show("Client not found !");
}
else
{
string inputData = InputNewClientValue.Text.Trim();
if (selectedValue == "Name")
{
client[0].Name = inputData;
int result = ctx.SaveChanges();
if (result == 1)
{
MessageBox.Show("Data changed !");
}
}
if (selectedValue == "Surname")
{
client[0].Surname = inputData;
int result = ctx.SaveChanges();
if (result == 1)
{
MessageBox.Show("Data changed !");
}
}
}
}
}
else
{
MessageBox.Show("Incorrect id !");
}
}
private void ReturnRentedAccessory(object sender, EventArgs e)
{
string input = ReturnInput.Text;
int x;
if (int.TryParse(input, out x))
{
using (var ctx = new PetRentalContext()) {
var rentals = ctx.Rentals
.Where(b => b.ReturnDate == null)
.Where(c => c.AccessoryId == x).ToArray();
var accessories = ctx.Accessories
.Where(d => d.Id == x)
.ToList();
if (accessories.Count == 0)
{
MessageBox.Show("Item does not exist in the database!");
}
else if (rentals.Length == 0)
{
MessageBox.Show("Selected item is not rented !");
}
else
{
rentals[0].ReturnDate = DateTime.Now;
int result = ctx.SaveChanges();
if (result == 1)
{
MessageBox.Show("Item returned !");
}
decimal amountToPay = accessories[0].OneDayRentalPrice;
int rentalDays = ((DateTime)rentals[0].ReturnDate.Value).Subtract(rentals[0].RentalDate).Days;
amountToPay += (accessories[0].OneDayRentalPrice * rentalDays);
AmountToPay.Text = amountToPay.ToString();
}
}
}
else
{
MessageBox.Show("Incorrect id");
}
}
private void RemoveSelClient(object sender, EventArgs e)
{
var clientId = ClientToRemId.Text;
int a;
if (int.TryParse(clientId, out a))
{
using (var ctx = new PetRentalContext()) {
var clientToRemove = ctx.Clients.Where(x => x.Id == a).ToList();
if (clientToRemove.Count == 1)
{
var clientRentals = ctx.Rentals.Where(x => x.ClientId == a).ToList();
if (clientRentals.Count == 0)
{
ctx.Clients.Remove(clientToRemove[0]);
int result = ctx.SaveChanges();
if (result == 1)
{
MessageBox.Show("Deleted !");
}
}
else
{
MessageBox.Show("This client has already rented something !");
}
}
else
{
MessageBox.Show("Client not found !");
}
}
}
else
{
MessageBox.Show("Incorrect client Id");
}
}
private void AddNewRental(object sender, EventArgs e)
{
string inputAccessory = AccessoryId.Text;
string inputClient = ClientId.Text;
int x;
int y;
if (int.TryParse(inputAccessory, out x) && int.TryParse(inputClient, out y))
{
using (var ctx = new PetRentalContext()) {
var rentals = ctx.Rentals
.Include(a => a.Accessory)
.ToList();
var acc = ctx.Accessories
.Where(p => p.Id == x)
.ToList();
var NotReturnedRentals = rentals
.Where(b => b.ReturnDate is null)
.Where(c => c.AccessoryId == x)
.ToList();
var clients = ctx.Clients
.Where(z => z.Id == y)
.ToList();
if (NotReturnedRentals.Count == 0)
{
if (clients.Count == 1)
{
if (acc.Count == 0)
{
MessageBox.Show("This item does not exist in the database !");
}
else
{
Client client = clients[0];
Accessory accessory = acc[0];
var newRental = new Rental()
{
Client = client, Accessory = accessory, RentalDate = DateTime.Now
};
ctx.Rentals.Add(newRental);
int result = ctx.SaveChanges();
if (result == 1)
{
MessageBox.Show("Rental added !");
}
}
}
else
{
MessageBox.Show("Client not found !");
}
}
else
{
MessageBox.Show("This accessory is rented now !");
}
}
}
else
{
MessageBox.Show("Incorrect id !");
}
}