public List <Clubs> GetClubs() { List <Clubs> retVal = new List <Clubs>(); try { ClubsBL clubs = new ClubsBL(_connString); tblClubs = clubs.GetClubs(); if (tblClubs != null && tblClubs.Rows.Count > 0) { foreach (DataRow row in tblClubs.Rows) { Clubs club = new Clubs(_connString, Utils.DBNullToGuid(row["Club_ID"])); retVal.Add(club); } } } catch (Exception ex) { throw ex; } return(retVal); }
public Clubs(Guid club_ID) { ClubsBL clubs = new ClubsBL(); tblClubs = clubs.GetClubByClub_ID(club_ID); Club_ID = club_ID; if (!tblClubs[0].IsClub_Long_NameNull()) Club_Long_Name = tblClubs[0].Club_Long_Name; if (!tblClubs[0].IsClub_Short_NameNull()) Club_Short_Name = tblClubs[0].Club_Short_Name; if (!tblClubs[0].IsClub_ContactNull()) Club_Contact = tblClubs[0].Club_Contact; }
public bool Update_Club(Guid club_ID, Guid user_ID) { bool retVal = false; try { ClubsBL clubs = new ClubsBL(_connString); retVal = clubs.Update_Clubs(club_ID, _club_Long_Name, _club_Short_Name, _club_Contact, _deleteClub, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public Guid?Insert_Club(Guid user_ID) { Guid?retVal = null; try { ClubsBL clubs = new ClubsBL(_connString); retVal = clubs.Insert_Clubs(_club_Long_Name, _club_Short_Name, _club_Contact, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public List<Clubs> GetClubs() { List<Clubs> clubList = new List<Clubs>(); ClubsBL clubs = new ClubsBL(); tblClubs = clubs.GetClubs(); if (tblClubs != null && tblClubs.Count > 0) { foreach (sss.tblClubsRow row in tblClubs) { Clubs club = new Clubs(row.Club_ID); clubList.Add(club); } } return clubList; }
public Clubs(string connString, Guid club_ID) { _connString = connString; try { ClubsBL clubs = new ClubsBL(_connString); tblClubs = clubs.GetClubByClub_ID(club_ID); DataRow row = tblClubs.Rows[0]; _club_ID = club_ID; _club_Long_Name = Utils.DBNullToString(row["Club_Long_Name"]); _club_Short_Name = Utils.DBNullToString(row["Club_Short_Name"]); _club_Contact = Utils.DBNullToGuid(row["Club_Contact"]); } catch (Exception ex) { throw ex; } }
public bool Update_Club(Guid club_ID, Guid user_ID) { bool success = false; ClubsBL clubs = new ClubsBL(); success = clubs.Update_Clubs(club_ID, Club_Long_Name, Club_Short_Name, Club_Contact, DeleteClub, user_ID); return success; }
public Guid? Insert_Club(Guid user_ID) { ClubsBL clubs = new ClubsBL(); Guid? newID = (Guid?)clubs.Insert_Clubs(Club_Long_Name, Club_Short_Name, Club_Contact, user_ID); return newID; }