// ------------------------------------------------
public Product(int productID)
{
IDal dal = DalFactory.GetDAL(GetType().Name);
string query = "sp_GetProduct";
Dictionary<string, string> parameters = new Dictionary<string, string>();
parameters.Add("@ProductID", productID.ToString());
var result = dal.RunQuery("VBase", query, parameters, true);
if(result.Count == 1)
{
ID = productID;
Dictionary<string, string> row = result[0];
try
{
int iTemp;
double dblTemp;
UPC = row["UPC"];
Name = row["Name"];
BrandName = row["BrandName"];
CompanyID = int.TryParse(row["Company_id"], out iTemp) ? iTemp : -1;
CaseCapacity = int.TryParse(row["CaseCapacity"], out iTemp) ? iTemp : -1;
UnitWholesale = Double.TryParse(row["UnitWholesale"], out dblTemp) ? dblTemp : 0.0;
// ------------------------------------
// The Category ID is stored in the DB.
// Here we will go get the actual Category object.
if(int.TryParse(row["Category_id"], out iTemp))
{
Category = new ProductCategory(iTemp);
}
}
catch(ArgumentNullException /*exp*/)
{
// Revisit logging.
}
catch(FormatException /*exp*/)
{
// Revisit logging.
}
catch(Exception /*exp*/)
{
// Revisit logging.
}
}
}
public void ProductCategory()
{
string name = Convert.ToString(TestContext.DataRow["Name"]);
int categoryID = Convert.ToInt32(TestContext.DataRow["CategoryID"]);
string description = Convert.ToString(TestContext.DataRow["Description"]);
ProductCategory prodCat = new ProductCategory(categoryID);
Assert.AreEqual(name, prodCat.Name);
Assert.AreEqual(categoryID, prodCat.ID);
Assert.AreEqual(description, prodCat.Description);
}
