public HttpResponseMessage addCar(cars_model_available car)
        {
            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                cars_model_available car_avilable = new cars_model_available();

                car_avilable.cost_per_day      = car.cost_per_day;
                car_avilable.car_number        = car.car_number;
                car_avilable.financial_penalty = car.financial_penalty;
                car_avilable.gear              = car.gear;
                car_avilable.model             = car.model;
                car_avilable.producer          = car.producer;
                car_avilable.production_year   = car.production_year;
                car_avilable.img               = car.img;
                car_avilable.banking_adress    = car.banking_adress;
                car_avilable.banking_longitued = car.banking_longitued;
                car_avilable.banking_name      = car.banking_name;


                entities.cars_model_available.Add(car_avilable);
                entities.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, entities.cars_model_available.ToList()));
            }
        }
        public HttpResponseMessage PostNewUser(userInfo user)
        {
            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                if (entities.Users.Any(u => u.email == user.email))
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, user.email));
                }
                else
                {
                    if (entities.Users.Any(u => u.userName == user.userName))
                    {
                        return(Request.CreateResponse(HttpStatusCode.BadRequest, user.userName));
                    }
                    else
                    {
                        Users users = new Users();
                        users.userName = user.userName;
                        users.userId   = user.Id;
                        users.email    = user.email;
                        users.password = user.password;
                        users.fullName = user.fullName;
                        users.BDate    = user.BDate;
                        users.img      = user.img;
                        users.gender   = user.gender;

                        entities.Users.Add(users);
                        entities.SaveChanges();

                        return(Request.CreateResponse(HttpStatusCode.OK, entities.Users.ToList()));
                    }
                }
            }
        }
        public HttpResponseMessage editCarNot(cars_not_avalable newCar)
        {
            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                cars_not_avalable car = entities.cars_not_avalable.FirstOrDefault(c => c.id == newCar.id);



                car.banking_adrress    = newCar.banking_adrress;
                car.banking_longitude  = newCar.banking_longitude;
                car.banking_name       = newCar.banking_name;
                car.car_number         = newCar.car_number;
                car.cost_per_day       = newCar.cost_per_day;
                car.fainancial_penalty = newCar.fainancial_penalty;
                car.gear            = newCar.gear;
                car.img             = newCar.img;
                car.model           = newCar.model;
                car.producer        = newCar.producer;
                car.production_year = newCar.production_year;


                entities.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, entities.cars_not_avalable.ToList()));
            }
        }
        public HttpResponseMessage deletOrder(Id id)
        {
            rentalCarsEntities entities = new rentalCarsEntities();

            entities.orders.Remove(entities.orders.FirstOrDefault(i => i.id == id.id));
            entities.SaveChanges();

            return(Request.CreateResponse(HttpStatusCode.OK, entities.orders.ToList()));
        }
        public HttpResponseMessage deletUser(Id id)
        {
            rentalCarsEntities entities = new rentalCarsEntities();
            var user = entities.Users.FirstOrDefault(u => u.id == id.id);

            entities.Users.Remove(user);
            entities.SaveChanges();

            return(Request.CreateResponse(HttpStatusCode.OK, entities.Users.ToList()));
        }
        public HttpResponseMessage deletCarAvailable(Id id)
        {
            rentalCarsEntities entities = new rentalCarsEntities();
            var car = entities.cars_model_available.FirstOrDefault(u => u.id == id.id);

            entities.cars_model_available.Remove(car);
            entities.SaveChanges();

            return(Request.CreateResponse(HttpStatusCode.OK, entities.cars_model_available.ToList()));
        }
        public HttpResponseMessage rentCars(rent cars)
        {
            string userId = Thread.CurrentPrincipal.Identity.Name;

            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                foreach (var car in cars.c)
                {
                    cars_not_avalable cars_not = new cars_not_avalable();

                    orders order = new orders();

                    order.bamking_name      = car.banking_name;
                    order.banking_address   = car.banking_adress;
                    order.banking_longitude = car.banking_longitued;
                    order.cost_per_day      = car.cost_per_day;
                    order.financial_penalty = car.financial_penalty;
                    order.gear               = car.gear;
                    order.model              = car.model;
                    order.producer           = car.producer;
                    order.production_year    = car.production_year;
                    order.userId             = userId;
                    order.start_renting_date = DateTime.Now;
                    order.car_number         = car.car_number;
                    order.returning_date     = DateTime.Now.AddDays(cars.num);

                    entities.orders.Add(order);

                    cars_not.cost_per_day       = car.cost_per_day;
                    cars_not.car_number         = car.car_number;
                    cars_not.fainancial_penalty = car.financial_penalty;
                    cars_not.gear            = car.gear;
                    cars_not.model           = car.model;
                    cars_not.producer        = car.producer;
                    cars_not.production_year = car.production_year;
                    cars_not.img             = car.img;
                    cars_not.id = car.id;
                    cars_not.banking_adrress   = car.banking_adress;
                    cars_not.banking_longitude = car.banking_longitued;
                    cars_not.banking_name      = car.banking_name;


                    entities.cars_model_available.Remove(entities.cars_model_available.FirstOrDefault(c => c.id == car.id));

                    entities.cars_not_avalable.Add(cars_not);
                }

                entities.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, cars));
            }
        }
        public HttpResponseMessage addWorker(Workers worker)
        {
            rentalCarsEntities entities = new rentalCarsEntities();
            Workers            w        = new Workers();

            w.first_name = worker.first_name;
            w.id         = worker.id;
            w.img        = worker.img;
            w.last_name  = worker.last_name;
            w.password   = worker.password;
            w.user_name  = worker.user_name;
            w.worker_id  = worker.worker_id;

            entities.Workers.Add(w);
            entities.SaveChanges();

            return(Request.CreateResponse(HttpStatusCode.OK, entities.Workers.ToList()));
        }
        public HttpResponseMessage editUser(Users user)
        {
            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                var item = entities.Users.FirstOrDefault(u => u.id == user.id);
                item.BDate    = user.BDate;
                item.email    = user.email;
                item.fullName = user.fullName;
                item.gender   = user.gender;
                item.id       = user.id;
                item.img      = user.img;
                item.password = user.password;
                item.userId   = user.userId;
                item.userName = user.userName;

                entities.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, entities.Users.ToList()));
            }
        }
        public HttpResponseMessage editWorker(Workers worker)
        {
            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                var item = entities.Workers.FirstOrDefault(x => x.id == worker.id);
                item.img        = worker.img;
                item.last_name  = worker.last_name;
                item.first_name = worker.last_name;
                item.worker_id  = worker.worker_id;
                item.user_name  = worker.user_name;
                item.password   = worker.password;
                item.id         = worker.id;

                // entities.Workers.Remove(entities.Workers.FirstOrDefault(u => u.id == worker.id));
                // entities.Workers.Add(worker);
                entities.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, entities.Workers.ToList()));
            }
        }
        public HttpResponseMessage returnCar(cars_not_avalable car)
        {
            using (rentalCarsEntities entities = new rentalCarsEntities())
            {
                cars_model_available car_avilable = new cars_model_available();



                car_avilable.cost_per_day      = car.cost_per_day;
                car_avilable.car_number        = car.car_number;
                car_avilable.financial_penalty = car.fainancial_penalty;
                car_avilable.gear              = car.gear;
                car_avilable.model             = car.model;
                car_avilable.producer          = car.producer;
                car_avilable.production_year   = car.production_year;
                car_avilable.img               = car.img;
                car_avilable.banking_adress    = car.banking_adrress;
                car_avilable.banking_longitued = car.banking_longitude;
                car_avilable.banking_name      = car.banking_name;


                entities.cars_model_available.Add(car_avilable);

                var car_not = entities.cars_not_avalable.FirstOrDefault(c => c.id == car.id);
                var order   = entities.orders.FirstOrDefault(c => c.car_number == car_not.car_number);

                if (order != null)
                {
                    order.actually_returning_date = DateTime.Now;
                }

                entities.cars_not_avalable.Remove(car_not);
                entities.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, entities.cars_not_avalable.ToList()));
            }
        }