public ActionResult SaveOrUpdate(QuestionViewEntities questionEntities)
{
QuestionBL teacherBl = new QuestionBL();
int recordAffected = teacherBl.SaveOrUpdate(questionEntities);
return(Json(recordAffected, JsonRequestBehavior.AllowGet));
}
//public ActionResult GetQuestionPaper()
//{
// QuestionBL topicBL = new QuestionBL();
// int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
// return Json(topicBL.GetQuestionPaper(questionCount), JsonRequestBehavior.AllowGet);
//}
//for GettblSubjectForDrp drp
public void GettblSubjectForDrp()
{
QuestionBL topicBL = new QuestionBL();
List <QuestionEntities> pocoList = new List <QuestionEntities>();
pocoList = topicBL.GettblSubjectForDrp();
List <QuestionEntities> itmasterList = new List <QuestionEntities>();
foreach (QuestionEntities up in pocoList)
{
QuestionEntities unt = new QuestionEntities();
unt.Id = up.Id;
unt.SubjectName = up.SubjectName;
itmasterList.Add(unt);
}
ViewBag.SubjectForDrp = itmasterList.Select(x =>
new SelectListItem()
{
Text = x.SubjectName,
Value = x.Id.ToString()
});
}
public ActionResult PrevQuestion(ExamPaper exam)
{
QuestionBL topicBL = new QuestionBL();
//int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
ExamPaper examPaper = new ExamPaper();
examPaper = (ExamPaper)Session["QuestionPaper"]; //topicBL.GetQuestionPaper(questionCount);
examPaper.QuestionEntities = examPaper.QuestionEntities.OrderBy(o => o.Id).ToList();
int index = examPaper.QuestionEntities.FindIndex(item => item.IsShown);
examPaper.QuestionEntities[index].IsShown = false;
if (index <= examPaper.QuestionEntities.Count - 1 && index > 0)
{
examPaper.QuestionEntities[index - 1].IsShown = true;
examPaper.QuestionEntities[index - 1].HasAlreadyShown = true;
}
if (index == 0)
{
examPaper.QuestionEntities[index].IsShown = true;
examPaper.QuestionEntities[index].HasAlreadyShown = true;
}
// Session.Abandon();
Session["QuestionPaper"] = examPaper;
return(RedirectToAction("QuestionPaper", "Question"));
}
public ActionResult DeleteQuestion(int ID, ref string recordCount)
{
QuestionBL topicBL = new QuestionBL();
int recordaffected = topicBL.DeleteQuestion(ID, ref recordCount);
return(Json(recordaffected, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllQuestion()
{
QuestionBL bl = new QuestionBL();
List <Questions> quesList = bl.GetAllQuestion();
return(Json(quesList, JsonRequestBehavior.AllowGet));
}
public ActionResult QuestionPaper()
{
ExamPaper examPaper = new ExamPaper();
if (Session["QuestionPaper"] == null)
{
QuestionBL topicBL = new QuestionBL();
// i = i + 1;
int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
examPaper = topicBL.GetNextPrevQuestion(1, 1, int.Parse(Session["UserId"].ToString()));
examPaper.QuestionEntities = examPaper.QuestionEntities.OrderBy(o => o.Id).ToList();
examPaper.QuestionEntities[0].IsShown = true;
examPaper.QuestionEntities[0].HasAlreadyShown = true;
examPaper.PageIndex = 1;
examPaper.PageSize = 1;
Session["QuestionPaper"] = examPaper;
}
else
{
examPaper = (ExamPaper)Session["QuestionPaper"];
}
return(View(examPaper));
// return View(examPaper);
}
public void Update(QuestionBL question)
{
BLToDALMapper poMapper = new BLToDALMapper();
Question mappedQuestion = poMapper.MapQuestion(question);
DAL.SDK.Kit.Instance.Questions.UpdateQuestion(mappedQuestion);
}
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 async Task <IHttpActionResult> PutQuestionItem(int id, Question item)
{
QuestionBL bL = new QuestionBL(_context);
if (!id.Equals(item.questionID))
{
return(BadRequest());
}
else if (!bL.QuestionExists(id))
{
var ItemId = await bL.CreateNewQuestion(item);
if (ItemId == null)
{
return(InternalServerError());
}
return(Created(Request.RequestUri, item));
}
var isUpdated = await bL.UpdateQuestion(item);
if (isUpdated == false)
{
return(InternalServerError());
}
return(StatusCode(HttpStatusCode.NoContent));
}
//private int GetQuestionCount(int QuestionCount)
//{
// QuestionBL topicBL = new QuestionBL();
// return topicBL.GetAllQuestion(QuestionCount);
//}
//public JsonResult GetNextQuestion(string pageindex,string pagesize, string radioValue,string quesId)
//{
// ExamPaper examPaper = new ExamPaper();
// QuestionBL topicBL = new QuestionBL();
// if (radioValue != null)
// {
// if(! String.IsNullOrEmpty(quesId))
// if(int.Parse(quesId) > 0 && !String.IsNullOrEmpty(radioValue))
// topicBL.SaveUserAnswer(int.Parse(radioValue), int.Parse(quesId), int.Parse(Session["UserId"].ToString()));
// }
// int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
// examPaper = topicBL.GetNextPrevQuestion(int.Parse(pageindex), int.Parse(pagesize), int.Parse(Session["UserId"].ToString()));
// examPaper.QuestionEntities = examPaper.QuestionEntities.OrderBy(o => o.Id).ToList();
// return Json(examPaper, JsonRequestBehavior.AllowGet);
//}
public ExamPaper GetQuestion(string pageindex, string pagesize, string radioValue, string quesId, string currentTime)
{
ExamPaper examPaper = new ExamPaper();
QuestionBL topicBL = new QuestionBL();
if (radioValue != null && radioValue != String.Empty)
{
if (!String.IsNullOrEmpty(quesId))
{
if (int.Parse(quesId) > 0 && !String.IsNullOrEmpty(radioValue))
{
topicBL.SaveUserAnswer(int.Parse(radioValue), int.Parse(quesId), int.Parse(Session["UserId"].ToString()), currentTime);
}
}
}
else
{
ExamBL examBL = new ExamBL();
examBL.UpdateExamTime(int.Parse(Session["UserId"].ToString()), currentTime);
}
int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
examPaper = topicBL.GetNextPrevQuestion(int.Parse(pageindex), int.Parse(pagesize), int.Parse(Session["UserId"].ToString()));
examPaper.QuestionEntities = examPaper.QuestionEntities.OrderBy(o => o.Id).ToList();
return(examPaper);
}
protected void btnAddQuestion_Click(object sender, EventArgs e)
{
QuestionBl = new QuestionBL();
SetDTO();
Questionid = Convert.ToInt32(QuestionBl.AddQuestion(Questiondto));
Response.Redirect("~/ViewQuestion.aspx?questionid=" + Questionid.ToString());
}
public JsonResult EditQuestion(string questionID)
{
QuestionBL bl = new QuestionBL();
int quesID = Convert.ToInt32(questionID);
Questions questions = bl.EditQuestion(quesID);
return(Json(questions, JsonRequestBehavior.AllowGet));
}
public ActionResult RealExamResult()
{
ResultEntities realexam = new ResultEntities();
QuestionBL question = new QuestionBL();
realexam = question.GetRightAnswerByUserID(int.Parse(Session["UserId"].ToString()));
return(View(realexam));
}
public QuestionBL Get(int id)
{
DALToBLMapper poMapper = new DALToBLMapper();
Question questions = DAL.SDK.Kit.Instance.Questions.GetQuestionById(id);
QuestionBL mappedQuestion = poMapper.MapQuestion(questions);
return(mappedQuestion);
}
public ActionResult MockTestResult()
{
//int x = int.Parse(Session["UserId"].ToString());
List <QuestionAnswerEntities> exam = new List <QuestionAnswerEntities>();
QuestionBL question = new QuestionBL();
exam = question.GetQuestionWithAnswerByUserID(int.Parse(Session["UserId"].ToString()));
return(View(exam));
}
public async Task <IHttpActionResult> PostQuestion(Question item)
{
QuestionBL bL = new QuestionBL(_context);
var ItemId = await bL.CreateNewQuestion(item);
if (ItemId == null)
{
return(InternalServerError());
}
return(Created(String.Format("{0}/{1}", Request.RequestUri, ItemId), item));
}
// Ask Question
public JsonResult PostQuestion(string question, string discription)
{
QuestionBL bl = new QuestionBL();
string res = bl.InsertQuestion(question, discription);
if (res == "1")
{
return(Json("Successfully Inserted!!", JsonRequestBehavior.AllowGet));
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteQuestion(string questionID)
{
QuestionBL bl = new QuestionBL();
int quesID = Convert.ToInt32(questionID);
string res = bl.DeleteQuestion(quesID);
if (res == "1")
{
return(Json("Successfully Deleted!!", JsonRequestBehavior.AllowGet));
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateQuestion(string questionID, string question, string discription)
{
QuestionBL bl = new QuestionBL();
int quesID = Convert.ToInt32(questionID);
string res = bl.UpdateQuestion(quesID, question, discription ?? "");
if (res == "1")
{
return(Json("Successfully Updated!!", JsonRequestBehavior.AllowGet));
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public ActionResult StartTest()
{
// GettblSubjectForDrp();
QuestionBL topicBL = new QuestionBL();
tblConfigBL configBL = new tblConfigBL();
int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
questionCount = int.Parse(configBL.GettblConfigByKeyName("QuestionCount").ConfigValue);
topicBL.GetQuestionPaper(questionCount, int.Parse(Session["UserId"].ToString()));
return(View());
}
private void BindItemsList()
{
questionbl = new QuestionBL();
questions = new List <QuestionDTO>();
questions = questionbl.GetAllQuestion(CurrentPage, 20);
if (questions != null)
{
ViewState["TotalPages"] = questions[1].TotalPage.ToString();
DataListQuestion.DataSource = questions;
DataListQuestion.DataBind();
this.lblPageInfo.Text = "Page " + (CurrentPage) + " of " + questions[1].TotalPage.ToString();
if (CurrentPage - 1 == 0)
{
lbtnPrevious.Enabled = false;
}
else
{
lbtnPrevious.Enabled = true;
}
if (CurrentPage == Convert.ToInt32(ViewState["TotalPages"]))
{
lbtnNext.Enabled = false;
}
else
{
lbtnNext.Enabled = true;
}
if (CurrentPage == 1)
{
lbtnFirst.Enabled = false;
}
else
{
lbtnFirst.Enabled = true;
}
if (CurrentPage == Convert.ToInt32(ViewState["TotalPages"]))
{
lbtnLast.Enabled = false;
}
else
{
lbtnLast.Enabled = true;
}
}
}
public static int UpvoteQuestion()
{
if (userid != -1)
{
QuestionBL wQuestionBl = new QuestionBL();
wQuestionBl.UpvoteQuestion(Questionid);
return(1);
}
else
{
return(0);
}
}
public ActionResult QuestionPaper(FormCollection collection, string command)
{
QuestionBL topicBL = new QuestionBL();
//int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
ExamPaper examPaper = new ExamPaper();
examPaper = (ExamPaper)Session["QuestionPaper"]; //topicBL.GetQuestionPaper(questionCount);
examPaper.QuestionEntities = examPaper.QuestionEntities.OrderBy(o => o.Id).ToList();
// int index = examPaper.QuestionEntities.FindIndex(item => item.IsShown);
int rightAnswerIndex = 0; // examPaper.QuestionEntities[0].AnswerEntities.FindIndex(o => o.ID == int.Parse(collection.AllKeys[0]));
foreach (AnswerEntities item in examPaper.QuestionEntities[0].AnswerEntities)
{
if (collection.AllKeys.Length == 2)
{
if (item.ID == int.Parse(collection.AllKeys[0]))
{
item.IsUserAnswer = 1;
//topicBL.SaveUserAnswer(item.ID, item.IsUserAnswer, int.Parse(Session["UserId"].ToString())); //save userdata
break;
}
}
}
examPaper.QuestionEntities[0].IsShown = false;
if (command == "Next")
{
if (examPaper.PageIndex < int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString()))
{
examPaper.PageIndex += 1;
}
}
else if (command == "Previous")
{
if (examPaper.PageIndex <= int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString()) && examPaper.PageIndex > 1)
{
examPaper.PageIndex -= 1;
}
}
examPaper = topicBL.GetNextPrevQuestion(examPaper.PageIndex, examPaper.PageSize, int.Parse(Session["UserId"].ToString()));
//Session.Abandon();
Session["QuestionPaper"] = examPaper;
return(RedirectToAction("QuestionPaper", "Question"));
}
public async Task <IHttpActionResult> GetAllQuestions()
{
try
{
QuestionBL bL = new QuestionBL(_context);
var results = await bL.GetQuestions();
return(Ok(results));
}
catch (Exception)
{
return(InternalServerError());
}
}
public JsonResult GetFirstQuestion()
{
ExamPaper examPaper = new ExamPaper();
QuestionBL topicBL = new QuestionBL();
// i = i + 1;
int questionCount = int.Parse(ConfigurationManager.AppSettings["QuestionCount"].ToString());
//examPaper = topicBL.GetQuestionPaper(questionCount);
examPaper.QuestionEntities = examPaper.QuestionEntities.OrderBy(o => o.Id).ToList();
examPaper.QuestionEntities[0].IsShown = true;
examPaper.QuestionEntities[0].HasAlreadyShown = true;
Session["QuestionPaper"] = examPaper;
return(Json(examPaper, JsonRequestBehavior.AllowGet));
}
protected void Page_Load(object sender, EventArgs e)
{
GetCookie();
if (Request.QueryString["Questionid"] != null)
{
QuestionBl = new QuestionBL();
Questiondto = new QuestionDTO();
Questionid = Convert.ToInt32(Request.QueryString["Questionid"]);
Questiondto = QuestionBl.GetQuestion(Questionid);
TxtTitle.Text = Questiondto.QTitle.ToString();
TxtDesc.InnerText = Questiondto.QDesc.ToString();
}
}
public async Task <IHttpActionResult> DeleteQuestion(int id)
{
QuestionBL bL = new QuestionBL(_context);
if (!bL.QuestionExists(id))
{
return(NotFound());
}
var result = await bL.DeleteQuestion(id);
if (result == null)
{
return(InternalServerError());
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetQuestionsByWord(string word)
{
try
{
QuestionBL bL = new QuestionBL(_context);
var results = await bL.GetQuestionsByVoca_Word(word);
if (results.Count() == 0)
{
return(NotFound());
}
return(Ok(results));
}
catch (Exception)
{
return(InternalServerError());
}
}
public async Task <IHttpActionResult> GetQuestionById(int id)
{
try
{
QuestionBL bL = new QuestionBL(_context);
var result = await bL.GetQuestionById(id);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
catch (Exception)
{
return(InternalServerError());
}
}
protected void SubmitAns_Click(object sender, EventArgs e)
{
System.Web.Security.MembershipUser user = System.Web.Security.Membership.GetUser();
Question question = new Question();
question.Title = QuestionTitleV.Text;
question.Description = DescriptionV.Text;
question.UserName = user.UserName;
if (System.Web.Security.Roles.IsUserInRole("Admin"))
{
question.IsApproved = true;
}
else
{
question.IsApproved = false;
}
question.CreatedOn = Convert.ToString(DateTime.Now);
question.IsDeleted = false;
QuestionBL.Add(question);
Email email = new Email();
email.to = System.Configuration.ConfigurationManager.AppSettings["Mail"];
email.subject = QuestionTitleV.Text;
email.body = QuestionTitleV.Text + "..............." + System.Web.Security.Membership.GetUser().Email + "................" + DescriptionV.Text + "<br/>" + "http://localhost:4949/WebUI/Admin/Default.aspx";
EmailBL.sendmail(email);
QuestionTitleV.Text = " ";
DescriptionV.Text = " ";
}
internal static bool Insert(QuestionBL questionBL)
{
OnlineExamHelper.Context.sp_OnlineQuestionNewInsertCommand(questionBL.Question, questionBL.Imageurl, questionBL.FK_Answer, questionBL.FK_Category);
return true;
}
internal static bool Update(QuestionBL questionBL)
{
OnlineExamHelper.Context.sp_OnlineQuestionNewUpdateCommand(questionBL.Question, questionBL.FK_Answer, questionBL.FK_Category, questionBL.QuestionId, questionBL.QuestionId);
return true;
}
internal static bool Delete(QuestionBL questionBL)
{
OnlineExamHelper.Context.sp_OnlineQuestionNewDeleteCommand(questionBL.QuestionId);
return true;
}
