/// <summary> /// Purpose: Add a new Product to the database /// Accepts: Hashtable /// Returns: String (Product Code) /// </summary> public string AddProduct(Hashtable hsh) { //The product code that was added to database string retProdcd = ""; Product prod = new Product(); QuickStart_DBEntities dbContext; try { dbContext = new QuickStart_DBEntities(); prod.ProductCode = Convert.ToString(hsh["productcode"]); prod.Name = Convert.ToString(hsh["name"]); prod.Brand = Convert.ToString(hsh["brand"]); prod.Description = Convert.ToString(hsh["description"]); prod.CategoryID = Convert.ToInt32(hsh["categoryid"]); prod.MSRP = Convert.ToDouble(hsh["msrp"]); prod.isFreeShipping = Convert.ToBoolean(hsh["isfreeshipping"]); prod.isTaxFree = Convert.ToBoolean(hsh["istaxfree"]); prod.QuantityInStock = Convert.ToInt32(hsh["quantityinstock"]); prod.IsQuantityUnlimited = Convert.ToBoolean(hsh["isquantityunlimited"]); prod.Created = DateTime.Now; prod.Modified = null; prod.isActive = true; //set to active dbContext.AddToProducts(prod); dbContext.SaveChanges(); retProdcd = prod.ProductCode; dbContext.Detach(prod); } catch (Exception e) { ErrorRoutine(e, "ProductData", "AddProduct"); } return retProdcd; }
/// <summary> /// Purpose: Add new user's information to the DB /// Accepts: Hashtable /// Returns: int /// </summary> public int AddUser(Hashtable hsh) { int newId = -1; User usr = new User(); QuickStart_DBEntities dbContext; try { dbContext = new QuickStart_DBEntities(); usr.Username = Convert.ToString(hsh["username"]); usr.Password = Convert.ToString(hsh["password"]); usr.Salutation = Convert.ToString(hsh["salutation"]); usr.FirstName = Convert.ToString(hsh["firstName"]); usr.LastName = Convert.ToString(hsh["lastName"]); usr.Address1 = Convert.ToString(hsh["address1"]); usr.Address2 = Convert.ToString(hsh["address2"]); usr.City = Convert.ToString(hsh["city"]); usr.StateProvinceID = Convert.ToInt32(hsh["stateProv"]); usr.ZipPostalCode = Convert.ToString(hsh["zipPC"]); usr.Email = Convert.ToString(hsh["email"]); usr.IsReceiveNewsletters = Convert.ToBoolean(hsh["newsletters"]); usr.Created = DateTime.Now; dbContext.AddToUsers(usr); dbContext.SaveChanges(); newId = usr.UserID; dbContext.Detach(usr); } catch (Exception e) { ErrorLoggerData.ErrorRoutine(e, "UserData", "AddUser"); } return newId; }