public async Task <IHttpActionResult> PutAnswerItem(int id, Answer item)
{
AnswerBL bL = new AnswerBL(_context);
if (!id.Equals(item.answerID))
{
return(BadRequest());
}
else if (!bL.AnswerExists(id))
{
var ItemId = await bL.CreateNewAnswer(item);
if (ItemId == null)
{
return(InternalServerError());
}
return(Created(Request.RequestUri, item));
}
var isUpdated = await bL.UpdateAnswer(item);
if (isUpdated == false)
{
return(InternalServerError());
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void Page_Load(object sender, EventArgs e)
{
GetCookie();
if (Request.QueryString["Questionid"] != null)
{
Questionid = Convert.ToInt32(Request.QueryString["Questionid"]);
QuestionBl = new QuestionBL();
Questiondto = new QuestionDTO();
AnswerBl = new AnswerBL();
lstAnswer = new List <AnswerDTO>();
Questiondto = QuestionBl.GetQuestion(Questionid);
LblQTitle.Text = Questiondto.QTitle.ToString();
ltrldesc.Text = Questiondto.QDesc.ToString();
LblQRate.Text = Questiondto.Rate.ToString();
lstAnswer = AnswerBl.GetAnswer(Questionid);
DatalistAnswer.DataSource = lstAnswer;
DatalistAnswer.DataBind();
}
Questionid = Convert.ToInt32(Request.QueryString["Questionid"].ToString());
}
public ActionResult InsertAnswer(AnswerBL answer)
{
try
{
answer.HTMLRep = TrueEditor.GenerateHTML(answer.Body);
if (BaseMVC.getUserId() != 0)
{
answer.IdUser = BaseMVC.getUserId();
}
else if (answer.AnonymousEmail == null || answer.AnonymousName == null)
{
return(Json(new { success = false, annonymousCredentials = false }));
}
var newUserId = KitBL.Instance.Answers.Insert(answer);
if (newUserId > 0)
{
UserBL user = new UserBL();
user.Id = newUserId;
user.UserType = UserTypeBL.Prospect;
user.FirstName = user.LastName = UserTypeBL.Member.ToString();
BaseMVC.setUser(user);
return(Json(new { success = true, newUser = true }));
}
return(Json(new { success = true }));
}
catch
{
return(Json(new { success = false }));
}
}
public async Task <IHttpActionResult> PostAnswer(Answer item)
{
AnswerBL bL = new AnswerBL(_context);
var ItemId = await bL.CreateNewAnswer(item);
if (ItemId == null)
{
return(InternalServerError());
}
return(Created(String.Format("{0}/{1}", Request.RequestUri, ItemId), item));
}
/// <summary>
/// Binds data to the page.
/// </summary>
/// <param name="topicID"></param>
private void BindQuestions()
{
LessonBL lessonBL = new LessonBL();
DataTable table = lessonBL.GetLesson(LessonID);
lblLessonTitle.Text = table.Rows[0].Field <string>("Title");
AnswerBL answerBL = new AnswerBL();
// Check that the number of questions are 5 before binding to labels.
if (Questions.Rows.Count == 5)
{
lblViewQ0.Text = Questions.Rows[0].Field <string>("Question");
ViewState["Q0"] = Questions.Rows[0].Field <int>("TopicID");
// Get the question answer and distractors.
chkQuizList0.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[0].Field <int>("QuestionID"));
chkQuizList0.DataTextField = "Text";
chkQuizList0.DataValueField = "Correct";
chkQuizList0.DataBind();
lblViewQ1.Text = Questions.Rows[1].Field <string>("Question");
ViewState["Q1"] = Questions.Rows[1].Field <int>("TopicID");
chkQuizList1.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[1].Field <int>("QuestionID"));
chkQuizList1.DataTextField = "Text";
chkQuizList1.DataValueField = "Correct";
chkQuizList1.DataBind();
lblViewQ2.Text = Questions.Rows[2].Field <string>("Question");
ViewState["Q2"] = Questions.Rows[2].Field <int>("TopicID");
chkQuizList2.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[2].Field <int>("QuestionID"));
chkQuizList2.DataTextField = "Text";
chkQuizList2.DataValueField = "Correct";
chkQuizList2.DataBind();
lblViewQ3.Text = Questions.Rows[3].Field <string>("Question");
ViewState["Q3"] = Questions.Rows[3].Field <int>("TopicID");
chkQuizList3.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[3].Field <int>("QuestionID"));
chkQuizList3.DataTextField = "Text";
chkQuizList3.DataValueField = "Correct";
chkQuizList3.DataBind();
lblViewQ4.Text = Questions.Rows[4].Field <string>("Question");
ViewState["Q4"] = Questions.Rows[4].Field <int>("TopicID");
chkQuizList4.DataSource = answerBL.GetAnswersByQuestionID(Questions.Rows[4].Field <int>("QuestionID"));
chkQuizList4.DataTextField = "Text";
chkQuizList4.DataValueField = "Correct";
chkQuizList4.DataBind();
}
}
private void ABindItemsList()
{
answerbl = new AnswerBL();
questions = answerbl.GetUserAnsweredQuestion(userid, ACurrentPage, 5);
if (questions != null)
{
ViewState["ATotalPages"] = questions[1].TotalPage.ToString();
datlstAnswer.DataSource = questions;
datlstAnswer.DataBind();
this.AlblPageInfo.Text = "Page " + (ACurrentPage) + " of " + questions[1].TotalPage.ToString();
if (ACurrentPage - 1 == 0)
{
AlbtnPrevious.Enabled = false;
}
else
{
AlbtnPrevious.Enabled = true;
}
if (ACurrentPage == Convert.ToInt32(ViewState["ATotalPages"]))
{
AlbtnNext.Enabled = false;
}
else
{
AlbtnNext.Enabled = true;
}
if (CurrentPage == 1)
{
AlbtnFirst.Enabled = false;
}
else
{
AlbtnFirst.Enabled = true;
}
if (ACurrentPage == Convert.ToInt32(ViewState["ATotalPages"]))
{
AlbtnLast.Enabled = false;
}
else
{
AlbtnLast.Enabled = true;
}
}
}
public static int DownvoteAnswer(int answerid)
{
if (userid != -1)
{
AnswerBL wQuestionBl = new AnswerBL();
wQuestionBl.DownvoteAnswer(answerid);
return(1);
}
else
{
return(0);
}
}
public static int UpvoteAnswer(string answerid)
{
if (userid != -1)
{
AnswerBL wQuestionBl = new AnswerBL();
wQuestionBl.UpvoteAnswer(Convert.ToInt32(answerid));
return(1);
}
else
{
return(0);
}
}
public async Task <IHttpActionResult> GetAllQuestions()
{
try
{
AnswerBL bL = new AnswerBL(_context);
var results = await bL.GetAnswers();
return(Ok(results));
}
catch (Exception)
{
return(InternalServerError());
}
}
protected void btnPostAnswer_Click(object sender, EventArgs e)
{
if (cookie != null)
{
SetDTO();
AnswerBl = new AnswerBL();
AnswerBl.AddAnswer(Answerdto);
TxtDesc.InnerText = "";
Response.Redirect("~/ViewQuestion.aspx?questionid=" + Questionid.ToString());
}
else
{
Response.Redirect("~/Login.aspx");
}
}
public async Task <IHttpActionResult> DeleteAnwser(int id)
{
AnswerBL bL = new AnswerBL(_context);
if (!bL.AnswerExists(id))
{
return(NotFound());
}
var result = await bL.DeleteAnswer(id);
if (result == null)
{
return(InternalServerError());
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetQuestionById(int id)
{
try
{
AnswerBL bL = new AnswerBL(_context);
var result = await bL.GetAnswerById(id);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
public async Task <IHttpActionResult> GetQuestionsByWord(int id)
{
try
{
AnswerBL bL = new AnswerBL(_context);
var results = await bL.GetQuestionsByQuestion_Id(id);
if (results.Count() == 0)
{
return(NotFound());
}
return(Ok(results));
}
catch (Exception)
{
return(InternalServerError());
}
}
public int Insert(AnswerBL answer)
{
var insertNewUser = 0;
BLToDALMapper poMapper = new BLToDALMapper();
Answer mappedAnswer = poMapper.MapAnswer(answer);
if (mappedAnswer.IdUser == 0 && (mappedAnswer.AnonymousEmail != "" || mappedAnswer.AnonymousName != ""))
{
mappedAnswer.IdUser = DAL.SDK.Kit.Instance.Users.Insert(new User
{
Email = mappedAnswer.AnonymousEmail,
FirstName = mappedAnswer.AnonymousName,
LastName = "Guest",
Flags = UserFlags.NotConfirmed,
JoinDate = DateTime.Now,
UserType = UserType.Prospect,
PasswordHashed = "password"
});
insertNewUser = mappedAnswer.IdUser;
if (mappedAnswer.IdUser == 0)
{
mappedAnswer.IdUser = 6;
}
else
{
mappedAnswer.Flags = DAL.Entities.AnswerFlags.NotConfirmed;
}
}
mappedAnswer.CreatedDate = DateTime.Now;
//insert answer
var answerId = DAL.SDK.Kit.Instance.Answers.Insert(mappedAnswer);
//send email
var question = DAL.SDK.Kit.Instance.Questions.GetQuestionById(answer.IdQuestion);
var user = DAL.SDK.Kit.Instance.Users.GetUserById(question.IdUser);
Softvision.BL.Services.SMTP.sendEmail("*****@*****.**", user.Email, "New answer to your question! ", user.FirstName + ", you have a new answer on on your question");
return(insertNewUser);
}
public int DownvoteAnswer(int AnswerId)
{
answerbl = new AnswerBL();
return(answerbl.DownvoteAnswer(AnswerId));
}
public int UpvoteAnswer(int AnswerId)
{
answerbl = new AnswerBL();
return(answerbl.UpvoteAnswer(AnswerId));
}
public Answer MapAnswer(AnswerBL answer)
{
return(Mapper.Map <AnswerBL, Answer>(answer));
}
/// <summary>
/// Retrieves the answers of a question.
/// </summary>
/// <param name="questionID"></param>
/// <returns></returns>
private DataTable GetAnswers(int questionID)
{
AnswerBL answerBL = new AnswerBL();
return(answerBL.GetAnswersByQuestionID(questionID));
}
