/*
* for check the connections
* no return type
* */
static private void CheckConnections()
{
Console.ForegroundColor = ConsoleColor.Blue;
Console.WriteLine("\n-----------------Check Connections--------------------\n");
Console.ForegroundColor = ConsoleColor.DarkGreen;
//check Mongo Db
MongoDBConnector mongoCon = new MongoDBConnector();
Console.WriteLine("....MongoDB....\n");
StatusWriter(mongoCon.CheckDB());
Console.WriteLine("\n------------------------------------------------------\n");
//check Postger Db
PostgrSqlDbConnector postgerCon = new PostgrSqlDbConnector();
Console.WriteLine("....PostgerDB....\n");
StatusWriter(postgerCon.CheckDB());
Console.WriteLine("\n------------------------------------------------------\n");
//check Mysql Db
MySqlDBConnector mysqlCon = new MySqlDBConnector();
Console.WriteLine("....MysqlDB....\n");
StatusWriter(mysqlCon.CheckDB());
Console.WriteLine("\n------------------------------------------------------\n");
//check Mssql Db
MsSqlDBConnector mssqlCon = new MsSqlDBConnector();
Console.WriteLine("....Mssql....\n");
StatusWriter(mssqlCon.CheckDB());
Console.WriteLine("\n------------------------------------------------------\n");
}
public void Read()
{
Console.WriteLine("Connecting.........");
MySqlDBConnector getCon = new MySqlDBConnector();
MySqlConnection con = getCon.GetCon();
try
{
con.Open();
Console.WriteLine("Connected\n");
string sql = "select user_id,fname,lname,password from user_login";
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
Console.WriteLine("{0}\t{1}" + " " + "{2}\t{3}", red["user_id"].ToString(), red["Fname"].ToString(), red["Lname"].ToString(), red["Password"].ToString());
}
}
catch (MySqlException e)
{
Console.WriteLine("\tError: " + e.Number.ToString() + "\n\t has occurred: " + e.Message.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
if (con.State == System.Data.ConnectionState.Open)
{
con.Clone();
}
}
}
