public DataTable ConvertReaderToTable(DbDataReader reader) { DataReaderAdapter dra = new DataReaderAdapter(); DataTable dt = new DataTable(); dra.FillFromReader(dt, reader); return dt; }
public DataTable ConvertReaderToTable(DbDataReader reader) { DataReaderAdapter dra = new DataReaderAdapter(); DataTable dt = new DataTable(); dra.FillFromReader(dt, reader); return(dt); }
DataTable GetTrailersComingIn() { try { string connectionString = WebConfigurationManager.ConnectionStrings["Orchestrator"].ConnectionString; using (SqlConnection conTrailersCominIn = new SqlConnection(connectionString)) { conTrailersCominIn.Open(); SqlCommand cmdTrailersComingIn = new SqlCommand("spTrailer_GetLastPosition"); cmdTrailersComingIn.CommandType = CommandType.StoredProcedure; cmdTrailersComingIn.Connection = conTrailersCominIn; cmdTrailersComingIn.Parameters.Add(new SqlParameter("@TrafficAreas", TrafficAreaIds)); SqlDataReader dr = cmdTrailersComingIn.ExecuteReader(); if (dr != null) { DataReaderAdapter dar = new DataReaderAdapter(); DataTable dt = new DataTable(); dar.FillFromReader(dt, dr); if (dt != null && dt.Columns.Count > 0) { conTrailersCominIn.Close(); return(dt); } } } } catch (SqlException sqle) { if (Utilities.MapSqlException(sqle) && getTrailersComingInErrorCount < 5) { getTrailersComingInErrorCount++; return(GetTrailersComingIn()); } else { throw; } } catch (Exception e) { throw e; } return(null); }
/// <summary> /// Converts <paramref name="dataReader" /> value to DataTable instance. /// </summary> public static DataTable ToDataTable(this IDataReader dataReader) { if (dataReader == null) { throw new ArgumentNullException("dataReader"); } var outputTable = new DataTable { Locale = CultureInfo.InvariantCulture }; var adapter = new DataReaderAdapter(); adapter.FillFromReader(outputTable, dataReader); dataReader.Close(); return(outputTable); }
DataTable GetMyTrailers() { try { string connectionString = WebConfigurationManager.ConnectionStrings["Orchestrator"].ConnectionString; using (SqlConnection conMyResource = new SqlConnection(connectionString)) { conMyResource.Open(); SqlCommand cmdMyResource = new SqlCommand("spResource_GetDepotCodeResources"); cmdMyResource.Parameters.Add(new SqlParameter("@ControlAreaId", _filter.ControlAreaId)); cmdMyResource.Parameters.Add(new SqlParameter("@TrafficAreaIds", TrafficAreaIds)); cmdMyResource.Parameters.Add(new SqlParameter("@StartDate", _filter.FilterStartDate)); cmdMyResource.Parameters.Add(new SqlParameter("@EndDate", _filter.FilterEnddate)); cmdMyResource.Parameters.Add(new SqlParameter("@OnlyShowAvailable", false)); cmdMyResource.Parameters.Add(new SqlParameter("@ResourceTypeId", 2)); cmdMyResource.Parameters.Add(new SqlParameter("@HomeDepotId", _filter.DepotId)); cmdMyResource.Parameters.Add(new SqlParameter("@DriverRequestsHoursAhead", Orchestrator.Globals.Configuration.DriverRequestHoursAhead)); cmdMyResource.Parameters.Add(new SqlParameter("@OnlyShowIfNoFuture", _filter.OnlyShowEmptyTrailers)); cmdMyResource.CommandType = CommandType.StoredProcedure; cmdMyResource.Connection = conMyResource; DataReaderAdapter dar = new DataReaderAdapter(); SqlDataReader dr = cmdMyResource.ExecuteReader(); if (dr != null) { DataTable dtMyTrailers = new DataTable(); dar.FillFromReader(dtMyTrailers, dr); if (dtMyTrailers != null && dtMyTrailers.Columns.Count > 0) { using (SqlConnection conMyResourceFuture = new SqlConnection(connectionString)) { conMyResourceFuture.Open(); SqlCommand cmdMyResourceFuture = new SqlCommand("spResource_GetAllResourceFutures"); cmdMyResourceFuture.CommandType = CommandType.StoredProcedure; cmdMyResourceFuture.Parameters.Add(new SqlParameter("@ResourceTypeId", 2)); cmdMyResourceFuture.Connection = conMyResourceFuture; _rdrMyResourceFuture = cmdMyResourceFuture.ExecuteReader(); if (_rdrMyResourceFuture != null) { DataTable dtMyResourceFuture = new DataTable(); dar.FillFromReader(dtMyResourceFuture, _rdrMyResourceFuture); if (dtMyResourceFuture != null) { DataView dv = null; dv = dtMyResourceFuture.DefaultView; DataView trailersWithFuture = dtMyTrailers.DefaultView; trailersWithFuture.RowFilter = "HasFuture = 1"; PopulateTrailerFutures(trailersWithFuture, dv); dtMyTrailers.DefaultView.RowFilter = ""; conMyResource.Close(); return(dtMyTrailers); } } } } } } } catch (SqlException sqle) { if (Utilities.MapSqlException(sqle) && getMyTrailersErrorCount < 5) { getMyTrailersErrorCount++; return(GetMyTrailers()); } else { throw; } } catch (Exception e) { throw e; } return(null); }
void Traffic_TrafficSheet4_PreRenderComplete(object sender, EventArgs e) { DataReaderAdapter dar = new DataReaderAdapter(); #region My Resource DataTable dtMyDrivers = new DataTable(); DataTable dtMyTrailers = new DataTable(); DataTable dtMyVehicles = new DataTable(); DataTable dtMyResourceFuture = new DataTable(); CheckBox chkShowDriversWithoutReload = ((CheckBox)RadPanelbar1.FindControl("chkShowDriversWithoutReloads")); try { if (_rdrMyResource != null) { dar.FillFromReader(dtMyDrivers, _rdrMyResource); if (_rdrMyResourceFuture != null) { dar.FillFromReader(dtMyResourceFuture, _rdrMyResourceFuture); if (dtMyResourceFuture != null) { DataView dv = null; dv = dtMyResourceFuture.DefaultView; //Fill My Drivers Grid if (dtMyDrivers != null && dtMyDrivers.Columns.Count > 0) { DataView driversWithFuture = dtMyDrivers.DefaultView; //if (_filter.OnlyShowDriversWithoutReloads == false) //{ // BUG: t.lunken this will restrict to only people who have got a future booking (Doh!) //driversWithFuture.RowFilter = "HasFuture = 1"; PopulateDriverFutures(driversWithFuture, dv); //} ((ComponentArt.Web.UI.Grid)RadPanelbar1.Items[0].Items[0].FindControl("grdMyDrivers")).ItemContentCreated += new ComponentArt.Web.UI.Grid.ItemContentCreatedEventHandler(TSResource_ItemContentCreated); ((ComponentArt.Web.UI.Grid)RadPanelbar1.Items[0].Items[0].FindControl("grdMyDrivers")).DataSource = driversWithFuture; ((ComponentArt.Web.UI.Grid)RadPanelbar1.Items[0].Items[0].FindControl("grdMyDrivers")).DataBind(); } } } } } finally { if (_rdrMyResource != null) { _rdrMyResource.Dispose(); } if (_rdrMyResourceFuture != null) { _rdrMyResourceFuture.Dispose(); } } #endregion }