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;
}
