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;
}
