[WebMethod]
    public void AddItemToStore(StoreItem item)
    {
        item.ID = GetLastItemID()+1;
        string st = @"provider=Microsoft.jet.oledb.4.0;Data Source = " +
            Server.MapPath("~/Data/mydb.mdb");
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = st;
        OleDbCommand cmmd = new OleDbCommand("INSERT INTO StoreProducts (item_id,item_name,amount,item_price,item_picture,item_details,item_category) VALUES(@itemIdParam,@itemNameParam,@amountParam,@itemPriceParam,@itemPicParam,@itemDetailsParam,@itemCategoryParam)", conn);
        cmmd.Parameters.Add("@itemIdParam", OleDbType.Numeric).Value = (int)item.ID;
        cmmd.Parameters.Add("@itemNameParam", OleDbType.VarChar).Value = item.Name.ToString();
        cmmd.Parameters.Add("@amountParam", OleDbType.Numeric).Value = (int)item.Amount;
        cmmd.Parameters.Add("@itemPriceParam", OleDbType.Double).Value = (double)item.Price;
        cmmd.Parameters.Add("@itemPicParam", OleDbType.VarChar).Value = item.Picture.ToString();
        cmmd.Parameters.Add("@itemDetailsParam", OleDbType.VarChar).Value = item.Details.ToString();
        cmmd.Parameters.Add("@itemCategoryParam", OleDbType.VarChar).Value = item.Category.ToString();
        conn.Open();
        cmmd.ExecuteNonQuery();
        conn.Close();
    }