protected DataSet getDataSet()
{
string user = (string)Session["userName"];
string pass = (string)Session["passWord"];
GWSiteClassLibrary.IScore sc = GWSiteClassLibrary.Factory.CreateScoreService();
DataSet ds = null;
ds = sc.GetAll(user, pass);
GridView5.DataSource = ds;
return(ds);
}
protected void Button1_Click(object sender, EventArgs e)
{
string user = (string)Session["userName"];
string pass = (string)Session["passWord"];
int id = int.Parse(DropDownList1.SelectedValue);
GWSiteClassLibrary.IScore sc = GWSiteClassLibrary.Factory.CreateScoreService();
DataSet ds1 = sc.GetMapScoreRank(user, pass, id, 10, "DESC");
GridView1.DataSource = ds1;
GridView1.DataBind();
Label2.Visible = true;
}
protected void gvmaps_SelectedIndexChanged(object sender, EventArgs e)
{
string user = (string)Session["userName"];
string pass = (string)Session["passWord"];
int uid = int.Parse(Session["UserID"].ToString());
int idmap = int.Parse(gvmaps.SelectedDataKey.Value.ToString());
GWSiteClassLibrary.IPlayer pl = GWSiteClassLibrary.Factory.CreatePlayerService();
DataSet ds = pl.FindByName(user, pass, "UserID", uid.ToString());
GridView1.DataSource = ds;
GridView1.DataBind();
int plid = int.Parse(GridView1.Rows[0].Cells[0].Text);
GWSiteClassLibrary.IScore score = GWSiteClassLibrary.Factory.CreateScoreService();
DataSet ds3 = score.GetPlayerRank(user, pass, idmap, plid, 1000, "DESC");// .GetAll(user, pass);
GridView2.DataSource = ds3;
GridView2.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
GWSiteClassLibrary.IMap m = GWSiteClassLibrary.Factory.CreateMapService();
GWSiteClassLibrary.IScore s = GWSiteClassLibrary.Factory.CreateScoreService();
GWSiteClassLibrary.IScore p = GWSiteClassLibrary.Factory.CreateScoreService();
DataSet dsMList = null;
DataSet dsMRank = null;
//DataSet dsPRank = null;
string user = (string)Session["userName"];
string pass = (string)Session["passWord"];
dsMList = m.GetAll(user, pass);
//dsMRank = s.GetMapScoreRank(user, pass, int.Parse(dsMList.Tables[0].Rows[0].ItemArray[0].ToString()), 3, "DESC");
//dsPRank = p.GetPlayerRank(user, pass, int.Parse(dsMList.Tables[0].Rows[0].ItemArray[0].ToString()), int.Parse(dsMList.Tables[0].Rows[0].ItemArray[0].ToString()), 2, "DESC");
//dsScore = s.GetPlayerRank(user,pass,
int size = dsMList.Tables[0].Rows.Count;
// Criar o XML
XElement root = new XElement("mapas");
for (int i = 0; i < size; i++)
{
string[] x = new string[10];
x[0] = dsMList.Tables[0].Rows[i].ItemArray[1].ToString();
dsMRank = s.GetMapScoreRank(user, pass, int.Parse(dsMList.Tables[0].Rows[i].ItemArray[0].ToString()), 3, "DESC");
// 1º Lugar
x[1] = dsMRank.Tables[0].Rows[0].ItemArray[1].ToString();
x[2] = dsMRank.Tables[0].Rows[0].ItemArray[2].ToString();
//dsPRank = p.GetPlayerRank(user, pass, int.Parse(dsMList.Tables[0].Rows[i].ItemArray[0].ToString()), int.Parse(dsMList.Tables[0].Rows[i].ItemArray[0].ToString()), 2, "DESC");
//x[3] = dsPRank.Tables[0].Rows[0].ItemArray[2].ToString();
// 2º Lugar
x[4] = dsMRank.Tables[0].Rows[1].ItemArray[1].ToString();
x[5] = dsMRank.Tables[0].Rows[1].ItemArray[2].ToString();
//x[6] = dsPRank.Tables[0].Rows[0].ItemArray[2].ToString();
// 3º Lugar
x[7] = dsMRank.Tables[0].Rows[2].ItemArray[1].ToString();
x[8] = dsMRank.Tables[0].Rows[2].ItemArray[2].ToString();
//x[9] = dsPRank.Tables[0].Rows[0].ItemArray[2].ToString();
// Top 3 de cada mapa + 2 scores de cada jogador
/*
* root.Add(new XElement("mapa", new XAttribute("nome", x[0]),
* new XElement("jogador", new XAttribute("nome", x[1]),
* new XElement("score", x[2]), new XElement("score", x[3])),
* new XElement("jogador", new XAttribute("nome", x[4]),
* new XElement("score", x[5]), new XElement("score", x[6])),
* new XElement("jogador", new XAttribute("nome", x[7]),
* new XElement("score", x[8]), new XElement("score", x[9]))
* ));*/
// TOP 3 de cada mapa + 1 score de cada jogador
root.Add(new XElement("mapa", new XAttribute("nome", x[0]),
new XElement("jogador", new XAttribute("nome", x[1]),
new XElement("score", x[2])),
new XElement("jogador", new XAttribute("nome", x[4]),
new XElement("score", x[5])),
new XElement("jogador", new XAttribute("nome", x[7]),
new XElement("score", x[8]))
));
}
string str = Server.MapPath(".");
root.Save(str + @"\TopMap.xml");
}
