/// <summary>
/// Allows you to load a specific record of the [JobPartType] table.
/// </summary>
/// <param name="col_JobPartTypeId">Update this description in the "Olymars/Description" extended property of the "JobPartTypeId" column.</param>
public bool Refresh(System.Data.SqlTypes.SqlInt32 col_JobPartTypeId)
{
bool Status;
Reset();
if (col_JobPartTypeId.IsNull)
{
throw new ArgumentNullException("col_JobPartTypeId", "The primary key 'col_JobPartTypeId' can not have a Null value!");
}
this.col_JobPartTypeId = col_JobPartTypeId;
this.Param.Reset();
this.Param.Param_JobPartTypeId = this.col_JobPartTypeId;
System.Data.SqlClient.SqlDataReader DR;
SPs.spS_JobPartType SP = new SPs.spS_JobPartType(false);
if (SP.Execute(ref this.Param, out DR))
{
Status = false;
if (DR.Read())
{
if (!DR.IsDBNull(SPs.spS_JobPartType.Resultset1.Fields.Column_Description.ColumnIndex))
{
this.col_Description = DR.GetSqlString(SPs.spS_JobPartType.Resultset1.Fields.Column_Description.ColumnIndex);
}
if (!DR.IsDBNull(SPs.spS_JobPartType.Resultset1.Fields.Column_GeneralUnitCost.ColumnIndex))
{
this.col_GeneralUnitCost = DR.GetSqlMoney(SPs.spS_JobPartType.Resultset1.Fields.Column_GeneralUnitCost.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_JobPartType", "Refresh");
}
}
/// <summary>
/// Allows you to load a specific record of the [tblCategory] table.
/// </summary>
/// <param name="col_Cat_LngID">Update this description in the "Olymars/Description" extended property of the "Cat_LngID" column.</param>
public bool Refresh(System.Data.SqlTypes.SqlInt32 col_Cat_LngID)
{
bool Status;
Reset();
if (col_Cat_LngID.IsNull)
{
throw new ArgumentNullException("col_Cat_LngID", "The primary key 'col_Cat_LngID' can not have a Null value!");
}
this.col_Cat_LngID = col_Cat_LngID;
this.Param.Reset();
this.Param.Param_Cat_LngID = this.col_Cat_LngID;
System.Data.SqlClient.SqlDataReader DR;
SPs.spS_tblCategory SP = new SPs.spS_tblCategory(false);
if (SP.Execute(ref this.Param, out DR))
{
Status = false;
if (DR.Read())
{
if (!DR.IsDBNull(SPs.spS_tblCategory.Resultset1.Fields.Column_Cat_StrName.ColumnIndex))
{
this.col_Cat_StrName = DR.GetSqlString(SPs.spS_tblCategory.Resultset1.Fields.Column_Cat_StrName.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_tblCategory", "Refresh");
}
}