public void FnLocationtoXml()
{
string Constring = System.Configuration.ConfigurationManager.ConnectionStrings["LoveJourney"].ConnectionString;
SqlConnection con = new SqlConnection(Constring);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("Sp_IFReports", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TableName", "DomAirportCodes");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet DsLoc = new DataSet();
da.Fill(DsLoc);
string DirectoryPath = Server.MapPath("~/App_Data");
DirectoryInfo dir = new DirectoryInfo(DirectoryPath);
if (!dir.Exists)
{
dir.Create();
}
string filepath = "~/App_Data/" + "Airports.xml";
string DirectoryPath1 = Server.MapPath(filepath);
DirectoryInfo dir1 = new DirectoryInfo(DirectoryPath1);
if (!dir1.Exists)
{
DataSet ds1 = new DataSet();
ds1.EnforceConstraints = false;
XmlDataDocument XmlDoc = new XmlDataDocument(ds1);
// Write down the XML declaration
XmlDeclaration xmlDeclaration = XmlDoc.CreateXmlDeclaration("1.0", "utf-8", null);
// Create the root element
XmlElement rootNode = XmlDoc.CreateElement("Airports");
XmlDoc.InsertBefore(xmlDeclaration, XmlDoc.DocumentElement);
XmlDoc.AppendChild(rootNode);
XmlDoc.Save(Server.MapPath(filepath));
}
StreamWriter XmlData = new StreamWriter(Server.MapPath("~/App_Data/" + "Airports.xml"), false);
DsLoc.WriteXml(XmlData);
XmlData.Close();
lblmsg.Visible = true;
lblmsg.Text = " All flights list Uploaded to XML Successfully";
}
finally
{
con.Close();
}
}
public XmlDataDocument DataCollection(string mac, string ip, string hostname, string UserName,string Domain)
{
string result = "";
if (string.IsNullOrEmpty(mac) && string.IsNullOrEmpty(ip) && string.IsNullOrEmpty(hostname) && string.IsNullOrEmpty(UserName) && string.IsNullOrEmpty(Domain))
{
result = "-2";
}
else
{
SqlStatment.InsertData(mac, ip, hostname, UserName,Domain);
result = "0";
}
XmlDataDocument xd = new XmlDataDocument();
//XmlStr.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
XmlDeclaration newDec = xd.CreateXmlDeclaration("1.0", "gb2312", null);
xd.AppendChild(newDec);
XmlElement xmlElemFileName = xd.CreateElement("result");
XmlText xmlTextFileName = xd.CreateTextNode(result);
xmlElemFileName.AppendChild(xmlTextFileName);
xd.AppendChild(xmlElemFileName);
return xd;
}
public XmlDataDocument CheckClient(string mac, string ip, string hostname,string UserName,string Domain)
{
string result = "";
if (string.IsNullOrEmpty(mac) && string.IsNullOrEmpty(ip) && string.IsNullOrEmpty(hostname) && string.IsNullOrEmpty(Domain))
{
result = "-2";
}
else
{
DataTable dt = SqlStatment.CheckLogin(hostname, mac, Domain);
result = dt.Rows[0][0].ToString();
}
XmlDataDocument xd = new XmlDataDocument();
//XmlStr.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>");
XmlDeclaration newDec = xd.CreateXmlDeclaration("1.0", "gb2312", null);
xd.AppendChild(newDec);
XmlElement xmlElemFileName = xd.CreateElement("result");
XmlText xmlTextFileName = xd.CreateTextNode(result);
xmlElemFileName.AppendChild(xmlTextFileName);
xd.AppendChild(xmlElemFileName);
return xd;
}
