public JsonResult <List <AdminMatch> > getstage(AdminMatch match)
{
List <AdminMatch> results = new List <AdminMatch>();
AdminMatch constructor = null;
Match tmp1 = null;
Match tmp2 = null;
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
System.Diagnostics.Debug.WriteLine("cargo base");
myConnection.Open();
if (match.stage_id > 1)
{
SqlCommand sqlCmd = new SqlCommand("getnextstage", myConnection);
sqlCmd.CommandType = CommandType.StoredProcedure;
System.Diagnostics.Debug.WriteLine(DateTime.Parse(match.match_date));
sqlCmd.Parameters.Add(new SqlParameter("@next_stage", match.stage_id));
sqlCmd.Parameters.Add(new SqlParameter("@tournament_id", match.tournament_id));
var returnparam = new SqlParameter {
ParameterName = "@result", Direction = ParameterDirection.ReturnValue
};
sqlCmd.Parameters.Add(returnparam);
sqlCmd.ExecuteNonQuery();
int result = (int)returnparam.Value;
sqlCmd.ExecuteNonQuery();
SqlDataReader dr = sqlCmd.ExecuteReader();
// System.Diagnostics.Debug.WriteLine();
while (dr.Read())
{
constructor = new AdminMatch();
constructor.match_id = (int)dr["match_id"];
constructor.name_team_1 = (string)dr["name_team_1"];
constructor.name_team_2 = (string)dr["name_team_2"];
constructor.team_1 = (string)dr["team_1"];
constructor.team_2 = (string)dr["team_2"];
results.Add(constructor);
}
return(Json(results));
}
else
{
SqlCommand sqlCmd = new SqlCommand("getnextstage", myConnection);
sqlCmd.CommandType = CommandType.StoredProcedure;
System.Diagnostics.Debug.WriteLine(DateTime.Parse(match.match_date));
sqlCmd.Parameters.Add(new SqlParameter("@next_stage", match.stage_id));
sqlCmd.Parameters.Add(new SqlParameter("@tournament_id", match.tournament_id));
var returnparam = new SqlParameter {
ParameterName = "@result", Direction = ParameterDirection.ReturnValue
};
sqlCmd.Parameters.Add(returnparam);
sqlCmd.ExecuteNonQuery();
int result = (int)returnparam.Value;
sqlCmd.ExecuteNonQuery();
SqlDataReader dr = sqlCmd.ExecuteReader();
// System.Diagnostics.Debug.WriteLine();
while (dr.Read())
{
constructor = new AdminMatch();
constructor.match_id = (int)dr["match_id"];
string action = "SELECT * FROM USERXSCORE WHERE USERXSCORE.MATCH_ID= " + constructor.team_1 + "and USERXINFO_ID =" + dr["team_1"];
SqlCommand sqlCmd2 = new SqlCommand(action, myConnection);
sqlCmd2.CommandType = CommandType.Text;
var reader2 = sqlCmd2.ExecuteReader();
while (reader2.Read())
{
tmp1 = new Match();
tmp1.winner_id = (string)reader2["winner_id"];
tmp1.winner_name = (string)reader2["winner_name"];
}
constructor.name_team_1 = tmp1.winner_name;
constructor.team_1 = tmp1.winner_id;
string action2 = "SELECT * FROM USERXSCORE WHERE USERXSCORE.MATCH_ID= " + constructor.team_2 + "and USERXINFO_ID =" + dr["team_2"];
SqlCommand sqlCmd3 = new SqlCommand(action2, myConnection);
sqlCmd2.CommandType = CommandType.Text;
var reader3 = sqlCmd2.ExecuteReader();
while (reader3.Read())
{
tmp2 = new Match();
tmp2.winner_id = (string)reader2["winner_id"];
tmp2.winner_name = (string)reader2["winner_name"];
}
constructor.name_team_2 = tmp2.winner_name;
constructor.team_2 = tmp2.winner_id;
results.Add(constructor);
}
return(Json(results));
}
}
public JsonResult <Match> AddMatch(AdminMatch match)
{
Match constructor = new Match();
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
System.Diagnostics.Debug.WriteLine("cargo base");
myConnection.Open();
SqlCommand sqlCmd = new SqlCommand("insertadminmatch", myConnection);
sqlCmd.CommandType = CommandType.StoredProcedure;
System.Diagnostics.Debug.WriteLine(match.stage_id + " " + match.sxm_winner1 + " " + match.sxm_winner2 + " " + match.tournament_id + " " + match.txc_team1 + " " + match.txc_team2 + " " + match.match_date + match.match_location);
sqlCmd.Parameters.Add(new SqlParameter("@match_date", match.match_date));
sqlCmd.Parameters.Add(new SqlParameter("@match_location", match.match_location));
sqlCmd.Parameters.Add(new SqlParameter("@stage_id", match.stage_id));
sqlCmd.Parameters.Add(new SqlParameter("@tournament_id", match.tournament_id));
if (match.sxm_winner1 != "")
{
System.Diagnostics.Debug.WriteLine("entrando al coso" + " winner1 " + match.sxm_winner1 + " winner2 " + match.sxm_winner2);
sqlCmd.Parameters.Add(new SqlParameter("@sxm_winner1", match.sxm_winner1));
sqlCmd.Parameters.Add(new SqlParameter("@sxm_winner2", match.sxm_winner2));
var returnparam = new SqlParameter {
ParameterName = "@result", Direction = ParameterDirection.ReturnValue
};
sqlCmd.Parameters.Add(returnparam);
sqlCmd.ExecuteNonQuery();
int result = (int)returnparam.Value;
if (result > 0)
{
constructor.Success = "true";
constructor.stagexmatch_id = result;
constructor.stagexmatch_name = "winner of match " + match.match_number;
return(Json(constructor));
}
else
{
constructor.Success = "false";
return(Json(constructor));
}
}
else
{
sqlCmd.Parameters.Add(new SqlParameter("@txc_team_1", match.txc_team1));
sqlCmd.Parameters.Add(new SqlParameter("@txc_team_2", match.txc_team2));
System.Diagnostics.Debug.WriteLine("no entro al coso");
var returnparam = new SqlParameter {
ParameterName = "@result", Direction = ParameterDirection.ReturnValue
};
sqlCmd.Parameters.Add(returnparam);
sqlCmd.ExecuteNonQuery();
int result = (int)returnparam.Value;
if (result > 0)
{
constructor.Success = "true";
constructor.stagexmatch_id = result;
constructor.stagexmatch_name = "winner of match " + match.match_number;
return(Json(constructor));
}
else
{
constructor.Success = "false";
return(Json(constructor));
}
}
}
