public DownloadBatchRow(SqlDataReader reader) { OriginalKey = reader.GetInt32(reader.GetOrdinal("OriginalKey")); PackageId = reader.GetString(reader.GetOrdinal("PackageId")); PackageVersion = reader.GetString(reader.GetOrdinal("PackageVersion")); PackageListed = reader.GetBoolean(reader.GetOrdinal("PackageListed")); PackageTitle = GetNullableField(reader, reader.GetOrdinal("PackageTitle")); PackageDescription = GetNullableField(reader, reader.GetOrdinal("PackageDescription")); PackageIconUrl = GetNullableField(reader, reader.GetOrdinal("PackageIconUrl")); DownloadUserAgent = reader.GetString(reader.GetOrdinal("DownloadUserAgent")); DownloadOperation = reader.GetString(reader.GetOrdinal("DownloadOperation")); DownloadTimestamp = reader.GetSqlDateTime(reader.GetOrdinal("DownloadTimestamp")); DownloadProjectTypes = NormalizeProjectTypes(GetNullableField(reader, reader.GetOrdinal("DownloadProjectTypes"))); DownloadDependentPackageId = GetNullableField(reader, reader.GetOrdinal("DownloadDependentPackageId")); }
private static MembershipEntry ConvertFromRow(SqlDataReader results, out string eTag, out int tableVersion, out string versionETag) { var entry = new MembershipEntry(); int port = results.GetInt32(PortIdx); int gen = results.GetInt32(GenerationIdx); entry.SiloAddress = SiloAddress.New(new IPEndPoint(IPAddress.Parse(results.GetString(AddressIdx)), port), gen); entry.HostName = results.GetString(HostNameIdx); entry.Status = (SiloStatus)results.GetInt32(StatusIdx); if (!results.GetSqlInt32(ProxyPortIdx).IsNull) entry.ProxyPort = results.GetInt32(ProxyPortIdx); if (!results.GetSqlBoolean(PrimaryIdx).IsNull) entry.IsPrimary = results.GetBoolean(PrimaryIdx); entry.RoleName = results.GetString(RoleNameIdx); entry.InstanceName = results.GetString(InstanceNameIdx); if (!results.GetSqlInt32(UpdateZoneIdx).IsNull) entry.UpdateZone = results.GetInt32(UpdateZoneIdx); if (!results.GetSqlInt32(FaultZoneIdx).IsNull) entry.FaultZone = results.GetInt32(FaultZoneIdx); if (!results.GetSqlDateTime(StartTimeIdx).IsNull) entry.StartTime = results.GetDateTime(StartTimeIdx); if (!results.GetSqlDateTime(IAmAliveTimeIdx).IsNull) entry.IAmAliveTime = results.GetDateTime(IAmAliveTimeIdx); eTag = results.GetString(ETagIdx); tableVersion = (int)results.GetInt64(VersionIdx); versionETag = results.GetString(VersionETagIdx); var suspectingSilosString = results.GetSqlString(SuspectingSilosIdx); var suspectingTimesString = results.GetSqlString(SuspectingTimesIdx); List<SiloAddress> suspectingSilos = new List<SiloAddress>(); List<DateTime> suspectingTimes = new List<DateTime>(); if (!suspectingSilosString.IsNull && !string.IsNullOrEmpty(suspectingSilosString.Value)) { string[] silos = suspectingSilosString.Value.Split('|'); foreach (string silo in silos) { suspectingSilos.Add(SiloAddress.FromParsableString(silo)); } } if (!suspectingTimesString.IsNull && !string.IsNullOrEmpty(suspectingTimesString.Value)) { string[] times = suspectingTimesString.Value.Split('|'); foreach (string time in times) { suspectingTimes.Add(TraceLogger.ParseDate(time)); } } if (suspectingSilos.Count != suspectingTimes.Count) throw new OrleansException(String.Format("SuspectingSilos.Length of {0} as read from SQL table is not eqaul to SuspectingTimes.Length of {1}", suspectingSilos.Count, suspectingTimes.Count)); for (int i = 0; i < suspectingSilos.Count; i++) { entry.AddSuspector(suspectingSilos[i], suspectingTimes[i]); } return entry; }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_Ord_DatOrderedOnWasUpdated = false; this.col_Ord_DatOrderedOnWasSet = false; this.col_Ord_DatOrderedOn = System.Data.SqlTypes.SqlDateTime.Null; this.col_Ord_LngCustomerIDWasUpdated = false; this.col_Ord_LngCustomerIDWasSet = false; this.col_Ord_LngCustomerID = System.Data.SqlTypes.SqlInt32.Null; this.col_Ord_CurTotalWasUpdated = false; this.col_Ord_CurTotalWasSet = false; this.col_Ord_CurTotal = System.Data.SqlTypes.SqlMoney.Null; bool alreadyOpened = false; Params.spS_tblOrder Param = new Params.spS_tblOrder(true); Param.CommandTimeOut = this.selectCommandTimeOut; switch (this.lastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case OlymarsDemo.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } if (!this.col_Ord_GuidID.IsNull) { Param.Param_Ord_GuidID = this.col_Ord_GuidID; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_tblOrder Sp = new SPs.spS_tblOrder(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_DatOrderedOn.ColumnIndex)) { this.col_Ord_DatOrderedOn = sqlDataReader.GetSqlDateTime(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_DatOrderedOn.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_LngCustomerID.ColumnIndex)) { this.col_Ord_LngCustomerID = sqlDataReader.GetSqlInt32(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_LngCustomerID.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_CurTotal.ColumnIndex)) { this.col_Ord_CurTotal = sqlDataReader.GetSqlMoney(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_CurTotal.ColumnIndex); } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = true; return(true); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = false; return(false); } } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new OlymarsDemo.DataClasses.CustomException(Param, "OlymarsDemo.BusinessComponents.tblOrder_Record", "Refresh"); } }
public void GetDateTimeTest () { cmd.CommandText = "Select type_datetime,10,convert(datetime,null)"; cmd.CommandText += "from datetime_family where id=1"; reader = cmd.ExecuteReader (); reader.Read (); // Test for standard exceptions GetMethodTests("DateTime"); // Test if data is returned correctly Assert.AreEqual (datetimeRow["type_datetime"], reader.GetDateTime(0), "#2 DataValidation Failed"); // Test for standard exceptions GetMethodTests("SqlDateTime"); // Test if data is returned correctly Assert.AreEqual (datetimeRow["type_datetime"], reader.GetSqlDateTime(0).Value, "#2 DataValidation Failed"); reader.Close (); }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_DescriptionWasUpdated = false; this.col_DescriptionWasSet = false; this.col_Description = System.Data.SqlTypes.SqlString.Null; this.col_PriceWasUpdated = false; this.col_PriceWasSet = false; this.col_Price = System.Data.SqlTypes.SqlMoney.Null; this.col_StartDateWasUpdated = false; this.col_StartDateWasSet = false; this.col_StartDate = System.Data.SqlTypes.SqlDateTime.Null; this.col_EndDateWasUpdated = false; this.col_EndDateWasSet = false; this.col_EndDate = System.Data.SqlTypes.SqlDateTime.Null; this.col_CustomerIdWasUpdated = false; this.col_CustomerIdWasSet = false; this.col_CustomerId = System.Data.SqlTypes.SqlInt32.Null; bool alreadyOpened = false; Params.spS_Job Param = new Params.spS_Job(true); Param.CommandTimeOut = this.selectCommandTimeOut; switch (this.lastKnownConnectionType) { case Bob.DataClasses.ConnectionType.ConnectionString: Param.SetUpConnection(this.connectionString); break; case Bob.DataClasses.ConnectionType.SqlConnection: Param.SetUpConnection(this.sqlConnection); alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open); break; case Bob.DataClasses.ConnectionType.SqlTransaction: Param.SetUpConnection(this.sqlTransaction); break; } if (!this.col_JobId.IsNull) { Param.Param_JobId = this.col_JobId; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_Job Sp = new SPs.spS_Job(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_Description.ColumnIndex)) { this.col_Description = sqlDataReader.GetSqlString(SPs.spS_Job.Resultset1.Fields.Column_Description.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_Price.ColumnIndex)) { this.col_Price = sqlDataReader.GetSqlMoney(SPs.spS_Job.Resultset1.Fields.Column_Price.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_StartDate.ColumnIndex)) { this.col_StartDate = sqlDataReader.GetSqlDateTime(SPs.spS_Job.Resultset1.Fields.Column_StartDate.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_EndDate.ColumnIndex)) { this.col_EndDate = sqlDataReader.GetSqlDateTime(SPs.spS_Job.Resultset1.Fields.Column_EndDate.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_CustomerId.ColumnIndex)) { this.col_CustomerId = sqlDataReader.GetSqlInt32(SPs.spS_Job.Resultset1.Fields.Column_CustomerId.ColumnIndex); } if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = true; return(true); } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); this.recordIsLoaded = false; return(false); } } else { if (sqlDataReader != null && !sqlDataReader.IsClosed) { sqlDataReader.Close(); } CloseConnection(Sp.Connection, alreadyOpened); throw new Bob.DataClasses.CustomException(Param, "Bob.BusinessComponents.Job_Record", "Refresh"); } }
public DownloadBatchRow(SqlDataReader reader) { OriginalKey = reader.GetInt32(reader.GetOrdinal("OriginalKey")); PackageId = reader.GetString(reader.GetOrdinal("PackageId")); PackageVersion = reader.GetString(reader.GetOrdinal("PackageVersion")); DownloadUserAgent = reader.GetString(reader.GetOrdinal("DownloadUserAgent")); DownloadOperation = reader.GetString(reader.GetOrdinal("DownloadOperation")); DownloadTimestamp = reader.GetSqlDateTime(reader.GetOrdinal("DownloadTimestamp")); }