public static SqlConnection GetSqlConnection() { SqlConnection con = null; try { con = DBAccessController.dbGetSqlConnection(); } catch (Exception ex) { WriteLog(ex, "GetSqlConnection()", true, true); } return(con); }
/// <summary> /// EXEC NON QUERY COMMANDS WITH NO RETURN OF DATA /// </summary> /// <param name="dataDecrypted"></param> /// <param name="action"></param> /// <returns></returns> public static async Task <bool> SqlCommandExecute(byte[] dataDecrypted, string action) { bool result = false; try { //INSERT, UPDATE AND DELETE string sqlCommandString = Encoding.UTF8.GetString(dataDecrypted); SqlCommand cmd = new SqlCommand(sqlCommandString, DBAccessController.dbGetSqlConnection()); int afectedRows = cmd.ExecuteNonQuery(); if (afectedRows > 0) { result = true; } } catch (Exception ex) { Sistem.WriteLog(ex, "SqlCommandExecute(byte[] dataDecrypted, string action)", true); } return(result); }
/// <summary> /// EXEC QUERY COMMANDS THAT RETURNS DATA /// </summary> /// <param name="dataDecrypted"></param> /// <param name="action"></param> /// <param name="returnDt"></param> /// <returns></returns> public static async Task <DataTable> SqlCommandExecute(byte[] dataDecrypted, string action, bool returnDt = true) { DataTable result = null; try { string sqlCommandString = Encoding.UTF8.GetString(dataDecrypted); SqlCommand cmd = new SqlCommand(Encoding.UTF8.GetString(dataDecrypted), DBAccessController.dbGetSqlConnection()); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(result); } catch (Exception ex) { Sistem.WriteLog(ex, "SqlCommandExecute(byte[] dataDecrypted, string action, bool returnDt = true)", true); } return(result); }