Exemplo n.º 1
0
        public void InitializeAddCar()
        {
            CarRentalManagementEntities context = new CarRentalManagementEntities();
            var carMakes = context.CarMakes.OrderBy(x => x.MakeId).Select(x => x.Make);

            comboBoxCarMake.DataSource = carMakes.ToList();
        }
        public void LoadReseverdCars()
        {
            CarRentalManagementEntities context      = new CarRentalManagementEntities();
            List <Reservation>          reservations = Controller <CarRentalManagementEntities, Reservation> .GetEntities(r => !r.IsReturend).ToList();

            List <int> carIds = reservations.Where(r => !r.IsReturend).Select(r => r.CarId).ToList();
            List <Car> cars   = Controller <CarRentalManagementEntities, Car> .GetEntities(c => carIds.Contains(c.CarId)).ToList();

            List <int> typeIds = cars.Select(r => r.TypeId).ToList();
            List <int> makeIds = cars.Select(r => r.MakeId).ToList();

            var rentedCars = (from s in cars
                              join cs in context.CarTypes on s.TypeId equals cs.TypeId
                              join os in context.CarMakes on s.MakeId equals os.MakeId
                              select new
            {
                CarMake = os.Make,
                CarType = cs.Type,
                Model = s.Model,
                Year = s.Year,
                Price = s.Price
            }).ToList();

            dataGridViewRentedCars.DataSource = rentedCars;
        }
        public void AddNewCar()
        {
            context = new CarRentalManagementEntities();
            var type   = comboBoxCarType.Text;
            var typeId = context.CarTypes.Where(x => x.Type == type).Select(x => x.TypeId).Distinct();
            var make   = comboBoxCarType.Text;
            var makeId = context.CarMakes.Where(x => x.Make == make).Select(x => x.MakeId).Distinct();

            MessageBox.Show("" + makeId.First());

            /*Car newCar = new Car()
             * {
             *  TypeId = typeId.First(),
             *  MakeId = makeId.First(),
             *  Color = textBoxCarColor.Text,
             *  Model = textBoxCarModel.Text,
             *  Year = Int32.Parse(textBoxCarYear.Text),
             *  Price = Decimal.Parse(textBoxCarPrice.Text),
             * };
             *
             * try
             * {
             *  context.Cars.Add(newCar);
             *  context.SaveChanges();
             * }
             * catch (Exception ex)
             * {
             *  MessageBox.Show("Cannot add car to database" + ex.InnerException.InnerException.Message + "\n Make " + makeId.First());
             *  return;
             * }*/
        }
        public void AddNewCar()
        {
            context = new CarRentalManagementEntities();
            var type   = comboBoxCarType.Text;
            var typeId = context.CarTypes.Where(x => x.Type == type).Select(x => x.TypeId).Distinct();
            var make   = comboBoxCarMake.Text;
            var makeId = context.CarMakes.Where(x => x.Make == make).Select(x => x.MakeId).Distinct();
            Car newCar = new Car()
            {
                TypeId = typeId.First(),
                MakeId = makeId.First(),
                Color  = textBoxCarColor.Text,
                Model  = textBoxCarModel.Text,
                Year   = Int32.Parse(textBoxCarYear.Text),
                Price  = Decimal.Parse(textBoxCarPrice.Text),
            };

            try
            {
                context.Cars.Add(newCar);
                context.SaveChanges();
                MessageBox.Show("Car added successfully");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Cannot add car to database" + ex.InnerException.InnerException.Message + "\n Make " + makeId.First());
                return;
            }
        }
        private void InitializeStudentRegistrationFormsAppMainForm()
        {
            CarRentalManagementEntities context = new CarRentalManagementEntities();
            //context.SeedDatabase();

            //Calling method that initializes all of the datagrids.
            //InitializeDataGridView<Reservation>(dataGridViewRentedCars);
        }
 public AddCar()
 {
     context = new CarRentalManagementEntities();
     InitializeComponent();
     InitializeAddCar();
     buttonAddCar.Click     += ButtonAddCar_Click;
     buttonCarMake.Click    += ButtonCarMake_Click;
     buttonAddCarType.Click += ButtonAddCarType_Click;
 }
        private void InitializeStudentRegistrationFormsAppMainForm()
        {
            CarRentalManagementEntities context = new CarRentalManagementEntities();

            //context.SeedDatabase();

            //Calling method that initializes all of the datagrids.
            InitializeDataGridView <Student>(dataGridViewStudents, "Department", "Courses");
            InitializeDataGridView <Department>(dataGridViewDepartments, "Courses", "Students");
        }
