public UpdaterModel(string server, string uid, string pwd, string db)
{
// var myConnectionString = "server=127.0.0.1;uid=user1;pwd=user123;database=valo_db;";
StringBuilder sb = new StringBuilder("server=");
sb.Append(server);
sb.Append(";uid=");
sb.Append(uid);
sb.Append(";pwd=");
sb.Append(pwd);
sb.Append(";database=");
sb.Append(db);
sb.Append(";");
try
{
conn = new MySqlConnection(sb.ToString());
conn.Open();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
switch (ex.Number)
{
case 0:
StaticLogger.LogError("Cannot connect to server. Contact administrator");
break;
case 1045:
StaticLogger.LogError("Invalid username/password, please try again");
break;
}
}
}
static void Main(string[] args)
{
using (StreamReader sr = new StreamReader("Data1.txt"))
{
try
{
StaticLogger.LogInfo("Start parsing...");
Shipment shipment = new Shipment(sr);
StaticLogger.LogInfo("Ended parsing...");
}
catch (Exception ex)
{
StaticLogger.LogError(ex.Message);
}
Console.Out.WriteLine("Done...");
Console.ReadKey();
}
}
