コード例 #1
0
        public ActionResult CheckOut(User_Transportation_Log trans)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    var userId    = transportationContext.Users.Where(u => u.BannerId == trans.BannerId).Select(i => i.UserId).FirstOrDefault();
                    var vehicleId = transportationContext.Vehicles.Where(v => v.VehicleName == trans.VehicleName).Select(i => i.VehicleId).FirstOrDefault();
                    var keyId     = transportationContext.Keys.Where(k => k.KeyName == trans.KeyName).Select(i => i.KeyId).FirstOrDefault();
                    var gasCardId = transportationContext.GasCards.Where(g => g.GasCardName == trans.GasCardName).Select(i => i.GasCardId).FirstOrDefault();

                    if (userId != 0 && vehicleId != 0 && keyId != 0 && gasCardId != 0)
                    {
                        SignOut signLog = new SignOut();
                        signLog.UserId       = userId;
                        signLog.VehicleId    = vehicleId;
                        signLog.KeyId        = keyId;
                        signLog.Destination  = trans.Destination;
                        signLog.GasCardId    = gasCardId;
                        signLog.CheckOutTime = DateTime.Now;
                        signLog.ActivityTime = DateTime.Now;
                        transportationContext.SignOuts.Add(signLog);
                        transportationContext.SaveChanges();
                    }
                    return(RedirectToAction("Index"));
                }
                catch
                {
                    return(new HttpStatusCodeResult(Response.StatusCode = 400));
                }
            }
            return(View());
        }
コード例 #2
0
        public ActionResult CreateUser(Admin_Create_User CUser)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    var departmentId = transportationContext.Departments.Where(d => d.DepartmentName == CUser.DepartmentName).Select(i => i.DepartmentId).FirstOrDefault();
                    var statusId     = transportationContext.UserStatuses.Where(s => s.StatusName == CUser.StatusName).Select(i => i.StatusId).FirstOrDefault();
                    if (departmentId != 0 && statusId != 0)
                    {
                        User user = new User();
                        user.BannerId     = CUser.BannerId;
                        user.FirstName    = CUser.FirstName;
                        user.LastName     = CUser.LastName;
                        user.DepartmentId = departmentId;
                        user.StatusId     = statusId;
                        transportationContext.Users.Add(user);
                        transportationContext.SaveChanges();

                        return(RedirectToAction("index"));
                    }

                    return(new HttpStatusCodeResult(Response.StatusCode = 400));
                }
                catch
                {
                    return(new HttpStatusCodeResult(Response.StatusCode = 400));
                }
            }
            return(View());
        }
コード例 #3
0
 public ActionResult CreateGasCard(Admin_Create_GasCard CGasCard)
 {
     if (ModelState.IsValid)
     {
         try
         {
             var statusId = transportationContext.GasCardStatuses.Where(Gs => Gs.StatusName == CGasCard.StatusName).Select(i => i.StatusId).FirstOrDefault();
             if (statusId != 0)
             {
                 //instantiate object
                 GasCard gasCard = new GasCard();
                 //set
                 gasCard.GasCardName = CGasCard.GasCardName;
                 gasCard.GasCardNum  = CGasCard.GasCardNum;
                 gasCard.GasCardPin  = CGasCard.GasCardPin;
                 gasCard.StatusId    = statusId;
                 //add
                 transportationContext.GasCards.Add(gasCard);
                 //save
                 transportationContext.SaveChanges();
                 return(RedirectToAction("Index"));
             }
             return(new HttpStatusCodeResult(Response.StatusCode = 400));
         }
         catch
         {
             return(new HttpStatusCodeResult(Response.StatusCode = 400));
         }
     }
     return(View());
 }
コード例 #4
0
 public ActionResult DeleteUser(int?id, User Trash)
 {
     try
     {
         User user = new User();
         if (ModelState.IsValid)
         {
             if (id == null)
             {
                 return(new HttpStatusCodeResult(Response.StatusCode = 400));
             }
             user = transportationContext.Users.Find(id);
             if (user == null)
             {
                 return(HttpNotFound());
             }
             transportationContext.Users.Remove(user);
             transportationContext.SaveChanges();
         }
         return(View(user));
     }
     catch
     {
         return(View());
     }
 }
