// Bind Student Information using studentid
private void BindStudentInfo(int studentId)
{
DBCommon db = new DBCommon();
SqlCommand cmd = new SqlCommand();
DataTable studInfo = db.GetTable(cmd);
if (studInfo != null)
{
}
}
private int GetTotalPassCredit(int StudentId, string ProgramId)
{
int Credits = 0;
DBCommon db = new DBCommon();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_GetTotalPassCredits";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentid", StudentId.ToString());
cmd.Parameters.AddWithValue("@ProgramId", ProgramId);
Credits = Convert.ToInt32(db.GetValue(cmd));
return(Credits);
}
private void BindEduPlanList(int StudentId)
{
DBCommon db = new DBCommon();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_GetEduPlantList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentId", StudentId);
DataTable dtplans = db.GetTable(cmd);
if (dtplans != null)
{
DataList1.DataSource = dtplans;
DataList1.DataBind();
}
}
private void BindStudentInfo(int StudentId)
{
DBCommon db = new DBCommon();
SqlCommand cmd = new SqlCommand("select * from tsstudent where StudentId = @StudentId");
cmd.Parameters.AddWithValue("@StudentId", StudentId);
DataTable studInfo = db.GetTable(cmd);
if (studInfo != null)
{
lblSID.Text = studInfo.Rows[0]["SID"].ToString();
lblName.Text = studInfo.Rows[0]["FirstName"].ToString() + " " + studInfo.Rows[0]["LastName"].ToString();
lblHeaderName.Text = studInfo.Rows[0]["FirstName"].ToString() + " " + studInfo.Rows[0]["LastName"].ToString();
LblDOB.Text = Convert.ToDateTime(studInfo.Rows[0]["DOB"]).ToString("MMM dd yyyy");
LblEmailid.Text = studInfo.Rows[0]["Email"].ToString();
}
}
public void GetProgramList()
{
int studentId = 0;
DBCommon db = new DBCommon();
using (SqlCommand cmd = new SqlCommand())
{
studentId = Convert.ToInt32(Session["StudentId"]);
//cmd.CommandText = "SELECT ProgramId, ProgramName from tsProgram order by ProgramName Asc";
cmd.CommandText = "sp_GetEduProgramListBrowse";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentID", studentId);
DataTable dt = db.GetTable(cmd);
ProgramList.DataSource = dt;
ProgramList.DataBind();
}
}
protected void Search_Click1(object sender, EventArgs e)
{
DBCommon db = new DBCommon();
SqlCommand cmd = new SqlCommand("select StudentId from tsstudent where SID=@SID ");
cmd.Parameters.AddWithValue("@SID", TextBox1.Text);
string StudentId = db.GetValue(cmd);
Session.RemoveAll();
if (StudentId != "")
{
Session["StudentId"] = Convert.ToInt32(StudentId);
Response.Redirect("StudentPlans.aspx");
}
else
{
Label1.Text = "Your SID is incorrect";
Label1.ForeColor = System.Drawing.Color.Red;
}
}
private void BuildPlan(int yearId, string ProgramId)
{
DBCommon db = new DBCommon();
SqlCommand cmd = new SqlCommand();
// SqlParameter prmStudentId = new SqlParameter("@StudentId", GSpaceCommon.SessionMgr.snStudentId);
// SqlParameter prmProgramId = new SqlParameter("@ProgramId", ddlPrograms.SelectedValue);
// SqlDataReader dr = Dbobject._getDataReader("sp_GetPassCoursesCrhs", CommandType.StoredProcedure, prmStudentId, prmProgramId);
// while (dr.Read())
// {
// switch (dr["category"].ToString())
// {
// case "General":
// lblGenPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblGenRemn.Text = int.Parse(lblTotGeneralHrs.Text) > int.Parse(lblGenPass.Text) ? Convert.ToString(int.Parse(lblTotGeneralHrs.Text) - int.Parse(lblGenPass.Text)) : "0";
// break;
// case "Major":
// lblMajPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblMajRemn.Text = int.Parse(lblTotMajorHrs.Text) > int.Parse(lblMajPass.Text) ? Convert.ToString(int.Parse(lblTotMajorHrs.Text) - int.Parse(lblMajPass.Text)) : "0";
// break;
// case "Major (C)":
// lblMajPassc.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblMajRemnc.Text = int.Parse(lblTotMajorHrsc.Text) > int.Parse(lblMajPassc.Text) ? Convert.ToString(int.Parse(lblTotMajorHrsc.Text) - int.Parse(lblMajPassc.Text)) : "0";
// break;
// case "Medullar":
// lblMedPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblMedRemn.Text = int.Parse(lblTotMedullarHrs.Text) > int.Parse(lblMedPass.Text) ? Convert.ToString(int.Parse(lblTotMedullarHrs.Text) - int.Parse(lblMedPass.Text)) : "0";
// break;
// case "Free-Elective":
// lblFreeElectPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblFreeElectRemn.Text = int.Parse(lblTotFreeElctvHrs.Text) > int.Parse(lblFreeElectPass.Text) ? Convert.ToString(int.Parse(lblTotFreeElctvHrs.Text) - int.Parse(lblFreeElectPass.Text)) : "0";
// break;
// case "Major-Elective":
// lblMajElectPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblMajElecRemn.Text = int.Parse(lblTotMajorElctvHrs.Text) > int.Parse(lblMajElectPass.Text) ? Convert.ToString(int.Parse(lblTotMajorElctvHrs.Text) - int.Parse(lblMajElectPass.Text)) : "0";
// break;
// case "Social Science":
// lblPsyPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblSocSciRemn.Text = int.Parse(lblTotSocSciHrs.Text) > int.Parse(lblPsyPass.Text) ? Convert.ToString(int.Parse(lblTotSocSciHrs.Text) - int.Parse(lblPsyPass.Text)) : "0";
// break;
// case "Psychology":
// lblPsyPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblPsyRemn.Text = int.Parse(lblTotPsyHrs.Text) > int.Parse(lblPsyPass.Text) ? Convert.ToString(int.Parse(lblTotPsyHrs.Text) - int.Parse(lblPsyPass.Text)) : "0";
// break;
// case "Math and Science":
// lblMathSciPass.Text = Convert.ToString(dr["sumofcredithours"] != DBNull.Value ? Convert.ToInt32(dr["sumofcredithours"]) : 0);
// lblMathSciRemn.Text = int.Parse(lblTotMathSciHrs.Text) > int.Parse(lblMathSciPass.Text) ? Convert.ToString(int.Parse(lblTotMathSciHrs.Text) - int.Parse(lblMathSciPass.Text)) : "0";
// lblTotPassedHrs.Text = Convert.ToString(Convert.ToInt32(lblGenPass.Text) + Convert.ToInt32(lblMajPass.Text) + Convert.ToInt32(lblMajPassc.Text) + Convert.ToInt32(lblMedPass.Text) + Convert.ToInt32(lblFreeElectPass.Text) + Convert.ToInt32(lblMajElectPass.Text) + Convert.ToInt32(lblPsyPass.Text) + Convert.ToInt32(lblPsyPass.Text) + Convert.ToInt32(lblMathSciPass.Text));
// lblTotRemain.Text = Convert.ToString(Convert.ToInt32(lblGenRemn.Text) + Convert.ToInt32(lblMajRemn.Text) + Convert.ToInt32(lblMajRemnc.Text) + Convert.ToInt32(lblMedRemn.Text) + Convert.ToInt32(lblFreeElectRemn.Text) + Convert.ToInt32(lblMajElecRemn.Text) + Convert.ToInt32(lblSocSciRemn.Text) + Convert.ToInt32(lblPsyRemn.Text) + Convert.ToInt32(lblMathSciRemn.Text));
// break;
// }
// }
// scon.Close();
// }
//
}
