public IEntity Get(MySql.Data.MySqlClient.MySqlDataReader aReader) { SupplierCategory suppliercategory = null; while (aReader.Read()) { suppliercategory = new SupplierCategory(); suppliercategory.ID = Convert.ToInt32(aReader[0]); suppliercategory.CODE = aReader[1].ToString(); suppliercategory.NAME = aReader[2].ToString(); suppliercategory.MODIFIED_BY = aReader["modified_by"].ToString(); suppliercategory.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); suppliercategory.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); } return(suppliercategory); }
public IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader) { IList result = new ArrayList(); while (aReader.Read()) { SupplierCategory suppliercategory = new SupplierCategory(); suppliercategory.ID = Convert.ToInt32(aReader[0]); suppliercategory.CODE = aReader[1].ToString(); suppliercategory.NAME = aReader[2].ToString(); suppliercategory.MODIFIED_BY = aReader["modified_by"].ToString(); suppliercategory.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString()); suppliercategory.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString(); result.Add(suppliercategory); } return(result); }