public static void InsertMysqlCumSunasaProduct()
{
ConectarTedef();
string query = "select * from ts_producto where flag = '0' order by codigoproducto";
OleDbCommand commandselect = new OleDbCommand(query, Conex);
OleDbDataReader reader = commandselect.ExecuteReader();
ConnectionMySQL.Connect();
while (reader.Read())
{
ConnectionMySQL.InsertCumSunasaProduct(reader.GetValue(0).ToString(), reader.GetValue(1).ToString(), reader.GetValue(3).ToString(), reader.GetValue(10).ToString(), reader.GetValue(9).ToString(), reader.GetValue(8).ToString(), reader.GetValue(4).ToString(), reader.GetValue(5).ToString(), reader.GetValue(6).ToString(), reader.GetValue(11).ToString(), reader.GetValue(12).ToString());
UpdateAfterInsert("ts_producto", "codigoproducto", 0, reader);
}
ConnectionMySQL.Disconnect();
FinalMessage();
}