public static DataTable GetPortalTicketsTablePage(LoginUser loginUser, int from, int to, string sortField, TabularReport tabReport) { from++; to++; SqlCommand command = new SqlCommand(); GetPortalTicketsSQL(loginUser, command, tabReport, true, false); command.Parameters.AddWithValue("@From", from); command.Parameters.AddWithValue("@To", to); Report.AddCommandParameters(command, loginUser); DataTable table = new DataTable(); using (SqlConnection connection = new SqlConnection(loginUser.ConnectionString)) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted); command.Connection = connection; command.Transaction = transaction; try { using (SqlDataAdapter adapter = new SqlDataAdapter(command)) { adapter.Fill(table); } transaction.Commit(); table = DataUtils.DecodeDataTable(table); table = DataUtils.StripHtmlDataTable(table); } catch (Exception ex) { transaction.Rollback(); ExceptionLogs.LogException(loginUser, ex, "Portal Tickets Data", DataUtils.GetCommandTextSql(command)); throw; } connection.Close(); } return(table); }
public static void GetSummaryCommand(LoginUser loginUser, SqlCommand command, SummaryReport summaryReport, bool isSchemaOnly, bool useUserFilter, bool useDefaultOrderBy) { command.CommandType = CommandType.Text; GetSummarySql(loginUser, command, summaryReport, isSchemaOnly, null, useUserFilter, useDefaultOrderBy); Report.AddCommandParameters(command, loginUser); }