public async Task <bool> UpdateInventory(int itemId, int warehouseId, InventoryUpdateModel price)
{
string productUrl = Util.FormatUrl(Consts.INVENTORY_UPDATEINVENTORYBYSKUWAREHOUSE);
productUrl = productUrl.Replace("{{skuId}}", itemId.ToString());
productUrl = productUrl.Replace("{{warehouseId}}", warehouseId.ToString());
var priceModel = JsonConvert.SerializeObject(price);
var httpResponse = await PutToUri(productUrl, new StringContent(priceModel));
return(httpResponse.IsSuccessStatusCode);
}
public ActionResult AddIngredients(InventoryUpdateModel inventoryUpdateModel)
{
var jsonResult = new JsonResult();
if (Session["loggedIn"] != null || m_helper.Login(inventoryUpdateModel.LoginDetails, Constants.ODBCString))
{
var connectionString = Constants.ODBCString;
using (var dbConnection = new ODBConnection(connectionString))
using (var persister = new ODBCPersister(dbConnection))
{
var count = int.Parse(persister.ExecuteScalar(string.Format(m_helper.GetQueryValue("checkCafeteriaManagerVendorID"), inventoryUpdateModel.InventoryModel.CafeteriaVendorID)).ToString());
if (count > 0)
{
// if it exists
var itemExists = int.Parse(persister.ExecuteScalar(string.Format(m_helper.GetQueryValue("checkStoreHouseInventoryItem"), inventoryUpdateModel.InventoryModel.IngredientID)).ToString()) > 0;
if (itemExists)
{
//update updateStoreHouseInventory
persister.ExecuteNonQueryCmd("StoreHouseInventory", string.Format(m_helper.GetQueryValue("updateStoreHouseInventory"),
inventoryUpdateModel.InventoryModel.IngredientID,
inventoryUpdateModel.InventoryModel.IngredientName,
inventoryUpdateModel.InventoryModel.IngredientQuantity,
inventoryUpdateModel.InventoryModel.IngredientQuantityUnit,
"instock",
inventoryUpdateModel.InventoryModel.IngredientID));
}
else
{
persister.ExecuteNonQueryCmd("StoreHouseInventory", string.Format(m_helper.GetQueryValue("insertStoreHouseInventory"),
inventoryUpdateModel.InventoryModel.IngredientID,
inventoryUpdateModel.InventoryModel.IngredientName,
inventoryUpdateModel.InventoryModel.IngredientQuantity,
inventoryUpdateModel.InventoryModel.IngredientQuantityUnit,
"instock",
inventoryUpdateModel.InventoryModel.CafeteriaVendorID));
}
}
else
{
var msg = "You are not previliged to complete this action";
jsonResult.Data = new { msg };
}
}
}
else
{
var msg = "Unable to Login";
jsonResult.Data = new { msg };
}
return(jsonResult);
}
