/// <summary> /// Loads the tblOrder 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_tblOrder != null) { oAbstract_tblOrder.Reset(); } return(false); } System.Data.SqlTypes.SqlGuid PK_Ord_GuidID = new Guid(this.SelectedItem.Value); if (this.oAbstract_tblOrder == null) { switch (this.LastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: this.oAbstract_tblOrder = new OlymarsDemo.AbstractClasses.Abstract_tblOrder(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: this.oAbstract_tblOrder = new OlymarsDemo.AbstractClasses.Abstract_tblOrder(this.sqlConnection); break; } } return(this.oAbstract_tblOrder.Refresh(PK_Ord_GuidID)); }
/// <summary> /// Loads the tblOrder 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_tblOrder != null) { oAbstract_tblOrder.Reset(); } return(false); } System.Data.SqlTypes.SqlGuid PK_Ord_GuidID = (System.Guid) this.SelectedValue; if (this.oAbstract_tblOrder == null) { switch (this.LastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: this.oAbstract_tblOrder = new OlymarsDemo.AbstractClasses.Abstract_tblOrder(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: this.oAbstract_tblOrder = new OlymarsDemo.AbstractClasses.Abstract_tblOrder(this.sqlConnection); break; } } return(this.oAbstract_tblOrder.Refresh(PK_Ord_GuidID)); }
/// <summary> /// Disposes the current instance of this object. /// </summary> public override void Dispose() { this.oAbstract_tblOrder = null; this.FK_Ord_LngCustomerID = 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_tblOrder = null; this.FK_Ord_LngCustomerID = System.Data.SqlTypes.SqlInt32.Null; if (this.param != null) { this.param.Dispose(); } } base.Dispose(disposing); }
private bool RefreshCurrentRecord() { EmptyControls(); Abstracts.Abstract_tblOrder oAbstract_tblOrder = null; switch (this.lastKnownConnectionType) { case OlymarsDemo.DataClasses.ConnectionType.ConnectionString: oAbstract_tblOrder = new Abstracts.Abstract_tblOrder(this.connectionString); break; case OlymarsDemo.DataClasses.ConnectionType.SqlConnection: oAbstract_tblOrder = new Abstracts.Abstract_tblOrder(this.sqlConnection); break; } if (oAbstract_tblOrder.Refresh(this.currentID)) { this.IgnoreChanges = true; if (!oAbstract_tblOrder.Col_Ord_DatOrderedOn.IsNull) { Control_Ord_DatOrderedOn.Text = oAbstract_tblOrder.Col_Ord_DatOrderedOn.Value.ToString(); } if (!oAbstract_tblOrder.Col_Ord_LngCustomerID.IsNull) { Control_Ord_LngCustomerID.SelectedValue = oAbstract_tblOrder.Col_Ord_LngCustomerID.Value; } if (!oAbstract_tblOrder.Col_Ord_CurTotal.IsNull) { Control_Ord_CurTotal.Text = oAbstract_tblOrder.Col_Ord_CurTotal.Value.ToString(); } this.IgnoreChanges = false; return(true); } else { MessageBox.Show("The record does not exist any more !", "Record not found", MessageBoxButtons.OK, MessageBoxIcon.Stop); return(false); } }