public ActionResult Create([Bind(Include = "ID,Name,Email,Phone,Message")] Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create([Bind(Include = "ID,Content,UserID,QuestionID,CreatedTime")] Answer answer)
{
if (ModelState.IsValid)
{
db.Answers.Add(answer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(answer));
}
public ActionResult Create(HttpPostedFileBase imageFile, UsersModel model)
{
if (ModelState.IsValid)
{
try
{
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 = new User();
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.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Pick a picture, Please!");
return(View(model));;
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
return(View(model));
}
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;
}
public int Insert(User entity)
{
if (db.Users.Count(x => x.UserName == entity.UserName) > 0)
{
return(-1);
}
else
{
db.Users.Add(entity);
db.SaveChanges();
return(entity.ID);
}
}
public ActionResult QuestionDetail(QuestionViewModel obj)
{
QuestionViewModel question = new QuestionDAO().getQuestionByID(obj.ID);
var session = Session[CommonConstants.USER_SESSION];
if (session == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
if (ModelState.IsValid)
{
int userId = Convert.ToInt32(((UserLogin)session).UserId);
Project3DBContext db = new Project3DBContext();
Answer answer = new Answer();
answer.QuestionID = obj.ID;
answer.Content = obj.AnswerContent;
answer.UserID = userId;
answer.CreatedTime = DateTime.Now;
db.Answers.Add(answer);
db.SaveChanges();
return(RedirectToAction("QuestionDetail", new { id = obj.ID }));
}
else
{
obj.Title = question.Title;
obj.Images = question.Images;
obj.Views = question.Views;
obj.Content = question.Content;
obj.CreatedTime = question.CreatedTime;
return(View("QuestionDetail", obj));
}
}
}
public ActionResult DeleteConfirmed(int id)
{
Question question = db.Questions.Find(id);
db.Questions.Remove(question);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int SendContact(Contact entity)
{
db.Contacts.Add(entity);
db.SaveChanges();
return(entity.ID);
}
