private void insertAttribueScore(int questionId, int attributeId, int score)
{
String insertionQuery1
= "INSERT INTO [Q_QUESTION_SCORE] ([SCORE], [ATTRIBUTE_ID], [QUESTION_ID])"
+ " VALUES (" + score + ", " + attributeId + ", " + questionId + ")";
DBUtils dbUtilsObj2 = new DBUtils();
int insertedID2 = dbUtilsObj2.CUDOperations(insertionQuery1);
}
public void deleteAttribute(int attributeID)
{
DBUtils dbUtilsObj = new DBUtils();
String deleteQuery
= "delete from Q_Attribute_Options"
+ " where Q_Attribute_attribute_id = " + attributeID;
dbUtilsObj.CUDOperations(deleteQuery);
String updateQuery
= "delete from Q_Attribute"
+ " where attribute_id = " + attributeID;
dbUtilsObj.CUDOperations(updateQuery);
Response.Redirect("~/KMSPages/QueAttributeList.aspx");
}
public void deleteRule(int ruleID)
{
DBUtils dbUtilsObj = new DBUtils();
String deleteQuery = "DELETE FROM I_Rule"
+ " WHERE rule_id = " + ruleID;
dbUtilsObj.CUDOperations(deleteQuery);
}
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");
}
public void updatedPassword(AppUser userObj)
{
DBUtils dbUtilsObj = new DBUtils();
String updateQuery = "UPDATE USERS"
+ " SET PASSWORD = '******', FIRST_TIME_LOGIN_FLAG = 0"
+ " WHERE USERNAME = '******'";
dbUtilsObj.CUDOperations(updateQuery);
}
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 deleteQuestion(int questionID)
{
DBUtils dbUtilsObj = new DBUtils();
String deleteQuery = "DELETE FROM Q_Favorite_List_has_Q_Question"
+ " WHERE Q_Question_question_id = " + questionID;
dbUtilsObj.CUDOperations(deleteQuery);
deleteQuery = "DELETE FROM Q_QUESTION_SCORE"
+ " WHERE QUESTION_ID = " + questionID;
dbUtilsObj.CUDOperations(deleteQuery);
deleteQuery = "delete from Q_Question_Attribute_Option"
+ " WHERE Q_Question_question_id = " + questionID;
dbUtilsObj.CUDOperations(deleteQuery);
deleteQuery
= "delete from Q_Question"
+ " where question_id = " + questionID;
dbUtilsObj.CUDOperations(deleteQuery);
Response.Redirect("~/KMSPages/QueQuestionList.aspx");
}
public void insertUser(AppUser appUserObj)
{
DBUtils dbUtilsObj = new DBUtils();
String updateQuery = "INSERT INTO USERS"
+ " VALUES ('"
+ appUserObj.username
+ "' , '" + appUserObj.pwd
+ "' , '" + appUserObj.instructorId
+ "' , '" + appUserObj.userType
+ "' , '" + appUserObj.module
+ "' , '" + appUserObj.course
+ "' , '1"
+ "')";
dbUtilsObj.CUDOperations(updateQuery);
}
protected void btnSave_Click(int attributeID)
{
try
{
SetRowData();
DataTable table = ViewState["CurrentTable"] as DataTable;
if (table != null)
{
foreach (DataRow row in table.Rows)
{
string priorityNum = row.ItemArray[1] as string;
string txName = row.ItemArray[2] as string;
if (txName != null)
{
// Do whatever is needed with this data,
// Possibily push it in database
// I am just printing on the page to demonstrate that it is working.
DBUtils dbUtilObj = new DBUtils();
String insertStmt = "INSERT INTO Q_Attribute_Options"
+ " (Q_Attribute_attribute_id, option_statement, PRIORITY_OPTION)"
+ " VALUES ("
+ " \'" + attributeID.ToString() + "\', \'"
+ txName + "\', \'" + priorityNum + "\')";
dbUtilObj.CUDOperations(insertStmt);
//LogUtils.myLog.Info(string.Format("{0}", txName));
}
}
}
}
catch (Exception ex)
{
LogUtils.myLog.Info("Exception : " + ex.Message, ex);
throw new Exception(ex.Message);
}
}
private void CreateQuery()
{
qus = new List <Query>();
for (int i = 0; i < QuestionList.Count; i++)
{
Query q = new Query();
//Declare @a int; Declare @b int;
//insert into Q_Question (App_Instructor_instructor_id,App_Course_course_id,App_Program_program_id,question_statement,question_type,App_Course_Topic_id,App_Clo_id,App_So_id) values (1,4,3,'Why are the pipes connected in parallel?',1,1016,7,13);
//select @a= MAX(question_id) from Q_Question select @b = attribute_option_id from Q_Attribute_Options where option_statement = 'SA';
//insert into Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id,Q_Question_question_id,SCORE) values (@b,@a,1);
//select @b = attribute_option_id from Q_Attribute_Options where option_statement = '400';
//insert into Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id,Q_Question_question_id,SCORE) values (@b,@a,1);
//insert into Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id,Q_Question_question_id,SCORE) values (4087,@a,1);
//select @b = attribute_option_id from Q_Attribute_Options where option_statement = 'No';
//insert into Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id,Q_Question_question_id,SCORE) values (@b,@a,1);
q.query = @"Declare @a int; Declare @b int;" +
"insert into Q_Question (App_Instructor_instructor_id,App_Course_course_id,App_Program_program_id,question_statement,question_type,App_Course_Topic_id,App_Clo_id,App_So_id) values (1," + QuestionList[i].CourseID + "," + QuestionList[i].ProgramID + ",'" + QuestionList[i].Question + "',1," + QuestionList[i].CoursetopicID + "," + QuestionList[i].CLO + "," + QuestionList[i].SO + ");" +
"select @a= MAX(question_id) from Q_Question;" +
"INSERT INTO Q_QUESTION_SCORE (SCORE, ATTRIBUTE_ID, QUESTION_ID) values (3,1301,@a)" +
"INSERT INTO Q_QUESTION_SCORE (SCORE, ATTRIBUTE_ID, QUESTION_ID) values (4,1302,@a)" +
"INSERT INTO Q_QUESTION_SCORE (SCORE, ATTRIBUTE_ID, QUESTION_ID) values (5,1303,@a)";
for (int j = 0; j < QuestionList[i].Attribute.Count; j++)
{
q.query += "insert into Q_Question_Attribute_Option (Q_Attribute_Options_attribute_option_id,Q_Question_question_id,SCORE) values ('" + QuestionList[i].Attribute[j] + "',@a,1);";
}
//Response.Write(q.query);
qus.Add(q);
DBUtils dbUtils = new DBUtils();
dbUtils.CUDOperations(q.query);
}
}
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");
}
