public static DataTable GetReList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Машина");
dtClient.Columns.Add("Модель");
dtClient.Columns.Add("Статус аренды");
dtClient.Columns.Add("Время аренды");
var query = from order in db.Order
join car in db.Cars on order.IdCar equals car.idCar
join client in db.Users on order.idClient equals client.IdUser
select new
{
order.idClient,
order.idOrder,
car = car.Car,
mod = car.CarModel,
order.RentStatus,
order.RentTime,
};
foreach (var rel in query)
{
if (rel.idClient == SecurityContext.idClient)
{
dtClient.Rows.Add(rel.idOrder, rel.car, rel.mod, rel.RentStatus, rel.RentTime);
}
}
return(dtClient);
}
private void Add_Click(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities(); // подключение бд
Order save = new Order // создание класса SAVE
{
RentStatus = RenStatus.Text,
IdCar = int.Parse(dtCar.Rows[CarLi.SelectedIndex].ItemArray[0].ToString()), // Из класса SAVE выбираются 4 переменные, в которые добавляются 4 переменные которые ввел пользователь
idClient = int.Parse(dtClient.Rows[ClientLi.SelectedIndex].ItemArray[0].ToString()),
RentTime = RenTime.Text
};
db.Order.Add(save); // далее идет добавление и сохранение данных в бд
db.SaveChanges();
MessageBox.Show("Заказ добавлен");
if (SecurityContext.avtovxod == 3)
{
OrderList reg = new OrderList();
this.Hide();
reg.Show();
}
if (SecurityContext.avtovxod == 1)
{
OrderClient reg = new OrderClient();
this.Hide();
reg.Show();
}
}
public static DataTable GetClientList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Фамилия");
dtClient.Columns.Add("Имя");
dtClient.Columns.Add("Отчество");
dtClient.Columns.Add("Номер телефона");
var Query = db.Users; // Запрос на выборку данных из таблицы Users
foreach (var rel in Query) // Отображение данных в DataGrid
{
if (SecurityContext.avtovxod == 3) // Вошел менеджер
{
if (rel.Role == "Client") // Отображение только клиентов
{
dtClient.Rows.Add(rel.IdUser, rel.SecondName, rel.Name, rel.MiddlName, rel.PhoneNumber);
}
}
if (SecurityContext.avtovxod == 1) // Вошел клиент
{
if (SecurityContext.idClient == rel.IdUser) // Клиент видит только себя
{
if (rel.Role == "Client") // Отображается только клиент
{
dtClient.Rows.Add(rel.IdUser, rel.SecondName, rel.Name, rel.MiddlName, rel.PhoneNumber);
}
}
}
}
return(dtClient);
}
private void aut_Click(object sender, RoutedEventArgs e)
{
if (Name.Text != "" && SecondName.Text != "" && MiddlName.Text != "" && Phone.Text != "" && Login.Text != "" && Password.Text != "")
{
rentcarEntities db = new rentcarEntities();
Users save = new Users // Класс пользователя
{
Name = Name.Text,
SecondName = SecondName.Text,
MiddlName = MiddlName.Text,
PhoneNumber = Phone.Text,
Login = Login.Text,
Password = Password.Text,
Role = "Client"
};
db.Users.Add(save); // добавление класса пользователя
db.SaveChanges(); // Сохранение класса пользователя
MessageBox.Show("Клиент добавлен");
MainWindow reg = new MainWindow();
this.Hide();
reg.Show();
}
else
{
MessageBox.Show("Вы заполнили не все поля");
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{ if (Rentime.Text != "" && RenStatus.Text != "")
{
rentcarEntities db = new rentcarEntities();
var order = db.Order.Find(SecurityContext.idOrder);
order.IdCar = int.Parse(dtCar.Rows[CarLi.SelectedIndex].ItemArray[0].ToString());
order.idClient = int.Parse(dtClient.Rows[ClietnLi.SelectedIndex].ItemArray[0].ToString());
order.RentTime = Rentime.Text;
order.RentStatus = RenStatus.Text;
double f = int.Parse(dtCar.Rows[CarLi.SelectedIndex].ItemArray[6].ToString()) * int.Parse(Rentime.ToString());
order.Summ = f.ToString();
db.Order.Create();
db.SaveChanges();
OrderList re = new OrderList();
this.Hide();
re.Show();
}
else
{
MessageBox.Show("Вы заполнили не все поля");
} }
catch
{
MessageBox.Show("Вы заполнили не все поля");
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
var order = db.Order.Find(SecurityContext.idOrder);
RenStatus.Text = order.RentStatus;
Rentime.Text = order.RentTime;
CarLi.ItemsSource = dtCar.DefaultView;
ClietnLi.ItemsSource = dtClient.DefaultView;
for (int i = 0; i < dtClient.Rows.Count; i++)
{
if (int.Parse(dtClient.Rows[i].ItemArray[0].ToString()) == order.idClient)
{
ClietnLi.SelectedIndex = i;
}
}
for (int i = 0; i < dtCar.Rows.Count; i++)
{
if (int.Parse(dtCar.Rows[i].ItemArray[0].ToString()) == order.IdCar)
{
CarLi.SelectedIndex = i;
}
}
}
public static DataTable GetReList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Машина");
dtClient.Columns.Add("Модель");
dtClient.Columns.Add("Статус аренды");
dtClient.Columns.Add("Время аренды");
dtClient.Columns.Add("ФИО");
dtClient.Columns.Add("Номер телефона");
dtClient.Columns.Add("Цена");
dtClient.Columns.Add("Общая цена");
var query = from order in db.Order
join car in db.Cars on order.IdCar equals car.idCar
join client in db.Users on order.idClient equals client.IdUser
select new
{ order.idOrder,
car = car.Car,
mod = car.CarModel,
order.RentStatus,
order.RentTime,
FIO = client.SecondName + " " + client.Name + " " + client.MiddlName,
Phone = client.PhoneNumber,
Price = car.CarPrice,
order.Summ };
foreach (var rel in query)
{
dtClient.Rows.Add(rel.idOrder, rel.car, rel.mod, rel.RentStatus, rel.RentTime, rel.FIO, rel.Phone, rel.Price, rel.Summ);
}
return(dtClient);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
var car_ = db.Cars.Find(SecurityContext.idClient);
Car.Text = car_.Car;
Carmodel.Text = car_.CarModel;
CarAvailable.Text = car_.CarAvailable;
CarCountry.Text = car_.CarCountry;
CarYear.Text = car_.CarYear;
VIN.Text = car_.VIN;
}
private void button1_Click(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
Order order = db.Order.Find(SecurityContext.idOrder);
db.Order.Remove(db.Order.Where(dr => dr.idOrder == SecurityContext.idOrder).FirstOrDefault());
db.SaveChanges();
OrderList re = new OrderList();
this.Hide();
re.Show();
}
private void button1_Click(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
var users = db.Users.Find(SecurityContext.idClient);
db.Users.Remove(db.Users.Where(dr => dr.IdUser == SecurityContext.idClient).FirstOrDefault());
db.SaveChanges();
ClientList re = new ClientList();
this.Hide();
re.Show();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
var users = db.Users.Find(SecurityContext.idClient);
Name.Text = users.Name;
SecondName.Text = users.SecondName;
MiddlName.Text = users.MiddlName;
Phone.Text = users.PhoneNumber;
Login.Text = users.Login;
Password.Text = users.Password;
}
private void button1_Click(object sender, RoutedEventArgs e)
{
try
{
rentcarEntities db = new rentcarEntities();
var car = db.Cars.Find(SecurityContext.idClient);
db.Cars.Remove(db.Cars.Where(dr => dr.idCar == SecurityContext.idClient).FirstOrDefault());
db.SaveChanges();
CarList re = new CarList();
this.Hide();
re.Show();
}
catch
{ MessageBox.Show("Данный автомобиль участвует в заказе"); }
}
private void button_Click(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
Cars car = db.Cars.Find(SecurityContext.idClient);
car.CarModel = Carmodel.Text;
car.Car = Car.Text;
car.CarAvailable = CarAvailable.Text;
car.CarCountry = CarCountry.Text;
car.CarYear = CarYear.Text;
car.VIN = VIN.Text;
db.Cars.Create();
db.SaveChanges();
CarList re = new CarList();
this.Hide();
re.Show();
}
private void button_Click(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
Users us = db.Users.Find(SecurityContext.idClient);
us.Name = Name.Text;
us.MiddlName = MiddlName.Text;
us.SecondName = SecondName.Text;
us.PhoneNumber = Phone.Text;
us.Login = Login.Text;
us.Password = Password.Text;
db.Users.Create();
db.SaveChanges();
ClientList re = new ClientList();
this.Hide();
re.Show();
}
public static DataTable GetCarList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Машина");
dtClient.Columns.Add("Модель");
dtClient.Columns.Add("Год выпуска");
dtClient.Columns.Add("Страна");
dtClient.Columns.Add("VIN");
var Query = db.Cars; // Выбираются данные из таблицы Автомобили
foreach (var rel in Query)
{
dtClient.Rows.Add(rel.idCar, rel.Car, rel.CarModel, rel.CarYear, rel.CarCountry, rel.VIN);
}
return(dtClient);
}
public static DataTable GetCarList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Машина");
dtClient.Columns.Add("Модель");
dtClient.Columns.Add("Год выпуска");
dtClient.Columns.Add("Страна");
dtClient.Columns.Add("VIN");
dtClient.Columns.Add("Цена");
var Query = db.Cars;
foreach (var rel in Query)
{
dtClient.Rows.Add(rel.idCar, rel.Car, rel.CarModel, rel.CarYear, rel.CarCountry, rel.VIN, rel.CarPrice);
}
return(dtClient);
}
private void button_Click(object sender, RoutedEventArgs e)
{
rentcarEntities db = new rentcarEntities();
Cars save = new Cars
{
Car = Car.Text,
CarAvailable = Available.Text,
CarCountry = Country.Text,
CarModel = Model.Text,
CarYear = Data.Text,
VIN = Vin.Text
};
db.Cars.Add(save);
db.SaveChanges();
MessageBox.Show("Машина добавлен");
CarList reg = new CarList();
this.Hide();
reg.Show();
}
public static DataTable GetClientList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Фамилия");
dtClient.Columns.Add("Имя");
dtClient.Columns.Add("Отчество");
dtClient.Columns.Add("Номер телефона");
var Query = db.Users;
foreach (var rel in Query)
{
if (rel.Role == "Client")
{
dtClient.Rows.Add(rel.IdUser, rel.SecondName, rel.Name, rel.MiddlName, rel.PhoneNumber);
}
}
return(dtClient);
}
public static DataTable GetReList()
{
rentcarEntities db = new rentcarEntities();
DataTable dtClient = new DataTable();
dtClient.Columns.Add("id");
dtClient.Columns.Add("Автомобиль");
dtClient.Columns.Add("Модель");
dtClient.Columns.Add("Год выпуска");
dtClient.Columns.Add("Страна изготовитель");
dtClient.Columns.Add("VIN");
dtClient.Columns.Add("Статус");
var Query = db.Cars;
foreach (var rel in Query)
{
{
dtClient.Rows.Add(rel.idCar, rel.Car, rel.CarModel, rel.CarYear, rel.CarCountry, rel.VIN, rel.CarAvailable);
}
}
return(dtClient);
}
private void aut_Click(object sender, RoutedEventArgs e)
{
if (Login.Text != "" && Password.Password != "")
{
try
{
rentcarEntities db = new rentcarEntities();
var rol = db.Users.Where(us => us.Login == Login.Text && us.Password == Password.Password).FirstOrDefault().Role; //
var f = db.Users.Where(us => us.Login == Login.Text && us.Password == Password.Password).FirstOrDefault().IdUser;
if (rol == "Client")
{
ClientForn re = new ClientForn();
this.Hide();
SecurityContext.idClient = f;
re.Show();
SecurityContext.avtovxod = 1;
}
else if (rol == "Manager")
{
ManagerForm re = new ManagerForm();
this.Hide();
re.Show();
SecurityContext.avtovxod = 3;
}
}
catch
{
MessageBox.Show("Вы ввели неправильно логин или пароль");
}
}
else
{
MessageBox.Show("Вы заполнили не все поля");
}
}
