Beispiel #1
0
        public string GetSavedSearches(string DBConnectionString, SaveSearchesRequestData objSavedSearchData)
        {
            string response = string.Empty;

            try
            {
                DataSet _objDsSearch = new DataSet();
                _objDsSearch = DBTask.ExecuteDataset(DBConnectionString, "dh_cl_get_search", objSavedSearchData.SportId, objSavedSearchData.UserId == 0 ? null : objSavedSearchData.UserId, objSavedSearchData.SearchTypeId);
                if (_objDsSearch.Tables != null && _objDsSearch.Tables.Count > 0)
                {
                    response = JSONHelper.FromDataTable(_objDsSearch.Tables[0]);
                }
            }
            catch (Exception ex)
            {
                response = ex.ToString();
            }
            return(response);
        }
Beispiel #2
0
        public List <SearchCricketData> getCricketData(string DBConnectionString, bool isFullDownload = true, int FullBatchCounter = 1, int FullRowCount = 0)
        {
            // public static string DBConnectionString { get { return ConfigurationManager.ConnectionStrings[GlobalInfo.DBSchemeName].ConnectionString; } }

            //string DBConnectionString;
            int FullDownloadFlag = isFullDownload ? 1 : 0;
            List <SearchCricketData> _objLstData = new List <SearchCricketData>();

            try
            {
                DataSet _objDsSearch = new DataSet();
                switch (isFullDownload)
                {
                case true:
                    _objDsSearch = DBTask.ExecuteDataset(DBConnectionString, "dh_s1_data_search_full", 1, FullDownloadFlag, FullBatchCounter, FullRowCount);
                    break;

                case false:
                    _objDsSearch = DBTask.ExecuteDataset(DBConnectionString, "dh_s1_data_search", 1, FullDownloadFlag);
                    break;
                }


                if (_objDsSearch.Tables != null && _objDsSearch.Tables.Count > 0)
                {
                    SearchCricketData _objSearchData;
                    foreach (DataRow rowitem in _objDsSearch.Tables[0].Rows)
                    {
                        _objSearchData              = new SearchCricketData();
                        _objSearchData.Id           = Convert.ToString(rowitem["s_id"]);
                        _objSearchData.RId          = Convert.ToString(rowitem["Row_Id"]);
                        _objSearchData.MatchId      = Convert.ToString(rowitem["match_id"]);
                        _objSearchData.MarkIn       = Convert.ToString(rowitem["markin_timecode"]);
                        _objSearchData.MarkOut      = Convert.ToString(rowitem["markout_timecode"]);
                        _objSearchData.ShortMarkIn  = Convert.ToString(rowitem["markin_short"]);
                        _objSearchData.ShortMarkOut = Convert.ToString(rowitem["markout_short"]);
                        _objSearchData.ClearId      = Convert.ToString(rowitem["clear_id"]).Trim();
                        _objSearchData.QClearId     = Convert.ToString(rowitem["clear_id"]).Replace("-", string.Empty);
                        _objSearchData.MediaId      = Convert.ToString(rowitem["media_id"]);
                        _objSearchData.CompType     = Convert.ToString(rowitem["comp_type"]);
                        _objSearchData.VenueId      = Convert.ToString(rowitem["venue_id"]);
                        _objSearchData.Venue        = Convert.ToString(rowitem["venue_name"]);
                        _objSearchData.SeriesId     = Convert.ToString(rowitem["series_id"]);
                        _objSearchData.Series       = Convert.ToString(rowitem["series_name"]);
                        //_objSearchData.MatchDate = Convert.ToString(rowitem["matchdate"]) != string.Empty ? Convert.ToDateTime(rowitem["matchdate"]).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture) : string.Empty;
                        _objSearchData.MatchDate         = Convert.ToString(rowitem["event_date"]) != "" ? int.Parse(Convert.ToDateTime(rowitem["event_date"]).ToString("yyyyMMdd", CultureInfo.InvariantCulture)) : 0;
                        _objSearchData.Team1Id           = Convert.ToString(rowitem["team1_id"]);
                        _objSearchData.Team1             = Convert.ToString(rowitem["team1"]);
                        _objSearchData.Team2Id           = Convert.ToString(rowitem["team2_id"]);
                        _objSearchData.Team2             = Convert.ToString(rowitem["team2"]);
                        _objSearchData.BatsmanId         = Convert.ToString(rowitem["batsman_id"]);
                        _objSearchData.Batsman           = Convert.ToString(rowitem["batsman"]);
                        _objSearchData.BowlerId          = Convert.ToString(rowitem["bowler_id"]);
                        _objSearchData.Bowler            = Convert.ToString(rowitem["bowler"]);
                        _objSearchData.FielderId         = Convert.ToString(rowitem["fielder_id"]);
                        _objSearchData.Fielder           = Convert.ToString(rowitem["fielder"]);
                        _objSearchData.ShotTypeId        = Convert.ToString(rowitem["shot_typeid"]);
                        _objSearchData.ShotType          = Convert.ToString(rowitem["shot_type"]);
                        _objSearchData.ShotZoneId        = Convert.ToString(rowitem["zone_id"]);
                        _objSearchData.ShotZone          = Convert.ToString(rowitem["zone_name"]);
                        _objSearchData.DeliveryTypeId    = Convert.ToString(rowitem["DeliveryTypeID"]);
                        _objSearchData.DeliveryType      = Convert.ToString(rowitem["DeliveryTypeName"]);
                        _objSearchData.DismissalId       = Convert.ToString(rowitem["dismissal_id"]);
                        _objSearchData.Dismissal         = Convert.ToString(rowitem["dismissal"]);
                        _objSearchData.RunsSaved         = Convert.ToString(rowitem["runssaved"]);
                        _objSearchData.RunsConceeded     = Convert.ToString(rowitem["runsconceded"]);
                        _objSearchData.BowlingLineId     = Convert.ToString(rowitem["line_id"]);
                        _objSearchData.BowlingLine       = Convert.ToString(rowitem["pitching_line"]);
                        _objSearchData.BowlingLengthId   = Convert.ToString(rowitem["length_id"]);
                        _objSearchData.BowlingLength     = Convert.ToString(rowitem["pitching_length"]);
                        _objSearchData.OverNo            = Convert.ToString(rowitem["OverNumber"]);
                        _objSearchData.BallNo            = Convert.ToString(rowitem["BallNumber"]);
                        _objSearchData.Runs              = Convert.ToString(rowitem["RunsScored"]);
                        _objSearchData.IsFour            = Convert.ToString(rowitem["is_four"]);
                        _objSearchData.IsSix             = Convert.ToString(rowitem["is_six"]);
                        _objSearchData.IsDot             = Convert.ToString(rowitem["is_dot"]);
                        _objSearchData.IsBeaten          = Convert.ToString(rowitem["is_beaten"]);
                        _objSearchData.IsEdged           = Convert.ToString(rowitem["Edge"]);
                        _objSearchData.IsWide            = Convert.ToString(rowitem["is_wide"]);
                        _objSearchData.IsNoBall          = Convert.ToString(rowitem["is_NoBall"]);
                        _objSearchData.IsOverTheWicket   = Convert.ToString(rowitem["is_over_tw"]);
                        _objSearchData.IsRoundTheWicket  = Convert.ToString(rowitem["is_round_tw"]);
                        _objSearchData.Skill             = Convert.ToString(rowitem["skill"]);
                        _objSearchData.IsCatch           = Convert.ToString(rowitem["is_catch"]);
                        _objSearchData.IsRunOut          = Convert.ToString(rowitem["Is_runout"]);
                        _objSearchData.IsDropped         = Convert.ToString(rowitem["Is_Dropped"]);
                        _objSearchData.FielderPositionId = Convert.ToString(rowitem["position_id"]);
                        _objSearchData.FielderPosition   = Convert.ToString(rowitem["FielderPosition"]);
                        _objSearchData.SType             = Convert.ToString(rowitem["s_type"]);
                        _objSearchData.Title             = Convert.ToString(rowitem["title"]);
                        _objSearchData.Description       = Convert.ToString(rowitem["description"]);
                        _objSearchData.Duration          = Convert.ToString(rowitem["duration"]);
                        _objSearchData.RunsSaved         = Convert.ToString(rowitem["runssaved"]);

                        _objSearchData.Innings             = Convert.ToString(rowitem["InningsNumber"]);
                        _objSearchData.MatchInstance       = string.Empty;
                        _objSearchData.BatsmanRuns         = Convert.ToString(rowitem["batsmanRuns"]) != string.Empty ? Convert.ToInt32(rowitem["batsmanRuns"]) : 0;
                        _objSearchData.BatsmanBallsFaced   = Convert.ToString(rowitem["batsmanBalls"]) != string.Empty ? Convert.ToInt32(rowitem["batsmanBalls"]) : 0;
                        _objSearchData.MatchResult         = Convert.ToString(rowitem["result"]);
                        _objSearchData.Winner              = Convert.ToString(rowitem["Winner"]);
                        _objSearchData.Loser               = Convert.ToString(rowitem["Loser"]);
                        _objSearchData.BowlerBallsBowled   = Convert.ToString(rowitem["BallsBowledByBowler"]) != string.Empty ? Convert.ToInt32(rowitem["BallsBowledByBowler"]) : 0;
                        _objSearchData.BowlerRunsConceeded = Convert.ToString(rowitem["RunsConcededByBowler"]) != string.Empty ? Convert.ToInt32(rowitem["RunsConcededByBowler"]) : 0;
                        _objSearchData.BowlerWickets       = Convert.ToString(rowitem["wicketsofbowler"]) != string.Empty ? Convert.ToInt32(rowitem["wicketsofbowler"]) : 0;
                        _objSearchData.TeamScore           = Convert.ToString(rowitem["TeamScore"]) != string.Empty ? Convert.ToInt32(rowitem["TeamScore"]) : 0;
                        _objSearchData.TeamOver            = Convert.ToString(rowitem["TeamOver"]) != string.Empty ? Convert.ToInt32(rowitem["TeamOver"]) : 0;

                        _objSearchData.WinnerPlayer   = Convert.ToString(rowitem["WinnerPlayer"]);
                        _objSearchData.LoserPlayer    = Convert.ToString(rowitem["LoserPlayer"]);
                        _objSearchData.WinningFielder = Convert.ToString(rowitem["WinningFielder"]);

                        _objSearchData.IsPowerPlayOver = Convert.ToString(rowitem["IsPowerPlayOver"]) != string.Empty ? Convert.ToString(Convert.ToInt32(rowitem["IsPowerPlayOver"])) : "0";
                        _objSearchData.is_middle       = Convert.ToString(rowitem["is_middle"]);
                        _objSearchData.is_death        = Convert.ToString(rowitem["is_death"]);
                        _objSearchData.is_lastover     = Convert.ToString(rowitem["is_lastover"]);
                        _objSearchData.is_lastBall     = Convert.ToString(rowitem["is_lastBall"]);

                        _objSearchData.ParentSeriesId = Convert.ToString(rowitem["parent_series_id"]);
                        _objSearchData.IsAsset        = Convert.ToString(rowitem["is_asset"]);

                        _objSearchData.IsWicket = Convert.ToString(rowitem["is_wicket"]);
                        _objSearchData.IsAppeal = Convert.ToString(rowitem["is_appeal"]);

                        _objSearchData.HasShortClip = Convert.ToString(rowitem["has_short_clip"]);
                        _objSearchData.EventId      = Convert.ToString(rowitem["event_id"]);
                        _objSearchData.EventText    = Convert.ToString(rowitem["event_text"]);

                        _objSearchData.IsTagged         = Convert.ToString(rowitem["is_tagged"]);
                        _objSearchData.Match            = Convert.ToString(rowitem["game_event_name"]);
                        _objSearchData.ParentSeriesName = Convert.ToString(rowitem["parent_series_name"]);
                        _objSearchData.IsMisField       = Convert.ToString(rowitem["is_misfield"]);
                        _objSearchData.AssetTypeId      = Convert.ToString(rowitem["asset_type_id"]);
                        _objSearchData.ClearId2         = Convert.ToString(rowitem["clear_id_2"]);
                        _objSearchData.QClearId2        = Convert.ToString(rowitem["clear_id_2"]).Replace("-", string.Empty);
                        _objSearchData.ClearId3         = Convert.ToString(rowitem["clear_id_3"]);
                        _objSearchData.QClearId3        = Convert.ToString(rowitem["clear_id_3"]).Replace("-", string.Empty);
                        _objSearchData.ClearId4         = Convert.ToString(rowitem["clear_id_4"]);
                        _objSearchData.QClearId4        = Convert.ToString(rowitem["clear_id_4"]).Replace("-", string.Empty);
                        _objSearchData.ClearId5         = Convert.ToString(rowitem["clear_id_5"]);
                        _objSearchData.QClearId5        = Convert.ToString(rowitem["clear_id_5"]).Replace("-", string.Empty);
                        _objSearchData.ClearId6         = Convert.ToString(rowitem["clear_id_6"]);
                        _objSearchData.QClearId6        = Convert.ToString(rowitem["clear_id_6"]).Replace("-", string.Empty);

                        _objSearchData.MediaId2     = Convert.ToString(rowitem["media_id_2"]);
                        _objSearchData.MediaId3     = Convert.ToString(rowitem["media_id_3"]);
                        _objSearchData.MediaId4     = Convert.ToString(rowitem["media_id_4"]);
                        _objSearchData.MediaId5     = Convert.ToString(rowitem["media_id_5"]);
                        _objSearchData.MediaId6     = Convert.ToString(rowitem["media_id_6"]);
                        _objSearchData.LanguageId   = Convert.ToString(rowitem["language_id"]);
                        _objSearchData.Language     = Convert.ToString(rowitem["language"]);
                        _objSearchData.BattingOrder = Convert.ToString(rowitem["batting_order_no"]);
                        _objSearchData.BowlingArm   = Convert.ToString(rowitem["Bowling_arm"]);

                        _objSearchData.CF_Batsman = new CompletionField
                        {
                            Input = new[] { Convert.ToString(rowitem["batsman"]) }
                        };
                        _objSearchData.CF_Bowler = new CompletionField
                        {
                            Input = new[] { Convert.ToString(rowitem["bowler"]) }
                        };
                        _objSearchData.batsmanddl = Convert.ToString(rowitem["batsman"]) + "|" + Convert.ToString(rowitem["batsman_id"]);
                        _objSearchData.bowlerddl  = Convert.ToString(rowitem["bowler"]) + "|" + Convert.ToString(rowitem["bowler_id"]);

                        _objLstData.Add(_objSearchData);
                        _objSearchData = null;
                    }
                }
            }

            catch (Exception ex)
            {
                //ErrorLog.LogServiceError("SearchDAO.cs", "GetSearchS1DataForCricket", ex.ToString());
            }
            return(_objLstData);
        }
