public void AddNewMerchandiseToLicense(string name, string company, string maxWeight, string maxUnitPrice,
string unitWeight, string unitPrice, string count)
{
double _maxUnitPrice = String.IsNullOrEmpty(maxUnitPrice) ? -1 : Convert.ToDouble(maxUnitPrice);
double _maxWeight = String.IsNullOrEmpty(maxWeight) ? -1 : Convert.ToDouble(maxWeight);
double _unitPrice = String.IsNullOrEmpty(unitPrice) ? -1 : Convert.ToDouble(unitPrice);
double _unitWeight = String.IsNullOrEmpty(unitWeight) ? -1 : Convert.ToDouble(unitWeight);
int _count = String.IsNullOrEmpty(count) ? -1 : Convert.ToInt32(count);
MerchandiseInLicense newMerchandise = new MerchandiseInLicense(name, company, _maxWeight, _maxUnitPrice,
_unitWeight, _unitPrice, _count);
merchantLicense.AddNewMercahndise(newMerchandise);
}
public MerchantLicense GetLicenseWithNumber(string licenseNumber)
{
string query = "select * from dbo.MerchantLicense where number = '" + licenseNumber + "'";
DBConnection dbConnection = new DBConnection();
List <List <Object> > queryResult = new List <List <Object> >();
queryResult = dbConnection.RunSelectQuery(query);
if (queryResult.Count == 0)
{
MessageBox.Show("No MerchantLicense Found with licenseNumber: " + licenseNumber);
return(null);
}
int licenseNum = Convert.ToInt16(licenseNumber);
string licenseName = Convert.ToString(queryResult[0][1]);
string SSN = Convert.ToString(queryResult[0][2]);
DateTime issuanceDate = Convert.ToDateTime(queryResult[0][3]);
DateTime expirationDate = Convert.ToDateTime(queryResult[0][4]);
double wholeValue = Convert.ToDouble(queryResult[0][5]);
string weight = Convert.ToString(queryResult[0][6]); /*treated as company List */
double maxUnitPrice = Convert.ToDouble(queryResult[0][7]);
double maxUnitWeight = Convert.ToDouble(queryResult[0][8]);
string importType = Convert.ToString(queryResult[0][9]);
string country = Convert.ToString(queryResult[0][10]);
MerchantLicense merchantLicense = new MerchantLicense();
merchantLicense.SetLicenseNumber(licenseNum);
merchantLicense.SetParameters(issuanceDate, expirationDate, licenseName, wholeValue, weight,
maxUnitPrice, maxUnitWeight, importType, country, SSN);
//MessageBox.Show("in DAO; found merchant license for ssn: " + SSN);
string queryToFindMerchandiseId = "select merchandiseid from dbo.LicenseHasMerchandise where licenseNumber = '"
+ licenseNumber + "'";
List <List <Object> > merchandiseIdObjects = new List <List <Object> >();
merchandiseIdObjects = dbConnection.RunSelectQuery(queryToFindMerchandiseId);
List <string> merchandiseIDs = new List <string>();
for (int i = 0; i < merchandiseIdObjects.Count; i++)
{
merchandiseIDs.Add(Convert.ToString(merchandiseIdObjects[i][0]));
}
//MessageBox.Show("in DAO: found merchanndise ids: " + String.Join("\n", merchandiseIDs.ToArray()));
List <List <Object> > merhcandiseObjects = new List <List <Object> >();
foreach (string merchandiseId in merchandiseIDs)
{
string queryToFindMerchandiseList = "select * from MerchandiseInfoInLicense where Id = '" + merchandiseId + "'";
merchandiseIdObjects = dbConnection.RunSelectQuery(queryToFindMerchandiseList);
string name = Convert.ToString(merchandiseIdObjects[0][1]);
string company = Convert.ToString(merchandiseIdObjects[0][2]);
double unitWeight = Convert.ToDouble(merchandiseIdObjects[0][3]);
double unitPrice = Convert.ToDouble(merchandiseIdObjects[0][4]);
double wholeWeight = Convert.ToDouble(merchandiseIdObjects[0][5]);
double _maxUnitPrice = Convert.ToDouble(merchandiseIdObjects[0][6]);
int count = Convert.ToInt32(merchandiseIdObjects[0][7]);
MerchandiseInLicense merchandise = new MerchandiseInLicense(name, company, wholeWeight, _maxUnitPrice, unitWeight,
unitPrice, count);
//MessageBox.Show("in DAO: found merchandise with id, name: " + merchandiseId + ", " + name);
merchantLicense.AddNewMercahndise(merchandise);
merchandiseIdObjects.Clear();
}
return(merchantLicense);
}