/// <summary>
/// Read Customers table by InUse, true for active Customers, false for
/// inactive Customers
/// </summary>
/// <param name="pInUse">True for active, false for inactive</param>
/// <returns></returns>
public DataTable Customers(bool pInUse = true)
{
var dt = new DataTable();
CustomerStatements cs = new CustomerStatements();
var selectStatement = cs.SelectStandard();
using (SqlConnection cn = new SqlConnection {
ConnectionString = ConnectionString
})
{
using (SqlCommand cmd = new SqlCommand {
Connection = cn
})
{
cmd.CommandText = selectStatement;
try
{
cmd.Parameters.AddWithValue("@InUse", pInUse);
cn.Open();
dt.Load(cmd.ExecuteReader());
}
catch (Exception e)
{
mHasException = true;
mLastException = e;
}
}
}
return(dt);
}
/// <summary>
/// Obtain column configurations for Customers table
/// </summary>
/// <returns></returns>
public List <DataGridViewColumnDefinition> CustomerConfigurationItems()
{
CustomerStatements cs = new CustomerStatements();
return(cs.ConfigureDataGridViewColumns());
}
