protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (Request["countryId"] != null) { int countryId = 0; if (int.TryParse(Request["countryId"], out countryId)) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { List <Match> games = db.Matches.Where(m => m.NationalTeam.Country_Id == countryId || m.NationalTeam1.Country_Id == countryId).ToList(); Repeater rptMatches = accCountry.Panes["apMatches"].FindControl("rptMatches") as Repeater; rptMatches.DataSource = games; rptMatches.DataBind(); List <UaFDatabase.Club> clubs = db.Clubs.Where(c => c.City.Country_ID == countryId).ToList(); Repeater rptClubs = accCountry.Panes["apClubs"].FindControl("rptClubs") as Repeater; rptClubs.DataSource = clubs; rptClubs.DataBind(); List <UaFDatabase.Player> players = db.Players.Where(p => p.Country_Id == countryId).OrderBy(p => p.Last_Name).ToList(); Repeater rptPlayers = accCountry.Panes["apPlayers"].FindControl("rptPlayers") as Repeater; rptPlayers.DataSource = players; rptPlayers.DataBind(); } } } }
protected void SetCompetitionStages() { using (UaFootball_DBDataContext db = DBManager.GetDB()) { BindDropdown(db, Constants.ObjectType.CompetitionStage, ddlStage, true, ddlCompetitions.SelectedValue); } }
public int SaveToDB(ClubDTO dtoObj) { Club dbObj = new Club(); using (UaFootball_DBDataContext db = DBManager.GetDB()) { if (dtoObj.Club_ID > 0) { dbObj = db.Clubs.Single(cc => cc.Club_ID == dtoObj.Club_ID); } else { db.Clubs.InsertOnSubmit(dbObj); } CopyDTOToDbObject(dtoObj, dbObj); IEnumerable <MultimediaTag> mTagsToDel = db.MultimediaTags.Where(t => t.Club_ID == dtoObj.Club_ID && t.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.ClubLogo); db.MultimediaTags.DeleteAllOnSubmit(mTagsToDel); db.SubmitChanges(); return(dbObj.Club_ID); } }
protected void Page_Load(object sender, EventArgs e) { IsNationalTeam = (Request[Constants.QueryParam.NationalTeam] != null && Request[Constants.QueryParam.NationalTeam].Equals("1")); string competitionLevelCode = IsNationalTeam ? Constants.DB.CompetitionLevelCd_NationalTeam : Constants.DB.CompetitionLevelCd_Club; if (!IsPostBack) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { ddlCompetitions.DataSource = GetGenericReferenceData(db, Constants.ObjectType.Competition).Where(grd => grd.GenericStringValue.Equals(competitionLevelCode)); ddlCompetitions.DataTextField = "Name"; ddlCompetitions.DataValueField = "Value"; ddlCompetitions.DataBind(); IEnumerable <GenericReferenceObject> seasons = GetGenericReferenceData(db, Constants.ObjectType.Season).Where(grd => grd.GenericStringValue.Equals(competitionLevelCode)); ddlSeasons.DataSource = seasons; ddlSeasons.DataTextField = "Name"; ddlSeasons.DataValueField = "Value"; ddlSeasons.DataBind(); ddlSeasons.SelectedValue = seasons.FirstOrDefault().Value.ToString(); ddlCompetitions.Items.Insert(0, new ListItem(Constants.UI.DropdownDefaultText, Constants.UI.DropdownDefaultValue)); ddlSeasons.Items.Insert(0, new ListItem(Constants.UI.DropdownDefaultText, Constants.UI.DropdownDefaultValue)); SearchParameters.Match searchParam = new SearchParameters.Match { CompetitionCode = competitionLevelCode, Season_Id = seasons.FirstOrDefault().Value }; BindData(searchParam); } } }
protected void btnDelete_Click(object sender, EventArgs e) { int multimediaId = MMId; using (UaFootball_DBDataContext db = DBManager.GetDB()) { if (multimediaId > 0) { UaFDatabase.Multimedia mm = db.Multimedias.SingleOrDefault(m => m.Multimedia_ID == multimediaId); if (mm != null) { db.MultimediaTags.DeleteAllOnSubmit(db.MultimediaTags.Where(m => m.Multimedia_ID == multimediaId)); db.Multimedias.DeleteOnSubmit(mm); string filePath = PathHelper.GetFileSystemPath(Constants.Paths.MultimediaStorageRoot, mm.FilePath, mm.FileName); if (File.Exists(filePath)) { File.Delete(filePath); } db.SubmitChanges(); } } } }
public PlayerDTO GetFromDB(int objectId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var dbData = (from player in db.Players where player.Player_Id == objectId select new { p = player, c = player.Country.Country_Name }).Single(); PlayerDTO ret = ConvertDBObjectToDTO(dbData.p); ret.Country_Name = dbData.c; ret.Multimedia = new List <MultimediaDTO>(); var dbPlayerLogos = from mt in db.MultimediaTags where mt.Player_ID == objectId && mt.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.PlayerLogo select mt.Multimedia; foreach (Multimedia m in dbPlayerLogos) { MultimediaDTO playerLogo = MultimediaDTO.FromDBObject(m); playerLogo.IsUploaded = true; ret.Multimedia.Add(playerLogo); } return(ret); } }
protected void Page_Load(object sender, EventArgs e) { AUTOPLAY = bool.FalseString.ToLower(); DEFAULT_VIDEO_URL = ""; List <VideoDTO> videosToPlay = new List <VideoDTO>(); int matchId = 0; int eventId = 0; if (Request["MatchId"] != null) { if (int.TryParse(Request["MatchId"], out matchId)) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var mm = from tag in db.MultimediaTags where tag.Match_ID == matchId && tag.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.MatchVideo select tag.Multimedia; videosToPlay = mm.Select(m => new VideoDTO { Description = m.Multimedia_ID.ToString(), URL = PathHelper.GetFullWebPath("Multimedia", m.FilePath, m.FileName) }).ToList(); } } } else { if (Request["EventId"] != null) { if (int.TryParse(Request["EventId"], out eventId)) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var mm = from tag in db.MultimediaTags where tag.MatchEvent_ID == eventId && tag.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.MatchVideo select tag.Multimedia; videosToPlay = mm.Select(m => new VideoDTO { Description = m.Multimedia_ID.ToString(), URL = PathHelper.GetFullWebPath("Multimedia", m.FilePath, m.FileName) }).ToList(); } } } } if (eventId > 0) { if (videosToPlay.Count == 1) { AUTOPLAY = bool.TrueString.ToLower(); DEFAULT_VIDEO_URL = videosToPlay[0].URL; } } else { if (videosToPlay.Count > 0) { rptVideoSelection.DataSource = videosToPlay; rptVideoSelection.DataBind(); } } }
public int SaveToDB(CountryDTO dtoObj) { Country dbObj = new Country(); using (UaFootball_DBDataContext db = DBManager.GetDB()) { if (dtoObj.Country_ID > 0) { dbObj = db.Countries.Single(cc => cc.Country_ID == dtoObj.Country_ID); } else { db.Countries.InsertOnSubmit(dbObj); NationalTeam newNationalTeam = new NationalTeam { Country = dbObj, NationalTeamType_Cd = Constants.DB.NationalTeamTypeCd_National }; NationalTeam newNationalU21Team = new NationalTeam { Country = dbObj, NationalTeamType_Cd = Constants.DB.NationalTeamTypeCd_U21 }; db.NationalTeams.InsertOnSubmit(newNationalTeam); db.NationalTeams.InsertOnSubmit(newNationalU21Team); } CopyDTOToDbObject(dtoObj, dbObj); db.SubmitChanges(); return(dbObj.Country_ID); } }
protected override void PrepareUI() { using (UaFootball_DBDataContext db = DBManager.GetDB()) { BindDropdown(db, Constants.ObjectType.Country, ddlCountries, false, string.Empty); for (int i = 1; i < 32; i++) { ddlDay.Items.Add(new ListItem(i.ToString(), i.ToString())); } string[] months = new string[12] { "Январь", "Февраль", "Март", "Апрель", "Май", "Июнь", "Июль", "Август", "Сентябрь", "Октябрь", "Ноябрь", "Декабрь" }; for (int i = 0; i < 12; i++) { ddlMonth.Items.Add(new ListItem(months[i], (i + 1).ToString())); } for (int i = DateTime.Now.Year - 62; i < DateTime.Now.Year - 15; i++) { ddlYear.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddlYear.SelectedValue = (DateTime.Now.Year - 25).ToString(); } }
protected override void PrepareUI() { using (UaFootball_DBDataContext db = DBManager.GetDB()) { BindDropdown(db, Constants.ObjectType.Country, ddlCountries, false, string.Empty); } }
protected override void PrepareUI() { using (UaFootball_DBDataContext db = DBManager.GetDB()) { BindDropdown(db, Constants.ObjectType.FIFAAssociation, ddlConfedereations, false, string.Empty); } }
public NationalTeamDTO GetFromDB(int objectId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var dbData = (from nationalTeam in db.NationalTeams join country in db.Countries on nationalTeam.Country_Id equals country.Country_ID where nationalTeam.NationalTeam_Id == objectId select new { Team = nationalTeam, CountryName = country.Country_Name }).Single(); NationalTeamDTO dtoObj = ConvertDBObjectToDTO(dbData.Team); dtoObj.Country_Name = dbData.CountryName; Multimedia mLogo = (from tag in db.MultimediaTags where tag.NationalTeam_ID == objectId && tag.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.NationalTeamLogo select tag.Multimedia).FirstOrDefault(); if (mLogo != null) { dtoObj.Logo = MultimediaDTO.FromDBObject(mLogo); dtoObj.Logo.IsUploaded = true; } return(dtoObj); } }
public List <MatchDTO> GetListFromDB(SearchParameters.Match searchParam) { List <MatchDTO> ret = new List <MatchDTO>(); using (UaFootball_DBDataContext db = DBManager.GetDB()) { var dbData = from matchData in db.vwMatches select matchData; if (searchParam.CompetitionCode != null) { dbData = dbData.Where(d => d.CompetitionLevel_Cd.Equals(searchParam.CompetitionCode)); } if (searchParam.Competition_Id > 0) { dbData = dbData.Where(d => d.Competition_Id == searchParam.Competition_Id); } if (searchParam.Season_Id > 0) { dbData = dbData.Where(d => d.Season_Id == searchParam.Season_Id); } if (searchParam.Referee_Id > 0) { dbData = dbData.Where(d => d.Referee_Id == searchParam.Referee_Id); } if (searchParam.Stadium_Id > 0) { dbData = dbData.Where(d => d.Stadium_Id == searchParam.Stadium_Id); } if (searchParam.Coach_Id > 0) { List <int> lineups = db.MatchLineups.Where(ml => ml.Coach_Id == searchParam.Coach_Id).Select(ml => ml.Match_Id).ToList(); dbData = dbData.Where(d => lineups.Contains(d.Match_ID)); } if (searchParam.Club_Id > 0) { dbData = dbData.Where(d => d.HomeClub_Id == searchParam.Club_Id || d.AwayClub_Id == searchParam.Club_Id); } if (searchParam.NationalTeam_Id > 0) { dbData = dbData.Where(d => d.HomeNationalTeam_Id == searchParam.NationalTeam_Id || d.AwayNationalTeam_Id == searchParam.NationalTeam_Id); } dbData = dbData.OrderByDescending(d => d.Date); foreach (var md in dbData) { ret.Add(ConvertDBObjectToDTO(md)); } } return(ret); }
public CityDTO GetFromDB(int objectId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { City c = db.Cities.Single(cc => cc.City_ID == objectId); return(ConvertDBObjectToDTO(c)); } }
public StadiumDTO GetFromDB(int objectId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { Stadium c = db.Stadiums.Single(cc => cc.Stadium_Id == objectId); return(ConvertDBObjectToDTO(c)); } }
public int SaveToDB(PlayerDTO dtoObj) { Player dbObj = new Player(); using (UaFootball_DBDataContext db = DBManager.GetDB()) { if (dtoObj.Player_Id > 0) { dbObj = db.Players.Single(cc => cc.Player_Id == dtoObj.Player_Id); } else { db.Players.InsertOnSubmit(dbObj); } CopyDTOToDbObject(dtoObj, dbObj); /*IEnumerable<MultimediaTag> mTagsToDel = db.MultimediaTags.Where(t => t.Player_ID == dtoObj.Player_Id && t.Multimedia.MultimediaSubType_CD == Constants.DB.MutlimediaSubTypes.PlayerLogo); * db.MultimediaTags.DeleteAllOnSubmit(mTagsToDel); * * foreach (MultimediaDTO multimedia in dtoObj.Multimedia) * { * Multimedia dbMultimedia = new Multimedia(); * multimedia.CopyDTOToDbObject(dbMultimedia); * * if (!multimedia.IsUploaded) * { * string mmRelativePath = PathHelper.GetMultimediaRelativePath(dbMultimedia); * string dropBoxFilePath = PathHelper.GetFileSystemPath(Constants.Paths.DropBoxPath, mmRelativePath, multimedia.FileName); * * FileInfo fi = new FileInfo(dropBoxFilePath); * if (fi.Exists) * { * DateTime Now = DateTime.Now; * string newFileName = string.Format("{0}{1}{2}{3}{4}{5}{6}{7}", Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second, Now.Millisecond, fi.Extension); * string newFilePath = PathHelper.GetFileSystemPath(Constants.Paths.MultimediaStorageRoot, mmRelativePath, multimedia.FileName); * * File.Copy(dropBoxFilePath, newFilePath); * * dbMultimedia.FilePath = ""; * dbMultimedia.FileName = newFileName; * } * } * * db.Multimedias.InsertOnSubmit(dbMultimedia); * * MultimediaTag newTag = new MultimediaTag(); * newTag.Multimedia = dbMultimedia; * newTag.Player = dbObj; * db.MultimediaTags.InsertOnSubmit(newTag); * * }*/ db.SubmitChanges(); return(dbObj.Player_Id); } }
protected void Page_Load(object sender, EventArgs e) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var allReferees = db.vw_RefereeLists.GroupBy(cl => cl.Country_Name).ToList(); rptCountries.DataSource = allReferees; rptCountries.DataBind(); } }
protected void tbObjectId_TextChanged(object sender, EventArgs e) { TextBox tbId = sender as TextBox; int id = 0; if (int.TryParse(tbId.Text, out id)) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { switch (ddlTagType.SelectedValue) { case _tagTypeClub: { Club c = db.Clubs.SingleOrDefault(cl => cl.Club_ID == id); if (c != null) { ListItem li = new ListItem(); li.Text = c.Club_Name; li.Value = c.Club_ID.ToString(); ddlTagValue.Items.Insert(0, li); ddlTagValue.SelectedIndex = 0; } break; } case _tagTypeGame: { vwMatch match = db.vwMatches.SingleOrDefault(m => m.Match_ID == id); if (match != null) { ListItem li = new ListItem(); li.Text = string.Format("{0} | {1} - {2}", match.Date.ToShortDateString(), match.HomeTeam, match.AwayTeam); li.Value = match.Match_ID.ToString(); ddlTagValue.Items.Insert(0, li); ddlTagValue.SelectedIndex = 0; } break; } case _tagTypePlayer: { UaFDatabase.Player p = db.Players.SingleOrDefault(m => m.Player_Id == id); if (p != null) { ListItem li = new ListItem(); li.Text = string.Format("{0} {1}", p.First_Name, p.Last_Name); li.Value = p.Player_Id.ToString(); ddlTagValue.Items.Insert(0, li); ddlTagValue.SelectedIndex = 0; } break; } } } } }
protected void Page_Load(object sender, EventArgs e) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { //var allCoaches = db.vw_CoachesLists.GroupBy(cl => cl.Country_Name).Select(cl=>new {CountryName = cl.Key, Referees = cl}).ToList(); var allCoaches = db.vw_CoachesLists.GroupBy(cl => cl.Country_Name).ToList(); var b = allCoaches.First(); rptCountries.DataSource = allCoaches; rptCountries.DataBind(); } }
public CoachDTO GetFromDB(int objectId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var dbData = (from Coach in db.Coaches where Coach.CoachId == objectId select new { p = Coach, c = Coach.Country.Country_Name }).Single(); CoachDTO ret = ConvertDBObjectToDTO(dbData.p); ret.CountryName = dbData.c; return(ret); } }
private void DeleteNote(int noteId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { MatchNote noteToDelete = db.MatchNotes.SingleOrDefault(mn => mn.MatchNote_Id == noteId); if (noteToDelete != null) { db.MatchNotes.DeleteOnSubmit(noteToDelete); } db.SubmitChanges(); } }
public RefereeDTO GetFromDB(int objectId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { var dbData = (from Referee in db.Referees where Referee.Referee_Id == objectId select new { p = Referee, c = Referee.Country.Country_Name }).Single(); RefereeDTO ret = ConvertDBObjectToDTO(dbData.p); ret.CountryName = dbData.c; return(ret); } }
protected void cbMatchKind_CheckedChanged(object sender, EventArgs e) { CheckBox cbMatchKind = sender as CheckBox; bool isNationalTeamMatch = cbMatchKind.Checked; string competitionFilter = isNationalTeamMatch ? Constants.DB.CompetitionLevelCd_NationalTeam : Constants.DB.CompetitionLevelCd_Club; using (UaFootball_DBDataContext db = new UaFootball_DBDataContext()) { BindDropdown(db, Constants.ObjectType.Competition, ddlCompetitions, true, competitionFilter); BindDropdown(db, Constants.ObjectType.Season, ddlSeasons, true, competitionFilter); } }
public List <PlayerDTO> GetFromDB(string query, Constants.QueryType qType, bool uaOnly, bool includeOnReview) { List <PlayerDTO> players = new List <PlayerDTO>(); using (UaFootball_DBDataContext db = DBManager.GetDB()) { IQueryable <Player> dbPlayers = null; if (qType == Constants.QueryType.StartsWith) { dbPlayers = from dbObj in db.Players where dbObj.Last_Name.StartsWith(query) select dbObj; } else if (qType == Constants.QueryType.All) { dbPlayers = from dbObj in db.Players select dbObj; } if (uaOnly) { dbPlayers = dbPlayers.Where(o => o.Country.Country_Code == Constants.CountryCodeUA); } if (!includeOnReview) { dbPlayers = dbPlayers.Where(o => (o.RequiresReview == null) || (o.RequiresReview == false)); } else { dbPlayers = dbPlayers.Where(o => (o.RequiresReview == true)); } var dbPlayers2 = from dbObj in dbPlayers orderby dbObj.Last_Name select new { p = dbObj, Country_Name = dbObj.Country.Country_Name }; foreach (var dbPlayer in dbPlayers2) { PlayerDTO player = ConvertDBObjectToDTO(dbPlayer.p); player.Country_Name = dbPlayer.Country_Name; players.Add(player); } } return(players); }
private int GetCountryId(bool isNationalMatch, int?teamId) { using (UaFootball_DBDataContext db = DBManager.GetDB()) { if (isNationalMatch) { return(db.NationalTeams.Single(nt => nt.NationalTeam_Id == teamId.Value).Country.Country_ID); } else { return(db.Clubs.Single(c => c.Club_ID == teamId.Value).City.Country_ID); } } }
protected void Page_Load(object sender, EventArgs e) { int matchId = 0; int playerId = 0; if (Request["MatchId"] != null) { matchId = int.Parse(Request["MatchId"]); } if (Request["PlayerId"] != null) { playerId = int.Parse(Request["PlayerId"]); } using (UaFootball_DBDataContext db = DBManager.GetDB()) { IQueryable <MatchEvent> events = null; if (playerId > 0) { //var mm = db.MultimediaTags.Where(mt=>mt.Multimedia.MultimediaType_CD == Constants.DB.MutlimediaTypes.Video && (mt.MatchEvent.Player1_Id == playerId || mt.MatchEvent.Player2_Id == playerId)); var mm = (from multimediaTag in db.MultimediaTags join multimedia in db.Multimedias on multimediaTag.Multimedia_ID equals multimedia.Multimedia_ID join matchEvent in db.MatchEvents on multimediaTag.MatchEvent_ID equals matchEvent.MatchEvent_Id join vMatch in db.vwMatches on matchEvent.Match_Id equals vMatch.Match_ID where matchEvent.Player1_Id == playerId || matchEvent.Player2_Id == playerId orderby vMatch.Date descending select new { HomeTeam = vMatch.HomeTeam, AwayTeam = vMatch.AwayTeam, VideoType = matchEvent.Event_Cd == Constants.DB.EventTypeCodes.Penalty ? "Пенальти" : matchEvent.Player1_Id == playerId ? "Гол" : "Пас", Minute = matchEvent.Minute, EventFlags = matchEvent.EventFlags, File = multimedia, EventTypeCode = matchEvent.Event_Cd, MatchDate = vMatch.Date, MatchType = vMatch.CompetitionLevel_Cd }).ToList(); foreach (var m in mm) { } rptVideos.DataSource = mm; rptVideos.DataBind(); } } }
protected void btnSearchByCountry_Click(object sender, EventArgs e) { int countryId = int.Parse(ddlCountries.SelectedValue); using (UaFootball_DBDataContext db = DBManager.GetDB()) { var playersList = from player in db.Players where player.Country_Id == countryId && !(player.RequiresReview ?? false) orderby player.Last_Name_Int, player.Last_Name select player; rptSearchPlayers.Visible = true; rptSearchPlayers.DataSource = playersList; rptSearchPlayers.DataBind(); rptDuplicates.Visible = false; rptDuplicates.DataSource = null; rptDuplicates.DataBind(); } }
public List <CityDTO> GetAllFromDB() { using (UaFootball_DBDataContext db = DBManager.GetDB()) { IEnumerable <CityDTO> cities = from city in db.Cities orderby city.Country.Country_Name, city.City_Name select new CityDTO { City_ID = city.City_ID, City_Name = city.City_Name, Country_ID = city.Country_ID, Country_Name = city.Country.Country_Name }; return(cities.ToList()); } }
protected override void PrepareUI() { bool isNationalTeamMatch = DataItem.HomeNationalTeam_Id.HasValue; string competitionFilter = isNationalTeamMatch ? Constants.DB.CompetitionLevelCd_NationalTeam : Constants.DB.CompetitionLevelCd_Club; using (UaFootball_DBDataContext db = new UaFootball_DBDataContext()) { BindDropdown(db, Constants.ObjectType.Competition, ddlCompetitions, true, competitionFilter); BindDropdown(db, Constants.ObjectType.Season, ddlSeasons, true, competitionFilter); BindDropdown(db, Constants.ObjectType.Stadium, ddlStadiums, true, string.Empty); } if (isNewObject) { tbDate.Text = FormatDate(DateTime.Now); } }
public List <CountryDTO> GetAllFromDB() { using (UaFootball_DBDataContext db = DBManager.GetDB()) { IEnumerable <CountryDTO> countries = from country in db.Countries orderby country.FIFAAssociation_ID, country.Country_Name select new CountryDTO { Country_ID = country.Country_ID, Country_Name = country.Country_Name, Country_Code = country.Country_Code, FIFAAssociation_ID = country.FIFAAssociation_ID, FIFAAssociation_Name = country.FIFAAssociation.FIFAAssociation_Name }; return(countries.ToList()); } }