public DropDownList GetHesaForMadah(int EmpID, int SafID, int FaslID, int MadaID, DropDownList dlist)
{
OleDbCommand com = new OleDbCommand("SELECT DISTINCT gadwal_alhasas.hasa_code FROM gadwal_alhasas WHERE CODE=@CODE and alsofof_code=@alsofof_code and fasl_code=@fasl_code and mawad_no=@mawad_no", MySchool.GadwalConnection);
com.Parameters.AddWithValue("@CODE", EmpID);
com.Parameters.AddWithValue("@alsofof_code", SafID);
com.Parameters.AddWithValue("@fasl_code", FaslID);
com.Parameters.AddWithValue("@mawad_no", MadaID);
com.Connection.Open();
OleDbDataReader DR = com.ExecuteReader();
Codes cd = new Codes();
ListItem li;
dlist.Items.Clear();
dlist.Items.Add( new ListItem ("ÇÎÊÑ ÇáÍÕÉ.............","0"));
while (DR.Read())
{
string s = cd.SessionName(Convert.ToInt32(DR["hasa_code"]));
li = new ListItem(s, DR["hasa_code"].ToString());
dlist.Items.Add(li);
}
com.Connection.Close();
return dlist;
}
