/// <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);
}
}