public static SqlDataBaseOjectHandler GlobalPerformQuery(string query) { SqlDataBaseOjectHandler handler = new SqlDataBaseOjectHandler(); try { SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn()); SqlConnectionClass.getConn().Open(); System.Data.ConnectionState state = SqlConnectionClass.getConn().State; if (!(state == System.Data.ConnectionState.Open)) { Helper_Classes_namespace.ErrorMessages.setErrorMessage(" Sorry no Db Connection !!!!!!! ", true); handler.hasErrors = true; return(handler); } command.ExecuteNonQuery(); handler.reader = command.ExecuteReader(); } catch (System.Exception em) { Helper_Classes_namespace.ErrorMessages.setErrorMessage(em.ToString(), true); handler.hasErrors = true; } return(handler); }
public SqlCommand PerformQuery(string query) { SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn()); SqlConnectionClass.getConn().Open(); System.Data.ConnectionState state = SqlConnectionClass.getConn().State; if (!(state == System.Data.ConnectionState.Open)) { MessageBox.Show(" Sorry no Db Connection !!!!!!! "); return(null); } return(command); }
public static void ClosePerformQuery() { SqlConnectionClass.getConn().Close(); }