public void MyBtnHandler(Object sender, EventArgs e)
{
selectedQuestionPanel.Visible = true;
int favQueListID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
Button btn = (Button)sender;
selectedQuestionPanel.Visible = true;
selectedQuestionStatment.Text = btn.CommandName.ToString();
int quesID = Int32.Parse(btn.CommandArgument);
QueDao queDaoObj = new QueDao();
List <FavListQueScore> favQueDetailList = queDaoObj.getQuestionDetailsByQuesIDAndAssessmentID(favQueListID, quesID);
int sum = 0;
foreach (FavListQueScore queScore in favQueDetailList)
{
sum += queScore.sumScoreValue;
}
Label4.Text = sum.ToString();
selectedQuestionDetailsView.DataSource = favQueDetailList;
selectedQuestionDetailsView.DataBind();
AjaxControlToolkit.ModalPopupExtender ModalPopupExtender =
this.Page.FindControl("ctl00$MainContent$MsgBoxModalPopupExtender") as AjaxControlToolkit.ModalPopupExtender;
UpdatePanel UpdatePanel = this.Page.FindControl("ctl00$MainContent$UpdatePanelMsgBox") as UpdatePanel;
UpdatePanel.Update();
ModalPopupExtender.Show();
}
private void LoadCLOList()
{
QueDao queDaoObj = new QueDao();
List <KMSABET.MyPocos.AppCLO> quesList = queDaoObj.getCLOList();
CLOListGridView.DataSource = quesList;
CLOListGridView.DataBind();
}
private void LoadList(String courseID)
{
QueDao queDaoObj = new QueDao();
List <QueQuestion> quesList = queDaoObj.getQuestionList(courseID);
attributeListTag.DataSource = quesList;
attributeListTag.DataBind();
}
private void LoadSOList()
{
QueDao queDaoObj = new QueDao();
List <KMSABET.MyPocos.AppSO> quesList = queDaoObj.getSOList();
SO_GridView1.DataSource = quesList;
SO_GridView1.DataBind();
}
private void LoadCourseTopicList()
{
QueDao queDaoObj = new QueDao();
List <KMSABET.MyPocos.AppCourseTopic> quesList = queDaoObj.getCourseTopicList();
courseTopicListTag.DataSource = quesList;
courseTopicListTag.DataBind();
}
private void LoadAttributeOptionsList()
{
QueDao queDaoObj = new QueDao();
List <KMSABET.MyPocos.QueAttributeOption> quesList = queDaoObj.getAttributeOptionsList();
AttributeOptionsGridView1.DataSource = quesList;
AttributeOptionsGridView1.DataBind();
}
private void LoadList()
{
QueDao queDaoObj = new QueDao();
String courseIdLocal = Session["CourseID"].ToString();
List <QueAttribute> attrList = queDaoObj.getAttrbuteList(courseIdLocal);
attributeListTag.DataSource = attrList;
attributeListTag.DataBind();
}
void display(List <QueAttribute> attr, int size, QueQuestion que, SqlConnection myConnection)
{
int count = 0, i = 0, j = 0, max = 1;
for (i = 0; i < size; i++)
{
max = max * attr[i].optionsList.Count;
}
List <int> attr_decsn = new List <int>();
for (int l = 0; l < size; l++)
{
attr_decsn.Add(0);
}
while (max > count++)
{
for (int z = 0; z <= size - 1; z++)
{
if (attr_decsn[z] == attr[z].optionsList.Count)
{
attr_decsn[z] = 0;
attr_decsn[z + 1]++;
}
que.attrOptionIds.Add(attr[z].optionsList[attr_decsn[z]].attributeOptionId);
//LogUtils.myLog.Info(attr[z].optionsList[attr_decsn[z]].optionStatement);
}
attr_decsn[0]++;
QueDao queDaoObj = new QueDao();
//LogUtils.myLog.Info("Going to print new questions");
for (int iter = 0; iter < Int32.Parse(numberQuestions.Text); iter++)
{
totalQuesCount++;
que.questionStatement = "Dummy Question " + totalQuesCount + " " + DateTime.Now.ToString()
+ " System Generated.";
String query = queDaoObj.insertQuestion(que);
try
{
SqlCommand myCommand = new SqlCommand(query, myConnection);
//LogUtils.myLog.Info(query);
myCommand.ExecuteNonQuery();
//LogUtils.myLog.Info("After inserting into DB. Total Questions : " + totalQuesCount);
}
catch (Exception e)
{
LogUtils.myLog.Debug(e.ToString(), e);
}
}
que.attrOptionIds = new List <int>();
}
}
private void LoadList(String courseId)
{
QueDao queDaoObj = new QueDao();
List <KMSABET.MyPocos.QueFavQuestionList> quesList = new List <MyPocos.QueFavQuestionList>();
if (Session["InstructorID"] == null || Session["userTypeId"].ToString().Equals("1"))
{
quesList = queDaoObj.getFavQuestionList(courseId);
}
else
{
quesList = queDaoObj.getFavQuestionList(courseId, Session["InstructorID"].ToString());
}
attributeListTag.DataSource = quesList;
attributeListTag.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int favQueListID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
if (favQueListID != 0)
{
bool deleteMode = Request.QueryString["delete"] == null ? false : bool.Parse(Request.QueryString["delete"]);
if (deleteMode)
{
DBUtils dbUtilsObj = new DBUtils();
String deleteQuery
= "delete from Q_Favorite_List_has_Q_Question "
+ " where Q_Favorite_List_favorite_list_id =" + favQueListID;
dbUtilsObj.CUDOperations(deleteQuery);
deleteQuery
= "DELETE FROM Q_FAVORITE_LIST_QUESTION_SCORE WHERE FAVORITE_LIST_ID = " + favQueListID;
dbUtilsObj.CUDOperations(deleteQuery);
String updateQuery
= "delete from Q_Favorite_List "
+ " where favorite_list_id = " + favQueListID;
dbUtilsObj.CUDOperations(updateQuery);
Response.Redirect("~/KMSPages/QueFavQuestionList.aspx");
}
QueDao queDaoObj = new QueDao();
MyPocos.QueFavQuestionList favList = queDaoObj.getFavQuestionListByID(favQueListID);
favListName1.Text = favList.favQuestionName;
questionList = queDaoObj.getQuestionListByFavID(favQueListID);
questionsListSelectedTag.DataSource = questionList;
questionsListSelectedTag.DataBind();
}
}
}
public void setEditData()
{
int favQueListID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
if (favQueListID != 0)
{
QueDao queDaoObj = new QueDao();
MyPocos.QueFavQuestionList favList = queDaoObj.getFavQuestionListByID(favQueListID);
questionList = queDaoObj.getQuestionListByFavID(favQueListID);
ViewState["selectedQuestionList"] = questionList;
favListName.Text = favList.favQuestionName;
questionsListSelectedTag.DataSource = questionList;
questionsListSelectedTag.DataBind();
favListName2.Text = favList.favQuestionName;
questionsListSelectedTag2.DataSource = questionList;
questionsListSelectedTag2.DataBind();
Wizard1.ActiveStepIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
QueDao queDaoObj = new QueDao();
if (Page.IsPostBack == false)
{
fillRelevanceScore(scoreTxtBx1, true);
fillRelevanceScore(TextBox1, true);
fillRelevanceScore(TextBox2, true);
fillCLODropDown(Session["CourseID"].ToString());
if (DropDownList3.SelectedItem != null)
{
fillSODropDown(DropDownList3.SelectedItem.Value);
fillCourseTopicDropDownByCloId(DropDownList3.SelectedItem.Value);
}
String value = ClientQueryString;
String[] valueArr = value.Split('=', '&');
if (valueArr.Count() > 1)
{
int inputId = Int32.Parse(valueArr[1]);
bool deleteMode = valueArr[7] == "true" ? true : false;
bool viewMode = valueArr[3] == "true" ? true : false;
bool editMode = valueArr[5] == "true" ? true : false;
if (deleteMode)
{
deleteQuestion(inputId);
}
this.Title = viewMode ? "View a Question" : "Update a Question";
ViewState["viewMode"] = viewMode;
ViewState["editMode"] = editMode;
ViewState["deleteMode"] = deleteMode;
List <int> idsList = new List <int>();
idsList.Add(inputId);
List <QueQuestion> queObjectTemp = queDaoObj.questionList(idsList);
if (queObjectTemp.Count > 0)
{
QueQuestion queObje = queObjectTemp[0];
quesStmt.Text = queObje.questionStatement;
fillCourseTopicDropDownByCloId(DropDownList3.SelectedItem.Value);
DropDownList5.SelectedValue = queObje.courseTopicId.ToString();
fillCLODropDown(Session["CourseID"].ToString());
DropDownList3.SelectedValue = queObje.cloId.ToString();
fillSODropDown(DropDownList3.SelectedItem.Value);
DropDownList4.SelectedValue = queObje.soId.ToString();
}
List <QueAttributeScore> attScoreList = queDaoObj.getQuestionScoreListByID(inputId);
foreach (QueAttributeScore attSocre in attScoreList)
{
if (attSocre.attributeID == 1301) // CLO
{
TextBox1.SelectedValue = attSocre.scoreValue.ToString();
}
else if (attSocre.attributeID == 1302) // SO
{
TextBox2.SelectedValue = attSocre.scoreValue.ToString();
}
else if (attSocre.attributeID == 1303) // Course Topic
{
scoreTxtBx1.SelectedValue = attSocre.scoreValue.ToString();
}
}
DropDownList5.Enabled = !viewMode;
DropDownList3.Enabled = !viewMode;
DropDownList4.Enabled = !viewMode;
scoreTxtBx1.Enabled = !viewMode;
Button1.Visible = !viewMode;
DataList12.Enabled = !viewMode;
TextBox1.Enabled = !viewMode;
TextBox2.Enabled = !viewMode;
quesStmt.Enabled = !viewMode;
cancelBtn.Text = viewMode ? "Close" : "Cancel";
Button1.Text = editMode ? "Update" : "Submit";
}
else
{
//FirstGridViewRow();
this.Title = "Add a Question";
}
}
String courseIdLocal = Session["CourseID"].ToString();
List <KMSABET.MyPocos.QueAttribute> attributeList = queDaoObj.getAttrbuteList(courseIdLocal);
DataList12.DataSource = attributeList;
DataList12.DataBind();
//MyUtilities.LogUtils.myLog.Info("Selected drop down value is: " + DropDownList1.SelectedValue);
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
int questionID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//Get questionID here
int attributeID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "attributeID"));
int AttributeTypeID = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "attributeTypeID"));
//pass Question ID to your DB and get all available options for the question
//Bind the RadiobUttonList here
RadioButtonList scoreTxtBoxElm = (RadioButtonList)e.Item.FindControl("scoreTxtBx");
HiddenField attributeIDText = (HiddenField)e.Item.FindControl("attributeID");
fillRelevanceScore(scoreTxtBoxElm, false);
//if (AttributeTypeID == 1001)
{
RadioButtonList RadioButtonList1 = (RadioButtonList)e.Item.FindControl("radlstPubs");
List <KMSABET.MyPocos.QueAttributeOption> optionsList = new List <KMSABET.MyPocos.QueAttributeOption>();
Boolean isRelevanceApplicable = false;
DBUtils dbUtils = new DBUtils();
String query = "SELECT * FROM Q_Attribute_Options QAO"
+ " JOIN Q_Attribute ON attribute_id = Q_Attribute_attribute_id"
+ " WHERE Q_Attribute_attribute_id = " + attributeID.ToString()
+ " ORDER BY QAO.PRIORITY_OPTION";
SqlDataReader attributeListReader = dbUtils.readOperation(query);
while (attributeListReader.Read())
{
KMSABET.MyPocos.QueAttributeOption optionTemp = new KMSABET.MyPocos.QueAttributeOption();
isRelevanceApplicable = (Boolean)attributeListReader["IS_RELEVANCE_APPLICABLE"];
optionTemp.attributeOptionId = (int)attributeListReader["attribute_option_id"];
optionTemp.optionStatement = attributeListReader["PRIORITY_OPTION"].ToString()
+ " - " + attributeListReader["option_statement"].ToString();
//optionTemp.attributeId = (int)attributeListReader["Q_Attribute_attribute_id"];
optionsList.Add(optionTemp);
}
dbUtils.closeDBConnection();
QueAttributeOption optionIgnoreThis = new QueAttributeOption();
optionIgnoreThis.attributeOptionId = 214748364 + attributeID;
optionIgnoreThis.optionStatement = "Ignore This";
optionsList.Add(optionIgnoreThis);
RadioButtonList1.DataSource = optionsList;
RadioButtonList1.DataTextField = "optionStatement";
RadioButtonList1.DataValueField = "attributeOptionId";
RadioButtonList1.DataBind();
attributeIDText.Value = attributeID.ToString();
if (isRelevanceApplicable == false)
{
Label scoreTxtBoxLabel = (Label)e.Item.FindControl("Label1");
scoreTxtBoxLabel.Visible = false;
scoreTxtBoxElm.Visible = false;
}
Boolean goneInside = false;
if (questionID != 0)
{
QueDao dbUtils1 = new QueDao();
List <QueAttributeOption> attOptions = dbUtils1.getOptionsListByAttributeIDQuestionID(attributeID, questionID);
foreach (QueAttributeOption attOption in attOptions)
{
scoreTxtBoxElm.SelectedValue = attOption.score.ToString();
RadioButtonList1.SelectedValue = attOption.attributeOptionId.ToString();
goneInside = true;
}
}
if (goneInside == false)
{
RadioButtonList1.SelectedValue = optionIgnoreThis.attributeOptionId.ToString();
}
}
/*else if (AttributeTypeID == 1002)
* {
* CheckBoxList CheckBoxList1 = (CheckBoxList)e.Item.FindControl("chkBxList1");
*
* List<KMSABET.MyPocos.QueAttributeOptions> optionsList = new List<KMSABET.MyPocos.QueAttributeOptions>();
*
* DBUtils dbUtils = new DBUtils();
* SqlDataReader attributeListReader = dbUtils.readOperation("SELECT * FROM Q_Attribute_Options"
+ " JOIN Q_Attribute ON attribute_id = Q_Attribute_attribute_id AND attribute_type_id = 1002"
+ " WHERE Q_Attribute_attribute_id = " + attributeID.ToString());
+ while (attributeListReader.Read())
+ {
+ KMSABET.MyPocos.QueAttributeOptions optionTemp = new KMSABET.MyPocos.QueAttributeOptions();
+
+ optionTemp.attributeOptionId = (int)attributeListReader["attribute_option_id"];
+ optionTemp.optionStatement = attributeListReader["option_statement"].ToString();
+ optionTemp.attributeId = (int)attributeListReader["Q_Attribute_attribute_id"];
+ optionsList.Add(optionTemp);
+ }
+ dbUtils.closeDBConnection();
+
+ CheckBoxList1.DataSource = optionsList;
+ CheckBoxList1.DataTextField = "optionStatement";
+ CheckBoxList1.DataValueField = "attributeOptionId";
+ CheckBoxList1.DataBind();
+
+ if (questionID != 0)
+ {
+ QueDao dbUtils1 = new QueDao();
+ List<QueAttributeOptions> attOptions = dbUtils1.getOptionsListByAttributeIDQuestionID(attributeID, questionID);
+ TextBox scoreTxtBoxElm = (TextBox)e.Item.FindControl("scoreTxtBx");
+ foreach (QueAttributeOptions attOption in attOptions)
+ {
+ scoreTxtBoxElm.Text = attOption.scoreValue.ToString();
+ CheckBoxList1.Items.FindByValue(attOption.attributeOptionId.ToString()).Selected = true;
+ }
+ }
+ }*/
}
}
protected void GenerateQuestions(object sender, EventArgs e)
{
LogUtils.myLog.Info(numberQuestions.Text);
String courseId = Session["CourseID"].ToString();
LogUtils.myLog.Info("Session[\"CourseID\"] : " + Session["CourseID"]);
LogUtils.myLog.Info("Before courseId : " + courseId);
if (courseId == null || courseId == "")
{
courseId = "4";
}
LogUtils.myLog.Info("After courseId : " + courseId);
LogUtils.myLog.Info("Button Generate Questions clicked." + DateTime.Now.ToString());
AppDao appDaoObj = new AppDao();
List <AppCourseTopic> topicList = appDaoObj.getCourseTopicList(courseId);
List <AppCLO> CLOList = appDaoObj.getCLOList(courseId);
QueDao queDaoObj = new QueDao();
String courseIdLocal = Session["CourseID"].ToString();
List <QueAttribute> attrList = queDaoObj.getAttrbuteList(courseIdLocal);
foreach (QueAttribute attr in attrList)
{
attr.optionsList = queDaoObj.getAttributeOptionListByAttrID(attr.attributeID.ToString());
}
foreach (AppCLO clo in CLOList)
{
List <AppSO> SOList = appDaoObj.getSOList(clo.cloId.ToString());
clo.soList = SOList;
}
foreach (AppCourseTopic courseTopic in topicList)
{
LogUtils.myLog.Info("Course Topic : " + courseTopic.topic);
foreach (AppCLO clo in CLOList)
{
LogUtils.myLog.Info("CLO : " + clo.cloStatement);
foreach (AppSO so in clo.soList)
{
LogUtils.myLog.Info("SO : " + so.statement);
QueQuestion queDetails = new QueQuestion();
queDetails.cloId = clo.cloId;
queDetails.soId = so.id;
queDetails.courseTopicId = courseTopic.id;
queDetails.courseId = Int32.Parse(courseId);
queDetails.attrOptionIds = new List <int>();
try
{
SqlConnection myConnection = new SqlConnection(MyConstants.DBConnectionString);
//LogUtils.myLog.Info(MyConstants.DBConnectionString);
myConnection.Open();
display(attrList, attrList.Count, queDetails, myConnection);
myConnection.Close();
}
catch (Exception ex)
{
LogUtils.myLog.Debug(e.ToString(), ex);
}
LogUtils.myLog.Info("After inserting questions. Total Questions : " + totalQuesCount);
}
}
}
/*List<QueAttribute> attrList = new List<QueAttribute>();
* QueAttribute attr1 = new QueAttribute();
* attr1.attributeID = 1;
* attr1.attributeStatement = "Time";
* attr1.optionsList = new List<QueAttributeOption>();
* QueAttributeOption o1 = new QueAttributeOption();
* o1.attributeId = 1;
* o1.optionStatement = "5 mins";
* o1.attributeOptionId = 1;
* attr1.optionsList.Add(o1);
*
* QueAttributeOption o2 = new QueAttributeOption();
* o2.attributeId = 1;
* o2.optionStatement = "10 mins";
* o2.attributeOptionId = 2;
* attr1.optionsList.Add(o2);
*
* QueAttributeOption o5 = new QueAttributeOption();
* o5.attributeId = 1;
* o5.optionStatement = "15 mins";
* o5.attributeOptionId = 5;
* attr1.optionsList.Add(o5);
*
* QueAttribute attr2 = new QueAttribute();
* attr2.attributeID = 1;
* attr2.attributeStatement = "Type";
* attr2.optionsList = new List<QueAttributeOption>();
* QueAttributeOption o3 = new QueAttributeOption();
* o3.attributeId = 2;
* o3.optionStatement = "MCQ";
* o3.attributeOptionId = 1;
* attr2.optionsList.Add(o3);
*
* QueAttributeOption o4 = new QueAttributeOption();
* o4.attributeId = 2;
* o4.optionStatement = "FB";
* o4.attributeOptionId = 2;
* attr2.optionsList.Add(o4);
*
* attrList.Add(attr1);
* attrList.Add(attr2);
* display(attrList, attrList.Count);
*/
}
