private Material PopulateReader(IDataReader dr)
 {
     Material material = new Material();
     if (dr["Id"] != DBNull.Value)
         material.Id = dr["Id"].ToString();
         material.Name = dr["Name"].ToString();
         material.Type = dr["Type"].ToString();
     return material;
 }
        public Material GetMaterial(string id)
        {
            Material material = new Material();

            IDataReader dr = new MaterialDataAdapter().GetMaterialById(id);
            if (dr.Read())
            {
                material = PopulateReader(dr);
            }
            return material;
        }