protected void timer1_tick(object sender, EventArgs e)
{
if (0 > DateTime.Compare(DateTime.Now, DateTime.Parse(Session["timeout"].ToString())))
{
lblTimer.Text = string.Format("Time Left: 00:{0}:{1}", ((Int32)DateTime.Parse(Session["timeout"].ToString()).Subtract(DateTime.Now).TotalMinutes).ToString(), ((Int32)DateTime.Parse(Session["timeout"].ToString()).Subtract(DateTime.Now).Seconds).ToString());
}
else
{
int authUserId = Convert.ToInt32(Session["authUserID"]);
int qid = 0;
timer1.Enabled = true;
int sid = Convert.ToInt32(Request.QueryString["sid"]);
var query = (from q in _db.Questions
where q.SubjectId == sid
select new
{
q.QuestionDescription,
q.QuestionId,
q.Ans1,
q.Ans2
,
q.Ans3,
q.Ans4
});
foreach (var item in query)
{
var isAnsExist = _db.UserAnswers.Any(c => c.SubjectId.Equals(sid) && c.QuestionId.Equals(item.QuestionId) && c.UserId.Equals(1));
if (!isAnsExist)
{
qid = item.QuestionId;
break;
}
}
var objUserAnswer = new UserAnswer()
{
SubjectId = sid,
QuestionId = qid,
UserId = authUserId,
UserAns = 0
};
_db.UserAnswers.Add(objUserAnswer);
_db.SaveChanges();
Response.Redirect("UserQuizForm.aspx?sid=" + sid);
}
}
protected void CategoryAddBtn_Click(object sender, EventArgs e)
{
try
{
var checkHasCategoryAlreadyExisted =
_db.Categories.Any(c => c.CategoryName.Equals(CategoryAddTextBox.Text));
if (!checkHasCategoryAlreadyExisted)
{
var categoryAddObj = new Category
{
CategoryName = CategoryAddTextBox.Text
};
_db.Categories.Add(categoryAddObj);
_db.SaveChanges();
CategoryAddSuccessMsgDisplayLabel.Text = "Category has been added successfully";
CatErrorMsgDisplayLabel.Text = "";
}
else
{
CategoryAddSuccessMsgDisplayLabel.Text = "";
CatErrorMsgDisplayLabel.Text = CategoryAddTextBox.Text + " already exist in database";
}
}
catch (Exception exception)
{
CatErrorMsgDisplayLabel.Text = exception.Message;
}
}
protected void BtnQuestionEdit_Click(object sender, EventArgs e)
{
try
{
int qid = Convert.ToInt32(Request.QueryString["qid"]);
var editObj = _db.Questions.Find(qid);
editObj.QuestionDescription = Request.Form["QuestionTextBox"];
editObj.SubjectId = Convert.ToInt32(this.SubjectDropDownList.Text);
editObj.Ans1 = Request.Form["Ans1TextBox"];
editObj.Ans2 = Request.Form["Ans2TextBox"];
editObj.Ans3 = Request.Form["Ans3TextBox"];
editObj.Ans4 = Request.Form["Ans4TextBox"];
editObj.TrueAns = Convert.ToInt32(Request.Form["TrueAnsTextBox"]);
_db.Entry(editObj).State = EntityState.Modified;
_db.SaveChanges();
Response.Redirect("AdminIndex.aspx");
}
catch (Exception exception)
{
}
}
protected void BtnQuestionSubmit_Click(object sender, EventArgs e)
{
if (QuestionTextBox.Text == "")
{
LabelQuestion.Text = "This field required!";
}
if (Ans1TextBox.Text == "")
{
LabelAns1.Text = "This field required!";
}
if (Ans2TextBox.Text == "")
{
LabelAns2.Text = "This field required!";
}
if (Ans3TextBox.Text == "")
{
LabelAns3.Text = "This field required!";
}
if (Ans4TextBox.Text == "")
{
LabelAns4.Text = "This field required!";
}
if (TrueAnsTextBox.Text == "")
{
LabelTrueAns.Text = "This field required!";
}
if (QuestionTextBox.Text != "" && Ans1TextBox.Text != "" && Ans2TextBox.Text != "" && Ans3TextBox.Text != "" && Ans4TextBox.Text != "" && TrueAnsTextBox.Text != "")
{
var subjId = Convert.ToInt32(SubjectDropDownList.Text);
var isQuestionExisted = _db.Questions.Any(q => q.QuestionDescription.Equals(QuestionTextBox.Text) && q.SubjectId.Equals(subjId));
if (!isQuestionExisted)
{
var objQuestion = new Question
{
SubjectId = subjId,
QuestionDescription = QuestionTextBox.Text,
Ans1 = Ans1TextBox.Text,
Ans2 = Ans2TextBox.Text,
Ans3 = Ans3TextBox.Text,
Ans4 = Ans4TextBox.Text,
TrueAns = Convert.ToInt32(TrueAnsTextBox.Text)
};
_db.Questions.Add(objQuestion);
_db.SaveChanges();
Ans1TextBox.Text = "";
Ans2TextBox.Text = "";
Ans3TextBox.Text = "";
Ans4TextBox.Text = "";
QuestionTextBox.Text = "";
TrueAnsTextBox.Text = "";
QuestionAddSuccessLabel.Text = "New question added successfully";
}
else
{
LabelQuestion.Text = "This question already exist.";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
LabelSubjectAddReqMsg.Text = "";
LabelSubjectAddSuccessMsg.Text = "";
SubjectAddTextBox.CssClass = "form-control";
if (Request.QueryString["sid"] != null)
{
var sid = Convert.ToInt32(Request.QueryString["sid"]);
var objSubjectDel = _db.Subjects.Find(sid);
_db.Entry(objSubjectDel).State = EntityState.Deleted;
_db.SaveChanges();
Response.Redirect("AdminIndex.aspx");
}
ExceptionMsgDisplayLabel.Visible = false;
}
catch (Exception exception)
{
ExceptionMsgDisplayLabel.Visible = true;
ExceptionMsgDisplayLabel.Text = exception.Message;
}
}
protected void BtnUserSignup_Click(object sender, EventArgs e)
{
if (UserNameTextBox.Text == "")
{
Label1.Text = "Required!";
}
if (PasswordTextBox.Text == "")
{
Label2.Text = "Required!";
}
if (ConfirmPasswordTextBox.Text == "")
{
Label3.Text = "Required!";
}
if (EmailTextBox.Text == "")
{
Label4.Text = "Required!";
}
if (AddressTextBox.Text == "")
{
Label5.Text = "Required!";
}
if (CountryDropDownList.Text == "")
{
Label6.Text = "Required!";
}
if (PhoneTextBox.Text == "")
{
Label7.Text = "Required!";
}
if (PasswordTextBox.Text != ConfirmPasswordTextBox.Text)
{
Label3.Text = "Password don't match!";
}
if (PhoneTextBox.Text != "" && CountryDropDownList.Text != "" && AddressTextBox.Text != "" && EmailTextBox.Text != "" && ConfirmPasswordTextBox.Text != "" && PasswordTextBox.Text != "" && UserNameTextBox.Text != "")
{
if (PasswordTextBox.Text == ConfirmPasswordTextBox.Text)
{
var isUserAlreadyExist = _db.Users.Any(c => c.Username == UserNameTextBox.Text);
if (!isUserAlreadyExist)
{
var objUser = new User
{
Username = UserNameTextBox.Text,
Password = PasswordTextBox.Text,
Email = EmailTextBox.Text,
Address = AddressTextBox.Text,
Phone = PhoneTextBox.Text,
Country = CountryDropDownList.Text
};
_db.Users.Add(objUser);
_db.SaveChanges();
Response.Redirect("UserLoginForm.aspx");
}
else
{
Label1.Text = "This Username already exist in database!";
}
}
}
}
