protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.User.Identity.Name.ToString() == "*****@*****.**")
{
GridView1.Visible = true;
XmlDocument reviews = Auxiliar.getReviewsAll();
GridView2.DataSource = null;
GridView2.DataBind();
XmlDataSource3.Data = "";
XmlDataSource3.DataBind();
DataSet xmlData = new DataSet();
var xmlReader1 = new XmlNodeReader(reviews);
xmlData.ReadXml(xmlReader1);
XmlDataSource3.Data = reviews.OuterXml;
GridView2.DataSource = xmlData;
GridView2.DataBind();
}
else
{
GridView1.Visible = false;
System.Diagnostics.Debug.WriteLine(HttpContext.Current.User.Identity.Name.ToString());
}
}
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
String id = Request["id"];
XmlDocument xdoc = XmlDataSource3.GetXmlDocument();
string script = "<script language=\"javascript\">\n" + "alert (\"Preencha todos os campos\");\n" + "</script>";
if (e.NewValues["id"].ToString().Length == 0 || e.NewValues["city"].ToString().Length == 0 || e.NewValues["Street"].ToString().Length == 0 || e.NewValues["pnumber"].ToString().Length == 0 || e.NewValues["value"].ToString().Length == 0)
{
ClientScript.RegisterStartupScript(script.GetType(), "Error", script);
e.Cancel = true;
}
else
{
XmlElement dono_inicial = xdoc.SelectSingleNode("properties/property[@id='" + e.OldValues["id"].ToString() + "' and @city='" + e.OldValues["city"] + "' and @Street='" + e.OldValues["Street"] + "' and @pnumber='" + e.OldValues["pnumber"] + "' and @value='" + e.OldValues["value"] + "']") as XmlElement;
while (dono_inicial != null)
{
dono_inicial.Attributes["id"].Value = e.NewValues["id"].ToString();
dono_inicial.Attributes["city"].Value = e.NewValues["city"].ToString();
dono_inicial.Attributes["Street"].Value = e.NewValues["Street"].ToString();
dono_inicial.Attributes["pnumber"].Value = e.NewValues["pnumber"].ToString();
dono_inicial.Attributes["value"].Value = e.NewValues["value"].ToString();
XmlDataSource3.Save();
dono_inicial = xdoc.SelectSingleNode("properties/property[@id='" + e.OldValues["id"].ToString() + "' and @id='" + e.OldValues["id"] + "' and @city='" + e.OldValues["city"] + "' and @Street='" + e.OldValues["Street"] + "'and @pnumber='" + e.OldValues["pnumber"] + "'and @value='" + e.OldValues["value"] + "']") as XmlElement;
}
e.Cancel = true;
FormView1.ChangeMode(FormViewMode.ReadOnly);
Response.Redirect("remove_prop.aspx?id=" + id + "");
}
}
protected void lnkSave_Click(object sender, EventArgs e)
{
XmlDocument xdoc = XmlDataSource3.GetXmlDocument();
XmlElement root = xdoc.DocumentElement;
XmlNodeList nodes = root.SelectNodes("/properties/property"); // You can also use XPath here
int land_register_number = 0;
foreach (XmlNode node in nodes)
{
int ld_register = Int32.Parse(node.Attributes[0].Value);
if (land_register_number < ld_register)
{
land_register_number = ld_register;
}
}
land_register_number++;
XmlElement properties = xdoc.SelectSingleNode("properties") as XmlElement;
XmlElement property = xdoc.CreateElement("property");
XmlElement land_register = xdoc.CreateElement("land_register");
XmlElement address = xdoc.CreateElement("address");
XmlElement city = xdoc.CreateElement("city");
XmlElement street = xdoc.CreateElement("street");
XmlElement port_number = xdoc.CreateElement("port_number");
XmlElement value = xdoc.CreateElement("value");
XmlElement owners = xdoc.CreateElement("owners");
XmlAttribute aland_register = xdoc.CreateAttribute("land_register");
aland_register.InnerText = (land_register_number).ToString();
land_register.InnerText = (land_register_number).ToString();
city.InnerText = ((TextBox)GridView1.FooterRow.FindControl("txtcity")).Text;
street.InnerText = ((TextBox)GridView1.FooterRow.FindControl("txtstreet")).Text;
port_number.InnerText = ((TextBox)GridView1.FooterRow.FindControl("txtport")).Text;
value.InnerText = ((TextBox)GridView1.FooterRow.FindControl("txtvalue")).Text;
property.Attributes.Append(aland_register);
property.AppendChild(land_register);
property.AppendChild(address);
address.AppendChild(city);
address.AppendChild(street);
address.AppendChild(port_number);
property.AppendChild(value);
property.AppendChild(owners);
properties.AppendChild(property);
XmlDataSource3.Save();
XmlDataSource1.DataBind();
XmlDataSource2.DataBind();
GridView1.ShowFooter = false;
Response.Redirect(Request.RawUrl);
}
private void getTop()
{
string link = "http://localhost:49486/RSS/top";
XmlReader reader = XmlReader.Create(link);
XmlDocument doc = new XmlDocument();
doc.Load(reader);
reader.Close();
XmlDataSource3.Data = doc.OuterXml;
XmlDataSource3.DataBind();
XmlDataSource3.XPath = "/rss/channel";
XmlDataSource2.Data = doc.OuterXml;
XmlDataSource2.DataBind();
XmlDataSource2.XPath = "/channel";
XmlDocument xdoc1 = XmlDataSource3.GetXmlDocument();
XmlDocument xdoc2 = XmlDataSource2.GetXmlDocument();
XmlNodeList channel = xdoc1.SelectNodes("//channel");
XmlNode info = channel[0];
XmlNodeList noticias = xdoc2.SelectNodes("//item");
top.InnerHtml = "<ul>";
foreach (XmlNode i in noticias)
{
top.InnerHtml += "" +
"<li>" +
"<a href = \"/Movie?ID=" + i.Attributes["id"].Value + "\" >" +
"<div class=\"thumb\">" +
"<div class=\"img\" style=\"background-image: url('" + i.Attributes["poster"].Value + "');\"></div>" +
"</div>" +
"<div class=\"info\">" +
"<div class=\"title\">" + i.Attributes["title"].Value + "</div>" +
"<div class=\"infos\">" +
"<div class=\"year\">" + i.Attributes["year"].Value + "</div>" +
"<div class=\"imdb\">TMDB: " + i.Attributes["rating"].Value + "</div>" +
"</div>" +
"</div>" +
"</a>" +
"</li>";
}
top.InnerHtml += "</ul>";
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
XmlDataSource3.DataFile = DropDownList1.SelectedValue;
XmlDataSource1.DataFile = DropDownList1.SelectedValue;
XmlDataSource4.DataFile = DropDownList1.SelectedValue;
try{
XmlDocument xdoc = XmlDataSource3.GetXmlDocument();
GridView1.DataBind();
DetailsView1.DataBind();
DetailsView2.DataBind();
GridView1.PageIndex = 0;
}
catch (FileNotFoundException)
{
Response.Redirect("Rss_invalido.aspx");
}
}
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
String nif = Request["nif"];
XmlDocument xdoc = XmlDataSource3.GetXmlDocument();
string script = "<script language=\"javascript\">\n" + "alert (\"Preencha todos os campos\");\n" + "</script>";
if (e.NewValues["fname"].ToString().Length == 0 || e.NewValues["lname"].ToString().Length == 0 || e.NewValues["pdate"].ToString().Length == 0)
{
ClientScript.RegisterStartupScript(script.GetType(), "Error", script);
e.Cancel = true;
}
else
{
//verificar se data e valida
DateTime data;
if (!DateTime.TryParse(e.NewValues["pdate"].ToString(), out data))
{
script = "<script language=\"javascript\">\n" + "alert (\"O campo data tem de ser válido\");\n" + "</script>";
ClientScript.RegisterStartupScript(script.GetType(), "Error", script);
e.Cancel = true;
}
else
{
XmlElement dono_inicial = xdoc.SelectSingleNode("properties/property/owner[@nif='" + e.OldValues["nif"].ToString() + "' and @fname='" + e.OldValues["fname"] + "' and @lname='" + e.OldValues["lname"] + "' and @pdate='" + e.OldValues["pdate"] + "']") as XmlElement;
while (dono_inicial != null)
{
dono_inicial.Attributes["fname"].Value = e.NewValues["fname"].ToString();
dono_inicial.Attributes["lname"].Value = e.NewValues["lname"].ToString();
dono_inicial.Attributes["pdate"].Value = e.NewValues["pdate"].ToString();
XmlDataSource3.Save();
dono_inicial = xdoc.SelectSingleNode("properties/property/owner[@nif='" + e.OldValues["nif"].ToString() + "' and @fname='" + e.OldValues["fname"] + "' and @lname='" + e.OldValues["lname"] + "' and @pdate='" + e.OldValues["pdate"] + "']") as XmlElement;
}
e.Cancel = true;
FormView1.ChangeMode(FormViewMode.ReadOnly);
Response.Redirect("prop_por_dono.aspx?nif=" + nif + "");
}
}
}
protected void remover_Click(object sender, EventArgs e)
{
String nif = Request["nif"];
XmlDocument xdoc = XmlDataSource3.GetXmlDocument();
XmlElement dono = xdoc.SelectSingleNode("properties/property/owner[@nif='" + nif + "']") as XmlElement;
while (dono != null)
{
XmlElement prop = dono.ParentNode as XmlElement;
prop.RemoveChild(dono);
XmlDataSource3.Save();
dono = xdoc.SelectSingleNode("properties/property/owner[@nif='" + nif + "']") as XmlElement;
}
Response.Redirect("Owners.aspx");
}
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// System.Diagnostics.Debug.WriteLine(GridView2.Rows[e.RowIndex].Cells[1].Text);
// System.Diagnostics.Debug.WriteLine(GridView2.Rows[e.RowIndex].Cells[2].Text);
Auxiliar.getOrDeleteReview(false, GridView2.Rows[e.RowIndex].Cells[3].Text, Int32.Parse(GridView2.Rows[e.RowIndex].Cells[2].Text));
XmlDocument reviews = Auxiliar.getReviewsAll();
GridView2.DataSource = null;
GridView2.DataBind();
XmlDataSource3.Data = "";
XmlDataSource3.DataBind();
DataSet xmlData = new DataSet();
var xmlReader1 = new XmlNodeReader(reviews);
xmlData.ReadXml(xmlReader1);
XmlDataSource3.Data = reviews.OuterXml;
GridView2.DataSource = xmlData;
GridView2.DataBind();
}
protected void propertyItemUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
HyperLink hyper = (HyperLink)row.FindControl("HyperLink1");
XmlDocument xdoc = XmlDataSource3.GetXmlDocument();
XmlElement property = xdoc.SelectSingleNode("properties/property[@land_register='" + hyper.Text + "']") as XmlElement;
XmlNode address = property.SelectSingleNode("address");
address.SelectSingleNode("city").InnerText = e.NewValues["city"].ToString();
address.SelectSingleNode("street").InnerText = e.NewValues["street"].ToString();
address.SelectSingleNode("port_number").InnerText = e.NewValues["port_number"].ToString();
property.SelectSingleNode("value").InnerText = e.NewValues["value"].ToString();
XmlDataSource3.Save();
XmlDataSource1.DataBind();
XmlDataSource2.DataBind();
e.Cancel = true;
GridView1.EditIndex = -1;
Response.Redirect(Request.RawUrl);
}
protected void Page_Load()
{
XmlDocument reviews = Auxiliar.getReviewsUser(HttpContext.Current.User.Identity.Name.ToString());
System.Diagnostics.Debug.WriteLine(reviews.OuterXml);
GridView2.DataSource = null;
GridView2.DataBind();
XmlDataSource3.Data = "";
XmlDataSource3.DataBind();
DataSet xmlData = new DataSet();
var xmlReader1 = new XmlNodeReader(reviews);
xmlData.ReadXml(xmlReader1);
XmlDataSource3.Data = reviews.OuterXml;
GridView2.DataSource = xmlData;
GridView2.DataBind();
XmlDocument Games = Auxiliar.GetGamesUser(HttpContext.Current.User.Identity.Name.ToString());
//XmlDocument Games = Auxiliar.GamesInfo(Int32.Parse(Request.QueryString["id"]));
var trans = new XslTransform();
String xsltFileName = Server.MapPath("~/XSLT/Game.xslt");
trans.Load(xsltFileName);
var reader = trans.Transform(Games, null, (XmlResolver)null);
var transformedDoc = new XmlDocument();
transformedDoc.Load(reader);
var ds = new DataSet();
var xmlReader = new XmlNodeReader(transformedDoc);
ds.ReadXml(xmlReader);
GridView1.DataSource = ds;
GridView1.DataBind();
Image[] image = new Image[GridView1.Rows.Count];
Label[] label = new Label[GridView1.Rows.Count];
HyperLink[] hyperlink = new HyperLink[GridView1.Rows.Count];
GridView1.Visible = false;
for (int i = 1; i < GridView1.Rows.Count; i++)
{
label[i] = new Label();
image[i] = new Image();
image[i].Attributes.Add("height", "150px");
XmlDocument x = new XmlDocument();
x.Load("http://thegamesdb.net/api/GetArt.php?id=" + GridView1.Rows[i].Cells[0].Text);
image[i].ImageUrl = "http://thegamesdb.net/banners/" + x.SelectNodes("//Images/boxart[@side='front']").Item(0).InnerText;
HtmlGenericControl createDiv = new HtmlGenericControl("DIV");
createDiv.Attributes.Add("class", "grid-item col-md-2 col-sm-12 sortable");
createDiv.Attributes.Add("style", "margin-top: 30px;margin-left:30px;");
//Centrar image na div
image[i].Attributes.Add("class", "img-responsive center-block");
image[i].Attributes.Add("style", "height:250px");
this.SimilarGames.Controls.Add(createDiv);
createDiv.Controls.Add(image[i]);
label[i] = new Label();
HtmlGenericControl createDivText = new HtmlGenericControl("DIV");
createDivText.Attributes.Add("class", "titles");
createDivText.Attributes.Add("style", "text-align: center;");
createDiv.Controls.Add(createDivText);
hyperlink[i] = new HyperLink();
XmlDocument xml = new XmlDocument();
xml.Load("http://thegamesdb.net/api/GetGame.php?id=" + GridView1.Rows[i].Cells[0].Text);
hyperlink[i].Text = xml.SelectNodes("//Game/GameTitle").Item(0).InnerText;
hyperlink[i].NavigateUrl = "~/" + String.Format("videoGameInfo.aspx?id={0}", xml.SelectNodes("//Game/id").Item(0).InnerText);
label[i].Controls.Add(hyperlink[i]);
createDivText.Controls.Add(label[i]);
}
}