// 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(); // } // }