public int Add(int ProdID, string ItemName, double ItemPrice, int Stock, byte[] Image, string Category) { EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect(); string sql = "Insert INTO Products values (@ProdId, @ItemName, @ItemPrice, @Stock, @Image, @Category)"; SqlParameter param1 = new SqlParameter("@ProdId", SqlDbType.Int); param1.Value = ProdID; SqlParameter param2 = new SqlParameter("@ItemName", SqlDbType.Text); param2.Value = ItemName; SqlParameter param3 = new SqlParameter("@ItemPrice", SqlDbType.Decimal); param3.Value = ItemPrice; SqlParameter param4 = new SqlParameter("@Stock", SqlDbType.Int); param4.Value = Stock; SqlParameter param5 = new SqlParameter("@Image", SqlDbType.Image); param5.Value = Image; SqlParameter param6 = new SqlParameter("@Category", SqlDbType.Text); param6.Value = Category; try { return(aEShoppingConn.ExecuteNonQuery(sql, CommandType.Text, param1, param2, param3, param4, param5, param6)); } catch (Exception ex) { LastError = ex.Message; return(-1); } }
public int Add(string Username, string Password, string Email, string Name, string Address, string City, int Zipcode, long PhNum) { EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect(); string sql = "Insert INTO Customers values (@Username, @Password, @Email, @Name, @Address, @City, @Zipcode, @PhNum)"; SqlParameter param1 = new SqlParameter("@Username", SqlDbType.Text); param1.Value = Username; SqlParameter param2 = new SqlParameter("@Password", SqlDbType.Text); param2.Value = Password; SqlParameter param3 = new SqlParameter("@Email", SqlDbType.Text); param3.Value = Email; SqlParameter param4 = new SqlParameter("@Name", SqlDbType.Text); param4.Value = Name; SqlParameter param5 = new SqlParameter("@Address", SqlDbType.Text); param5.Value = Address; SqlParameter param6 = new SqlParameter("@City", SqlDbType.Text); param6.Value = City; SqlParameter param7 = new SqlParameter("@Zipcode", SqlDbType.Decimal); param7.Value = Zipcode; SqlParameter param8 = new SqlParameter("@PhNum", SqlDbType.Decimal); param8.Value = PhNum; try { return(aEShoppingConn.ExecuteNonQuery(sql, CommandType.Text, param1, param2, param3, param4, param5, param6, param7, param8)); } catch (Exception ex) { LastError = ex.Message; return(-1); } }
public int UpdateProduct(double newPrice, int newStock, int prodID) { try { EShoppingDBConnect aEShoppingConn = new EShoppingDBConnect(); string query = "update Products set Stock = @newStock, ItemPrice = @newPrice " + "where ProdID = @ID"; SqlParameter param1 = new SqlParameter("@ID", SqlDbType.Int); param1.Value = prodID; SqlParameter param2 = new SqlParameter("@newPrice", SqlDbType.Decimal); param2.Value = newPrice; SqlParameter param3 = new SqlParameter("@newStock", SqlDbType.Int); param3.Value = newStock; return(aEShoppingConn.ExecuteNonQuery(query, CommandType.Text, param1, param2, param3)); } catch (Exception ex) { LastError = ex.Message; return(-1); } }