public static void InsertMysqlAutorization()
{
ConectarEpslog();
string query = "select * from datosgenerales where flag = '0' and cautocode <> '0000'";
OleDbCommand commandselect = new OleDbCommand(query, Conex);
OleDbDataReader reader = commandselect.ExecuteReader();
while (reader.Read())
{
if (!CompanyExists(reader))
{
ConnectionMySQL.Connect();
ConnectionMySQL.InsertCompany(reader.GetString(24), reader.GetString(17), reader.GetString(16), reader.GetString(18));
ConnectionMySQL.Disconnect();
}
if (!InsuredExists(reader))
{
string clinic_history_code = GetClinicHistoryCode();
ConnectionMySQL.Connect();
ConnectionMySQL.InsertInsured(reader.GetString(27), reader.GetString(17), reader.GetString(0), reader.GetString(22), reader.GetString(1), reader.GetString(23), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9), reader.GetString(10), reader.GetString(11), Helper.GetDate(reader.GetString(12)), reader.GetInt16(13).ToString(), reader.GetString(14).ToString(), Helper.GetDate(reader.GetString(19)), Helper.GetDate(reader.GetString(20)), Helper.GetDate(reader.GetString(21)), reader.GetString(29), "", clinic_history_code);
ConnectionMySQL.Disconnect();
}
string intern_code = GetInternCode();
ConnectionMySQL.Connect();
ConnectionMySQL.InsertAuthorization(reader.GetString(1), reader.GetString(25), reader.GetString(5), reader.GetString(2), Helper.GetDateTime(reader.GetString(3)), reader.GetString(8), reader.GetString(6), reader.GetString(7), Helper.GetDate(reader.GetString(12)), reader.GetValue(35).ToString(), intern_code, null);
ConnectionMySQL.Disconnect();
ConnectionMySQL.Connect();
ConnectionMySQL.UpdateCompany(reader.GetValue(3).ToString(), reader.GetValue(17).ToString());
ConnectionMySQL.Disconnect();
UpdateAfterInsert("DatosGenerales", "cAutoCode", 2, reader);
}
Desconectar();
}