private DataTable BindGridView(string strcmd)
{
try
{
//create a dataset object and fill it
DataSet ds = dbContext.ExecDataSet(strcmd);
int row_count = ds.Tables[0].Rows.Count;
lbl_rowcount.Text = "Total - " + row_count.ToString();
return(ds.Tables[0]);
}
catch (Exception ex)
{
Log.Error("" + ex);
lbl_msg.Visible = true;
lbl_msg.Text = "Something went wrong. Please try again......";
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
courseId = Convert.ToInt32(Request.QueryString["id"]);
string StrDepartment = "select deptId, deptName from tbldepartment";
dbContext.BindDropDownlist(StrDepartment, ref ddlDepartment);
string StrCourse = "select courseId, courseNumber from tblcourse";
dbContext.BindDropDownlist(StrCourse, ref ddlCourseNumber);
// dbContext.BindDropDownlist(StrCourse, ref ddlCourseStatus);
string StrClassroom = "select classroomId, classroomNumber from tblclassroom";
dbContext.BindDropDownlist(StrClassroom, ref ddlClassRoom);
string constr = ConfigurationManager.ConnectionStrings["MySql_ConnectionString"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
string strcmd = "SELECT A.courseId, A.courseNumber, A.courseName, A.courseLevel, A.credits, B.deptName, A.status as status, A.term, A.credits, B.deptName from tblcourse as A " +
"LEFT OUTER JOIN tbldepartment as B on B.deptId = A.deptId " +
"WHERE A.courseId = " + courseId + " ";
DataSet ds = dbContext.ExecDataSet(strcmd);
if (ds.Tables[0].Rows.Count > 0)
{
ddlDepartment.SelectedValue = ds.Tables[0].Rows[0][5].ToString();
ddlCourseNumber.SelectedValue = ds.Tables[0].Rows[0]["courseNumber"].ToString();
txtCourseName.Text = ds.Tables[0].Rows[0]["courseName"].ToString();
ddlCourseStatus.SelectedValue = ds.Tables[0].Rows[0]["status"].ToString();
ddlCourseLevel.SelectedValue = ds.Tables[0].Rows[0]["courseLevel"].ToString();
ddlCourseCredits.SelectedValue = ds.Tables[0].Rows[0]["credits"].ToString();
ddlCourseTerm.SelectedValue = ds.Tables[0].Rows[0]["term"].ToString();
if (ds.Tables[0].Rows[0]["status"].ToString() == "1")
{
lblCourseStatus.Text = "Active";
btnCourseStatus.Text = "DEACTIVE";
btnCourseStatus.CssClass = "btn btn-danger btn-sm btn-block";
}
else
{
lblCourseStatus.Text = "Deactive";
btnCourseStatus.Text = "ACTIVE";
btnCourseStatus.CssClass = "btn btn-success btn-sm btn-block";
}
}
//MySqlCommand cmd = new MySqlCommand(strcmd, con);
//con.Open();
//MySqlDataReader dr = cmd.ExecuteReader();
//if (dr.HasRows)
//{
// dr.Read();
// ddlDepartment.SelectedValue = dr["deptName"].ToString();
// ddlCourseNumber.SelectedValue = dr["courseNumber"].ToString();
//}
}
}
catch (Exception ex)
{
Log.Error(ex);
}
}
