/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual TerritoriesInfo GetValueByID(string TerritoryID)
{
motor.OpenConnection();
TerritoriesInfo value = TerritoriesDAO.GetValueByID(TerritoryID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual EmployeesInfo GetValueByID(int EmployeeID)
{
motor.OpenConnection();
EmployeesInfo value = EmployeesDAO.GetValueByID(EmployeeID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual TagInfo GetValueByID(int TagID)
{
motor.OpenConnection();
TagInfo value = TagDAO.GetValueByID(TagID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual CustomerCustomerDemoInfo GetValueByID(string CustomerID, string CustomerTypeID)
{
motor.OpenConnection();
CustomerCustomerDemoInfo value = CustomerCustomerDemoDAO.GetValueByID(CustomerID, CustomerTypeID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual ShippersInfo GetValueByID(int ShipperID)
{
motor.OpenConnection();
ShippersInfo value = ShippersDAO.GetValueByID(ShipperID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual CategoriesInfo GetValueByID(int CategoryID)
{
motor.OpenConnection();
CategoriesInfo value = CategoriesDAO.GetValueByID(CategoryID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual RegionInfo GetValueByID(int RegionID)
{
motor.OpenConnection();
RegionInfo value = RegionDAO.GetValueByID(RegionID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual OrderDetailsInfo GetValueByID(int OrderID, int ProductID)
{
motor.OpenConnection();
OrderDetailsInfo value = OrderDetailsDAO.GetValueByID(OrderID, ProductID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
/// <summary>
/// Retrieves the data using only the primary key ID. Ex.: "Select * from MyTable where id=1"
/// </summary>
/// <returns>The class filled if found.</returns>
public virtual ProductsInfo GetValueByID(int ProductID)
{
motor.OpenConnection();
ProductsInfo value = ProductsDAO.GetValueByID(ProductID);
if (this.closeConnectionWhenFinish)
{
motor.CloseConnection();
}
return(value);
}
private void btnTestConnection_Click(object sender, RoutedEventArgs e)
{
Motor motor = new Motor(MyPassword.Text);
try
{
motor.OpenConnection();
motor.CloseConnection();
MessageBox.Show("OK");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}