public static List <EPROGRAM> SelectList()
{
List <EPROGRAM> programlar = null;
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("LISANSPROGRAMI_SELECTLIST", BAGLAN.conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
programlar = new List <EPROGRAM>();
while (rdr.Read())
{
EPROGRAM program = new EPROGRAM();
program.ID1 = Convert.ToInt32(rdr["ID"]);
program.KODU1 = rdr["KODU"].ToString();
program.PROGRAM1 = rdr["PROGRAM"].ToString();
programlar.Add(program);
}
}
rdr.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
programlar = null;
}
finally
{
cmd.Connection.Close();
}
return(programlar);
}
public static EPROGRAM Select(int id)
{
EPROGRAM program = null;
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("LISANSPROGRAMI_SELECT", BAGLAN.conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
cmd.Parameters.AddWithValue("PROGRAM_NO", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
program = new EPROGRAM();
program.ID1 = Convert.ToInt32(rdr["ID"]);
program.KODU1 = rdr["KODU"].ToString();
program.PROGRAM1 = rdr["PROGRAM"].ToString();
program.FAKULTE1 = Convert.ToInt32(rdr["FAKULTESI"]);
}
}
rdr.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
program = null;
}
finally
{
cmd.Connection.Close();
}
return(program);
}
