コード例 #1
0
        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 }));
        }
コード例 #2
0
 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"));
 }