public Object[] GetCustomerWithAbbreviationOrBarcodeId(string abbreviationId, string barcodeId)
{
Object[] custObjects = new Object[2];
CustomerObject customerO = new CustomerObject();
BarcodeCustomerObject barcodeCust = new BarcodeCustomerObject();
// find customer in SINGULAR's tables...
customerO = this.GetCustomerWithAbbreviation(abbreviationId);
if (customerO.Name == null && barcodeId.Equals(""))
{
return(null);
}
custObjects[1] = customerO;
String SQLQuery = "SELECT * FROM " + Properties.Resources.BarcodeCustomersTable;
if (abbreviationId.Equals("") && !barcodeId.Equals(""))
{
SQLQuery += " WHERE BARCODEID = '" + barcodeId + "'";
}
if (!abbreviationId.Equals("") && barcodeId.Equals(""))
{
SQLQuery += " WHERE ABBREVIATION = '" + abbreviationId + "'";
}
if (!abbreviationId.Equals("") && !barcodeId.Equals(""))
{
SQLQuery += " WHERE ABBREVIATION = '" + abbreviationId + "' AND BARCODEID = '" + barcodeId + "'";
}
DataTable DBTable = this.RefreshSQLConnection(SQLQuery, Properties.Resources.BarcodeCustomersTable);
// there is no customer in barcodecust table...
if (DBTable == null)
{
custObjects[0] = null;
return(custObjects);
}
if (DBTable.Rows.Count > 0)
{
barcodeCust.AbbreviationId = DBTable.Rows[0]["ABBREVIATION"].ToString();
barcodeCust.BarcodeId = DBTable.Rows[0]["BARCODEID"].ToString();
barcodeCust.OfferId = Convert.ToInt32(DBTable.Rows[0]["OFFERID"].ToString());
barcodeCust.DateRegistered = Convert.ToDateTime(DBTable.Rows[0]["DATEREGISTERED"].ToString());
custObjects[0] = barcodeCust;
custObjects[1] = customerO;
DBTable.Clear();
}
return(custObjects);
}
private CustomerObject GetCustomerWithAbbreviation(string abbreviationId)
{
CustomerObject customerO = new CustomerObject();
String SQLQuery = "SELECT ID, NAME FROM " + Properties.Resources.CustomersTable +
" WHERE ABBREVIATION = '" + abbreviationId + "'";
DataTable DBTable = this.RefreshSQLConnection(SQLQuery, Properties.Resources.CustomersTable);
if (DBTable == null)
{
return(customerO);
}
if (DBTable.Rows.Count > 0)
{
// find customer
customerO.Name = DBTable.Rows[0]["NAME"].ToString();
// find license plates
String SQLQueryL = "SELECT NAME FROM " + Properties.Resources.LicensePlatesTable +
" WHERE CUAID = '" + DBTable.Rows[0]["ID"] + "'";
DataTable DBTableL = this.RefreshLicensePlatesSQLConnection(SQLQueryL, Properties.Resources.LicensePlatesTable);
if (DBTableL.Rows.Count > 0)
{
customerO.LicensePlates = new String[DBTableL.Rows.Count];
int i = 0;
foreach (DataRow row in DBTableL.Rows)
{
customerO.LicensePlates[i] = row["NAME"].ToString();
i++;
}
}
DBTable.Clear();
DBTableL.Clear();
}
return(customerO);
}
