private Club(int intClubID, string strClubName, string strAdvisor, string strUmbrellaOrg, UmbrellaOrg umbrellaOrg)
{
this.IntClubID = intClubID;
this.StrClubName = strClubName;
this.StrAdvisor = strAdvisor;
this.StrUmbrellaOrg = strUmbrellaOrg;
this.UmbrellaOrg = umbrellaOrg;
}
private static Club GetClubFromDR(NpgsqlDataReader dr)
{
int id = Convert.ToInt32(dr["intClubID"]);
string strClubName = dr["strClubName"].ToString();
string strAdvisor = dr["strAdvisor"].ToString();
string strUmbrellaOrg = dr["strUmbrellaOrg"].ToString();
UmbrellaOrg umbrellaOrg = (UmbrellaOrg)Enum.Parse(typeof(UmbrellaOrg), strUmbrellaOrg, true);
Club club = Club.Of(id, strClubName, strAdvisor, strUmbrellaOrg, umbrellaOrg);
return(club);
}
public void UpdateClubs(int IntClubID, string StrClubName, string StrAdvisor, string StrUmbrellaOrg, UmbrellaOrg umbrellaOrg)
{
Club upClup = new Club
{
IntClubID = IntClubID,
StrClubName = StrClubName,
StrAdvisor = StrAdvisor,
StrUmbrellaOrg = StrUmbrellaOrg,
UmbrellaOrg = umbrellaOrg
};
bool success = ClubsDAL.UpdateClub(upClup);
}
public void InsertClubs(string StrClubName, string StrAdvisor, string StrUmbrellaOrg, UmbrellaOrg umbrellaOrg)
{
Club newClub = new Club
{
StrClubName = StrClubName,
StrAdvisor = StrAdvisor,
StrUmbrellaOrg = StrUmbrellaOrg,
UmbrellaOrg = umbrellaOrg
};
bool success = ClubsDAL.InsertClub(newClub);
}
public static Club Of(int intClubID, string strClubName, string strAdvisor, string strUmbrellaOrg, UmbrellaOrg umbrellaOrg)
{
return(new Club(intClubID, strClubName, strAdvisor, strUmbrellaOrg, umbrellaOrg));
}
