public static Domain.MaterialLocationCollection GetMaterialLocationCollection()
{
YellowstonePathology.Business.Domain.MaterialLocationCollection result = new Domain.MaterialLocationCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select * from tblMaterialLocation order by Name;";
cmd.CommandType = System.Data.CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.MaterialLocation materialLocation = new YellowstonePathology.Business.Domain.MaterialLocation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(materialLocation, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(materialLocation);
}
}
}
return(result);
}
private static Domain.MaterialLocationCollection BuildMaterialLocationCollection(XElement sourceElement)
{
Domain.MaterialLocationCollection materialLocationCollection = new Domain.MaterialLocationCollection();
if (sourceElement != null)
{
foreach (XElement materialLocationElement in sourceElement.Elements("MaterialLocation"))
{
materialLocationCollection.Add(BuildMaterialLocation(materialLocationElement));
}
}
return(materialLocationCollection);
}
private static Domain.MaterialLocationCollection BuildMaterialLocationCollection(XElement sourceElement)
{
Domain.MaterialLocationCollection materialLocationCollection = new Domain.MaterialLocationCollection();
if (sourceElement != null)
{
foreach (XElement materialLocationElement in sourceElement.Elements("MaterialLocation"))
{
materialLocationCollection.Add(BuildMaterialLocation(materialLocationElement));
}
}
return materialLocationCollection;
}
