Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public MySqlConnection OpenConnection(string connnectionString)
- {
- if (conn == null || conn.State != ConnectionState.Open)
- {
- try
- {
- conn = new MySqlConnection(connnectionString);
- if (conn.State != ConnectionState.Open)
- conn.Open();
- }
- catch (Exception ex)
- {
- if (conn != null)
- {
- conn.Dispose();
- }
- }
- logger.LogError("--Debug Connection Issue-- \n" + "Connection state : " + conn.State);
- }
- return conn;
- }
- public int ExecuteCommand(string queryString)
- {
- try
- {
- conn = OpenConnection(connnectionString);
- MySqlCommand cmd = new MySqlCommand(queryString, conn);
- object id = cmd.ExecuteScalar();
- string newProdID = id != null ? id.ToString() : "0";
- conn.Close();
- conn.Dispose();
- return Int32.Parse(newProdID);
- }
- catch (Exception ex)
- {
- logger.LogError("Mysql Error Additional Log Info:" + "\n Query String: " + queryString + "\n Connection state: " + conn.State + " \n Exeception Stacktrace : " + ex.StackTrace + " \n Exeception InnerException : " + ex.InnerException + " \n Exeception Message : " + ex.Message);
- throw ex;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement