private void LoadPayments()
{
AlaKurumsalDatabase db = new AlaKurumsalDatabase();
List <Payment> payments = db.Payments.ToList();
dgPayment.ItemsSource = payments;
}
private void CWguncelleexpand_Click(object sender, RoutedEventArgs e)
{
Payment payment = dgPayment.SelectedItem as Payment;
if (payment != null)
{
AlaKurumsalDatabase alaKurumsalDatabase = new AlaKurumsalDatabase();
var paymentnew = alaKurumsalDatabase.Payments.Find(payment.Id);
paymentnew.BookingNo = int.Parse(PWbooking.Text);
paymentnew.HasInstallment = PWtaksit.IsChecked;
paymentnew.InstallmentNumber = int.Parse(PWtaksitsayi.Text);
paymentnew.PaymentMethod = PWmethod.Text;
alaKurumsalDatabase.SaveChanges();
LoadPayments();
MessageBox.Show("Güncellendi.");
}
else
{
MessageBox.Show("Güncellemek için bir ödeme seçmelisin!");
}
}
private void LoadStudents()
{
AlaKurumsalDatabase db = new AlaKurumsalDatabase();
List <Vehicle> vehicles = db.Vehicles.ToList();
dgVehicles.ItemsSource = vehicles;
}
private void VWguncelle(object sender, RoutedEventArgs e)
{
Vehicle vehicle = dgVehicles.SelectedItem as Vehicle;
if (vehicle != null)
{
AlaKurumsalDatabase alaKurumsalDatabase = new AlaKurumsalDatabase();
var vehiclenew = alaKurumsalDatabase.Vehicles.Find(vehicle.Id);
vehiclenew.ModelName = VWmodel.Text;
vehiclenew.BrandName = VWbrand.Text;
vehiclenew.Color = VWcolor.Text;
vehiclenew.Country = VWcountry.Text;
vehiclenew.Owner = VWowner.Text;
vehiclenew.Year = int.Parse(VWyear.Text);
vehiclenew.IsAvailable = VWavailable.IsChecked;
vehiclenew.IsCrashed = VWcrashed.IsChecked;
vehiclenew.IsSold = VWsold.IsChecked;
vehiclenew.IsRentable = VWrentable.IsChecked;
vehiclenew.IsPreOwned = VWpreowned.IsChecked;
vehiclenew.IsOnSale = VWsale.IsChecked;
vehiclenew.AvailableDate = VWdate.SelectedDate.Value;
alaKurumsalDatabase.SaveChanges();
LoadStudents();
MessageBox.Show("Güncellendi.");
}
else
{
MessageBox.Show("Güncellemek için bir araç seçmelisin!");
}
}
private void LoadBookings()
{
AlaKurumsalDatabase db = new AlaKurumsalDatabase();
List <Booking> bookings = db.Bookings.ToList();
dgBooking.ItemsSource = bookings;
}
private void CWguncelleexpand_Click(object sender, RoutedEventArgs e)
{
Customer customer = dgCustomers.SelectedItem as Customer;
if (customer != null)
{
AlaKurumsalDatabase alaKurumsalDatabase = new AlaKurumsalDatabase();
var customernew = alaKurumsalDatabase.Customers.Find(customer.Id);
customernew.Name = CWisim.Text;
customernew.Surname = CWsoyisim.Text;
customernew.Phone = CWtelefon.Text;
customernew.Age = int.Parse(CWyas.Text);
customernew.City = CWsehir.Text;
customernew.HasLicence = CWehliyet.IsChecked;
customernew.HasCriminalRecord = CWsabika.IsChecked;
customernew.LicenceEndDate = CWdate.SelectedDate.Value;
alaKurumsalDatabase.SaveChanges();
LoadCustomers();
MessageBox.Show("Güncellendi.");
}
else
{
MessageBox.Show("Güncellemek için bir müşteri seçmelisin!");
}
}
private void LoadCustomers()
{
AlaKurumsalDatabase db = new AlaKurumsalDatabase();
List <Customer> customers = db.Customers.ToList();
dgCustomers.ItemsSource = customers;
}
private void BWguncelle(object sender, RoutedEventArgs e)
{
Booking booking = dgBooking.SelectedItem as Booking;
if (booking != null)
{
AlaKurumsalDatabase alaKurumsalDatabase = new AlaKurumsalDatabase();
var bookingnew = alaKurumsalDatabase.Bookings.Find(booking.Id);
bookingnew.CustomerName = BWcustomer.Text;
bookingnew.VehicleModel = BWvehicle.Text;
bookingnew.HirePoint = BWhire.Text;
bookingnew.DropPoint = BWdrop.Text;
bookingnew.StartDate = BWbaslangic.SelectedDate.Value;
bookingnew.EndDate = BWbitis.SelectedDate.Value;
bookingnew.IsSold = BWsold.IsChecked;
//var vehnew = alaKurumsalDatabase.Vehicles.Find(vehicle.Id);
/* Vehicle vehicle = new Vehicle();
* string tempmodel;
* tempmodel = BWvehicle.Text;
* var vehnew = alaKurumsalDatabase.Vehicles.Find(vehicle.Id);
* if (vehnew.ModelName == tempmodel)
* {
* vehnew.IsAvailable = false;
* }
* alaKurumsalDatabase.Vehicles.Update(vehicle);*/
alaKurumsalDatabase.SaveChanges();
LoadBookings();
MessageBox.Show("Güncellendi.");
}
else
{
MessageBox.Show("Güncellemek için bir araç seçmelisin!");
}
}
public AlaService()
{
db = new AlaKurumsalDatabase();
}
