private void Refresh()
{
DataTable dt = CourseRegManager.GetClassDetailsInfo();
ddlCourseTrac.DataSource = dt;
ddlCourseTrac.DataValueField = "id";
ddlCourseTrac.DataTextField = "TracName";
ddlCourseTrac.DataBind();
ddlCourseTrac.Items.Insert(0, new System.Web.UI.WebControls.ListItem(""));
DataTable dts = CourseRegManager.GetAllDaysInfor("");
//ddlDays.DataSource = dts;
//ddlDays.DataValueField = "id";
//ddlDays.DataTextField = "TracName";
//ddlDays.DataBind();
//ddlDays.Items.Insert(0, new System.Web.UI.WebControls.ListItem(""));
DataTable dtst = StudentManager.GetAllStudentSearch("", "", "", "");
HistoryGridView.DataSource = dtst;
HistoryGridView.DataBind();
dgSubSedule.DataSource = null;
dgSubSedule.DataBind();
hfID.Value = "";
}
protected void txtFAcultySearch_TextChanged(object sender, EventArgs e)
{
DataTable dt = CourseRegManager.GetFAcultyNAme(txtFAcultySearch.Text);
txtFAcultySearch.Text = dt.Rows[0]["FacultyName"].ToString();
lblFacultyID.Text = dt.Rows[0]["ID"].ToString();
UP1.Update();
}
public DataTable PopulateItem()
{
DataTable dtitm = CourseRegManager.GetAllDaysInfor("");
DataRow dr = dtitm.NewRow();
dtitm.Rows.InsertAt(dr, 0);
return(dtitm);
}
protected void ddlCourseTrac_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dts = CourseRegManager.GetCourseDetailsInfo(ddlCourseTrac.SelectedValue);
ddlCourseName.DataSource = dts;
ddlCourseName.DataValueField = "id";
ddlCourseName.DataTextField = "CourseName";
ddlCourseName.DataBind();
ddlCourseName.Items.Insert(0, new System.Web.UI.WebControls.ListItem(""));
}
protected void HistoryGridView_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable dt = CourseRegManager.GetCourseSheduleInfo(HistoryGridView.SelectedRow.Cells[7].Text);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
lblID.Text = row["ID"].ToString();
ddlCourseTrac.SelectedValue = row["TracID"].ToString();
ddlCourseName.SelectedValue = row["CourseID"].ToString();
txtFAcultySearch.Text = row["FacultyName"].ToString();
txtBatchNo.Text = row["BatchNo"].ToString();
txtYear.Text = row["Year"].ToString();
txtStartDate.Text = row["dttST"].ToString();
txtEndDate.Text = row["dttEnd"].ToString();
hfID.Value = row["ID"].ToString();
}
DataTable dts = CourseRegManager.GetCourseDetailsOfCourseShedule(hfID.Value);
// ViewState["SelectDtl"] = dts;
//GridViewRow gvr = (GridViewRow)((DropDownList)sender).NamingContainer;
// DataTable dtdtl = (DataTable)ViewState["SelectDtl"];
// DataRow dr = dtdtl.Rows[gvr.DataItemIndex];
// //dr["ID"] = lblID.Text;
// ((DropDownList)gvr.FindControl("ddlDays")).SelectedValue= dr["Days"].ToString();
//((TextBox)gvr.FindControl("txtStartTime")).Text = dr["sttime"].ToString();
//((RadioButtonList)gvr.FindControl("rbStartAmPm")).SelectedValue=dr["StAPM"].ToString();
//((TextBox)gvr.FindControl("txtEndTime")).Text = dr["endtime"].ToString();
//((RadioButtonList)gvr.FindControl("rbEndAmPm")).SelectedValue = dr["EndAPM"].ToString();
//((TextBox)gvr.FindControl("txtRoomNo")).Text = dr["RoomNo"].ToString();
//var query = from c in dts.AsEnumerable() where c.Field<string>("ID") == ((DropDownList)gvr.FindControl("ddlDays")).SelectedValue.ToString() select s;
//dgSubSedule.DataSource = query;
//dgSubSedule.DataBind();
}
catch (FormatException fex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true);
}
catch (Exception ex)
{
if (ex.Message.Contains("Database"))
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true);
}
}
}
