public void DeleteManufactor(int id)
        {
            Manufactor manufactorToDelete = DB.Manufactors.Where(p => p.ManufactorID == id).SingleOrDefault();

            if (manufactorToDelete != null)
            {
                List <Model> manufactorsModel = DB.Models.Where(p => p.ManufactorID == id).ToList();
                List <Car>   manufactorsCars  = DB.Cars.Where(p => p.ManufactorID == id).ToList();
                if (manufactorsModel != null)
                {
                    DB.Models.RemoveRange(manufactorsModel);
                }
                if (manufactorsCars != null)
                {
                    foreach (Car item in manufactorsCars)
                    {
                        if (item.Picture != null)
                        {
                            File.Delete(HttpContext.Current.Server.MapPath("~/Uploads/" + item.Picture));
                        }
                    }


                    List <Order> manufactorsOrders = DB.Orders.Where(p => p.Car.ManufactorID == id).ToList();
                    if (manufactorsOrders != null)
                    {
                        DB.Orders.RemoveRange(manufactorsOrders);
                    }

                    DB.Cars.RemoveRange(manufactorsCars);
                }

                DB.Manufactors.Remove(manufactorToDelete);
                DB.SaveChanges();
            }
        }