protected void ddlTagType_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddlTagType = sender as DropDownList;
ddlTagValue.Items.Clear();
List <GenericReferenceObject> lTagValueSource = new List <GenericReferenceObject>();
switch (ddlTagType.SelectedValue)
{
case _tagTypeClub:
{
using (UaFootball_DBDataContext db = DBManager.GetDB())
{
if (ddlMultimediaSubType.SelectedValue == Constants.DB.MutlimediaSubTypes.PlayerLogo)
{
MultimediaTagDTO playerTag = TagsCache.SingleOrDefault(tc => tc.Type == _tagTypePlayer);
if (playerTag != null)
{
List <Player_GetClubsResult> clubs = db.Player_GetClubs(playerTag.Player_ID).ToList();
if (clubs != null)
{
foreach (Player_GetClubsResult club in clubs)
{
lTagValueSource.Add(new GenericReferenceObject {
Name = string.Format("{0} ({1})", club.Club, club.City), Value = club.Club_Id,
});
}
}
}
}
else
{
lTagValueSource = db.Clubs.OrderByDescending(c => c.Club_ID).Select(c => new GenericReferenceObject {
Name = c.Club_Name, GenericStringValue = c.City.City_Name, Value = c.Club_ID
}).Take(20).ToList();
foreach (GenericReferenceObject go in lTagValueSource)
{
go.Name = string.Format("{0} ({1})", go.Name, go.GenericStringValue);
}
}
}
break;
}
case _tagTypeNatTeam:
{
using (UaFootball_DBDataContext db = DBManager.GetDB())
{
if (ddlMultimediaSubType.SelectedValue == Constants.DB.MutlimediaSubTypes.PlayerLogo)
{
lTagValueSource = new List <GenericReferenceObject>();
lTagValueSource = db.NationalTeams.Where(nt => nt.NationalTeamType_Cd == Constants.DB.NationalTeamTypeCd_National && nt.Country.Country_Code == Constants.CountryCodeUA).Select(c => new GenericReferenceObject {
Name = c.Country.Country_Name, Value = c.NationalTeam_Id
}).ToList();
}
else
{
lTagValueSource = db.NationalTeams.Where(nt => nt.NationalTeamType_Cd == Constants.DB.NationalTeamTypeCd_National).OrderBy(c => c.Country.Country_Name).Select(c => new GenericReferenceObject {
Name = c.Country.Country_Name, Value = c.NationalTeam_Id
}).ToList();
}
}
break;
}
case _tagTypePlayer:
{
using (UaFootball_DBDataContext db = DBManager.GetDB())
{
List <UaFDatabase.Player> lPlayers = new List <UaFDatabase.Player>();
if (ddlMultimediaSubType.SelectedValue == Constants.DB.MutlimediaSubTypes.PlayerLogo)
{
lPlayers = db.Players.OrderByDescending(c => c.Player_Id).Take(50).OrderBy(p => p.Last_Name).ToList();
foreach (UaFDatabase.Player p in lPlayers)
{
string fName = p.First_Name ?? "";
string lName = p.Last_Name ?? "";
string dName = string.IsNullOrEmpty(p.Display_Name) ? "" : string.Concat("(", p.Display_Name, ")");
string name = Regex.Replace(string.Concat(fName, " ", lName, " ", dName), @"\s+", " ");
lTagValueSource.Add(new GenericReferenceObject {
Name = name, Value = p.Player_Id
});
}
}
else
{
MultimediaTagDTO matchTag = TagsCache.SingleOrDefault(tc => tc.Type == _tagTypeGame);
if (matchTag != null)
{
vwMatch match = db.vwMatches.Single(v => v.Match_ID == matchTag.Match_ID);
bool homeTeamPriority = match.HomeTeamCountryCode == Constants.CountryCodeUA;
var players = from matchLineup in db.MatchLineups
where matchLineup.Match_Id == matchTag.Match_ID && matchLineup.Player_Id != null
select new { Player = matchLineup.Player, IsHomeTeam = matchLineup.IsHomeTeamPlayer, IsSubstitute = matchLineup.IsSubstitute, No = matchLineup.ShirtNumber };
if (homeTeamPriority)
{
players = players.OrderByDescending(pl => pl.IsHomeTeam).ThenBy(pl => pl.No);
}
else
{
players = players.OrderBy(pl => pl.IsHomeTeam).ThenBy(pl => pl.No);
}
foreach (var player in players)
{
GenericReferenceObject go = new GenericReferenceObject();
go.Name = string.Format("{0} - {1}", player.No.ToString().PadLeft(2, ' '), FormatName(player.Player.First_Name, player.Player.Last_Name, player.Player.Display_Name, player.Player.Country_Id));
go.Value = player.Player.Player_Id;
lTagValueSource.Add(go);
}
}
}
}
break;
}
case _tagTypeGame:
{
using (UaFootball_DBDataContext db = DBManager.GetDB())
{
var lst = (from match in db.vwMatches orderby match.Match_ID descending select match).Take(50);
lTagValueSource = lst.Select(l => new GenericReferenceObject {
Name = string.Format("{0} | {1} - {2}", l.Date.ToShortDateString(), l.HomeTeam, l.AwayTeam), Value = l.Match_ID
}).ToList();
}
break;
}
case _tagTypeEvent:
{
MultimediaTagDTO matchTag = TagsCache.SingleOrDefault(tc => tc.Type == _tagTypeGame);
if (matchTag != null)
{
using (UaFootball_DBDataContext db = DBManager.GetDB())
{
DataLoadOptions opt = new DataLoadOptions();
opt.LoadWith <MatchEvent>(me => me.Player1);
List <UaFDatabase.MatchEvent> events = db.MatchEvents.Where(me => me.Match_Id == matchTag.Match_ID).OrderBy(me => me.Event_Cd).ThenBy(me => me.Minute).ToList();
foreach (UaFDatabase.MatchEvent mEvent in events)
{
GenericReferenceObject go = new GenericReferenceObject();
go.Name = string.Format("{0} мин - {1} - {2}", mEvent.Minute, UIHelper.EventCodeMap[mEvent.Event_Cd], FormatName(mEvent.Player.First_Name, mEvent.Player.Last_Name, mEvent.Player.Display_Name, mEvent.Player.Country_Id));
go.Value = mEvent.MatchEvent_Id;
go.GenericStringValue = mEvent.Event_Cd;
lTagValueSource.Add(go);
}
}
}
break;
}
}
ddlTagValue.Items.Clear();
foreach (GenericReferenceObject o in lTagValueSource)
{
ListItem li = new ListItem(o.Name, o.Value.ToString());
li.Attributes.Add("eventType", o.GenericStringValue);
ddlTagValue.Items.Add(li);
}
}
