//GETTERS
public static void setNames(ComboBox comb)
{
SqlConnection con = new DBConnection().getConnection();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Names";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
comb.Items.Add(dr["First_Name"].ToString() + " " + dr["Middle_Name"].ToString() + " " + dr["Last_Name"].ToString());
}
}
public static void setClassName(ComboBox text)
{
//SET THE YEAR OF THE SCHOOL SESSION THE LIST BOX CONTROL
SqlConnection con = new DBConnection().getConnection();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT DISTINCT ClassName FROM Class";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
text.Items.Add((dr["ClassName"].ToString()));
}
}
public static void setSessionYear(ListBox text)
{
//SET THE YEAR OF THE SCHOOL SESSION THE LIST BOX CONTROL
SqlConnection con = new DBConnection().getConnection();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT Session.Start_Year FROM Session";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
text.Items.Add(string.Format("{0:MM/dd/yyy}", dr["Start_Year"]));
}
}
public static void setFeeName(ComboBox Fee)
{
//GET THE FEE NAME FROM THE DATABASE
SqlConnection con = new DBConnection().getConnection();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT DISTINCT Fee_Name FROM SetFees";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
Fee.Items.Add(dr["Fee_Name"].ToString());
}
}
public void promoteClass(ListBox text)
{
//SET THE YEAR OF THE SCHOOL SESSION THE LIST BOX CONTROL
SqlConnection con = new DBConnection().getConnection();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT DISTINCT ClassName FROM Class";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
var id = Convert.ToInt32(dr["Student_Id"]);
setStudentId(id);
text.Items.Add((dr["ClassName"].ToString()));
}
}
void setEventClass(ListBox text)
{
try
{
//SET THE YEAR OF THE SCHOOL SESSION THE LIST BOX CONTROL
SqlConnection con = new DBConnection().getConnection();
con.Open();
text.Items.Clear();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT Id,Class FROM EventClass WHERE Event_Id='" + dataAccess.eventId + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
// text.Items.Add((dr[0].ToString()));
text.Items.Add((dr[1].ToString()));
}
con.Close();
}
catch (Exception) { }
}
public static void setEventClassName(ListBox text, TextBox Com)
{
SqlConnection con = new DBConnection().getConnection();
text.Items.Clear();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT *FROM EventClass WHERE EventClass.Event_Id in(SELECT Event_Id FROM Events WHERE Fee_Name =@feename)";
cmd.Parameters.Add(new SqlParameter("@feename", SqlDbType.VarChar));
cmd.Parameters["@feename"].Value = Com.Text;
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
text.Items.Add((dr["Class"].ToString()));
}
con.Close();
}