public static List<ActiveEmployee> ReadActiveEmloyees()
{
List<ActiveEmployee> activeEmployees = new List<ActiveEmployee>();
string filename = ConfigurationManager.AppSettings [ "filename" ];
XElement activeEmployeesXMLElement = XElement.Load(filename);
XNamespace mna = activeEmployeesXMLElement.GetDefaultNamespace();
IEnumerable<XElement> activeEmployeesElements =
from el in activeEmployeesXMLElement.Descendants(mna + "ActiveEmployee")
select el;
foreach (XElement activeEmployeeElement in activeEmployeesElements)
{
string contactPhoneNo = activeEmployeeElement.Element(mna + "ContactPhoneNo").Value;
string firstName = activeEmployeeElement.Element(mna + "FirstName").Value;
string hRStatus = activeEmployeeElement.Element(mna + "HRStatus").Value;
string lDAPId = activeEmployeeElement.Element(mna + "LDAPId").Value;
string lastName = activeEmployeeElement.Element(mna + "LastName").Value;
string middleName = activeEmployeeElement.Element(mna + "MiddleName").Value;
string modifiedDate = activeEmployeeElement.Element(mna + "ModifiedDate").Value;
string workEmail = activeEmployeeElement.Element(mna + "WorkEmail").Value;
string workforceId = activeEmployeeElement.Element(mna + "WorkforceId").Value;
ActiveEmployee activeEmployee = new ActiveEmployee(firstName, middleName, lastName, contactPhoneNo, hRStatus, lDAPId, modifiedDate, workEmail, workforceId);
activeEmployees.Add(activeEmployee);
}
return activeEmployees;
}
public static List<ActiveEmployee> ReadActiveEmloyees2()
{
List<ActiveEmployee> activeEmployees = new List<ActiveEmployee>();
string filename = ConfigurationManager.AppSettings [ "filename" ];
XmlReader xmlReader = XmlReader.Create(filename);
XElement activeEmployeesXMLElement = XElement.Load(xmlReader);
XmlNameTable nameTable = xmlReader.NameTable;
XmlNamespaceManager namespaceManager = new XmlNamespaceManager(nameTable);
XNamespace mna = activeEmployeesXMLElement.GetDefaultNamespace();
namespaceManager.AddNamespace("ns", mna.ToString());
IEnumerable<XElement> activeEmployeesElements =
from el in activeEmployeesXMLElement.Descendants(mna + "ActiveEmployee")
select el;
foreach (XElement activeEmployeeElement in activeEmployeesElements)
{
string contactPhoneNo = activeEmployeeElement.XPathSelectElement("ns:ContactPhoneNo", namespaceManager).Value;
string firstName = activeEmployeeElement.XPathSelectElement("ns:FirstName", namespaceManager).Value;
string hRStatus = activeEmployeeElement.XPathSelectElement("ns:HRStatus", namespaceManager).Value;
string lDAPId = activeEmployeeElement.XPathSelectElement("ns:LDAPId", namespaceManager).Value;
string lastName = activeEmployeeElement.XPathSelectElement("ns:LastName", namespaceManager).Value;
string middleName = activeEmployeeElement.XPathSelectElement("ns:MiddleName", namespaceManager).Value;
string modifiedDate = activeEmployeeElement.XPathSelectElement("ns:ModifiedDate", namespaceManager).Value;
string workEmail = activeEmployeeElement.XPathSelectElement("ns:WorkEmail", namespaceManager).Value;
string workforceId = activeEmployeeElement.XPathSelectElement("ns:WorkforceId", namespaceManager).Value;
ActiveEmployee activeEmployee = new ActiveEmployee(firstName, middleName, lastName, contactPhoneNo, hRStatus, lDAPId, modifiedDate, workEmail, workforceId);
activeEmployees.Add(activeEmployee);
}
return activeEmployees;
}