public void UpdateShippingLogRoute(Shipping_Log_Route route) { }
public List<Shipping_Log_Route> GetShippingLogRoutes(MySqlConnection connection) { List<Shipping_Log_Route> shippinglogroutes= new List<Shipping_Log_Route>(); MySqlDataReader dataReader=null; try{ string selectquery="SELECT * FROM `shipping_log_routes`;"; dataReader=Select(selectquery,connection); while (dataReader.Read()) { Shipping_Log_Route shippinglogroute = new Shipping_Log_Route(Convert.ToInt32(dataReader[0].ToString()), dataReader[1].ToString()); shippinglogroutes.Add(shippinglogroute); } dataReader.Close(); return shippinglogroutes; }catch{ if(dataReader!=null) { dataReader.Close(); return null; } } return null; }