public GroceryItem(string connString, int itemID, int updateUserID)
{
_ConnString = connString;
_CreatedBy = new User(connString);
_LastModifiedBy = new User(connString);
_LastModifiedBy.LoadUserDetails(updateUserID);
LoadItem(itemID);
}
public GroceryItem(string sku, string brand, string description, int qty, int orderThreshold, int maxQty, double unitCost, double retailPrice, int createdBy, int lastModifiedBy, string connString)
{
_SKU = sku;
_Brand = brand;
_Description = description;
_CurrentQty = qty;
_OrderThreshold = orderThreshold;
_MaxQty = maxQty;
_UnitCost = unitCost;
_RetailPrice = retailPrice;
_ConnString = connString;
_CreatedBy = new User(connString);
_LastModifiedBy = new User(connString);
_CreatedBy.LoadUserDetails(createdBy);
_LastModifiedBy.LoadUserDetails(lastModifiedBy);
}
public bool LoadItem(int itemID)
{
try
{
string sql = "SELECT * FROM GroceryItems WHERE ItemID = @itemid";
SqlParameter[] p = new SqlParameter[] {
new SqlParameter("@itemid", itemID)
};
DataRow dr = SqlHelper.ExecuteDataset(_ConnString, CommandType.Text, sql, p).Tables[0].Rows[0];
_ItemID = (int)dr["ItemID"];
_SKU = dr["SKU"].ToString();
_Brand = dr["Brand"].ToString();
_Description = dr["Description"].ToString();
_CurrentQty = (int)dr["CurrentQty"];
_OnOrderQty = (int)dr["OnOrderQty"];
_MaxQty = (int)dr["MaxQty"];
_OrderThreshold = (int)dr["OrderThreshold"];
_DateLastReceived = (DateTime)dr["DateLastReceived"];
_QtyLastReceived = (int)dr["QtyLastReceived"];
_UnitCost = (double)dr["UnitCost"];
_RetailPrice = (double)dr["RetailPrice"];
_DateCreated = (DateTime)dr["DateLastCreated"];
User createdBy = new User(_ConnString);
User lastModifiedBy = new User(_ConnString);
createdBy.LoadUserDetails((int)dr["CreatedBy"]);
lastModifiedBy.LoadUserDetails((int)dr["LastModifiedBy"]);
_CreatedBy = createdBy;
_LastModifiedBy = lastModifiedBy;
return true;
}
catch (Exception)
{
return false;
}
}
