protected void Button1_Click(object sender, EventArgs e) { DataSet dsSiteMap = new DataSet(); SiteMapBL objSiteMap = new SiteMapBL(); string sPath = string.Empty; sPath = "XML/SiteMap.xml"; sPath = Server.MapPath(sPath); FileStream fs = new FileStream(sPath, FileMode.Open); dsSiteMap.ReadXml(fs); fs.Close(); DataSet SiteMapds = objSiteMap.SearchUsedCars(); for (int k = 0; k < SiteMapds.Tables[0].Rows.Count; k++) { dsSiteMap.Tables[0].Rows.Add(); //http://UnitedCarExchange.com/SearchCarDetails.aspx?Make=Toyota&Model=Sienna&ZipCode=0&WithinZip=5&C=zIgOMkOB46344 //http://UnitedCarExchange.com//2010-Hyundai-Santa%20Fe-707638577695 string sUrl = "http://www.UnitedCarExchange.com/Buy-Sell-UsedCar/" + SiteMapds.Tables[0].Rows[k]["YearofMake"].ToString() + "-" + SiteMapds.Tables[0].Rows[k]["Make"].ToString() + "-" + SiteMapds.Tables[0].Rows[k]["Model"].ToString() + "-" + SiteMapds.Tables[0].Rows[k]["Caruniqueid"].ToString() + ""; //dsSiteMap.Tables[0].Rows[dsSiteMap.Tables["url"].Rows.Count - 1][0] = sUrl; dsSiteMap.Tables[0].Rows[dsSiteMap.Tables["url"].Rows.Count - 1][0] = sUrl.Replace('&', '-'); } StreamWriter xmlDoc = new StreamWriter((sPath), false); dsSiteMap.WriteXml(xmlDoc); xmlDoc.Close(); }
protected void btnStateWiseURL_Click(object sender, EventArgs e) { DataSet dsSiteMap = new DataSet(); SiteMapBL objSiteMap = new SiteMapBL(); string sPath = string.Empty; sPath = "XML/XMLStateCityURLs.xml"; sPath = Server.MapPath(sPath); FileStream fs = new FileStream(sPath, FileMode.Open); dsSiteMap.ReadXml(fs); fs.Close(); DataSet SiteMapds = objSiteMap.XmlSiteMapbyCityState(); for (int k = 0; k < SiteMapds.Tables[0].Rows.Count; k++) { dsSiteMap.Tables[0].Rows.Add(); string sUrl = "http://www.UnitedCarExchange.com/SellUsedCars/" + SiteMapds.Tables[0].Rows[k]["state"].ToString() + "/" + SiteMapds.Tables[0].Rows[k]["city"].ToString().Replace("#", ""); //dsSiteMap.Tables[0].Rows[dsSiteMap.Tables["url"].Rows.Count - 1][0] = sUrl; dsSiteMap.Tables[0].Rows[dsSiteMap.Tables["url"].Rows.Count - 1][0] = sUrl.Replace('&', '-'); } StreamWriter xmlDoc = new StreamWriter((sPath), false); dsSiteMap.WriteXml(xmlDoc); xmlDoc.Close(); }