示例#1
0
        public ActionResult DeleteConfirmed(int id)
        {
            NewNEWAssign newNEWAssign = db.NewNEWAssigns.Find(id);

            db.NewNEWAssigns.Remove(newNEWAssign);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
示例#2
0
 public ActionResult Edit([Bind(Include = "AssignID,ContID,SelectedDate,ContainerNumber,ContainerSize,Driver,Truck,Trailer,Location,Destination,Status,PickUpTime,PickUpDate,EstDate,EstTime,AssignCode")] NewNEWAssign newNEWAssign)
 {
     if (ModelState.IsValid)
     {
         db.Entry(newNEWAssign).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ContID = new SelectList(db.NewContainers, "ContainerID", "ContainerNumber", newNEWAssign.ContID);
     return(View(newNEWAssign));
 }
示例#3
0
        // GET: NewNEWAssigns/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            NewNEWAssign newNEWAssign = db.NewNEWAssigns.Find(id);

            if (newNEWAssign == null)
            {
                return(HttpNotFound());
            }
            return(View(newNEWAssign));
        }
示例#4
0
        // GET: NewNEWAssigns/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            NewNEWAssign newNEWAssign = db.NewNEWAssigns.Find(id);

            if (newNEWAssign == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ContID = new SelectList(db.NewContainers, "ContainerID", "ContainerNumber", newNEWAssign.ContID);
            return(View(newNEWAssign));
        }
示例#5
0
        public ActionResult Create([Bind(Include = "AssignID,ContID,SelectedDate,ContainerNumber,ContainerSize,Driver,Truck,Trailer,Location,Destination,Status,PickUpTime,PickUpDate,EstDate,EstTime,AssignCode")] NewNEWAssign newNEWAssign)
        {
            if (ModelState.IsValid)
            {
                var containers = db.NewContainers.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).ToList();

                var Priority1 = containers.Where(x => x.Priority == "High").ToList();
                var Priority2 = containers.Where(x => x.Priority == "Medium").ToList();
                var Priority3 = containers.Where(x => x.Priority == "Low").ToList();

                var FreeDri = db.DatesBookedDrivers.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).ToList();
                var FreeTru = db.DatesBookedTrucks.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).ToList();
                var FreeTra = db.DatesBookedTrailers.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).ToList();

                foreach (var item in Priority1)
                {
                    if (FreeDri != null && FreeTra != null && FreeTru != null)
                    {
                        try
                        {
                            var Pri1        = Priority1.Where(x => x.Status == "UnAssigned").First();
                            var Dri         = FreeDri.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var DriverYeah  = db.NewDrivers.Find(Dri.DriveID);
                            var Tru         = FreeTru.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var TruckYeah   = db.NewTrucks.Find(Dri.DriveID);
                            var Tra         = FreeTra.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var TrailerYeah = db.NewTrailers.Find(Dri.DriveID);

                            NewNEWAssign obj = new NewNEWAssign();
                            obj.AssignID        = Pri1.ContainerID;
                            obj.PickUpDate      = Pri1.PickUp;
                            obj.PickUpTime      = Pri1.PickUpTime;
                            obj.ContainerNumber = Pri1.ContainerNumber;
                            obj.ContainerSize   = Pri1.ContainerSize;
                            obj.Location        = Pri1.Location;
                            obj.Destination     = Pri1.Destination;

                            ////////
                            ////////

                            obj.Driver  = DriverYeah.Email;
                            obj.Trailer = TrailerYeah.reg;
                            obj.Truck   = TruckYeah.reg;


                            Pri1.Status    = "Pending";
                            Dri.PickUpDate = newNEWAssign.SelectedDate;
                            Tra.PickUpDate = newNEWAssign.SelectedDate;
                            Tru.PickUpDate = newNEWAssign.SelectedDate;
                        }
                        catch (Exception)
                        {
                        }
                    }
                    else
                    {
                        foreach (var item1 in Priority1)
                        {
                            var Pri1 = Priority1.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).First();
                            Pri1.PickUp = Pri1.PickUp.AddDays(1);
                        }
                    }
                }


                foreach (var item in Priority2)
                {
                    if (FreeDri != null && FreeTra != null && FreeTru != null)
                    {
                        try
                        {
                            var Pri2        = Priority2.Where(x => x.Status == "UnAssigned").First();
                            var Dri         = FreeDri.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var DriverYeah  = db.NewDrivers.Find(Dri.DriveID);
                            var Tru         = FreeTru.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var TruckYeah   = db.NewTrucks.Find(Dri.DriveID);
                            var Tra         = FreeTra.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var TrailerYeah = db.NewTrailers.Find(Dri.DriveID);

                            NewNEWAssign obj = new NewNEWAssign();
                            obj.AssignID        = Pri2.ContainerID;
                            obj.PickUpDate      = Pri2.PickUp;
                            obj.PickUpTime      = Pri2.PickUpTime;
                            obj.ContainerNumber = Pri2.ContainerNumber;
                            obj.ContainerSize   = Pri2.ContainerSize;
                            obj.Location        = Pri2.Location;
                            obj.Destination     = Pri2.Destination;

                            ////////
                            ////////

                            obj.Driver  = DriverYeah.Email;
                            obj.Trailer = TrailerYeah.reg;
                            obj.Truck   = TruckYeah.reg;


                            Pri2.Status    = "Pending";
                            Dri.PickUpDate = newNEWAssign.SelectedDate;
                            Tra.PickUpDate = newNEWAssign.SelectedDate;
                            Tru.PickUpDate = newNEWAssign.SelectedDate;
                        }
                        catch (Exception)
                        {
                        }
                    }
                    else
                    {
                        foreach (var item2 in Priority2)
                        {
                            var Pri2 = Priority2.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).First();
                            Pri2.PickUp = Pri2.PickUp.AddDays(1);
                        }
                    }
                }


                foreach (var item in Priority3)
                {
                    if (FreeDri != null && FreeTra != null && FreeTru != null)
                    {
                        try
                        {
                            var Pri3        = Priority3.Where(x => x.Status == "UnAssigned").First();
                            var Dri         = FreeDri.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var DriverYeah  = db.NewDrivers.Find(Dri.DriveID);
                            var Tru         = FreeTru.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var TruckYeah   = db.NewTrucks.Find(Dri.DriveID);
                            var Tra         = FreeTra.Where(x => x.PickUpDate != newNEWAssign.SelectedDate).First();
                            var TrailerYeah = db.NewTrailers.Find(Dri.DriveID);

                            NewNEWAssign obj = new NewNEWAssign();
                            obj.AssignID        = Pri3.ContainerID;
                            obj.PickUpDate      = Pri3.PickUp;
                            obj.PickUpTime      = Pri3.PickUpTime;
                            obj.ContainerNumber = Pri3.ContainerNumber;
                            obj.ContainerSize   = Pri3.ContainerSize;
                            obj.Location        = Pri3.Location;
                            obj.Destination     = Pri3.Destination;

                            ////////
                            ////////

                            obj.Driver  = DriverYeah.Email;
                            obj.Trailer = TrailerYeah.reg;
                            obj.Truck   = TruckYeah.reg;


                            Pri3.Status    = "Pending";
                            Dri.PickUpDate = newNEWAssign.SelectedDate;
                            Tra.PickUpDate = newNEWAssign.SelectedDate;
                            Tru.PickUpDate = newNEWAssign.SelectedDate;
                        }
                        catch (Exception)
                        {
                        }
                    }
                    else
                    {
                        foreach (var item3 in Priority3)
                        {
                            var Pri3 = Priority3.Where(x => x.Status == "UnAssigned" && x.PickUp == newNEWAssign.SelectedDate).First();
                            Pri3.PickUp = Pri3.PickUp.AddDays(1);
                        }
                    }
                }



                db.NewNEWAssigns.Add(newNEWAssign);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.ContID = new SelectList(db.NewContainers, "ContainerID", "ContainerNumber", newNEWAssign.ContID);
            return(View(newNEWAssign));
        }