public ActionResult Edit(HttpPostedFileBase imageFile, UsersModel model) { if (ModelState.IsValid) { if (imageFile != null) { string fileName = System.IO.Path.GetFileName(imageFile.FileName); string filePath = @"~/Assets/client/images/" + fileName; //Save the Image File in Folder. imageFile.SaveAs(Server.MapPath(filePath)); User user = db.Users.Where(x => x.ID == model.ID) .SingleOrDefault(); user.UserName = model.UserName; user.Password = model.Password; user.Role = model.Role; user.Name = model.Name; user.Age = model.Age; user.Email = model.Email; user.Hospital = model.Hospital; user.Specialize = model.Specialize; user.Experience = model.Experience; user.Images = fileName; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { User user = db.Users.Where(x => x.ID == model.ID) .SingleOrDefault(); user.UserName = model.UserName; user.Password = model.Password; user.Role = model.Role; user.Name = model.Name; user.Age = model.Age; user.Email = model.Email; user.Hospital = model.Hospital; user.Specialize = model.Specialize; user.Experience = model.Experience; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } return(View(model)); }
public ActionResult Edit([Bind(Include = "ID,Content,UserID,QuestionID,CreatedTime")] Answer answer) { if (ModelState.IsValid) { db.Entry(answer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(answer)); }
public ActionResult Edit([Bind(Include = "ID,Name,Email,Phone,Message")] Contact contact) { if (ModelState.IsValid) { db.Entry(contact).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contact)); }
public QuestionViewModel getQuestionByID(int id) { //Object[] param = new SqlParameter[] //{ // new SqlParameter("@id", id) //}; //var model = db.Database.SqlQuery<QuestionViewModel>("selectQuestionByID @id", param).SingleOrDefault(); var model = from a in db.Questions join b in db.Users on a.UserID equals b.ID select new QuestionViewModel() { ID = a.ID, Title = a.Title, Content = a.Content, CreatedTime = a.CreatedTime, Views = a.Views, Likes = a.Likes, UserID = a.UserID, Anonymous = a.Anonymous, Name = b.Name, Images = b.Images }; var model1 = db.Questions.SingleOrDefault(x => x.ID == id); model1.Views++; db.Entry(model1).State = EntityState.Modified; db.SaveChanges(); return(model.SingleOrDefault(x => x.ID == id)); //var model = from a in db.Questions // join b in db.Users on a.UserID equals b.ID // select new QuestionViewModel() // { // ID = a.ID, // Title = a.Title, // Content = a.Content, // CreatedTime = a.CreatedTime, // Views = a.Views, // Likes = a.Likes, // UserID = a.UserID, // Name = b.Name, // Images = b.Images // }; //var model1 = model.SingleOrDefault(x => x.ID == id); //model1.Views++; //db.Entry(model1).State = EntityState.Modified; //db.SaveChanges(); //return model1; }