/// <summary> /// Allows you to load a specific record of the [JobPart] table. /// </summary> /// <param name="col_JobPartId">Update this description in the "Olymars/Description" extended property of the "JobPartId" column.</param> public bool Refresh(System.Data.SqlTypes.SqlInt32 col_JobPartId) { bool Status; Reset(); if (col_JobPartId.IsNull) { throw new ArgumentNullException("col_JobPartId", "The primary key 'col_JobPartId' can not have a Null value!"); } this.col_JobPartId = col_JobPartId; this.Param.Reset(); this.Param.Param_JobPartId = this.col_JobPartId; System.Data.SqlClient.SqlDataReader DR; SPs.spS_JobPart SP = new SPs.spS_JobPart(false); if (SP.Execute(ref this.Param, out DR)) { Status = false; if (DR.Read()) { if (!DR.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_JobId.ColumnIndex)) { this.col_JobId = DR.GetSqlInt32(SPs.spS_JobPart.Resultset1.Fields.Column_JobId.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_Description.ColumnIndex)) { this.col_Description = DR.GetSqlString(SPs.spS_JobPart.Resultset1.Fields.Column_Description.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_JobPartTypeId.ColumnIndex)) { this.col_JobPartTypeId = DR.GetSqlInt32(SPs.spS_JobPart.Resultset1.Fields.Column_JobPartTypeId.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_Units.ColumnIndex)) { this.col_Units = DR.GetSqlDecimal(SPs.spS_JobPart.Resultset1.Fields.Column_Units.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_PricePerUnit.ColumnIndex)) { this.col_PricePerUnit = DR.GetSqlMoney(SPs.spS_JobPart.Resultset1.Fields.Column_PricePerUnit.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_JobPart.Resultset1.Fields.Column_TotalPrice.ColumnIndex)) { this.col_TotalPrice = DR.GetSqlMoney(SPs.spS_JobPart.Resultset1.Fields.Column_TotalPrice.ColumnIndex); } Status = true; } if (DR != null && !DR.IsClosed) { DR.Close(); } if (CloseConnectionAfterUse && SP.Connection != null && SP.Connection.State == System.Data.ConnectionState.Open) { SP.Connection.Close(); SP.Connection.Dispose(); } return(Status); } else { if (DR != null && !DR.IsClosed) { DR.Close(); } if (CloseConnectionAfterUse && SP.Connection != null && SP.Connection.State == System.Data.ConnectionState.Open) { SP.Connection.Close(); SP.Connection.Dispose(); } throw new Bob.DataClasses.CustomException(this.Param, "Bob.AbstractClasses.Abstract_JobPart", "Refresh"); } }