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); }