protected void Search_Click(object sender, EventArgs e) { string oracleConnectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString; OracleConnection con = new OracleConnection(oracleConnectionString); int ab = con.ConnectionTimeout; try { string query = QueryBuilderClass.BowlerQueryBuilder(DropTeam, EconomyDrop, Wickets_Taken, Name); OracleCommand cmd = new OracleCommand(query, con); con.Open(); OracleConnection.ClearAllPools(); OracleDataReader rdr = cmd.ExecuteReader(); BowlerSearchRes.DataSource = rdr; BowlerSearchRes.DataBind(); } catch (OracleException ex) { Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex); } finally { con.Close(); } }
protected void BatsmanSearch_Click(object sender, EventArgs e) { string oracleConnectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString; OracleConnection con = new OracleConnection(oracleConnectionString); try { string query = QueryBuilderClass.BatsmanQueryBuilder(BattingTeamNameDropDown, BattingAverageDropDown, BattingStrikeRateDropDown, BatsmanNameTextBox); OracleCommand cmd = new OracleCommand(query, con); con.Open(); OracleDataReader rdr = cmd.ExecuteReader(); BatsmanSearchResult.DataSource = rdr; BatsmanSearchResult.DataBind(); } catch (OracleException ex) { Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex); } finally { con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { string bowlerName = (string)Session["BowlerName"]; BowlerPageHeading.Text = BowlerPageHeading.Text + " : " + bowlerName; Dictionary <string, string> bowlerDetailsQueryMap = QueryBuilderClass.BowlerDetailsQueryBuilder(bowlerName); string oracleConnectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString; OracleConnection con = new OracleConnection(oracleConnectionString); try { con.Open(); foreach (string query in bowlerDetailsQueryMap.Values) { //string query1 = "select * from (select batsman, bowler, sixes, fours, sixes + fours as total_boundaries from (select s.strike_bat as batsman, s.bowler as bowler, s.sixes as sixes, f.fours as fours from( select strike_bat, bowler, count(run_scored)as sixes from ball_by_ball where run_scored = '6' group by strike_bat, bowler) s, (select strike_bat, bowler, count(run_scored)as fours from ball_by_ball where run_scored = '4' group by strike_bat, bowler) f where s.strike_bat = f.strike_bat and s.bowler = f.bowler) order by total_boundaries desc, sixes desc, fours desc) all_data where ROWNUM = 1 AND Bowler = 'P Kumar'"; //string query = "select * from (select bowler, max(wickets) as wickets, min(runs_conceded) as runs_conceded from (select x.season as season, x.match_id as match_id, x.bowler as bowler, x.wickets as wickets, y.runs_conceded as runs_conceded from(select season, match_id, bowler, count(out_decision) as wickets from ball_by_ball where out_decision != '*' group by season, match_id, bowler) x, (select season, match_id, bowler, sum(run_scored) as runs_conceded from ball_by_ball group by season, match_id, bowler) y where x.season = y.season and x.match_id = y.match_id and x.bowler = y.bowler) group by bowler order by wickets desc, runs_conceded asc) all_data where Bowler = '" + bowlerName + "'"; OracleCommand cmd = new OracleCommand(query, con); OracleDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { if (query == bowlerDetailsQueryMap["wicketsRunsQuery"]) { while (rdr.Read()) { WicketsLabel.Text = rdr.GetInt32(1).ToString(); RunsConcededLabel.Text = rdr.GetInt32(2).ToString(); } } if (query == bowlerDetailsQueryMap["boundariesAgainstQuery"]) { while (rdr.Read()) { WorstBatsmanLabel.Text = rdr.GetString(0); SixesLabel.Text = rdr.GetInt32(2).ToString(); FoursLabel.Text = rdr.GetInt32(3).ToString(); } } if (query == bowlerDetailsQueryMap["bowlerAllRecordsQuery"]) { while (rdr.Read()) { WicketsLabel2.Text = rdr.GetInt32(1).ToString(); RunsConcededLabel2.Text = rdr.GetInt32(2).ToString(); BallsBowledLabel.Text = rdr.GetInt32(3).ToString(); AverageLabel.Text = rdr.GetFloat(4).ToString(); StrikeRateLabel.Text = rdr.GetFloat(5).ToString(); EconomyRateLabel.Text = rdr.GetFloat(6).ToString(); } } if (query == bowlerDetailsQueryMap["bestBatsmanQuery"]) { while (rdr.Read()) { BestBatsmanLabel.Text = rdr.GetString(1); BestBatsmanWicketsLabel.Text = rdr.GetInt32(2).ToString(); } } if (query == bowlerDetailsQueryMap["bowledWicketsQuery"]) { while (rdr.Read()) { BowledLabel.Text = rdr.GetInt32(1).ToString(); } } if (query == bowlerDetailsQueryMap["inningFourConcededQuery"]) { while (rdr.Read()) { inningFourLabel.Text = rdr.GetInt32(4).ToString(); } } if (query == bowlerDetailsQueryMap["inningSixConcededQuery"]) { while (rdr.Read()) { inningSixLabel.Text = rdr.GetInt32(4).ToString(); } } //if (query == bowlerDetailsQueryMap["seasonBestQuery"]) //{ // seasonWicketsLabel.Text = rdr.GetInt32(2).ToString(); //} } } } catch (OracleException ex) { Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex); } finally { con.Close(); } }
protected void DropTeam_SelectedIndexChanged(object sender, EventArgs e) { TeamDetailsDiv.Visible = true; TeamNameLabel.Text = DropTeam.SelectedItem.Text; string team = DropTeam.SelectedItem.Text; Dictionary <string, string> teamDetailsQueryMap = QueryBuilderClass.TeamDetailsQueryBuilder(team); string oracleConnectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString; OracleConnection con = new OracleConnection(oracleConnectionString); try { con.Open(); foreach (string query in teamDetailsQueryMap.Values) { OracleCommand cmd = new OracleCommand(query, con); OracleDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { if (query == teamDetailsQueryMap["winPercentage"]) { while (rdr.Read()) { winNumberLabel.Text = rdr.GetInt32(1).ToString(); loseNumberLabel.Text = rdr.GetInt32(2).ToString(); winPercentageLabel.Text = rdr.GetFloat(3).ToString(); } } if (query == teamDetailsQueryMap["winPercentageChasingMatch"]) { while (rdr.Read()) { successfulChasesLabel.Text = rdr.GetInt32(1).ToString(); failedChasesLabel.Text = rdr.GetInt32(2).ToString(); winPercentageAfterTossWin.Text = rdr.GetFloat(3).ToString(); } } if (query == teamDetailsQueryMap["totalNumberOfAllOuts"]) { while (rdr.Read()) { totalNumberOfAllOutsLabel.Text = rdr.GetInt32(1).ToString(); } } if (query == teamDetailsQueryMap["homeGroundQuery"]) { while (rdr.Read()) { homeWinsLabel.Text = rdr.GetInt32(1).ToString(); homeLoseLabel.Text = rdr.GetInt32(2).ToString(); homeWinPercentageLabels.Text = rdr.GetFloat(3).ToString(); } } if (query == teamDetailsQueryMap["maxBoundariesByATeam"]) { while (rdr.Read()) { maxBoundariesInningsLabel.Text = rdr.GetInt32(4).ToString(); } } if (query == teamDetailsQueryMap["highestRunsScored"]) { while (rdr.Read()) { highestRunsScoredLabel.Text = rdr.GetInt32(4).ToString(); SeasonLabel.Text = rdr.GetString(0); } } } } } catch (OracleException ex) { Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex); } finally { con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { string batsmanName = (string)Session["BatsmanName"]; BatsmanPageHeading.Text = BatsmanPageHeading.Text + " : " + batsmanName; Dictionary <string, string> batsmanDetailsQueryMap = QueryBuilderClass.BatsmanDetailsQueryBuilder(batsmanName); string oracleConnectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString; OracleConnection con = new OracleConnection(oracleConnectionString); try { con.Open(); foreach (string query in batsmanDetailsQueryMap.Values) { //string query1 = "select * from (select batsman, bowler, sixes, fours, sixes + fours as total_boundaries from (select s.strike_bat as batsman, s.bowler as bowler, s.sixes as sixes, f.fours as fours from( select strike_bat, bowler, count(run_scored)as sixes from ball_by_ball where run_scored = '6' group by strike_bat, bowler) s, (select strike_bat, bowler, count(run_scored)as fours from ball_by_ball where run_scored = '4' group by strike_bat, bowler) f where s.strike_bat = f.strike_bat and s.bowler = f.bowler) order by total_boundaries desc, sixes desc, fours desc) all_data where ROWNUM = 1 AND Bowler = 'P Kumar'"; //string query = "select * from (select bowler, max(wickets) as wickets, min(runs_conceded) as runs_conceded from (select x.season as season, x.match_id as match_id, x.bowler as bowler, x.wickets as wickets, y.runs_conceded as runs_conceded from(select season, match_id, bowler, count(out_decision) as wickets from ball_by_ball where out_decision != '*' group by season, match_id, bowler) x, (select season, match_id, bowler, sum(run_scored) as runs_conceded from ball_by_ball group by season, match_id, bowler) y where x.season = y.season and x.match_id = y.match_id and x.bowler = y.bowler) group by bowler order by wickets desc, runs_conceded asc) all_data where Bowler = '" + bowlerName + "'"; OracleCommand cmd = new OracleCommand(query, con); OracleDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { if (query == batsmanDetailsQueryMap["batsmanWithMostDucks"]) { while (rdr.Read()) { DucksLabel.Text = rdr.GetInt32(1).ToString(); } } if (query == batsmanDetailsQueryMap["batsmanCenturiesAndHalfCenturies"]) { while (rdr.Read()) { HalfCenturiesLabel.Text = rdr.GetInt32(2).ToString(); CenturiesLabel.Text = rdr.GetInt32(1).ToString(); } } if (query == batsmanDetailsQueryMap["batsmanHighestScore"]) { while (rdr.Read()) { SeasonLabel.Text = rdr.GetString(0); MaximumRunsScoredLabel.Text = rdr.GetInt32(2).ToString(); } } if (query == batsmanDetailsQueryMap["batsmanRunOuts"]) { while (rdr.Read()) { RunOutsLabel.Text = rdr.GetInt32(1).ToString(); } } if (query == batsmanDetailsQueryMap["MaximumBallsPlayedByBatsman"]) { while (rdr.Read()) { SeasonLabel1.Text = rdr.GetString(0); BallsPlayedLabel.Text = rdr.GetInt32(4).ToString(); } } if (query == batsmanDetailsQueryMap["batsmanMaximumFours"]) { while (rdr.Read()) { SeasonLabel2.Text = rdr.GetString(0); NumberOfFoursLabel.Text = rdr.GetInt32(4).ToString(); } } if (query == batsmanDetailsQueryMap["batsmanMaximumSixes"]) { while (rdr.Read()) { SeasonLabel3.Text = rdr.GetString(0); NumberOfSixesLabel.Text = rdr.GetInt32(4).ToString(); } } } } } catch (OracleException ex) { Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex); } finally { con.Close(); } }