public List <localFakulte> FakulteListele()
{
List <localFakulte> lf = new List <localFakulte>();
using (SqlConnection conn = new SqlConnection(conStrig))
{
conn.Open();
SqlCommand cmdd = new SqlCommand("spFakulteListele", conn);
cmdd.CommandTimeout = 600;
cmdd.CommandType = CommandType.StoredProcedure;
SqlDataReader rd = cmdd.ExecuteReader();
if (rd.HasRows == true)
{
while (rd.Read())
{
localFakulte f = new localFakulte();
f.fakulteAdi = rd["fakulteAdi"].ToString();
lf.Add(f);
}
}
conn.Dispose();
conn.Close();
}
return(lf);
}
public List <localFakulte> FakulteAdi()
{
List <localFakulte> ld = new List <localFakulte>();
using (SqlConnection conn = new SqlConnection(conStrig))
{
conn.Open();
SqlCommand cmdd = new SqlCommand("spFakulteGetir", conn);
cmdd.CommandTimeout = 600;
cmdd.CommandType = CommandType.StoredProcedure;
SqlDataReader rd = cmdd.ExecuteReader();
if (rd.HasRows == true)
{
while (rd.Read())
{
localFakulte d = new localFakulte();
d.fakulteAdi = rd["fakulteAdi"].ToString();
d.fakulteId = Convert.ToInt32(rd["fakulteId"]);
ld.Add(d);
}
}
conn.Dispose();
conn.Close();
}
return(ld);
}
