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