public ActionResult VerficationRequest([Bind(Include = "VerficationID,RequestContent,CompanyID")] VerficationRequest verficationRequest, HttpPostedFileBase[] files) { if (ModelState.IsValid && verficationRequest.CompanyID > 0 && !string.IsNullOrEmpty(verficationRequest.RequestContent)) { var existUser = db.Users.Find(CurrentUser.UserID); if (existUser != null) { var requestExist = db.VerficationRequests.Find(verficationRequest.VerficationID); if (requestExist == null) { verficationRequest.EntryDate = DateTime.Now; verficationRequest.UserID = CurrentUser.UserID; existUser.IsVerfied = false; verficationRequest.VerfiedStatusID = 1; verficationRequest.LastUpdated = DateTime.Now; db.VerficationRequests.Add(verficationRequest); } else { existUser.IsVerfied = false; requestExist.CompanyID = verficationRequest.CompanyID; requestExist.VerfiedStatusID = 1; requestExist.LastUpdated = DateTime.Now; requestExist.RequestContent = verficationRequest.RequestContent; } db.SaveChanges(); AddImages(files, CurrentUser.UserID); db.SaveChanges(); return(RedirectToAction("Index")); } } var companies = db.Companies.Where(x => x.IsActive && !x.IsDeleted && x.ByUserID == CurrentUser.UserID); var existCompQuery = db.VerficationRequests.AsQueryable(); if (verficationRequest.VerficationID > 0) { existCompQuery = existCompQuery.Where(x => x.VerficationID != verficationRequest.VerficationID); } var existsCompanies = existCompQuery.Select(x => x.CompanyID).ToList(); companies = companies.Where(x => !existsCompanies.Contains(x.CompanyID)); ViewBag.Companies = new SelectList(companies, "CompanyID", "CompanyName"); return(View(verficationRequest)); }
public ActionResult AdminVerifyCompany([Bind(Include = "VerficationID,AdminMessage,VerfiedStatusID")] VerficationRequest verficationRequest) { var requestExist = db.VerficationRequests.Find(verficationRequest.VerficationID); if (requestExist == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } requestExist.VerfiedStatusID = verficationRequest.VerfiedStatusID; requestExist.AdminMessage = verficationRequest.AdminMessage; if (requestExist.VerfiedStatusID == 2) { var companyBrokers = db.CompanyBrokers.Where(x => x.CompanyID == requestExist.CompanyID); foreach (var row in companyBrokers) { row.User.IsVerfied = true; } } db.SaveChanges(); return(RedirectToAction("AdminVerificationCompanies")); }