public static System.Collections.Generic.List <KursusListe> GetKursusListByKursusDag(int KursusDagID) { System.Collections.Generic.List <KursusListe> result = new System.Collections.Generic.List <KursusListe>(); int ID = -1; DBAccess db = new DBAccess(); db.AddInt("KursusDagID", KursusDagID); SqlDataReader dr = default(SqlDataReader); try { dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByKursusDag)); if (dr.HasRows) { while (dr.Read()) { KursusListe kd = new KursusListe(); kd.KursusDeltagerID = System.Convert.ToInt32(dr.DBtoInt("KursusDeltagerID")); kd.KursusDagID = System.Convert.ToInt32(dr.DBtoInt("KursusDagID")); kd.Status = (RescueTekniq.BOL.KursusStatusEnum)(dr.DBtoInt("KursusListeStatus")); result.Add(kd); } } dr.Close(); } catch (Exception ex) { throw (ex); } return(result); }
private static void Populate(SqlDataReader dr, KursusListe c) { var with_1 = c; with_1.KursusDagID = System.Convert.ToInt32(dr.DBtoInt("KursusDagID")); with_1.KursusDeltagerID = System.Convert.ToInt32(dr.DBtoInt("KursusDeltagerID")); with_1.Status = (RescueTekniq.BOL.KursusStatusEnum)(dr.DBtoInt("Status")); PopulateStandard(dr, c); }
private static void AddParms(ref DBAccess db, KursusListe c) { var with_1 = c; db.AddInt("KursusDagID", with_1.KursusDagID); db.AddInt("KursusDeltagerID", with_1.KursusDeltagerID); db.AddInt("Status", (System.Int32)with_1.Status); AddParmsStandard(db, c); }