Exemplo n.º 8
0
        public void MoveToAvailable()
        {
            CarRentalManagementEntities context   = new CarRentalManagementEntities();
            int             selectedrowindexCarId = dataGridViewRentedCars.SelectedCells[0].RowIndex;
            DataGridViewRow selectedRowCarId      = dataGridViewRentedCars.Rows[selectedrowindexCarId];
            string          carId = Convert.ToString(selectedRowCarId.Cells["CarId"].Value);

            Reservation res = Controller <CarRentalManagementEntities, Reservation> .GetEntities(r => r.CarId == Int32.Parse(carId)).First();

            res.IsReturend = true;
            Controller <CarRentalManagementEntities, Reservation> .UpdateEntity(res);
        }
 public void MoveToAvailable()
 {
     CarRentalManagementEntities context   = new CarRentalManagementEntities();
     int             selectedrowindexCarId = dataGridViewAvailableCars.SelectedCells[0].RowIndex;
     DataGridViewRow selectedRowCarId      = dataGridViewAvailableCars.Rows[selectedrowindexCarId];
     string          carId      = Convert.ToString(selectedRowCarId.Cells["CarId"].Value);
     var             isReserved = (from reserved in context.Reservations
                                   where reserved.CarId == Int32.Parse(carId)
                                   select new
     {
         isReserved = reserved.IsReturend
     });
 }
 public AdminForm()
 {
     rentalDataSet = new DataSet()
     {
         DataSetName = "rentalDataSet",
     };
     context = new CarRentalManagementEntities();
     InitializeComponent();
     InitializeAdminForm();
     buttonAddNewCar.Click       += ButtonAddNewCar_Click;
     buttonViewReports.Click     += ButtonViewReports_Click;
     buttonMoveToAvailable.Click += ButtonMoveToAvailable_Click;
     buttonBackupDatabase.Click  += ButtonBackupDatabase_Click;
 }
        public void MoveToAvailable()
        {
            CarRentalManagementEntities context   = new CarRentalManagementEntities();
            int             selectedrowindexCarId = dataGridViewAvailableCars.SelectedCells[0].RowIndex;
            DataGridViewRow selectedRowCarId      = dataGridViewAvailableCars.Rows[selectedrowindexCarId];
            string          carId = Convert.ToString(selectedRowCarId.Cells["CarId"].Value);

            Reservation isReturned = new Reservation()
            {
                IsReturend = false,
            };

            context.Reservations.Find(carId);
        }
        public void AddNewCar()
        {
            context = new CarRentalManagementEntities();
            Car newCar = new Car()
            {
                Color = textBoxCarColor.Text,
                Model = textBoxCarModel.Text,
                Year  = Int32.Parse(textBoxCarYear.Text),
                Price = Int32.Parse(textBoxCarPrice.Text),
            };

            try
            {
                context.Cars.Add(newCar);
                context.SaveChanges();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Cannot add car to databse" + ex.InnerException.InnerException.Message);
                return;
            }
        }
        /// <summary>
        /// Method to add new type in car types.
        /// </summary>
        public void AddNewType()
        {
            CarRentalManagementEntities entities = new CarRentalManagementEntities();
            CarType carType = new CarType()
            {
                Type = textBoxCarType.Text
            };

            try
            {
                entities.CarTypes.Add(carType);
                entities.SaveChanges();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Cannot add Car Type to database" + ex.InnerException.InnerException.Message);
                return;
            }

            this.DialogResult = DialogResult.OK;
            entities.Dispose();
            Close();
        }
Exemplo n.º 14
0
        private void ButtonAddCarMake_Click(object sender, EventArgs e)
        {
            CarRentalManagementEntities entities = new CarRentalManagementEntities();
            CarMake carMake = new CarMake()
            {
                Make = textBoxAddCarMake.Text
            };

            try
            {
                entities.CarMakes.Add(carMake);
                entities.SaveChanges();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Cannot add Car Make to database" + ex.InnerException.InnerException.Message);
                return;
            }

            this.DialogResult = DialogResult.OK;
            entities.Dispose();
            Close();
        }