public static void CreateProfileXml()
{
DBConnect proc = new DBConnect();
DataTable rs3;
DataTable rs2;
DataTable rs;
int i = 0;
int j = 0;
int k = 0;
rs = proc.getAllProfil();
rs2 = proc.getAllPoste();
rs3 = proc.getAllTeam();
// Create the root node of a new XML document.
Chilkat.Xml xml = new Chilkat.Xml();
// This is going to be a collection of contacts.
xml.Tag = "profiles";
// Create a child node to hold a contact record.
// Our "xml" object will now reference the new node.
while (i < rs.Rows.Count)
{
xml = xml.NewChild("profil", "");
// Create a "company" record. NewChild2 does not return the child node that is created
xml.NewChild2("id", Convert.ToString(rs.Rows[i]["idProfil"]));
xml.NewChild2("nom", rs.Rows[i]["nom"].ToString()+", "+rs.Rows[i]["prenom"].ToString());
xml.NewChild2("email", rs.Rows[i]["email"].ToString());
xml.NewChild2("phone", rs.Rows[i]["phoneNumber"].ToString());
xml.NewChild2("seniority", Convert.ToString(rs.Rows[i]["seniority"]));
// Move up the tree and create another contact record.
// GetParent2 updates our internal reference to the parent.
xml.GetParent2();
i++;
}
// We can always get back to the root by calling GetRoot (or GetRoot2)
xml.GetRoot2();
// Add the tag that specifies our character encoding.
xml.Encoding = "utf-8";
// Save the document.
xml.SaveXml("profiles.xml");
//GÉNÉRATION DE POSTES.XML
xml = new Chilkat.Xml();
xml.Tag = "postes";
while (j < rs2.Rows.Count)
{
xml = xml.NewChild("poste", "");
xml.NewChild2("id", Convert.ToString(rs2.Rows[j]["idPoste"]));
xml.NewChild2("nom", rs2.Rows[j]["nom"].ToString());
xml.NewChild2("description", rs2.Rows[j]["description"].ToString());
xml.GetParent2();
j++;
}
// We can always get back to the root by calling GetRoot (or GetRoot2)
xml.GetRoot2();
// Add the tag that specifies our character encoding.
xml.Encoding = "utf-8";
// Save the document.
xml.SaveXml("postes.xml");
//GÉNÉRATION DE POSTES.XML
xml = new Chilkat.Xml();
xml.Tag = "teams";
while (k < rs3.Rows.Count)
{
xml = xml.NewChild("team", "");
xml.NewChild2("id", Convert.ToString(rs3.Rows[k]["idTeam"]));
xml.NewChild2("nom", rs3.Rows[k]["nom"].ToString());
xml.NewChild2("description", rs3.Rows[k]["description"].ToString());
xml.GetParent2();
k++;
}
// We can always get back to the root by calling GetRoot (or GetRoot2)
xml.GetRoot2();
// Add the tag that specifies our character encoding.
xml.Encoding = "utf-8";
// Save the document.
xml.SaveXml("teams.xml");
}