public static MaterialUnitCollection GetMaterialUnitsByLanguageISO(string LanguageISO)
{
MaterialUnitCollection c = new MaterialUnitCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetMaterialUnitsByLanguageISO, new System.Data.SqlClient.SqlParameter("LanguageISO", LanguageISO));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
MaterialUnit o = new MaterialUnit();
LoadMaterialUnitByReader(row, o);
c.Add(o);
}
}
return(c);
}
public static void LoadMaterialUnitByReader(DataRow row, MaterialUnit o)
{
o.ID = Convert.ToInt32(row["ID"]);
o.Title = row["Title"].ToString();
o.Type = Convert.ToInt32(row["Type"]);
}
