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();
}
}
