/*
* 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....");
PostgrSqlDbConnector getCon = new PostgrSqlDbConnector();
NpgsqlConnection con = getCon.GetCon();
try
{
con.Open();
Console.WriteLine("Connected\n");
string query = "selec * from user_login.user_login";
NpgsqlCommand cmd = new NpgsqlCommand(query, con);
NpgsqlDataReader 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 (NpgsqlException e)
{
Console.WriteLine("\n\t" + e.Message.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
