/// <summary> /// Loads the tblProduct abstract class for the current selected record primary key. /// </summary> /// <returns>true if the call succeeded; false, otherwise.</returns> public bool RefreshCurrentRecord() { if (this.SelectedIndex == -1) { if (oAbstract_tblProduct != null) { oAbstract_tblProduct.Reset(); } return(false); } System.Data.SqlTypes.SqlGuid PK_Pro_GuidID = new Guid(this.SelectedItem.Value); if (this.oAbstract_tblProduct == null) { switch (this.LastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: this.oAbstract_tblProduct = new OlymarsDemo.AbstractClasses.Abstract_tblProduct(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: this.oAbstract_tblProduct = new OlymarsDemo.AbstractClasses.Abstract_tblProduct(this.sqlConnection); break; } } return(this.oAbstract_tblProduct.Refresh(PK_Pro_GuidID)); }
/// <summary> /// Loads the tblProduct abstract class for the current selected record primary key. /// </summary> /// <returns>true if the call succeeded; false, otherwise.</returns> public bool RefreshCurrentRecord() { if (this.SelectionMode != System.Windows.Forms.SelectionMode.One) { throw new InvalidOperationException("SelectionMode property is not set to One. Hence, you cannot call this method."); } if (this.SelectedIndex == -1) { if (oAbstract_tblProduct != null) { oAbstract_tblProduct.Reset(); } return(false); } System.Data.SqlTypes.SqlGuid PK_Pro_GuidID = (System.Guid) this.SelectedValue; if (this.oAbstract_tblProduct == null) { switch (this.LastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: this.oAbstract_tblProduct = new OlymarsDemo.AbstractClasses.Abstract_tblProduct(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: this.oAbstract_tblProduct = new OlymarsDemo.AbstractClasses.Abstract_tblProduct(this.sqlConnection); break; } } return(this.oAbstract_tblProduct.Refresh(PK_Pro_GuidID)); }
/// <summary> /// Disposes the current instance of this object. /// </summary> public override void Dispose() { this.oAbstract_tblProduct = null; this.FK_Pro_LngCategoryID = System.Data.SqlTypes.SqlInt32.Null; if (this.param != null) { this.param.Dispose(); } base.Dispose(); }
/// <summary> /// Disposes the current instance of this object. /// </summary> /// <param name="disposing"> /// true to release both managed and unmanaged resources; /// false to release only unmanaged resources. /// </param> protected override void Dispose(bool disposing) { if (disposing) { this.oAbstract_tblProduct = null; this.FK_Pro_LngCategoryID = System.Data.SqlTypes.SqlInt32.Null; if (this.param != null) { this.param.Dispose(); } } base.Dispose(disposing); }
private bool RefreshCurrentRecord() { EmptyControls(); Abstracts.Abstract_tblProduct oAbstract_tblProduct = null; switch (this.lastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: oAbstract_tblProduct = new Abstracts.Abstract_tblProduct(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: oAbstract_tblProduct = new Abstracts.Abstract_tblProduct(this.sqlConnection); break; } if (oAbstract_tblProduct.Refresh(this.currentID)) { this.IgnoreChanges = true; if (!oAbstract_tblProduct.Col_Pro_StrName.IsNull) { Control_Pro_StrName.Text = oAbstract_tblProduct.Col_Pro_StrName.Value.ToString(); } if (!oAbstract_tblProduct.Col_Pro_CurPrice.IsNull) { Control_Pro_CurPrice.Text = oAbstract_tblProduct.Col_Pro_CurPrice.Value.ToString(); } if (!oAbstract_tblProduct.Col_Pro_LngCategoryID.IsNull) { Control_Pro_LngCategoryID.SelectedValue = oAbstract_tblProduct.Col_Pro_LngCategoryID.Value; } this.IgnoreChanges = false; return(true); } else { MessageBox.Show("The record does not exist any more !", "Record not found", MessageBoxButtons.OK, MessageBoxIcon.Stop); return(false); } }