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("Вы заполнили не все поля"); } }