Esempio n. 1
0
        public ActionResult Receipt(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Vehicles vehicle = db.Vehicles.Find(id);
            Members  member  = vehicle.Member;

            if (vehicle == null)
            {
                return(HttpNotFound());
            }
            db.Vehicles.Remove(vehicle);
            db.SaveChanges();

            vehicle.CheckOutTime = DateTime.Parse(DateTime.Now.ToString("g"));
            TimeSpan?ParkingDuration = vehicle.CheckOutTime - vehicle.CheckInTime;

            vehicle.AmountFee = 5 * (int)Math.Ceiling(ParkingDuration?.TotalMinutes / 10 ?? 0);
            //vehicle.
            VehicleType vType = db.VehicleType?.Where(vt => vt.Id == vehicle.VehicleTypeId).SingleOrDefault();

            vehicle.VehicleType = vType;
            Members currentMember = db.Members?.Where(m => m.Id == vehicle.MemberId).SingleOrDefault();

            vehicle.Member = currentMember;

            return(View("Receipt", vehicle));
        }
Esempio n. 2
0
        public void DodajDoKoszyka(Towar towar)
        {
            // Najpierw sprawdzamy czy dany towar już istnieje w koszyku danego klienta
            var elementKoszyka =
                (
                    from element in db.ElementyKoszyka
                    where element.IdSesjiKoszyka == this.IdSesjiKoszyka && element.IdTowaru == towar.IdTowaru
                    select element
                ).FirstOrDefault();

            //jeżeli brak tego towaru w koszyku
            if (elementKoszyka == null)
            {
                // Wtedy tworzymy nowy element w koszyku
                elementKoszyka = new ElementKoszyka()
                {
                    IdSesjiKoszyka = this.IdSesjiKoszyka,
                    IdTowaru       = towar.IdTowaru,
                    Ilosc          = 1,
                    DataUtworzenia = DateTime.Now
                };
                //i dodajemy do kolekcji lokalne
                db.ElementyKoszyka.Add(elementKoszyka);
            }
            else
            {
                // Jeżeli dany towar istnieje już w koszyku to liczbe sztuk zwiekszamy o 1
                elementKoszyka.Ilosc++;
            }
            // Zapisujemy zmiany do bazy
            db.SaveChanges();
        }
Esempio n. 3
0
        public ActionResult Create([Bind(Include = "ID,CarID,Description,Active,Price,Photo,Email,phone")] Adverts adverts)
        {
            string main = Server.MapPath("~/Content/Photo/AdvertsPhoto");

            if (ModelState.IsValid)
            {
                HttpPostedFileBase postedFile = Request.Files["Photo"];
                if (postedFile.ContentLength > 0)
                {
                    var fileName = Path.GetFileName(postedFile.FileName);
                    var path     = Path.Combine(main, fileName);
                    adverts.Photo = fileName;
                    postedFile.SaveAs(path);
                }
                db.Notice.Add(adverts);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }



            //var email = User.Identity.GetUserName();

            //ViewBag.RepairID = new SelectList(db.Repairs.Where(u => u.Email == email), "ID", "Name");

            //ViewBag.CarID = new SelectList(db.Car, "ID", "Brand", adverts.CarID);
            return(View(adverts));
        }
