public static decimal?GetBalanceStoreSpaceByBinNo(string WarehouseCode, string BinNo) { var connection = ApiService.dbConnection; decimal?balanceStoreSpace = null; decimal?whStoreSpace = null; whwh2 myWhDetail = WarehouseHelper.GetWarehouseDetail(WarehouseCode, BinNo); whStoreSpace = myWhDetail.StoreSpace; decimal invStoreSpace = 0; try { connection.Open(); invStoreSpace = connection.ExecuteScalar <decimal>(qryInventory.selectInvStoreSpaceByBin, new { WarehouseCode, BinNo }); } catch (Exception) { throw; } finally { connection.Close(); } if (whStoreSpace.HasValue) { balanceStoreSpace = whStoreSpace - invStoreSpace; } return(balanceStoreSpace); }
public IHttpActionResult GenerateBinNos([FromBody] dynamic StoregeLayout) { List <string> BinList = WarehouseHelper.GenerateBinNo(StoregeLayout); if (BinList == null) { return(BadRequest()); } return(Ok(BinList)); }
public IHttpActionResult DeleteWarehouse(string WarehouseCode, int Type) { int afRowCnt = WarehouseHelper.DeleteWarehouse(WarehouseCode, Type); if (afRowCnt == 0) { return(BadRequest()); } return(Ok()); }
public IHttpActionResult GetWarehouse(string WarehouseCode) { var whwh1 = WarehouseHelper.GetWarehouse(WarehouseCode); var whwh2 = WarehouseHelper.GetWarehouseDetails(WarehouseCode); if (whwh1 == null) { return(BadRequest()); } var data = new { whwh1, whwh2 }; return(Ok(data)); }
public IHttpActionResult SaveWarehouse(dynamic data) { JObject whwh1 = data.whwh1; var myWh = JsonConvert.DeserializeObject <whwh1>(whwh1.ToString()); JArray whwh2 = data.whwh2; var myWhDetails = JsonConvert.DeserializeObject <List <whwh2> >(whwh2.ToString()); int afRowCnt = WarehouseHelper.SaveWarehouse(myWh); if (myWhDetails.Count > 0) { afRowCnt += WarehouseHelper.SaveWarehouseDetails(myWhDetails); } if (afRowCnt == 0) { return(BadRequest()); } return(Ok()); }