public ActionResult DeleteConfirmed(int id)
        {
            StallRequest stallRequest = db.StallRequests.Find(id);

            db.StallRequests.Remove(stallRequest);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: StallRequests/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StallRequest stallRequest = db.StallRequests.Find(id);

            if (stallRequest == null)
            {
                return(HttpNotFound());
            }
            return(View(stallRequest));
        }
        public ActionResult UpdateStatus(int?id, int?Status)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StallRequest stallRequest = db.StallRequests.Find(id);

            if (stallRequest == null)
            {
                return(HttpNotFound());
            }
            stallRequest.RequestStatusId = Status;
            db.SaveChanges();

            return(RedirectToAction("Index"));
        }
        // GET: StallRequests/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StallRequest stallRequest = db.StallRequests.Find(id);

            if (stallRequest == null)
            {
                return(HttpNotFound());
            }
            ViewBag.CreatedBy       = new SelectList(db.AspNetUsers, "Id", "Email", stallRequest.CreatedBy);
            ViewBag.InstituteId     = new SelectList(db.Institutes, "Id", "Institute1");
            ViewBag.RequestStatusId = new SelectList(db.RequestStatus, "Id", "Status", stallRequest.RequestStatusId);
            ViewBag.CategoryId      = new SelectList(db.StallCategories, "Id", "StallType", stallRequest.CategoryId);
            return(View(stallRequest));
        }
 public ActionResult Edit([Bind(Include = "Id,StallName,StallDetails,Logo,RequestStatusId,CategoryId,CreatedBy,CreatedAt,OwnerName,ContactNo,Email,Address,City,Profession,Institute")] StallRequest stallRequest, HttpPostedFileBase Logo)
 {
     if (ModelState.IsValid)
     {
         if (Logo != null && Logo.ContentLength > 0)
         {
             var fileName = Path.GetFileName(Logo.FileName);
             var path     = Path.Combine(Server.MapPath("~/UploadedImages/"), fileName);
             Logo.SaveAs(path);
             stallRequest.Logo = fileName;
         }
         stallRequest.CreatedAt       = DateTime.Now;
         stallRequest.CreatedBy       = User.Identity.GetUserId();
         db.Entry(stallRequest).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.CreatedBy       = new SelectList(db.AspNetUsers, "Id", "Email", stallRequest.CreatedBy);
     ViewBag.InstituteId     = new SelectList(db.Institutes, "Id", "Institute1");
     ViewBag.RequestStatusId = new SelectList(db.RequestStatus, "Id", "Status", stallRequest.RequestStatusId);
     ViewBag.CategoryId      = new SelectList(db.StallCategories, "Id", "StallType", stallRequest.CategoryId);
     return(View(stallRequest));
 }
        public ActionResult Create([Bind(Include = "Id,StallName,StallDetails,Logo,RequestStatusId,CategoryId,CreatedBy,CreatedAt,OwnerName,ContactNo,Email,Address,City,Profession,Institute")] StallRequest stallRequest, HttpPostedFileBase Logo)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    var obj = db.StallRequests.FirstOrDefault(s => s.Email == stallRequest.Email);
                    if (obj != null)
                    {
                        ViewBag.ErrorMessage    = "Email Already Exists!";
                        ViewBag.CreatedBy       = new SelectList(db.AspNetUsers, "Id", "Email", stallRequest.CreatedBy);
                        ViewBag.InstituteId     = new SelectList(db.Institutes, "Id", "Institute1");
                        ViewBag.RequestStatusId = new SelectList(db.RequestStatus, "Id", "Status", stallRequest.RequestStatusId);
                        ViewBag.CategoryId      = new SelectList(db.StallCategories, "Id", "StallType", stallRequest.CategoryId);
                        return(View(stallRequest));
                    }
                    if (Logo != null && Logo.ContentLength > 0)
                    {
                        var fileName = Path.GetFileName(Logo.FileName);
                        var path     = Path.Combine(Server.MapPath("~/UploadedImages/"), fileName);
                        Logo.SaveAs(path);
                        stallRequest.Logo = fileName;
                    }
                    try
                    {
                        stallRequest.RequestStatusId = 1;
                        stallRequest.CreatedAt       = DateTime.Now;
                        stallRequest.CreatedBy       = User.Identity.GetUserId();
                        db.StallRequests.Add(stallRequest);
                        db.SaveChanges();
                        string actionName     = this.ControllerContext.RouteData.Values["action"].ToString();
                        string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
                        return(RedirectToAction("SubmissionResponce", "Home", new { status = "Your stall proposal is successfully registerd with your crdentials,Team SEE Lahore will soon respond you through Email.Stay Connected for Bigest Event of Lahore,See Lahore 2018", url = controllerName + "/" + actionName }));
                    }
                    catch (DbEntityValidationException ex)
                    {
                        string message = "";
                        foreach (var validationErrors in ex.EntityValidationErrors)
                        {
                            foreach (var validationError in validationErrors.ValidationErrors)
                            {
                                message = message + validationError.PropertyName + "  " + validationError.ErrorMessage + "\n\n";
                            }
                        }

                        HomeController.EntityinfoMessage(stallRequest.OwnerName + ": " + message);
                        HomeController.EntitywriteErrorLog(ex);
                        string actionName     = this.ControllerContext.RouteData.Values["action"].ToString();
                        string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
                        return(RedirectToAction("SubmissionResponce", "Home", new { status = "Due to Server overload something went wrong! please try again. Sorry for Inconvenience", url = controllerName + "/" + actionName }));
                    }
                }
                ViewBag.CreatedBy       = new SelectList(db.AspNetUsers, "Id", "Email", stallRequest.CreatedBy);
                ViewBag.InstituteId     = new SelectList(db.Institutes, "Id", "Institute1");
                ViewBag.RequestStatusId = new SelectList(db.RequestStatus, "Id", "Status", stallRequest.RequestStatusId);
                ViewBag.CategoryId      = new SelectList(db.StallCategories, "Id", "StallType", stallRequest.CategoryId);
                return(View(stallRequest));
            }
            catch (Exception ex)
            {
                string actionName     = this.ControllerContext.RouteData.Values["action"].ToString();
                string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
                HomeController.infoMessage(ex.Message);
                HomeController.writeErrorLog(ex);
                return(RedirectToAction("SubmissionResponce", "Home", new { status = "Due to Server overload something went wrong! please try again. Sorry for Inconvenience", url = controllerName + "/" + actionName }));
            }
        }