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"]); }