示例#1
0
        /// <summary>
        /// Function For Check Database Before Application Running
        /// </summary>
        static void DBCheckDBisAlive(Connection.Database DBConfig, string ApplicationLocation)
        {
            var check = DBConfig.IsConnected(out string Error);

            if (!check)
            {
                Console.WriteLine($"Can't Connect to Database!, Is Server Running?\n Error");
                ApplicationRelaunch(ApplicationLocation);
            }
        }
示例#2
0
        /// <summary>
        /// Function For strQuery sql return boolean
        /// </summary>
        /// <param name="SerialByte"></param>
        /// <param name="DBConfig"></param>
        /// <returns></returns>
        public static bool DBRowsAffected(string strstrQuery, Connection.Database DBConfig)
        {
            bool result = false;

            using (MySqlConnection conn = new MySqlConnection())
            {
                DBConfig.OpenConnection(conn);
                using (var cmd = new MySqlCommand(strstrQuery, conn))
                {
                    using (MySqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            result = true;
                        }
                    }
                }
            }
            return(result);
        }
示例#3
0
        /// <summary>
        /// Function For Queries Result to String
        /// </summary>
        /// <param name="ColumnName">Target Column Name</param>
        /// <param name="strQuery">strQuery</param>
        /// <param name="DBConfig">Database Configuration</param>
        /// <returns></returns>
        public static string DBRowsString(string strColumnName, string strQuery, Connection.Database DBConfig)
        {
            string result = "NULL";

            using (MySqlConnection conn = new MySqlConnection())
            {
                DBConfig.OpenConnection(conn);
                using (var cmd = new MySqlCommand(strQuery, conn))
                {
                    using (MySqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            reader.Read();
                            result = reader.GetString(strColumnName);
                        }
                    }
                }
            }

            return(result);
        }
示例#4
0
        /// <summary>
        /// Function For Database Check Connection (For Application Startup Only)
        /// </summary>
        /// <param name="DBConfig">Database Configuration</param>
        static void DBDatabaseCheck(Connection.Database DBConfig, int MaxReconnect)
        {
            int  counter = 0;
            bool result;

            while (true)
            {
                result = DBConfig.IsConnected(out string ErrorResult);
                if (!result)
                {
                    if (counter >= MaxReconnect)
                    {
                        Console.WriteLine($"Can't Connect to Database!\nErrorResult");
                        Environment.Exit(0);
                    }
                    counter++;
                    System.Threading.Thread.Sleep(500);
                }
                else
                {
                    break;
                }
            }
        }
示例#5
0
 /// <summary>
 /// Function For Check Database Connection State
 /// </summary>
 /// <param name="DBConfig">Database Class Configuration</param>
 /// <returns></returns>
 static bool DBCheckDBIsAliveBool(Connection.Database DBConfig)
 {
     return(DBConfig.IsConnected(out string error));
 }
示例#6
0
 /// <summary>
 /// Function For Queries Result to Datatable
 /// </summary>
 public static System.Data.DataTable DBRowsDatatable(string strQuery, Connection.Database DBConfig)
 {
     return(DBConfig.MySqlToDataTable(strQuery));
 }
示例#7
0
 /// <summary>
 /// Function For strQuery SQL Inserting Row
 /// </summary>
 /// <param name="strQuery"></param>
 /// <param name="DBConfig"></param>
 public static void DBRowsInsert(string strQuery, Connection.Database DBConfig)
 {
     DBConfig.InsertToMySql(strQuery);
 }
示例#8
0
        /*
         *  Partial Class Helper
         *  Database Function
         *  Create Function with Keycode Name 'DB'
         *  Example 'DBnamefunction()';
         */


        /// <summary>
        /// Create New Connection Database
        /// </summary>
        /// <param name="Hostname"></param>
        /// <param name="DBName"></param>
        /// <param name="Username"></param>
        /// <param name="Password"></param>
        /// <returns></returns>
        public static Connection.Database DBCreateConnection(string Hostname, string DBName, string Username, string Password)
        {
            Connection.Database DB = new Connection.Database();
            DB.MyConnectionString = string.Format("server={0};uid={1};pwd={2};database={3}", Hostname, Username, Password, DBName);
            return(DB);
        }
示例#9
0
        /*
         *
         *      /// <summary>
         *      /// Function For Build Autogenerate strQuery from Datatable to String(SQL strQuery)
         *      /// </summary>
         *      /// <param name="table">Datatable Target</param>
         *      /// <param name="table_name">Table Name</param>
         *      /// <param name="DBConfig">Database Configuration</param>
         *      /// <returns></returns>
         *      public static string DBBulkInsertBuilder(ref DataTable table, string table_name, Connection.Database DBConfig)
         *      {
         *          return DBConfig.BulkInsert(ref table, table_name);
         *      }
         */

        /// <summary>
        /// Function For Build Dictonary from table/datatable
        /// </summary>
        /// <param name="strQuery"></param>
        /// <param name="strKeyColumnName"></param>
        /// <param name="strValueColumnName"></param>
        /// <param name="DBConfig"></param>
        /// <returns></returns>
        public static Dictionary <string, string> DBTableToDict(string strQuery, string strKeyColumnName, string strValueColumnName, Connection.Database DBConfig)
        {
            Dictionary <string, string> result = new Dictionary <string, string>();
            DataTable dtQueryTable             = DBConfig.MySqlToDataTable(strQuery);

            foreach (DataRow dr in dtQueryTable.Rows)
            {
                result.Add(GetDataFromRow(dr, strKeyColumnName), GetDataFromRow(dr, strValueColumnName));
            }

            return(result);
        }