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