public UserQuestion MapUserQuestion(UserQuestionDTO q)
{
return(new UserQuestion
{
QuestionText = q.QuestionText,
Email = q.Email,
Name = q.Name
});
}
public bool Create(UserQuestionDTO userQuestion)
{
try
{
var data = MapperProfile.MapperConfig().Map <UserQuestionDTO, UserQuestion>(userQuestion);
_unitOfWork.UserQuestionRepository.Create(data);
return(_unitOfWork.Commit());
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public ActionResult CreateQuestion(UserQuestionDTO userQuestion)
{
if (!ModelState.IsValid)
{
return(Redirect("/"));
}
userQuestion.QuesDateCreate = DateTime.Now;
userQuestion.QuesNew = true;
if (new UserQuestionDao(_provider).Create(userQuestion))
{
TempData[MessageConst.SUCCESS] = "Send question successfully!";
return(RedirectToAction("Contact"));
}
return(Redirect("/"));
}
public static UserQuestionDTO GetQuestionById(int id)
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
UserQuestionDTO question = new UserQuestionDTO();
db.Questions.ToList().ForEach(x =>
{
if (x.QuestionId == id)
{
question = Convertion.QuestionConvertion.ConvertToUserQuestionDTO(x);
}
});
return(question);
}
}
public bool CreateQuestion(UserQuestionDTO q)
{
var question = MapUserQuestion(q);
try
{
_context.UserQuestion.Add(question);
_context.SaveChanges();
return(true);
}
catch (Exception e)
{
System.Console.WriteLine(e);
return(false);
}
}
public static UserQuestionDTO ConvertToUserQuestionDTO(Questions question)
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
UserQuestionDTO userQuestion = new UserQuestionDTO();
userQuestion.OuestionTitle = question.OuestionTitle;
userQuestion.QuestionId = question.QuestionId;
userQuestion.QuestionContent = question.QuestionContent;
userQuestion.QuestionDate = question.QuestionDate;
userQuestion.QuestionView = question.QuestionView;
userQuestion.ProffestionName = (db.Proffestions.FirstOrDefault(p => p.ProffestionId == question.ProffestionId)).ProffestionName;
User user = db.User.FirstOrDefault(u => u.UserId == question.UserId);
userQuestion.UserKind = user.UserKind;
userQuestion.UserMail = user.UserMail;
userQuestion.UserName = user.UserName;
userQuestion.UserId = user.UserId;
return(userQuestion);
}
}
//method answer question
public ActionResult AnswerQuestion(UserQuestionDTO u)
{
try
{
if (ModelState.IsValid)
{
var senderEmail = new MailAddress("*****@*****.**", "NGO");
var receiverEmail = new MailAddress(u.UserMail, u.UserName);
var password = "******";
var sub = "NGO support";
var body = u.AnswerContent;
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 25,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(senderEmail.Address, password)
};
using (var mess = new MailMessage(senderEmail, receiverEmail)
{
Subject = sub,
Body = body
})
{
smtp.Send(mess);
}
TempData[MessageConst.SUCCESS] = "Send mail to " + u.UserMail + " is successful!";
new UserQuestionDao(_unitOfWork).InsertAns(u.ID, u.AnswerContent);
}
}
catch (Exception e)
{
TempData["error"] = "Something went wrong. Please try again!";
Console.WriteLine(e.Message);
}
return(RedirectToAction("QuesDetail", new { id = u.ID }));
}
public bool SubmitUserQuestion(UserQuestionDTO q)
{
return(_repo.CreateQuestion(q));
}
