public static void getKurseviViewbyKursAndModul(DS_PretragaKandidata.view_KurseviDataTable dt_kursevi, int TrainingTypeID = 0, int TrainingSubTypeID = 0)
{
dt_kursevi.Clear();
using (SqlConnection cn = Connection.GetOpenConnection())
{
SqlCommand com = new SqlCommand("usp_getKursevi", cn);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@TrainingTypeID", TrainingTypeID);
com.Parameters.AddWithValue("@TrainingSubTypeID", TrainingSubTypeID);
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(dt_kursevi);
}
}
public static void getKurseviViewbyKurs(DS_PretragaKandidata.view_KurseviDataTable dt_kursevi, int TrainingTypeID = 0)
{
dt_kursevi.Clear();
using (SqlConnection cn = Connection.GetOpenConnection())
{
string TTID = TrainingTypeID.ToString();
SqlCommand com = new SqlCommand();
com.Connection = cn;
if (TrainingTypeID != 0)
{
com.CommandText = "select * from view_Kursevi where TrainingTypeID=" + TTID;
}
else
{
com.CommandText = "select * from view_Kursevi";
}
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(dt_kursevi);
}
}