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; } }