public int insertInstructor(AppUser appUserObj)
{
DBUtils dbUtilsObj = new DBUtils();
String updateQuery = "INSERT INTO APP_INSTRUCTOR"
+ " (INSTRUCTOR_NAME, EMAIL"
+ ") output inserted.instructor_id"
+ " VALUES ('"
+ appUserObj.fullName
+ "' , '" + appUserObj.email
+ "')";
int instructorId = dbUtilsObj.CUDOperationsScalar(updateQuery);
return(instructorId);
}
protected void Button1_Click(object Source, EventArgs e)
{
//LogUtils.myLog.Info("OptionID : " + DataBinder.Eval(AttributeOptions.Rows[0].DataItem, "attributeID"));
bool editMode = (bool)(ViewState["editMode"] == null ? false : ViewState["editMode"]);
if (editMode)
{
int attributeID = Int32.Parse(Request.QueryString["id"]);
String updateQuery
= "update Q_Attribute"
+ " set attribute_statement = '" + attStmt.Text
+ "', attribute_type_id = " + RadioButtonList1.SelectedValue
+ ", WEIGHTAGE = " + attWeight.Text
+ ", IS_RELEVANCE_APPLICABLE = " + (CheckBoxRelevance.Checked == false ? '0' : '1')
+ " where attribute_id = " + attributeID;
DBUtils dbUtilsObj = new DBUtils();
dbUtilsObj.CUDOperations(updateQuery);
String deleteQuery
= "delete from Q_Attribute_Options"
+ " where Q_Attribute_attribute_id = " + attributeID;
int rowDeleted = dbUtilsObj.CUDOperations(deleteQuery);
btnSave_Click(attributeID);
}
else
{
String insertionQuery
= "INSERT INTO Q_Attribute (ATTRIBUTE_STATEMENT, ATTRIBUTE_TYPE_ID, WEIGHTAGE, COURSE_ID, IS_RELEVANCE_APPLICABLE)"
+ " output inserted.attribute_id"
+ " VALUES ('"
+ attStmt.Text + "','" + RadioButtonList1.SelectedValue
+ "','" + attWeight.Text
+ "','" + Session["courseId"]
+ "', '" + CheckBoxRelevance.Checked
+ "')";
LogUtils.myLog.Info("My Insert Query is: " + insertionQuery);
DBUtils dbUtilsObj = new DBUtils();
int insertedID = dbUtilsObj.CUDOperationsScalar(insertionQuery);
LogUtils.myLog.Info("Inserted ID of Attribute is: " + insertedID);
btnSave_Click(insertedID);
}
Response.Redirect("~/KMSPages/QueAttributeList.aspx");
}
protected void Submit_Button_Click1(object sender, EventArgs e)
{
int questionID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
if (questionID != 0)
{
String updateQuery = "UPDATE Q_Question"
+ " SET App_Instructor_instructor_id = 1"
+ " , App_Course_course_id = " + Session["CourseID"].ToString()
+ " , App_Course_Topic_id = " + DropDownList5.SelectedValue
+ " , App_Clo_id = " + DropDownList3.SelectedValue
+ " , App_So_id = " + DropDownList4.SelectedValue
+ " , question_statement = '" + quesStmt.Text
+ "' ,question_type = 1"
+ " WHERE question_id = " + questionID;
DBUtils dbUtilsObj = new DBUtils();
dbUtilsObj.CUDOperations(updateQuery);
String deleteQuery = "DELETE FROM Q_Question_Attribute_Option WHERE Q_Question_question_id = " + questionID;
dbUtilsObj.CUDOperations(deleteQuery);
deleteQuery = "DELETE FROM Q_QUESTION_SCORE WHERE QUESTION_ID = " + questionID;
dbUtilsObj.CUDOperations(deleteQuery);
}
else
{
String insertionQuery
= "INSERT INTO Q_Question (App_Instructor_instructor_id, App_Course_course_id,"
+ " App_Course_Topic_id,"
+ " App_Clo_id, App_So_id, question_statement, question_type) "
+ " output inserted.question_id"
+ " VALUES (1," + Session["CourseID"].ToString() + ","
+ DropDownList5.SelectedValue + "," + DropDownList3.SelectedValue + ","
+ DropDownList4.SelectedValue + "," + "'" + quesStmt.Text + "',1)";
//LogUtils.myLog.Info("My Insert Query is: " + insertionQuery);
DBUtils dbUtilsObj = new DBUtils();
questionID = dbUtilsObj.CUDOperationsScalar(insertionQuery);
}
//LogUtils.myLog.Info("Inserted ID of Question is: " + insertedID);
insertAttribueScore(questionID, 1301, Int32.Parse(TextBox1.Text));
insertAttribueScore(questionID, 1302, Int32.Parse(TextBox2.Text));
insertAttribueScore(questionID, 1303, Int32.Parse(scoreTxtBx1.Text));
foreach (DataListItem item in DataList12.Items)
{
HiddenField attributeIDText = (HiddenField)item.FindControl("attributeID");
String scoreValue = ((RadioButtonList)item.FindControl("scoreTxtBx")).Text;
String selectedItemRdBtn = ((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem.Value;
RadioButtonList rdBtn = ((RadioButtonList)item.FindControl("radlstPubs"));
ListItem selItem = rdBtn.SelectedItem;
if (selItem != null)
{
Int32 ignoreThisValue = Int32.Parse("214748364") + Int32.Parse(attributeIDText.Value);
if (selItem.Value == ignoreThisValue.ToString())
{
continue;
}
}
//LogUtils.myLog.Info("Score of the Attribute is : " + scoreValue);
if (((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem != null)
{
if (scoreValue == "")
{
scoreValue = "10";
}
String insertionQuery1
= "INSERT INTO Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id"
+ ", Q_Question_question_id, SCORE) "
+ " output inserted.ques_att_option_id"
+ " VALUES (" + selectedItemRdBtn + "," + questionID + "," + scoreValue + ")";
DBUtils dbUtilsObj1 = new DBUtils();
int insertedID1 = dbUtilsObj1.CUDOperationsScalar(insertionQuery1);
}
if (((CheckBoxList)item.FindControl("chkBxList1")).SelectedItem != null)
{
CheckBoxList chkBoxLst1 = ((CheckBoxList)item.FindControl("chkBxList1"));
foreach (ListItem itemTemp in chkBoxLst1.Items)
{
if (itemTemp.Selected == true)
{
String selectedItemChckBox = itemTemp.Value;
String insertionQuery1
= "INSERT INTO Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id, Q_Question_question_id) "
+ " output inserted.ques_att_option_id"
+ " VALUES (" + selectedItemChckBox + "," + questionID + "," + scoreValue + ")";
DBUtils dbUtilsObj2 = new DBUtils();
int insertedID2 = dbUtilsObj2.CUDOperationsScalar(insertionQuery1);
//LogUtils.myLog.Info("Inserted ID of Check box is: " + insertedID2);
}
}
}
}
Response.Redirect("~/KMSPages/QueQuestionList.aspx");
}
protected void Submit_Button_Click1(object sender, EventArgs e)
{
int cloID = ViewState["cloID"] == null ? 0 : (int)ViewState["cloID"];
int ruleID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
if (ruleID != 0)
{
String updateQuery = "UPDATE I_Rule"
+ " SET rule_statement = '" + ruleStmt.Text + "'"
+ " WHERE rule_id = " + ruleID;
DBUtils dbUtilsObj = new DBUtils();
dbUtilsObj.CUDOperations(updateQuery);
String deleteQuery = "DELETE FROM I_Rule_Case WHERE I_Rule_rule_id = " + ruleID;
dbUtilsObj.CUDOperations(deleteQuery);
}
else
{
String insertionQuery
= "INSERT INTO I_Rule"
+ " (I_CLO_clo_id"
+ " ,rule_statement)"
+ " output inserted.rule_id"
+ " VALUES"
+ " (" + cloID
+ " , '" + ruleStmt.Text + "')";
//LogUtils.myLog.Info("My Insert Query is: " + insertionQuery);
DBUtils dbUtilsObj = new DBUtils();
ruleID = dbUtilsObj.CUDOperationsScalar(insertionQuery);
}
//LogUtils.myLog.Info("Inserted ID of Question is: " + insertedID);
foreach (DataListItem item in DataList1.Items)
{
if (((HiddenField)item.FindControl("ruleQuestionTypeIDHidden")).Value == "1101")
{
if (((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem != null)
{
String selectedItemRdBtn = ((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem.Value;
String insertionQuery1
= "INSERT INTO I_Rule_Case"
+ " (I_Rule_Ques_Answer_answer_id"
+ " ,I_Rule_rule_id)"
+ " VALUES (" + selectedItemRdBtn
+ ", " + ruleID + ")";
DBUtils dbUtilsObj1 = new DBUtils();
dbUtilsObj1.CUDOperations(insertionQuery1);
}
}
else
{
if (((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem != null)
{
String selectedItemRdBtn = ((RadioButtonList)item.FindControl("radlstPubs")).SelectedItem.Value;
String insertionQuery1
= "INSERT INTO I_Rule_Case"
+ " (COMPARISON_TYPE"
+ " , COMPARISON_VALUE"
+ " , I_RULE_QUESTION_ID"
+ " ,I_Rule_rule_id)"
+ " VALUES (" + selectedItemRdBtn
+ " , " + ((TextBox)item.FindControl("dbQueryValue")).Text
+ " , " + ((HiddenField)item.FindControl("ruleQuestionIDHidden")).Value
+ ", " + ruleID + ")";
DBUtils dbUtilsObj1 = new DBUtils();
dbUtilsObj1.CUDOperations(insertionQuery1);
}
}
}
Response.Redirect("~/KMSPages/ImpRuleList.aspx");
}
protected void Wizard1_FinishButtonClick(object sender, EventArgs e)
{
bool editMode = Request.QueryString["editMode"] == null ? false : bool.Parse(Request.QueryString["editMode"]);
int favID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
String selectedItems = "";
selectedItemList = (Dictionary<String, String>)ViewState["searchCriteria"];
foreach (KeyValuePair<string, string> entry in selectedItemList)
{
selectedItems += entry.Key + ",";
}
if (selectedItems.Length > 0)
selectedItems = selectedItems.Substring(0, selectedItems.Length - 1);
if (editMode)
{
try
{
String assessmentName = favListName.Text;
String courseId = Session["CourseID"].ToString();
String instructorId = Session["userId"].ToString();
String updateQuery
= "UPDATE Q_Favorite_List"
+ " SET Favorite_list_name = '" + assessmentName + "'"
+ " , App_Instructor_instructor_id = " + instructorId
+ " , App_Course_course_id = " + courseId
+ " WHERE favorite_list_id = " + favID;
DBUtils dbUtilsObj = new DBUtils();
dbUtilsObj.CUDOperations(updateQuery);
String deleteQuery =
"DELETE FROM Q_Favorite_List_has_Q_Question WHERE Q_Favorite_List_favorite_list_id = " + favID;
dbUtilsObj.CUDOperations(deleteQuery);
}
catch (Exception ex)
{
LogUtils.myLog.Error("Error while adding assessment : ", ex);
}
}
else
{
String insertionQuery
= "INSERT INTO Q_Favorite_List ( Favorite_list_name, App_Instructor_instructor_id, App_Course_course_id) "
+ " output inserted.favorite_list_id"
+ " VALUES ('"
+ favListName.Text
+ "', " + Session["userId"].ToString() + ", " + Session["CourseID"].ToString() + ")";
//LogUtils.myLog.Info("My Insert Query is: " + insertionQuery);
DBUtils dbUtilsObj = new DBUtils();
favID = dbUtilsObj.CUDOperationsScalar(insertionQuery);
//LogUtils.myLog.Info("Inserted ID of Question is: " + insertedID);
}
List<Int32> queList = new List<Int32>();
foreach (QueQuestion que in selectedQuestionList)
{
queList.Add(que.questionId);
String insertQuery
= "INSERT INTO Q_Favorite_List_has_Q_Question ( Q_Favorite_List_favorite_list_id , Q_Question_question_id ) "
+ "VALUES (" + favID + "," + que.questionId + ")";
DBUtils dbUtilsObj1 = new DBUtils();
dbUtilsObj1.CUDOperations(insertQuery);
}
queDaoObj.insertAssessmentQuesScoreList(favID, questionScoreList);
Response.Redirect("~/KMSPages/QueFavQuestionList.aspx");
}