Esempio n. 4
0
        public ActionResult Create([Bind(Include = "ID,Brand,Model,Year,VIN,Series,Photo,Buy_Date,Sell_Date,Buy_Cost,Sell_Cost,OwnerID")] Cars cars)
        {
            string main   = Server.MapPath("~/Content/Photo/CarsPhotos");
            var    e_mail = User.Identity.GetUserName();



            //var TargetLocation = Path.Combine(main, src);
            if (ModelState.IsValid)
            {
                HttpPostedFileBase postedFile = Request.Files["Photo"];

                if (postedFile.ContentLength > 0)
                {
                    var fileName = Path.GetFileName(postedFile.FileName);
                    var path     = Path.Combine(main, fileName);
                    cars.Photo = fileName;
                    postedFile.SaveAs(path);
                }

                db.Car.Add(cars);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            else
            {
                return(View(cars));
            }
        }
Esempio n. 5
0
        public ActionResult Create([Bind(Include = "CarId,Name,PartNumber,PurchasePrice,SellPrice,PurchaseDate,SaleDate")] PartsModels partsModels)
        {
            ViewBag.CarId = new SelectList(db.Cars, "ID", "Model", partsModels.CarId);

            if (db.Parts.Count() > 0)
            {
                var max = db.Parts.OrderByDescending(p => p.ID).FirstOrDefault().ID;
                partsModels.ID = max + 1;
            }
            else
            {
                var max = 0;
                partsModels.ID = max + 1;
            }

            var carBrand = db.Cars.Where(c => c.ID == partsModels.CarId).FirstOrDefault().Brand.Name;
            var car      = db.Cars.Where(c => c.ID == partsModels.CarId).FirstOrDefault();

            partsModels.Owner    = 0;
            partsModels.Brand    = carBrand;
            partsModels.Car      = car;
            partsModels.SaleDate = DateTime.Now;

            db.Parts.Add(partsModels);

            db.SaveChanges();



            return(RedirectToAction("Index"));
        }
        public ActionResult Create([Bind(Include = "Id,Type,RegNum,Make,Model,Color,WheelCount")] Vehicle vehicle)
        {
            if (ModelState.IsValid)
            {
                bool valid = true;
                // Check if the same duplicate reg numbers exist with the same type
                var list =
                    db.Vehicles.Where(v => v.RegNum.Contains(vehicle.RegNum) && v.Type == vehicle.Type)
                    .Select(v => v)
                    .ToList();
                if (list.Count() > 0)
                {
                    valid = false;
                }

                // Check if duplicates exist within a category of vehicles
                if ((vehicle.Type == VehicleTypes.Bus) ||
                    (vehicle.Type == VehicleTypes.Car) ||
                    (vehicle.Type == VehicleTypes.Motorcycle))
                {
                    list =
                        db.Vehicles.Where(v => v.RegNum.Contains(vehicle.RegNum))
                        .Select(v => v)
                        .ToList();

                    if (list.Count > 0)
                    {
                        foreach (var item in list)
                        {
                            if ((item.Type == VehicleTypes.Bus) ||
                                (item.Type == VehicleTypes.Car) ||
                                (item.Type == VehicleTypes.Motorcycle))
                            {
                                valid = false;
                            }
                        }
                    }
                }

                if (valid)
                {
                    vehicle.ArrivalTime = DateTime.Now;
                    vehicle.RegNum      = vehicle.RegNum.ToUpper();
                    db.Vehicles.Add(vehicle);
                    db.SaveChanges();
                }
                else
                {
                    ModelState.AddModelError("RegNum", "Fordon är redan parkerat");
                    return(View("Create"));
                }
                return(RedirectToAction("Index"));
            }

            return(View(vehicle));
        }
        public ActionResult Create([Bind(Include = "ID,CarId,Name,Description,ServiceCost,PartId")] RepairModels repairModels)
        {
            if (ModelState.IsValid)
            {
                db.Repairs.Add(repairModels);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(repairModels));
        }
Esempio n. 8
0
        public ActionResult Create([Bind(Include = "MemberId,FirstName,LastName,Age,Phone")] Member member)
        {
            if (ModelState.IsValid)
            {
                db.Members.Add(member);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(member));
        }
        public ActionResult Create([Bind(Include = "Id,TypeOfVehicle,RegNumber,Color,NoOfWheels,Brand,Model,CheckInTime,CheckOutTime,ParkingDuration,ParkingFee")] ParkedVehicle parkedVehicle)
        {
            if (ModelState.IsValid)
            {
                db.ParkedVehicles.Add(parkedVehicle);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(parkedVehicle));
        }
Esempio n. 10
0
        public ActionResult Create([Bind(Include = "Id,VehicleType,RequredSpace")] VehicleTypeList vehicleTypeList)
        {
            if (ModelState.IsValid)
            {
                db.VehicleTypeLists.Add(vehicleTypeList);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(vehicleTypeList));
        }
Esempio n. 11
0
        public ActionResult Create([Bind(Include = "ID,IdCar,IsActive")] AdModel adModel)
        {
            if (ModelState.IsValid)
            {
                db.AdModels.Add(adModel);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(adModel));
        }
Esempio n. 12
0
 public ActionResult Checkin([Bind(Include = "Id,Registration,VehicleTypeId, VehicleColorId, Brand, Model, NumberOfWheels")] Vehicle vehicle, string username, string password)
 {
     if (string.IsNullOrWhiteSpace(username))
     {
         ModelState.AddModelError("username", "The Username field is required.");
         MakeCreateDropDowns(vehicle);
         return(View(vehicle));
     }
     ViewBag.UserName = username;
     if (ModelState.IsValid)
     {
         if (!registrationVerifier.Verify(vehicle.Registration))
         {
             ModelState.AddModelError(nameof(vehicle.Registration), registrationVerifier.LastErrorMessage);
             MakeCreateDropDowns(vehicle);
             return(View(vehicle));
         }
         vehicle.Registration = RegistrationNormalizer.NormalizeForStorage(vehicle.Registration);
         if (db.Vehicles.Any(v => v.Registration == vehicle.Registration))
         {
             ModelState.AddModelError(nameof(vehicle.Registration), $"A vehicle with the registration '{RegistrationNormalizer.NormalizeForDisplay(vehicle.Registration)}' already exist in the garage");
             MakeCreateDropDowns(vehicle);
             return(View(vehicle));
         }
         var user = db.Members.FirstOrDefault(m => m.Username == username);
         if (user == null)
         {
             ModelState.AddModelError("username", $"No member with the username '{username}' could be found!");
             MakeCreateDropDowns(vehicle);
             return(View(vehicle));
         }
         if (user.Password != password)
         {
             ModelState.AddModelError("password", "Wrong password!");
             MakeCreateDropDowns(vehicle);
             return(View(vehicle));
         }
         vehicle.MemberId    = user.Id;
         vehicle.CheckinTime = DateTime.Now;
         vehicle.Type        = db.VehicleTypes.FirstOrDefault(t => t.Id == vehicle.VehicleTypeId);
         vehicle.ParkingUnit = FindFirstFreeUnit(vehicle.Units);
         if (vehicle.ParkingUnit + vehicle.Units > db.GarageConfiguration.ParkingUnits)
         {
             ModelState.AddModelError(nameof(vehicle.VehicleTypeId), $"Not enough space to park a {vehicle.Type.Type}");
             MakeCreateDropDowns(null);
             return(View(vehicle));
         }
         db.Vehicles.Add(vehicle);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     MakeCreateDropDowns(vehicle);
     return(View(vehicle));
 }
Esempio n. 13
0
        public ActionResult Create([Bind(Include = "Id,Owner,RegNr,Color,NumberOfWheels,VehicleType,InTime,OutTime")] Vehicle vehicle)
        {
            if (ModelState.IsValid)
            {
                db.Vehicles.Add(vehicle);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(vehicle));
        }
Esempio n. 14
0
        public ActionResult Create([Bind(Include = "IdTowaru,Nazwa,Kod,Cena,FotoUrl,Opis,Promocja,IdRodzaju")] Towar towar)
        {
            if (ModelState.IsValid)
            {
                db.Towary.Add(towar);
                db.SaveChanges();
                return(RedirectToAction("AdminIndex"));
            }

            return(View(towar));
        }
Esempio n. 15
0
        public ActionResult Create([Bind(Include = "ID,Name,LastName,PhoneNo,Email")] OwnerModels ownerModels)
        {
            if (ModelState.IsValid)
            {
                db.Owner.Add(ownerModels);
                db.SaveChanges();
                return(RedirectToAction("Create", "Car"));
            }

            return(View(ownerModels));
        }
Esempio n. 16
0
        public ActionResult Create([Bind(Include = "ProductId,Nazwa,Opis,Cena,Jakosc")] Product product)
        {
            if (ModelState.IsValid)
            {
                db.Products.Add(product);
                db.SaveChanges();
                return(RedirectToAction("AdminIndex"));
            }

            return(View(product));
        }
Esempio n. 17
0
        public ActionResult Create([Bind(Include = "CompanyProfileId,ProfileContent")] CompanyProfile companyProfile)
        {
            if (ModelState.IsValid)
            {
                db.CompanyProfiles.Add(companyProfile);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(companyProfile));
        }
Esempio n. 18
0
        public ActionResult Create([Bind(Include = "Id,RegNumber,Color,Brand,Model,NumberOfWheels,CheckIn,VehicleType,MemberId")] ParkedVehicle parkedVehicle)
        {
            if (ModelState.IsValid)
            {
                db.Vehicles.Add(parkedVehicle);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(parkedVehicle));
        }
Esempio n. 19
0
        public ActionResult Create([Bind(Include = "Id,FirstName,LastName,PersonalNumber,PhoneNo,Adress,Zipcode,City")] Member member)
        {
            if (ModelState.IsValid)
            {
                db.Members.Add(member);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(member));
        }
Esempio n. 20
0
        public ActionResult Register([Bind(Include = "Id,Username,Password,Name,Phone")] Member member)
        {
            if (ModelState.IsValid)
            {
                db.Members.Add(member);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(member));
        }
Esempio n. 21
0
        public ActionResult Create([Bind(Include = "Id,FirstName,LastName")] Owner owner)
        {
            if (ModelState.IsValid)
            {
                db.Owners.Add(owner);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(owner));
        }
Esempio n. 22
0
        public ActionResult Create([Bind(Include = "CustomerId,Name,Surname,Email,Phone,Discount")] Customer customer)
        {
            if (ModelState.IsValid)
            {
                db.Customers.Add(customer);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(customer));
        }
Esempio n. 23
0
        public ActionResult Create([Bind(Include = "ID,CarID,Name,CatNo,PurchasePrice,PurchaseSale,PurchaseDate,SaleDate")] PartModels partModels)
        {
            if (ModelState.IsValid)
            {
                db.Parts.Add(partModels);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(partModels));
        }
Esempio n. 24
0
        public ActionResult Create([Bind(Include = "ID,CarID,Active,OfferAmount")] AdvertisementModels advertisementModels)
        {
            //if (ModelState.IsValid)
            //{
            db.Advertisements.Add(advertisementModels);
            db.SaveChanges();
            return(RedirectToAction("Index"));
            //}

            //return View(advertisementModels);
        }
Esempio n. 25
0
        public ActionResult Create([Bind(Include = "HourId,Day,Hours")] Hour hour)
        {
            if (ModelState.IsValid)
            {
                db.Hours.Add(hour);
                db.SaveChanges();
                return(RedirectToAction("AdminIndex"));
            }

            return(View(hour));
        }
Esempio n. 26
0
        public ActionResult Create([Bind(Include = "ID,UserID,Name,Surname,PhoneNumber,Email")] OwnerModels ownerModels)
        {
            if (ModelState.IsValid)
            {
                db.Owner.Add(ownerModels);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(ownerModels));
        }
        public ActionResult Create([Bind(Include = "Id,Name,Membershipnumber,Phonenumber,Address")] Member member)
        {
            if (ModelState.IsValid)
            {
                db.Members.Add(member);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(member));
        }
Esempio n. 28
0
        public ActionResult Create([Bind(Include = "OfferId,ServiceName,Price")] Offer offer)
        {
            if (ModelState.IsValid)
            {
                db.Offers.Add(offer);
                db.SaveChanges();
                return(RedirectToAction("AdminIndex"));
            }

            return(View(offer));
        }
Esempio n. 29
0
        public ActionResult Create([Bind(Include = "Id,Name")] VehicleType vehicleType)
        {
            if (ModelState.IsValid)
            {
                db.VehicleTypes.Add(vehicleType);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(vehicleType));
        }
Esempio n. 30
0
        public ActionResult Create([Bind(Include = "Id,FirstName,LastName,PersonalIdentityNumber,TelephoNnumber")] Customer customer)
        {
            if (ModelState.IsValid)
            {
                db.Customers.Add(customer);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(customer));
        }