/// <summary> /// Allows you to load a specific record of the [tblOrder] table. /// </summary> /// <param name="col_Ord_GuidID">Update this description in the "Olymars/Description" extended property of the "Ord_GuidID" column.</param> public bool Refresh(System.Data.SqlTypes.SqlGuid col_Ord_GuidID) { bool Status; Reset(); if (col_Ord_GuidID.IsNull) { throw new ArgumentNullException("col_Ord_GuidID", "The primary key 'col_Ord_GuidID' can not have a Null value!"); } this.col_Ord_GuidID = col_Ord_GuidID; this.Param.Reset(); this.Param.Param_Ord_GuidID = this.col_Ord_GuidID; System.Data.SqlClient.SqlDataReader DR; SPs.spS_tblOrder SP = new SPs.spS_tblOrder(false); if (SP.Execute(ref this.Param, out DR)) { Status = false; if (DR.Read()) { if (!DR.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_DatOrderedOn.ColumnIndex)) { this.col_Ord_DatOrderedOn = DR.GetSqlDateTime(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_DatOrderedOn.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_LngCustomerID.ColumnIndex)) { this.col_Ord_LngCustomerID = DR.GetSqlInt32(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_LngCustomerID.ColumnIndex); } if (!DR.IsDBNull(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_CurTotal.ColumnIndex)) { this.col_Ord_CurTotal = DR.GetSqlMoney(SPs.spS_tblOrder.Resultset1.Fields.Column_Ord_CurTotal.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 OlymarsDemo.DataClasses.CustomException(this.Param, "OlymarsDemo.AbstractClasses.Abstract_tblOrder", "Refresh"); } }
/// <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"); } }