protected string GetHostPhone(string HostID)
{
string phone = "Unavailable";
string ClubsConnect = ConfigurationManager.ConnectionStrings["ClubsConnect"].ToString();
MISGACLUBS cdb = new MISGACLUBS(ClubsConnect);
Clubs item = cdb.Clubs.SingleOrDefault(c => c.ClubID.Trim() == HostID.Trim());
if (item != null)
{
phone = item.ProPhone;
}
return(phone);
}
private string[] GetMixerInfo(string ClubID)
{
club = ClubID;
string ClubsConnect = ConfigurationManager.ConnectionStrings["ClubsConnect"].ToString();
MISGACLUBS cdb = new MISGACLUBS(ClubsConnect);
Clubs item = cdb.Clubs.SingleOrDefault(c => c.ClubID.Trim() == club);
if (item != null)
{
MrTimeZone etz = new MrTimeZone();
Events mixer = new Events()
{
Type = "AWAY",
Cost = "$xx",
Date = etz.eastTimeNow().AddDays(5),
Deadline = etz.eastTimeNow().AddDays(1),
PlayerLimit = 10,
Title = string.Format("View {0} | {1} display", item.ClubID, item.ClubName),
SpecialRule = "SR"
};
if (mixer.Type.ToUpper().Trim() == "AWAY")
{
_lines = fillAwayDescription(item, mixer);
}
// found club in database
}
else
{
_badID[13] = "Club " + club + " NOT found in Clubs database";
_message[1] = "Club " + club + " NOT found in Clubs database";
_lines = _message;
// club not in database
}
return(_lines);
}
private static bool clubInDatabase(string eventID)
{
bool found = false;
club = eventID.Substring(11, 3);
string ClubsConnect = ConfigurationManager.ConnectionStrings["ClubsConnect"].ToString();
MISGACLUBS cdb = new MISGACLUBS(ClubsConnect);
Clubs item = cdb.Clubs.SingleOrDefault(c => c.ClubID.Trim() == club);
if (item != null)
{
found = true;
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB mdb = new MRMISGADB(MRMISGADBConn);
Events mixer = mdb.Events.FirstOrDefault(ev => ev.EventID == eventID);
if (mixer.Type.ToUpper().Trim() == "HOME")
{
_lines = fillHomeDescription(item, mixer);
}
if (mixer.Type.ToUpper().Trim() == "AWAY")
{
_lines = fillAwayDescription(item, mixer);
}
// found club in database
}
else
{
found = false;
_badID[13] = "Club " + club + " NOT found in Clubs database";
_message[1] = "Club " + club + " NOT found in Clubs database";
_lines = _message;
// club not in database
}
return(found);
}
