コード例 #1
0
        private Dictionary <string, object> prepareInventoryParameters(clsInventory prInventory)
        {
            Dictionary <string, object> par = new Dictionary <string, object>(11);

            par.Add("itemID", prInventory.itemID);
            par.Add("description", prInventory.description);
            par.Add("pricePerItem", prInventory.pricePerItem);
            par.Add("lastModified", prInventory.lastModified);
            par.Add("quantity", prInventory.quantity);
            par.Add("category", prInventory.category);
            par.Add("branchCode", prInventory.branchCode);
            par.Add("clothingSize", prInventory.clothingSize);
            par.Add("clothingGender", prInventory.clothingGender);
            par.Add("furnitureWeight", prInventory.furnitureWeight);
            par.Add("furnitureNumParts", prInventory.furnitureNumParts);
            return(par);
        }
コード例 #2
0
 public string PostInventory(clsInventory prInventory)
 { // insert inventory
     try
     {
         int lcRecCount = clsDbConnection.Execute("INSERT INTO tblInventory " +
                                                  "(description, pricePerItem, quantity, category, branchCode, clothingSize, clothingGender, furnitureWeight, furnitureNumParts) " +
                                                  "VALUES (@description, @pricePerItem, @quantity, @category, @branchCode, @clothingSize, @clothingGender, @furnitureWeight, @furnitureNumParts)",
                                                  prepareInventoryParameters(prInventory));
         if (lcRecCount == 1)
         {
             return("One inventory item inserted");
         }
         else
         {
             return("Unexpected inventory insert count: " + lcRecCount);
         }
     }
     catch (Exception ex)
     {
         return(ex.GetBaseException().Message);
     }
 }
コード例 #3
0
 public string PutInventory(clsInventory prInventory)
 {  // update inventory
     try
     {
         int lcRecCount = clsDbConnection.Execute("UPDATE tblInventory SET " +
                                                  "description = @description, pricePerItem = @pricePerItem, lastModified = @lastModified, quantity = @quantity, category = @category, branchCode = @branchCode, " +
                                                  "clothingSize = @clothingSize, clothingGender = @clothingGender, furnitureWeight = @furnitureWeight, furnitureNumParts = @furnitureNumParts " +
                                                  "WHERE itemID = @itemID",
                                                  prepareInventoryParameters(prInventory));
         if (lcRecCount == 1)
         {
             return("One inventory item updated");
         }
         else
         {
             return("Unexpected inventory update count: " + lcRecCount);
         }
     }
     catch (Exception ex)
     {
         return(ex.GetBaseException().Message);
     }
 }