Beispiel #3
0
        public List <SearchS2Data> GetAllSearchS2Data(string DBConnectionString, int SportId, bool isFullDownload = true)
        {
            int FullDownloadFlag            = isFullDownload ? 1 : 0;
            List <SearchS2Data> _objLstData = new List <SearchS2Data>();

            try
            {
                DataSet _objDsSearch = new DataSet();

                _objDsSearch = DBTask.ExecuteDataset(DBConnectionString, "dh_s2_data_search_enhanced", SportId, FullDownloadFlag);
                //  _objDsSearch = DBTask.ExecuteDataset(DBConnectionString, "dh_s2_data_search", SportId, FullDownloadFlag);
                if (_objDsSearch.Tables != null && _objDsSearch.Tables.Count > 0)
                {
                    foreach (DataRow rowitem in _objDsSearch.Tables[0].Rows)
                    {
                        SearchS2Data _objSearchData = new SearchS2Data();
                        _objSearchData.Id      = Convert.ToString(rowitem["s_id"]);
                        _objSearchData.RId     = Convert.ToInt64(rowitem["s_id"]);
                        _objSearchData.MatchId = Convert.ToString(rowitem["match_id"]);
                        //_objSearchData.Match = Convert.ToString(rowitem["match_name"]);
                        _objSearchData.MarkIn   = Convert.ToString(rowitem["mark_in"]);
                        _objSearchData.MarkOut  = Convert.ToString(rowitem["mark_out"]);
                        _objSearchData.ClearId  = Convert.ToString(rowitem["clear_id"]).Trim();
                        _objSearchData.QClearId = Convert.ToString(rowitem["clear_id"]).Replace("-", string.Empty);
                        _objSearchData.MediaId  = Convert.ToString(rowitem["media_id"]);
                        _objSearchData.CompType = Convert.ToString(rowitem["comp_type"]);
                        _objSearchData.VenueId  = Convert.ToString(rowitem["venue_id"]);
                        _objSearchData.Venue    = Convert.ToString(rowitem["venue_name"]);
                        _objSearchData.SeriesId = Convert.ToString(rowitem["series_id"]);
                        _objSearchData.Series   = Convert.ToString(rowitem["series_name"]);
                        //_objSearchData.MatchDate = Convert.ToString(rowitem["matchdate"]) != string.Empty ? Convert.ToDateTime(rowitem["matchdate"]).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture) : string.Empty;
                        _objSearchData.MatchDate             = Convert.ToString(rowitem["event_date"]) != "" ? int.Parse(Convert.ToDateTime(rowitem["event_date"]).ToString("yyyyMMdd", CultureInfo.InvariantCulture)) : 0;
                        _objSearchData.MatchStageId          = Convert.ToString(rowitem["match_stage_id"]);
                        _objSearchData.MatchStage            = Convert.ToString(rowitem["match_stage"]);
                        _objSearchData.Team1Id               = Convert.ToString(rowitem["team1_id"]);
                        _objSearchData.Team1                 = Convert.ToString(rowitem["team1"]);
                        _objSearchData.Team2Id               = Convert.ToString(rowitem["team2_id"]);
                        _objSearchData.Team2                 = Convert.ToString(rowitem["team2"]);
                        _objSearchData.Attribute_Id_Level1   = Convert.ToString(rowitem["attribute_id_level_1"]);
                        _objSearchData.Attribute_Name_Level1 = Convert.ToString(rowitem["attribute_name_level_1"]);
                        _objSearchData.Attribute_Id_Level2   = Convert.ToString(rowitem["attribute_id_level_2"]);
                        _objSearchData.Attribute_Name_Level2 = Convert.ToString(rowitem["attribute_name_level_2"]);
                        _objSearchData.Attribute_Id_Level3   = Convert.ToString(rowitem["attribute_id_level_3"]);
                        _objSearchData.Attribute_Name_Level3 = Convert.ToString(rowitem["attribute_name_level_3"]);
                        _objSearchData.Attribute_Id_Level4   = Convert.ToString(rowitem["attribute_id_level_4"]);
                        _objSearchData.Attribute_Name_Level4 = Convert.ToString(rowitem["attribute_name_level_4"]);
                        _objSearchData.EmotionId             = Convert.ToString(rowitem["emotion_id"]) != string.Empty ? Convert.ToString(Convert.ToInt32(rowitem["emotion_id"])) : "0";
                        _objSearchData.EmotionName           = Convert.ToString(rowitem["emotion_name"]);
                        //_objSearchData.EntityName = Convert.ToString(rowitem["entity_name"]);
                        _objSearchData.EntityName_1   = Convert.ToString(rowitem["entity_1"]);
                        _objSearchData.EntityName_2   = Convert.ToString(rowitem["entity_2"]);
                        _objSearchData.EntityName_3   = Convert.ToString(rowitem["entity_3"]);
                        _objSearchData.EntityName_4   = Convert.ToString(rowitem["entity_4"]);
                        _objSearchData.EntityName_5   = Convert.ToString(rowitem["entity_5"]);
                        _objSearchData.EntityId_1     = Convert.ToString(rowitem["entity_1_id"]);
                        _objSearchData.EntityId_2     = Convert.ToString(rowitem["entity_2_id"]);
                        _objSearchData.EntityId_3     = Convert.ToString(rowitem["entity_3_id"]);
                        _objSearchData.EntityId_4     = Convert.ToString(rowitem["entity_4_id"]);
                        _objSearchData.EntityId_5     = Convert.ToString(rowitem["entity_5_id"]);
                        _objSearchData.ParentSeriesId = Convert.ToString(rowitem["parent_series_id"]);
                        _objSearchData.IsAsset        = Convert.ToString(rowitem["is_asset"]);
                        _objSearchData.IsBigMoment    = Convert.ToString(rowitem["is_big_moment"]) != string.Empty ? Convert.ToString(Convert.ToInt32(rowitem["is_big_moment"])) : "0";
                        _objSearchData.IsFunnyMoment  = Convert.ToString(rowitem["is_funny_moment"]) != string.Empty ? Convert.ToString(Convert.ToInt32(rowitem["is_funny_moment"])) : "0";
                        _objSearchData.IsAudioPiece   = Convert.ToString(rowitem["is_audio_piece"]) != string.Empty ? Convert.ToString(Convert.ToInt32(rowitem["is_audio_piece"])) : " 0";
                        _objSearchData.Title          = Convert.ToString(rowitem["title"]);
                        _objSearchData.Description    = Convert.ToString(rowitem["description"]);
                        _objSearchData.Duration       = Convert.ToString(rowitem["duration"]);
                        _objSearchData.ClearId2       = Convert.ToString(rowitem["clear_id_2"]);
                        _objSearchData.MediaId2       = Convert.ToString(rowitem["media_id_2"]);
                        _objSearchData.IsTagged       = Convert.ToString(Convert.ToInt32(rowitem["is_tagged"]));
                        _objSearchData.LanguageId     = Convert.ToString(rowitem["language_id"]);
                        _objSearchData.Language       = Convert.ToString(rowitem["language"]);;
                        _objSearchData.SType          = Convert.ToString(rowitem["s_type"]);//new
                        _objSearchData.EventId        = _objSearchData.IsBigMoment == "1" ? "5" : _objSearchData.IsFunnyMoment == "1" ? "6" : _objSearchData.IsAudioPiece == "1" ? "12" : "0";
                        _objSearchData.EventText      = _objSearchData.IsBigMoment == "1" ? "BM" : _objSearchData.IsFunnyMoment == "1" ? "FM" : _objSearchData.IsAudioPiece == "1" ? "AP" : "";
                        _objSearchData.SportId        = SportId;
                        _objLstData.Add(_objSearchData);
                    }
                }
            }

            catch (Exception ex)
            {
                //ErrorLog.LogServiceError("SearchDAO.cs", "GetAllSearchS2Data", ex.ToString());
            }
            return(_objLstData);
        }