protected void Kurset_List()
{
//Shfaq requests qe ka bere studenti
BLL.Studenti s = new BLL.Studenti();
ListGridView.DataSource = s.GetRequestsForStudenti(Convert.ToInt32(Session["UserID"]));
ListGridView.DataBind();
}
public Studenti StudentiSelectByID(int id)
{
SqlConnection con = Generals.GetNewConnection();
Studenti studenti = null;
try
{
SqlCommand cmd = new SqlCommand("StudentiSelectByID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentiID", id);
SqlDataReader rdr = cmd.ExecuteReader();
SqlCommand cmdpersoni = new SqlCommand("PersoniSelectByID", con);
cmdpersoni.CommandType = CommandType.StoredProcedure;
cmdpersoni.Parameters.AddWithValue("@personiID", id);
SqlDataReader rdrpersoni = cmd.ExecuteReader();
while (rdr.Read())
{
studenti = new Studenti();
string vitiakademik = rdr["VitiAkademik"].ToString();
studenti.PersoniID = (int)rdrpersoni["PersoniID"];
studenti.Emri = rdrpersoni["Emri"].ToString();
studenti.Mbiemri = rdrpersoni["Mbiemri"].ToString();
studenti.Email = rdrpersoni["Email"].ToString();
studenti.Mosha = (int)rdrpersoni["Mosha"];
studenti.NrTelefonit = rdrpersoni["NrTelefonit"].ToString();
studenti.Gjinia = (char)rdrpersoni["Gjinia"];
if (rdrpersoni["CreatedBy"] != DBNull.Value)
{
studenti.CreatedBy = (int)rdrpersoni["CreatedBy"];
}
if (rdrpersoni["CreatedDate"] != DBNull.Value)
{
studenti.CreatedDate = rdrpersoni["CreatedDate"].ToString();
}
if (rdrpersoni["ModifiedBy"] != DBNull.Value)
{
studenti.ModifiedBy = (int)rdrpersoni["ModifiedBy"];
}
if (rdrpersoni["ModifiedDate"] != DBNull.Value)
{
studenti.ModifiedDate = rdrpersoni["ModifiedDate"].ToString();
}
}
}
finally
{
con.Close();
}
return(studenti);
}
