public ActionResult SetRatings(int id, double rate) { Mydbcontext db = new Mydbcontext(); Ratings r = new Ratings(); r.Rate = rate; r.Businessid = id; r.Username = Session["Username"].ToString(); db.Ratings.Add(r); db.SaveChanges(); int i = 0; double ratings = 0; var bd = from t in db.Ratings where t.Businessid == id select t; foreach (var t in bd) { ratings += t.Rate; i++; } ratings /= i; ratings = Math.Truncate(ratings * 100) / 100; var details = new BusinessDetails() { Id = id, Overall = ratings }; db.BusinessDetails.Attach(details); db.Entry(details).Property(x => x.Overall).IsModified = true; db.Configuration.ValidateOnSaveEnabled = false; db.SaveChanges(); return(RedirectToAction("Details", "Advertise", new { id = id })); }
public ActionResult Edit(UserDetails details) { if (Session["Username"] != null) { string name = Session["Username"].ToString(); Mydbcontext db = new Mydbcontext(); UserDetails user = db.UserDetails.FirstOrDefault(u => u.Username.Equals(name)); user.Firstname = details.Firstname; user.Lastname = details.Lastname; user.Email = details.Email; user.Password = details.Password; user.ConfirmPassword = details.ConfirmPassword; db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }