//zmiana ceny samohcodu
private void ChangePriceCar()
{
if (String.IsNullOrWhiteSpace(TxB_CarPrice.Text))
{
MessageBox.Show("Podaj cenę!");
}
else
{
try
{
car.Price = double.Parse(TxB_CarPrice.Text);
using (CarRentalEntities db = new CarRentalEntities())
{
db.Cars.AddOrUpdate(car);
db.SaveChanges();
}
TxB_CarPrice.Text = null;
Bt_ChangePrice.IsEnabled = false;
TxB_CarPrice.IsEnabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
}
//usun samochod
private void DelCar()
{
if (ListView_Cars.SelectedIndex >= 0)
{
var selectedCar = (Cars)ListView_Cars.SelectedItem;
if (MessageBox.Show("Usunąć samochód?", "Potwierdzenie", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
var carToDel = (from item in db.Cars where item.Reg_Number == selectedCar.Reg_Number select item).First();
if (carToDel != null && carToDel.Status != "zajęty")
{
db.Cars.Remove(carToDel);
}
db.SaveChanges();
}
}
catch (Exception)
{
MessageBox.Show("Nie można usunąć wynajętego samochodu");
//throw;
}
}
else
{
}
}
Bt_DelCar.IsEnabled = false;
}
//import klientow
private void ImportCust()
{
try
{
string fileName = null;
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
fileName = openFileDialog.FileName;
}
using (var sr = new StreamReader(fileName))
{
var line = sr.ReadLine();
int i = 0;
while (line != null)
{
if (i != 0)
{
string[] splited = line.Split(',');
customer.FirstName = splited[0];
customer.LastName = splited[1];
customer.PhoneNumber = int.Parse(splited[2]);
customer.Address = splited[3];
customer.City = splited[4];
customer.Id_Number = splited[5];
using (CarRentalEntities db = new CarRentalEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
}
//customersList.Add(new Customers()
//{
// FirstName=splited[0],
// LastName=splited[1],
// PhoneNumber=int.Parse(splited[2]),
// Address=splited[3],
// City=splited[4],
// Id_Number=splited[5]
//});
}
i++;
line = sr.ReadLine();
}
}
}
catch (Exception)
{
MessageBox.Show("Błąd!");
//throw;
}
CustomersList();
}
//usowanie klienta
private void DelCust()
{
bool Check = false;
if (LisView_Customser.SelectedIndex >= 0)
{
Bt_DelCust.IsEnabled = true;
var cust = (Customers)LisView_Customser.SelectedItem;
if (MessageBox.Show("Na pewno chceszusunąć klienta?", "Potwierdzenie", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
var custToDelete = (from item in db.Customers where item.Id_Customer == cust.Id_Customer select item).First();
foreach (var item in rentList)
{
if (item.CustomerID == custToDelete.Id_Customer)
{
Check = false;
break;
}
else
{
Check = true;
}
}
if (custToDelete != null && Check == true)
{
db.Customers.Remove(custToDelete);
db.SaveChanges();
}
else
{
MessageBox.Show("Nie można usunąć klienta, który wypożycza auto");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
}
else
{
}
Bt_DelCust.IsEnabled = false;
}
private void EndRent()
{
bool DistanceCheck = false;
if (String.IsNullOrWhiteSpace(TxB_Distance.Text))
{
Lb_DistanceError.Content = "Podaj przejechany dystans";
Lb_DistanceError.Visibility = Visibility.Visible;
DistanceCheck = false;
}
else
{
car.Course += int.Parse(TxB_Distance.Text);
DistanceCheck = true;
}
car.Status = "wolny";
if (DistanceCheck == true)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
var rentToDel = (from item in db.Rent where item.Id_Rent == rent.Id_Rent select item).First();
if (rentToDel != null)
{
db.Rent.Remove(rentToDel);
}
db.Cars.AddOrUpdate(car);
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
Close();
}
}
//zwalnianie pracownika
private void DelEmp()
{
if (LisView_Emp.SelectedIndex >= 0)
{
Bt_DelEmp.IsEnabled = true;
var emp = (Employees)LisView_Emp.SelectedItem;
if (MessageBox.Show("Na pewno chcesz zwolnic tego pracownika?", "Potwierdzenie", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
var loginToDelete = (from item in db.LoginData where item.Id_Emp == emp.Id_Employee select item).First();
var empToDelete = (from item in db.Employees where item.Id_Employee == emp.Id_Employee select item).First();
if (empToDelete != null)
{
db.LoginData.Remove(loginToDelete);
db.Employees.Remove(empToDelete);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
}
else
{
}
}
public void SetLoginData()
{
bool loginCheck = false;
bool passCheck = false;
if (String.IsNullOrWhiteSpace(TxB_EmpLogin.Text))
{
Lb_LoginError.Content = "Podaj login";
Lb_LoginError.Visibility = Visibility.Visible;
loginCheck = false;
}
else
{
Lb_LoginError.Visibility = Visibility.Collapsed;
loginData.Login = TxB_EmpLogin.Text;
loginCheck = true;
}
if (String.IsNullOrWhiteSpace(PassBox_Emp.Password))
{
Lb_PassError.Content = "Podaj haslo";
Lb_PassError.Visibility = Visibility.Visible;
passCheck = false;
}
else
{
if (PassBox_Emp.Password.Length<8)
{
Lb_PassError.Content = "Hasło musi mieć conajmniej 8 znaków";
Lb_PassError.Visibility = Visibility.Visible;
passCheck = false;
}
else
{
Lb_PassError.Visibility = Visibility.Collapsed;
loginData.Password = PassBox_Emp.Password;
passCheck = true;
}
}
loginData.Id_Emp = id;
if(loginCheck && passCheck==true)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
db.LoginData.Add(loginData);
db.SaveChanges();
}
Close();
}
catch (Exception)
{
throw;
}
}
}
//dodawanie samochodu
public void AddCar()
{
bool RNumberCheck = false;
bool MarkCheck = false;
bool ModelCheck = false;
bool CourseCheck = false;
bool ClassCheck = false;
bool PriceCheck = false;
if (String.IsNullOrWhiteSpace(TxB_RNumber.Text))
{
Lb_RNumberError.Content = "Podaj nr. rejestracyjny";
Lb_RNumberError.Visibility = Visibility.Visible;
RNumberCheck = false;
}
else
{
try
{
Lb_RNumberError.Visibility = Visibility.Collapsed;
car.Reg_Number = TxB_RNumber.Text;
RNumberCheck = true;
}
catch (Exception ex)
{
Lb_RNumberError.Content = ex.Message;
Lb_RNumberError.Visibility = Visibility.Visible;
RNumberCheck = false;
//throw;
}
}
if (String.IsNullOrWhiteSpace(TxB_Mark.Text))
{
Lb_MarkError.Content = "Podaj markę";
Lb_MarkError.Visibility = Visibility.Visible;
MarkCheck = false;
}
else
{
try
{
Lb_MarkError.Visibility = Visibility.Collapsed;
car.Mark = TxB_Mark.Text;
MarkCheck = true;
}
catch (Exception ex)
{
Lb_MarkError.Content = ex.Message;
Lb_MarkError.Visibility = Visibility.Visible;
MarkCheck = false;
//throw;
}
}
if (String.IsNullOrWhiteSpace(TxB_Model.Text))
{
Lb_ModelError.Content = "Podaj model";
Lb_ModelError.Visibility = Visibility.Visible;
ModelCheck = false;
}
else
{
try
{
Lb_ModelError.Visibility = Visibility.Collapsed;
car.Model = TxB_Model.Text;
ModelCheck = true;
}
catch (Exception ex)
{
Lb_ModelError.Content = ex.Message;
Lb_ModelError.Visibility = Visibility.Visible;
ModelCheck = false;
//throw;
}
}
if (String.IsNullOrWhiteSpace(TxB_Course.Text))
{
Lb_CourseError.Content = "Podaj przebieg";
Lb_CourseError.Visibility = Visibility.Visible;
CourseCheck = false;
}
else
{
try
{
Lb_CourseError.Visibility = Visibility.Collapsed;
car.Course = int.Parse(TxB_Course.Text);
CourseCheck = true;
}
catch (Exception ex)
{
Lb_CourseError.Content = ex.Message;
Lb_CourseError.Visibility = Visibility.Visible;
CourseCheck = false;
//throw;
}
}
if (ComboB_Class.SelectedIndex == -1)
{
Lb_ClassError.Content = "Wybierz klase";
Lb_ClassError.Visibility = Visibility.Visible;
ClassCheck = false;
}
else
{
Lb_ClassError.Visibility = Visibility.Collapsed;
//car.Class = ComboB_Class.SelectedItem.ToString();
car.Class = ComboB_Class.Text;
ClassCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_Price.Text))
{
Lb_PriceError.Content = "Podaj cene";
Lb_PriceError.Visibility = Visibility.Visible;
PriceCheck = false;
}
else
{
try
{
Lb_PriceError.Visibility = Visibility.Collapsed;
car.Price = double.Parse(TxB_Price.Text);
PriceCheck = true;
}
catch (Exception ex)
{
Lb_PriceError.Content = ex.Message;
Lb_PriceError.Visibility = Visibility.Visible;
PriceCheck = false;
//throw;
}
}
car.Status = "wolny";
if (RNumberCheck && MarkCheck && ModelCheck && CourseCheck && ClassCheck && PriceCheck == true)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
db.Cars.Add(car);
db.SaveChanges();
Close();
}
}
catch (Exception)
{
//MessageBox.Show(ex.Message);
throw;
}
}
}
private void Rent()
{
bool FNameCheck = false;
bool LNameCheck = false;
bool PhoneCheck = false;
bool AddressCheck = false;
bool CityCheck = false;
bool IdNumCheck = false;
bool carCheck = false;
bool endDateCheck = false;
//customer = null;
if (Radio_NewCust.IsChecked == true)
{
if (String.IsNullOrWhiteSpace(TxB_CustFirstName.Text))
{
Lb_FNameError.Content = "Podaj imie";
Lb_FNameError.Visibility = Visibility.Visible;
FNameCheck = false;
}
else
{
Lb_FNameError.Visibility = Visibility.Collapsed;
customer.FirstName = TxB_CustFirstName.Text;
FNameCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_CustLastName.Text))
{
Lb_LNameError.Content = "Podaj nazwisko";
Lb_LNameError.Visibility = Visibility.Visible;
LNameCheck = false;
}
else
{
Lb_LNameError.Visibility = Visibility.Collapsed;
customer.LastName = TxB_CustLastName.Text;
LNameCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_CustPhone.Text))
{
Lb_PhoneError.Content = "Podaj telefon";
Lb_PhoneError.Visibility = Visibility.Visible;
PhoneCheck = false;
}
else
{
try
{
Lb_PhoneError.Visibility = Visibility.Collapsed;
customer.PhoneNumber = int.Parse(TxB_CustPhone.Text);
PhoneCheck = true;
}
catch (Exception ex)
{
Lb_PhoneError.Content = ex.Message;
Lb_PhoneError.Visibility = Visibility.Visible;
PhoneCheck = false;
//throw;
}
}
if (String.IsNullOrWhiteSpace(TxB_CustAddress.Text))
{
Lb_AddressError.Content = "Podaj adres";
Lb_AddressError.Visibility = Visibility.Visible;
AddressCheck = false;
}
else
{
Lb_AddressError.Visibility = Visibility.Collapsed;
customer.Address = TxB_CustAddress.Text;
AddressCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_CustCity.Text))
{
Lb_CityError.Content = "Podaj ulice";
Lb_CityError.Visibility = Visibility.Visible;
CityCheck = false;
}
else
{
Lb_CityError.Visibility = Visibility.Collapsed;
customer.City = TxB_CustCity.Text;
CityCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_CustIdNum.Text))
{
Lb_IdNumError.Content = "Podaj numer dowodu";
Lb_IdNumError.Visibility = Visibility.Visible;
IdNumCheck = false;
}
else
{
Lb_IdNumError.Visibility = Visibility.Collapsed;
customer.Id_Number = TxB_CustIdNum.Text;
IdNumCheck = true;
}
}
else if (Radio_Cust.IsChecked == true)
{
FNameCheck = LNameCheck = PhoneCheck = AddressCheck = CityCheck = IdNumCheck = true;
rent.CustomerID = customer.Id_Customer;
}
else
{
MessageBox.Show("Dokonaj byworu");
}
if (String.IsNullOrWhiteSpace(TxB_CarReg_Number.Text))
{
Lb_SelectedCarError.Content = "Wybierz samochód";
Lb_SelectedCarError.Visibility = Visibility.Visible;
carCheck = false;
}
else
{
Lb_SelectedCarError.Visibility = Visibility.Collapsed;
rent.Reg_Number = TxB_CarReg_Number.Text;
carCheck = true;
}
rent.StartDate = startDate.ToString("dd/MM/yyyy");
if (DatePicker_End.SelectedDate == null)
{
Lb_EndDateError.Content = "Wybierz datę";
Lb_EndDateError.Visibility = Visibility.Visible;
endDateCheck = false;
}
else if (DatePicker_End.SelectedDate <= DateTime.Now)
{
Lb_EndDateError.Content = "Błędna data";
Lb_EndDateError.Visibility = Visibility.Visible;
EndDateCheck = false;
}
else
{
Lb_EndDateError.Visibility = Visibility.Collapsed;
rent.EndDate = endDate.ToString("dd/MM/yyyy");
endDateCheck = true;
}
rent.Cost = cost;
car.Status = "zajety";
if (FNameCheck && LNameCheck && PhoneCheck && AddressCheck && CityCheck && IdNumCheck && EndDateCheck && carCheck && endDateCheck == true)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
db.Customers.AddOrUpdate(customer);
db.Rent.Add(rent);
db.Cars.AddOrUpdate(car);
db.SaveChanges();
Close();
}
}
catch (Exception)
{
throw;
}
}
}
//tworzenie uzytkownika
public void CreateEmp()
{
bool fNameCheck = false;
bool lNameCheck = false;
bool phoneCheck = false;
bool salaryCheck = false;
if (String.IsNullOrWhiteSpace(TxB_EmpFirstName.Text))
{
Lb_EmpFNameError.Content = "Podaj imie";
Lb_EmpFNameError.Visibility = Visibility.Visible;
fNameCheck = false;
}
else
{
Lb_EmpFNameError.Visibility = Visibility.Collapsed;
employee.FirstName = TxB_EmpFirstName.Text;
fNameCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_EmpLastName.Text))
{
Lb_EmpLNameError.Content = "Podaj nazwisko";
Lb_EmpLNameError.Visibility = Visibility.Visible;
lNameCheck = false;
}
else
{
Lb_EmpLNameError.Visibility = Visibility.Collapsed;
employee.LastName = TxB_EmpLastName.Text;
lNameCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_EmpPhone.Text))
{
Lb_EmpPhoneError.Content = "Podaj telefon";
Lb_EmpPhoneError.Visibility = Visibility.Visible;
phoneCheck = false;
}
else
{
try
{
Lb_EmpPhoneError.Visibility = Visibility.Collapsed;
employee.PhoneNumber = int.Parse(TxB_EmpPhone.Text);
phoneCheck = true;
}
catch (Exception ex)
{
Lb_EmpPhoneError.Content = ex.Message;
Lb_EmpPhoneError.Visibility = Visibility.Visible;
phoneCheck = false;
//throw;
}
}
if (CheckB_Perm.IsChecked == true)
{
employee.AdvancePermission = true;
}
else
{
employee.AdvancePermission = false;
}
if (String.IsNullOrWhiteSpace(TxB_EmpSalary.Text))
{
Lb_EmpSalaryError.Content = "Podaj kwotę wynagrodzenia";
Lb_EmpSalaryError.Visibility = Visibility.Visible;
salaryCheck = false;
}
else
{
try
{
Lb_EmpSalaryError.Visibility = Visibility.Collapsed;
employee.Salary = double.Parse(TxB_EmpSalary.Text);
salaryCheck = true;
}
catch (Exception ex)
{
Lb_EmpSalaryError.Content = ex.Message;
Lb_EmpSalaryError.Visibility = Visibility.Visible;
salaryCheck = false;
//throw;
}
}
if (fNameCheck && lNameCheck && phoneCheck && salaryCheck == true)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
db.Employees.Add(employee);
db.SaveChanges();
Close();
}
}
catch (Exception)
{
throw;
}
}
}
//modyfikowanie uzytkownika
public void ModUser()
{
bool phoneCheck = false;
bool salaryCheck = false;
if (String.IsNullOrWhiteSpace(TxB_EmpPhone.Text))
{
Lb_EmpPhoneError.Content = "Podaj telefon";
Lb_EmpPhoneError.Visibility = Visibility.Visible;
phoneCheck = false;
}
else
{
Lb_EmpPhoneError.Visibility = Visibility.Collapsed;
phoneCheck = true;
}
if (String.IsNullOrWhiteSpace(TxB_EmpSalary.Text))
{
Lb_EmpSalaryError.Content = "Podaj kwotę wynagrodzenia";
Lb_EmpSalaryError.Visibility = Visibility.Visible;
salaryCheck = false;
}
else
{
Lb_EmpSalaryError.Visibility = Visibility.Collapsed;
salaryCheck = true;
}
if (phoneCheck && salaryCheck == true)
{
try
{
using (CarRentalEntities db = new CarRentalEntities())
{
var toMod = db.Employees.SingleOrDefault(i => i.Id_Employee == employee.Id_Employee);
if (toMod != null)
{
toMod.PhoneNumber = int.Parse(TxB_EmpPhone.Text);
toMod.Salary = double.Parse(TxB_EmpSalary.Text);
if (CheckB_Perm.IsChecked == true)
{
toMod.AdvancePermission = true;
}
else
{
toMod.AdvancePermission = false;
}
}
db.SaveChanges();
Close();
}
}
catch (Exception)
{
MessageBox.Show("Błąd");
//throw;
}
}
}