public static MasterDataSet.CountryDataTable GetCountries()
{
using (CountryTableAdapter adapter = new CountryTableAdapter())
{
return(adapter.GetCountries());
}
}
public static List <Country> GetCountryForAutocomplete(int?start, int?numItems, string filter, string idiomaId, ref int?totalRows)
{
List <Country> theList = new List <Country>();
Country theData = null;
try
{
CountryTableAdapter localAdapter = new CountryTableAdapter();
CountryDS.CountryDataTable theTable =
localAdapter.GetCountryForAutocomplete(numItems, start, filter, idiomaId, ref totalRows);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (CountryDS.CountryRow theRow in theTable.Rows)
{
theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception exc)
{
log.Error("Ocurrió un error al obtener la lista de Departamentos de la Base de Datos", exc);
throw exc;
}
return(theList);
}
public static Country GetRecordById(string countryId, string idiomaId)
{
CountryTableAdapter localAdapter = new CountryTableAdapter();
if (string.IsNullOrEmpty(countryId))
{
throw new ArgumentException("El identificador countryId no puede ser null o vacio");
}
if (string.IsNullOrEmpty(idiomaId))
{
throw new ArgumentException("El identificador idiomaId no puede ser null o vacio");
}
Country theData = null;
try
{
CountryDS.CountryDataTable theTable =
localAdapter.GetCountryById(countryId, idiomaId);
if (theTable != null && theTable.Rows.Count > 0)
{
CountryDS.CountryRow theRow = theTable[0];
theData = FillRecord(theRow);
}
}
catch (Exception exc)
{
log.Error("Ocurrió un error mientras se obtenía el country de id =" + countryId, exc);
throw exc;
}
return(theData);
}
public DataSet GetComboCountry()
{
CountryTableAdapter a = new CountryTableAdapter();
DataSet ds = new DataSet();
ds.Tables.Add(a.GetCombo());
return(ds);
}
public static Guid InsertCountry(string name)
{
using (CountryTableAdapter adapter = new CountryTableAdapter())
{
Guid countryId = Guid.NewGuid();
adapter.Insert(countryId, name);
return(countryId);
}
}
public bool InsertCountry(string Name, string usr, string pass)
{
if (authenticate(usr, pass, 25) == false)
{
return(false);
}
try
{
CountryTableAdapter u = new CountryTableAdapter();
u.Insert(Name);
}
catch (Exception e) { return(false); }
return(true);
}
public bool UpdateCountry(string Name, int Original_ID, string usr, string pass)
{
if (authenticate(usr, pass, 26) == false)
{
return(false);
}
try
{
CountryTableAdapter u = new CountryTableAdapter();
u.UpdateQuery(Name, Original_ID);
}
catch (Exception e) { return(false); }
return(true);
}
public bool DeleteCounty(int Original_ID, string usr, string pass)
{
if (authenticate(usr, pass, 24) == false)
{
return(false);
}
try
{
CountryTableAdapter u = new CountryTableAdapter();
u.DeleteQuery(Original_ID);
}
catch (Exception e) { return(false); }
return(true);
}
static void Main(string[] args)
{
Stopwatch mainStopWatch = new Stopwatch();
Stopwatch stopwatch = new Stopwatch();
int allDataCount = 0;
orclConnStr = File.ReadAllLines("oracleConnStr.txt")[0];
mainStopWatch.Start();
Console.WriteLine("BEGIN TRANSFER");
OracleConnection oracleConnection = new OracleConnection(orclConnStr);
try
{
oracleConnection.Open();
using (var adapter = new Subscription_typeTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_Id = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_Prize = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.Prize).ToArray()
};
OracleParameter p_Desc = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.Special).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.SUBSCRIPTION_PLAN (ID, COST, DESCRIPTION) VALUES (:1,:2,:3)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_Id);
cmd.Parameters.Add(p_Prize);
cmd.Parameters.Add(p_Desc);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("SUBSCRIPTION_PLAN DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new CountryTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_Name = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.Name).ToArray()
};
OracleParameter p_Population = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.Population).ToArray()
};
OracleParameter p_Lang = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.Main_language).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.COUNTRY (NAME, POPULATION, LANGUAGE) VALUES (:1, :2, :3)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_Name);
cmd.Parameters.Add(p_Population);
cmd.Parameters.Add(p_Lang);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("COUNTRY DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new REMOTE_PLACETableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_ID = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_Name = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.NAME).ToArray()
};
OracleParameter p_Population = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.POPULATION).ToArray()
};
OracleParameter p_xCord = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.X_COORDINATE).ToArray()
};
OracleParameter p_yCord = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.Y_COORDINATE).ToArray()
};
OracleParameter p_CountryName = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.COUNTRYNAME).ToArray()
};
OracleParameter p_TransmitterId = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.TRANSMITER_ID).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.PLACE(ID, CITY, POPULATION, X_COORD, Y_COORD, COUNTRYNAME, TRANSMITERID) VALUES(:1, :2, :3, :4, :5, :6, :7)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_ID);
cmd.Parameters.Add(p_Name);
cmd.Parameters.Add(p_Population);
cmd.Parameters.Add(p_xCord);
cmd.Parameters.Add(p_yCord);
cmd.Parameters.Add(p_CountryName);
cmd.Parameters.Add(p_TransmitterId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("PLACE DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new CallTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_ID = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_DateStart = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => (OracleTimeStamp)s.Date_Started).ToArray()
};
OracleParameter p_DateEnd = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => (OracleTimeStamp)s.Date_Started.AddMinutes(s.Duration)).ToArray()
};
OracleParameter p_Type = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => {
if (s.Is_Conference && s.Is_Video)
{
return("VIDEO_CONFERENCE");
}
else if (s.Is_Conference && !s.Is_Video)
{
return("CONFERENCE");
}
else if (!s.Is_Conference && s.Is_Video)
{
return("VIDEO");
}
else
{
return("REGULAR");
}
}).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.CALL (ID, START_TIME, END_TIME, TYPE) VALUES (:1, :2, :3, :4)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_ID);
cmd.Parameters.Add(p_DateStart);
cmd.Parameters.Add(p_DateEnd);
cmd.Parameters.Add(p_Type);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("CALL DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new AllMessagesTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_ID = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_Length = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.LENGTH).ToArray()
};
OracleParameter p_DateSent = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => (OracleTimeStamp)s.DATE_SENT).ToArray()
};
OracleParameter p_DataAmount = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.DATA_AMOUNT).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.MESSAGE (ID, LENGTH, DATE_SENT, DATA_AMOUNT) VALUES (:1, :2, :3, :4)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_ID);
cmd.Parameters.Add(p_Length);
cmd.Parameters.Add(p_DateSent);
cmd.Parameters.Add(p_DataAmount);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("MESSAGE DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
stopwatch.Start();
List <string> RemotePlaceData = new List <string>();
OracleCommand readCmd = new OracleCommand()
{
Connection = oracleConnection,
CommandText = "SELECT ID FROM ii738.PLACE ORDER BY TRANSMITERID",
CommandType = System.Data.CommandType.Text
};
using (var rdr = readCmd.ExecuteReader())
while (rdr.Read())
{
RemotePlaceData.Add(rdr.GetValue(0).ToString());
}
stopwatch.Stop();
Console.WriteLine("FETCHED REMOTE PLACE DATA IN {0}", stopwatch.Elapsed);
stopwatch.Reset();
using (var adapter = new Transmiter_CallTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_CallId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.CallID).ToArray()
};
OracleParameter p_PlaceId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => RemotePlaceData[(int)s.TransmiterID]).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.CALL_PLACE (CALLID, PLACEID) VALUES (:1, :2)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_CallId);
cmd.Parameters.Add(p_PlaceId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("CALL_PLACE DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new Transmiter_MessageTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_MessageId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.MessageID).ToArray()
};
OracleParameter p_PlaceId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => RemotePlaceData[(int)s.TransmiterID]).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.MESSAGE_PLACE (MESSAGEID, PLACEID) VALUES (:1, :2)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_MessageId);
cmd.Parameters.Add(p_PlaceId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("MESSAGE_PLACE DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
//RESTART CONNECTION
oracleConnection.Dispose();
oracleConnection = new OracleConnection(orclConnStr);
oracleConnection.Open();
Console.WriteLine("RESETING CONNECTION");
using (var adapter = new ALL_SUBSTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_Id = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_Name = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.NAME).ToArray()
};
OracleParameter p_Surname = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
IsNullable = true,
Value = data.Select(s => s.SURNAME).ToArray()
};
OracleParameter p_Sex = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.SEX).ToArray()
};
OracleParameter p_StartDate = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => s.START_DATE).ToArray()
};
OracleParameter p_EndDate = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => s.END_DATE).ToArray()
};
OracleParameter p_SubscriptionPlanId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.SUBSCRIPTION_PLANID).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.ACCOUNT (ID, NAME, SURNAME, SEX, START_DATE, END_DATE, SUBSCRIPTION_PLANID) VALUES (:1, :2, :3, :4, :5, :6, :7)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_Id);
cmd.Parameters.Add(p_Name);
cmd.Parameters.Add(p_Surname);
cmd.Parameters.Add(p_Sex);
cmd.Parameters.Add(p_StartDate);
cmd.Parameters.Add(p_EndDate);
cmd.Parameters.Add(p_SubscriptionPlanId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("ACCOUNT DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new AllPhoneNumsTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_Id = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_PhoneNumber = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.Phone_Number).ToArray()
};
OracleParameter p_isActive = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.Is_Active).ToArray()
};
OracleParameter p_AccountId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => s.Sub_Id).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.PHONE_NUMBER (ID, PH_NUMBER, IS_ACTIVE, ACCOUNTID) VALUES (:1, :2, :3, :4)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_Id);
cmd.Parameters.Add(p_PhoneNumber);
cmd.Parameters.Add(p_isActive);
cmd.Parameters.Add(p_AccountId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("PHONE_NUMBER DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
stopwatch.Start();
Dictionary <string, string> RemotePhoneNumberData = new Dictionary <string, string>();
OracleCommand readPhoneCmd = new OracleCommand()
{
Connection = oracleConnection,
CommandText = "SELECT ID, PH_NUMBER FROM ii738.PHONE_NUMBER",
CommandType = System.Data.CommandType.Text
};
using (var rdr = readPhoneCmd.ExecuteReader())
while (rdr.Read())
{
RemotePhoneNumberData.Add(rdr.GetValue(1).ToString(), rdr.GetValue(0).ToString());
}
stopwatch.Stop();
Console.WriteLine("FETCHED REMOTE PHONE NUMBER DATA IN {0}", stopwatch.Elapsed);
stopwatch.Reset();
using (var adapter = new Internet_Packet_UsageTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_Id = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.ID).ToArray()
};
OracleParameter p_StartDate = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => s.Date_started).ToArray()
};
OracleParameter p_EndDate = new OracleParameter()
{
OracleDbType = OracleDbType.TimeStamp,
Value = data.Select(s => s.Date_ended).ToArray()
};
OracleParameter p_Amount = new OracleParameter()
{
OracleDbType = OracleDbType.Int32,
Value = data.Select(s => s.Bytes_uploaded + s.Bytes_downloaded).ToArray()
};
OracleParameter p_PhoneNumberId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => RemotePhoneNumberData[s.NumberNumber]).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.DATA_TRANSMISSION (ID, START_DATE, END_DATE, AMOUNT, PHONE_NUMBERID) VALUES (:1, :2, :3, :4, :5)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_Id);
cmd.Parameters.Add(p_StartDate);
cmd.Parameters.Add(p_EndDate);
cmd.Parameters.Add(p_Amount);
cmd.Parameters.Add(p_PhoneNumberId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("DATA_TRANSMISSION DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new Trans_Inter_Pac_UsgTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_TransmissionId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.Internet_Packet_UsageID).ToArray()
};
OracleParameter p_PlaceId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => RemotePlaceData[(int)s.TransmiterID]).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.DATA_TRANSMISSION_PLACE (DATA_TRANSMISSIONID, PLACEID) VALUES (:1, :2)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_TransmissionId);
cmd.Parameters.Add(p_PlaceId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("DATA_TRANSMISSION_PLACE DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new Number_CallTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_PhoneNumberId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => RemotePhoneNumberData[s.NumberNumber]).ToArray()
};
OracleParameter p_CallId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.CallID).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.PHONE_NUMBER_CALL (PHONE_NUMBERID, CALLID) VALUES (:1, :2)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_PhoneNumberId);
cmd.Parameters.Add(p_CallId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("PHONE_NUMBER_CALL DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
using (var adapter = new Number_MessageTableAdapter())
{
stopwatch.Start();
var data = adapter.GetData();
OracleParameter p_PhoneNumberId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => RemotePhoneNumberData[s.NumberNumber]).ToArray()
};
OracleParameter p_MessageId = new OracleParameter()
{
OracleDbType = OracleDbType.Varchar2,
Value = data.Select(s => "MS" + s.MessageID).ToArray()
};
OracleCommand cmd = oracleConnection.CreateCommand();
cmd.CommandText = "INSERT INTO ii738.PHONE_NUMBER_MESSAGE (PHONE_NUMBERID, MESSAGEID) VALUES (:1, :2)";
cmd.ArrayBindCount = data.Count;
cmd.Parameters.Add(p_PhoneNumberId);
cmd.Parameters.Add(p_MessageId);
cmd.ExecuteNonQuery();
stopwatch.Stop();
allDataCount += data.Count;
Console.WriteLine("PHONE_NUMBER_MESSAGE DONE, {0} RECORDS IN {1}", data.Count, stopwatch.Elapsed);
stopwatch.Reset();
}
}
catch (OracleException ex)
{
Console.WriteLine("!!!!ORCL EX!!!!");
Console.WriteLine(ex);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
mainStopWatch.Stop();
oracleConnection.Dispose();
Console.WriteLine("DONE!");
Console.WriteLine("TRANSFERED {0} RECORDS IN {1}", allDataCount, mainStopWatch.Elapsed);
Console.ReadLine();
}
}