コード例 #5
0
        public ActionResult EditUser(User user)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    var departmentId = transportationContext.Departments.Where(d => d.DepartmentName == user.Department.DepartmentName).Select(i => i.DepartmentId).FirstOrDefault();
                    if (departmentId != 0)
                    {
                        user.DepartmentId                       = departmentId;
                        user.Department.DepartmentId            = departmentId;
                        transportationContext.Entry(user).State = System.Data.Entity.EntityState.Modified;
                        transportationContext.SaveChanges();
                    }

                    return(RedirectToAction("Index", "Admin"));
                }
                return(View(user));
            }
            catch
            {
                return(View());
            }
        }
コード例 #6
0
        public ActionResult NewRequest(TransportationRequest_View_DemoForSymposium transRequest)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    // Grabs current logged on user ID as they will be the requester
                    //Note: This Lambda function is using the logged in user as the requester so if html is edited the validation is still correct
                    var RequesterId = transportationContext.Users.Where(u => u.BannerId == _LoggedInUser.userInfo.EmployeeId.Substring(1)).Select(i => i.UserId).FirstOrDefault();

                    if (RequesterId != null)
                    {
                        TransportationRequest newRequest = new TransportationRequest();
                        newRequest.RequesterUserId = RequesterId;
                        newRequest.LeaveDate       = transRequest.LeaveDate.GetValueOrDefault();
                        newRequest.LeaveTime       = transRequest.LeaveTime.GetValueOrDefault();
                        newRequest.ReturnDate      = transRequest.ReturnDate.GetValueOrDefault();
                        newRequest.ReturnTime      = transRequest.ReturnTime.GetValueOrDefault();
                        newRequest.Destination     = transRequest.Destination;
                        newRequest.TripPurpose     = transRequest.TripPurpose;
                        newRequest.NumOfStudents   = transRequest.NumOfStudents.GetValueOrDefault();

                        //Create Empty Int Object
                        var transReqId = new ObjectParameter("TranReqId", typeof(int));
                        //Save Request and Get transportation request Id
                        transportationContext.p_TransReq_Add(newRequest.RequesterUserId, newRequest.LeaveDate, newRequest.LeaveTime, newRequest.ReturnDate, newRequest.ReturnTime, newRequest.Destination, newRequest.TripPurpose, newRequest.NumOfStudents, transReqId);

                        //Save to Driver Group Table
                        DriverGroup driverGroup = new DriverGroup();
                        driverGroup.NeedGasCard    = transRequest.NeedGasCard.GetValueOrDefault();
                        driverGroup.TranRequestId  = Convert.ToInt16(transReqId.Value);
                        driverGroup.UserId         = transRequest.UserId;
                        driverGroup.VehicleAddOnId = transRequest.VehicleAddOnId;
                        driverGroup.VehicleTypeId  = transRequest.VehicleTypeId;

                        //Add new driver associated with request
                        transportationContext.DriverGroups.Add(driverGroup);
                        //save
                        transportationContext.SaveChanges();

                        return(RedirectToAction("RequestConfirmation"));
                    }

                    // Will require a foreach loop to grab all drivers listed on request
                    //var DriverId = transportationContext.Users.Where(u => u.UserId == transRequest.UserId).Select(i => i.UserId).FirstOrDefault();

                    // Will require a foreach loop to grab all passangers listed on the request
                    //var PassangerId = transportationContext.Users.Where(u => u.UserId == transRequest.UserId).Select(i => i.UserId).FirstOrDefault();

                    // Add all drivers to DriverGroup Table
                    //foreach ( /* Driver listed on form (may need to make an array) */)
                    //{
                    //    DriverGroup Driver = new DriverGroup();
                    //    Driver.RequestId = 0/*Transportation Request primary key*/;
                    //    Driver.UserId = transportationContext.Users.Where(u => u.UserId == 0/*Current Driver Id*/).Select(i => i.UserId).FirstOrDefault();
                    //    if (true /*Driver requires a vehicle*/)
                    //    {
                    //        //Driver.VehicleType
                    //    }
                    //    transportationContext.DriverGroups.Add(Driver);
                    //}
                }
                catch
                {
                    return(new HttpStatusCodeResult(Response.StatusCode = 400));
                }
            }
            return(View());
        }