public Tables.Product GetOne_Product(Guid id) { Params.spS_tblProduct param = new Params.spS_tblProduct(true); param.SetUpConnection(string.Empty); param.Param_Pro_GuidID = id; using (SPs.spS_tblProduct sp = new SPs.spS_tblProduct(true)) { System.Data.SqlClient.SqlDataReader sqlDataReader = null; sp.Execute(ref param, out sqlDataReader); param.Dispose(); if (sqlDataReader.Read()) { Tables.Product record = new Tables.Product(); record.Col_Pro_GuidID.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_GuidID.ColumnIndex); if (!record.Col_Pro_GuidID.UseNull) { record.Col_Pro_GuidID.Value = sqlDataReader.GetSqlGuid(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_GuidID.ColumnIndex).Value; } record.Name.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_StrName.ColumnIndex); if (!record.Name.UseNull) { record.Name.Value = sqlDataReader.GetSqlString(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_StrName.ColumnIndex).Value; } record.Col_Pro_CurPrice.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_CurPrice.ColumnIndex); if (!record.Col_Pro_CurPrice.UseNull) { record.Col_Pro_CurPrice.Value = sqlDataReader.GetSqlMoney(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_CurPrice.ColumnIndex).Value; } record.CategoryID.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_LngCategoryID.ColumnIndex); if (!record.CategoryID.UseNull) { record.CategoryID.Value = sqlDataReader.GetSqlInt32(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_LngCategoryID.ColumnIndex).Value; } sqlDataReader.Close(); sp.Connection.Close(); return(record); } else { sqlDataReader.Close(); sp.Connection.Close(); return(null); } } }
/// <summary> /// [To be supplied.] /// </summary> /// <returns>[To be supplied.]</returns> public bool Refresh() { this.displayName = null; this.col_Pro_StrNameWasUpdated = false; this.col_Pro_StrNameWasSet = false; this.col_Pro_StrName = System.Data.SqlTypes.SqlString.Null; this.col_Pro_CurPriceWasUpdated = false; this.col_Pro_CurPriceWasSet = false; this.col_Pro_CurPrice = System.Data.SqlTypes.SqlMoney.Null; this.col_Pro_LngCategoryIDWasUpdated = false; this.col_Pro_LngCategoryIDWasSet = false; this.col_Pro_LngCategoryID = System.Data.SqlTypes.SqlInt32.Null; bool alreadyOpened = false; Params.spS_tblProduct Param = new Params.spS_tblProduct(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_Pro_GuidID.IsNull) { Param.Param_Pro_GuidID = this.col_Pro_GuidID; } System.Data.SqlClient.SqlDataReader sqlDataReader = null; SPs.spS_tblProduct Sp = new SPs.spS_tblProduct(false); if (Sp.Execute(ref Param, out sqlDataReader)) { if (sqlDataReader.Read()) { if (!sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_StrName.ColumnIndex)) { this.col_Pro_StrName = sqlDataReader.GetSqlString(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_StrName.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_CurPrice.ColumnIndex)) { this.col_Pro_CurPrice = sqlDataReader.GetSqlMoney(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_CurPrice.ColumnIndex); } if (!sqlDataReader.IsDBNull(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_LngCategoryID.ColumnIndex)) { this.col_Pro_LngCategoryID = sqlDataReader.GetSqlInt32(SPs.spS_tblProduct.Resultset1.Fields.Column_Pro_LngCategoryID.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.Product", "Refresh"); } }