public ImpRuleQuestion getRuleQuestionByID(int ruleQeustionID)
{
ImpRuleQuestion ques1 = new ImpRuleQuestion();
DBUtils dbUtils = new DBUtils();
String myQuery = "SELECT *"
+ " FROM I_Rule_Question q"
+ " JOIN I_CLO C ON Q.I_CLO_clo_id = C.clo_id"
+ " JOIN App_Course AC ON AC.course_id = C.App_Course_course_id"
+ " JOIN App_Program AP ON AP.program_id = AC.App_Program_program_id"
+ " JOIN App_CODE CD on CD.CODE_ID = Q.rule_question_type_id"
+ " WHERE rule_question_id = " + ruleQeustionID
+ " order by 1 desc";
SqlDataReader attributeListReader = dbUtils.readOperation(myQuery);
while (attributeListReader.Read())
{
ques1.ruleQuesId = (int)attributeListReader["rule_question_id"];
ques1.ruleQuestionStatemet = attributeListReader["rule_ques_statement"].ToString();
ques1.dBQueryStatement = attributeListReader["DATABASE_QUERY_STATEMENT"].ToString();
ques1.ruleQuesTypeID = (int)attributeListReader["rule_question_type_id"];
ques1.ruleQuesType = attributeListReader["CODE_VALUE"].ToString();
AppCLO myClo = new AppCLO();
myClo.cloId = (int)attributeListReader["clo_id"];
myClo.cloStatement = attributeListReader["clo_statement"].ToString();
myClo.courseId = (int)attributeListReader["course_id"];
myClo.courseName = attributeListReader["course_name"].ToString();
myClo.programId = (int)attributeListReader["program_id"];
myClo.programName = attributeListReader["program_name"].ToString();
ques1.cloData = myClo;
}
dbUtils.closeDBConnection();
return(ques1);
}
public ImpRule getRuleByID(int ruleID)
{
ImpRule ques1 = new ImpRule();
DBUtils dbUtils = new DBUtils();
String myQuery = " select * from I_Rule R"
+ " JOIN I_CLO C ON R.I_CLO_clo_id = C.clo_id"
+ " JOIN App_Course AC ON AC.course_id = C.App_Course_course_id"
+ " JOIN App_Program AP ON AP.program_id = AC.App_Program_program_id"
+ " WHERE rule_id=" + ruleID;
myQuery += " order by 1 desc";
SqlDataReader attributeListReader = dbUtils.readOperation(myQuery);
while (attributeListReader.Read())
{
ques1.ruleId = (int)attributeListReader["rule_id"];
ques1.ruleStatemet = attributeListReader["rule_statement"].ToString();
AppCLO myClo = new AppCLO();
myClo.cloId = (int)attributeListReader["clo_id"];
myClo.cloStatement = attributeListReader["clo_statement"].ToString();
myClo.courseId = (int)attributeListReader["course_id"];
myClo.courseName = attributeListReader["course_name"].ToString();
myClo.programId = (int)attributeListReader["program_id"];
myClo.programName = attributeListReader["program_name"].ToString();
ques1.cloData = myClo;
}
dbUtils.closeDBConnection();
return(ques1);
}
public List <AppCLO> getCLOList(String courseId)
{
DBUtils dbUtils1 = new DBUtils();
String queryString = "SELECT *"
+ " FROM [I_CLO] C"
+ " JOIN App_Course CO ON C.App_Course_course_id = CO.course_id"
+ " JOIN App_Program AP ON AP.program_id = CO.App_Program_program_id"
+ " WHERE App_Course_course_id = " + courseId
+ " ORDER BY 1 DESC";
//LogUtils.myLog.Info("My Query for CLO List is : " + queryString);
SqlDataReader attributeListReader1 = dbUtils1.readOperation(queryString);
List <AppCLO> CLOList = new List <AppCLO>();
while (attributeListReader1.Read())
{
AppCLO att2 = new AppCLO();
att2.cloId = (int)attributeListReader1["clo_id"];
att2.cloStatement = attributeListReader1["clo_statement"].ToString();
att2.courseId = (int)attributeListReader1["App_Course_course_id"];
att2.courseName = attributeListReader1["course_name"].ToString();
CLOList.Add(att2);
}
dbUtils1.closeDBConnection();
return(CLOList);
}
protected void Page_Load(object sender, EventArgs e)
{
ImpDao impDaoObj = new ImpDao();
int cloID = Request.QueryString["cloID"] == null ? 0 : Int32.Parse(Request.QueryString["cloID"]);
if (Page.IsPostBack == false)
{
int ruleID = Request.QueryString["id"] == null ? 0 : Int32.Parse(Request.QueryString["id"]);
bool viewMode = Request.QueryString["viewMode"] == null ? false : Boolean.Parse(Request.QueryString["viewMode"]);
bool editMode = Request.QueryString["editMode"] == null ? false : Boolean.Parse(Request.QueryString["editMode"]);
bool deleteMode = Request.QueryString["deleteMode"] == null ? false : Boolean.Parse(Request.QueryString["deleteMode"]);
if (ruleID != 0)
{
if (deleteMode)
{
deleteRule(ruleID);
Response.Redirect("~/KMSPages/ImpRuleList.aspx");
}
ImpRule rule = impDaoObj.getRuleByID(ruleID);
cloID = rule.cloData.cloId;
ruleStmt.Text = rule.ruleStatemet;
if (viewMode == true)
{
ruleStmt.Enabled = false;
DataList1.Enabled = false;
}
Button1.Visible = !viewMode;
cancelBtn.Text = viewMode ? "Close" : "Cancel";
Button1.Text = editMode ? "Update" : "Submit";
}
ViewState["cloID"] = cloID;
AppCLO myClo = impDaoObj.getCloByCloID(cloID);
TextBox1.Text = myClo.programName;
TextBox2.Text = myClo.courseName;
TextBox3.Text = myClo.cloStatement;
}
List <ImpRuleQuestion> quesList = impDaoObj.getRuleQuestionList(Int32.Parse(ViewState["cloID"].ToString()));
DataList1.DataSource = quesList;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ImpDao impDaoObj = new ImpDao();
int cloID = Request.QueryString["cloID"] == null ? 0 : Int32.Parse(Request.QueryString["cloID"]);
if (Page.IsPostBack == false)
{
AppCLO myClo = impDaoObj.getCloByCloID(cloID);
TextBox1.Text = myClo.programName;
TextBox2.Text = myClo.courseName;
TextBox3.Text = myClo.cloStatement;
expertSugLbl.Visible = false;
}
List <ImpRuleQuestion> quesList = impDaoObj.getRuleQuestionList(cloID);
DataList1.DataSource = quesList;
DataList1.DataBind();
}
public AppCLO getCloByCloID(int cloID)
{
AppCLO myClo = new AppCLO();
DBUtils dbUtils = new DBUtils();
String myQuery = "select * from I_CLO C"
+ " JOIN App_Course AC ON AC.course_id = C.App_Course_course_id"
+ " JOIN App_Program AP ON AP.program_id = AC.App_Program_program_id"
+ " WHERE clo_id=" + cloID;
SqlDataReader attributeListReader = dbUtils.readOperation(myQuery);
while (attributeListReader.Read())
{
myClo.cloId = (int)attributeListReader["clo_id"];
myClo.cloStatement = attributeListReader["clo_statement"].ToString();
myClo.courseId = (int)attributeListReader["course_id"];
myClo.courseName = attributeListReader["course_name"].ToString();
myClo.programId = (int)attributeListReader["program_id"];
myClo.programName = attributeListReader["program_name"].ToString();
}
dbUtils.closeDBConnection();
return(myClo);
}
