public async Task <ActionResult> AddReview(AddReviewViewModel model) { try { if (model != null) { using (ExploreDbContext context = new ExploreDbContext()) { // Add the review to database ReviewModel newReview = new ReviewModel(); newReview.createddate = DateTime.Now; newReview.dislikes = 0; newReview.likes = 0; newReview.overallrating = model.rating; newReview.id = Convert.ToString(Guid.NewGuid()); newReview.reviewmessage = model.review; newReview.PositionId = model.id; newReview.UserId = User.Identity.GetUserId(); context.AddReviewModel(newReview); await context.SaveChangesAsync(); } } } catch (Exception) { throw; } return(RedirectToActionPermanent("Index", new { id = model.id }) ); }
public async Task <ActionResult> LikeReview(string id) { if (id == null) { return(Json(null)); } try { id = id.Trim(); using (ExploreDbContext dbContext = new ExploreDbContext()) { var review = dbContext.Review.Where(x => x.id == id).FirstOrDefault(); if (review != null) { review.likes++; await dbContext.SaveChangesAsync(); } } } catch (Exception) { throw; } return(Json("success", JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Index(string id = null) { if (id == null) { ViewBag.Title = "No details found"; return(RedirectToActionPermanent("Index", "Explore", new { })); } PositionModel viewModel = null; var userManager = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>(); using (ExploreDbContext context = new ExploreDbContext()) { viewModel = context.Position.Where(x => x.id == id).FirstOrDefault(); viewModel.company = context.Company.Where(x => x.id == viewModel.companyid).FirstOrDefault(); List <ReviewModel> reviews = null; var searchString = Request.Form["searchMessage"]; if (string.IsNullOrWhiteSpace(searchString)) { reviews = context.Review.Where(x => x.PositionId == id).ToList(); } else { reviews = context.Review.Where(x => x.PositionId == id && x.reviewmessage.Contains(searchString)).ToList(); } foreach (var review in reviews) { review.Owner = await userManager.FindByIdAsync(review.UserId); } } return(View(viewModel)); }
public ActionResult Delete(string id) { using (ExploreDbContext dbContext = new ExploreDbContext()) { var model = dbContext.Company.Where(x => x.id == id).FirstOrDefault(); return(View(model)); } }
// GET: Admin public ActionResult Index() { using (ExploreDbContext dbContext = new ExploreDbContext()) { IEnumerable <CompanyModel> viewModel = dbContext.Company.ToList(); return(View(viewModel)); } }
public ActionResult Create(CompanyModel model) { using (ExploreDbContext dbContext = new ExploreDbContext()) { dbContext.Company.Add(model); dbContext.SaveChanges(); } return(View("Index")); }
public ActionResult Delete(CompanyModel model) { using (ExploreDbContext dbContext = new ExploreDbContext()) { if (model != null) { dbContext.Company.Remove(model); } } return(RedirectToAction("Index")); }
public ActionResult AddCompanyReview(CompanyViewModel companyModel) { try { //Get the Database Context ExploreDbContext dbContext = new ExploreDbContext(); // Create Company CompanyModel newCompany = new CompanyModel() { companyname = companyModel.CompanyName, location = companyModel.Lat + "," + companyModel.Long, overallrating = companyModel.rating, id = Guid.NewGuid().ToString() }; newCompany = dbContext.Company.Add(newCompany); // Create Job Position PositionModel newPosition = new PositionModel() { id = Guid.NewGuid().ToString(),companyid = newCompany.id, overallrating = companyModel.rating, positionname = companyModel.PositionName }; newPosition = dbContext.AddPositionModel(newPosition); //Create Job Review ReviewModel newReview = new ReviewModel() { id = Guid.NewGuid().ToString(), createddate = DateTime.Now,dislikes = 0, likes=0, reviewmessage = companyModel.review, overallrating = companyModel.rating,UserId = User.Identity.GetUserId(), PositionId = newPosition.id,totalreview = 1 }; newReview = dbContext.AddReviewModel(newReview); dbContext.SaveChanges(); } catch (Exception ex) { //Suppress Exception } return RedirectToActionPermanent("Index"); }
public ActionResult Edit(CompanyModel model) { using (ExploreDbContext dbContext = new ExploreDbContext()) { CompanyModel editModel = dbContext.Company.Where(x => x.id == model.id).FirstOrDefault(); if (editModel != null) { editModel.description = model.description; editModel.companyname = model.companyname; editModel.address = model.address; editModel.location = model.location; editModel.logourl = model.logourl; editModel.website = model.website; dbContext.SaveChanges(); } } return(RedirectToAction("Index")); }
public ActionResult Index(string searchstring = null) { //Create the Data Context Class ExploreDbContext dbContext = new ExploreDbContext(); // Get the Top 10 Companies List<CompanyModel> companiesModel = null; if (searchstring == null && dbContext.Company.Count() > 0) { companiesModel = dbContext.Company.Take(10).ToList(); } else companiesModel = dbContext.Company.Where(x => x.companyname.Contains(searchstring)).ToList(); return View(companiesModel); }
public async Task <ActionResult> AddReview(CompanyViewModel model) { try { if (model != null) { ExploreDbContext dbContext = new ExploreDbContext(); // Create Job Position PositionModel jobPosition = new PositionModel(); jobPosition.companyid = model.id; // Associate the Company for the position jobPosition.id = Convert.ToString(Guid.NewGuid()); jobPosition.overallrating = model.rating; jobPosition.positionname = model.PositionName; jobPosition.totalrevies = 1; dbContext.AddPositionModel(jobPosition); ReviewModel reviewMessage = new ReviewModel(); reviewMessage.id = Convert.ToString(Guid.NewGuid()); reviewMessage.PositionId = jobPosition.id; reviewMessage.createddate = DateTime.Now; reviewMessage.likes = 0; reviewMessage.dislikes = 0; reviewMessage.reviewmessage = model.review; reviewMessage.UserId = User.Identity.GetUserId(); dbContext.AddReviewModel(reviewMessage); await dbContext.SaveChangesAsync(); } } catch (Exception ex) { throw; } return(RedirectToActionPermanent("Index", new { id = model.id })); }
// GET: Company public ActionResult Index(string id) { if (id == null) { ViewBag.Title = "No details found"; return(RedirectToActionPermanent("Index", "Explore", new object { })); } else { //Retrieve the Company from Database CompanyModel getCompany = null; using (ExploreDbContext context = new ExploreDbContext()) { getCompany = context.Company.Where(x => x.id.Equals(id)).FirstOrDefault(); //Get the Relevant Job Positions IList <PositionModel> companyPositions = context.Position.Where(x => x.companyid == id).ToList(); getCompany.Positions = companyPositions != null ? companyPositions : new List <PositionModel>(); } return(View(getCompany)); } }
public RatingAggregator(ExploreDbContext dbContext) { this._dbContext = dbContext; }