public static async Task <whit1> GetItem(string itemRefNo) { var myParams = new[] { new KeyValuePair <string, object>("ItemRefNo", itemRefNo) }; whit1 myItem = await Settings.ApiHelper.GetAsync <whit1>("api/item/getitembyitemrefno", myParams); return(myItem); }
public IHttpActionResult SaveBarCodeItem(whit1 Item) { if (!ModelState.IsValid) { return(BadRequest()); } int afRecCnt = ItemHelper.SaveItem(Item); if (afRecCnt <= 0) { return(BadRequest()); } return(Ok()); }
public static whit1 GetItem(string ItemCode) { var connection = ApiService.dbConnection; whit1 myItem = null; try { connection.Open(); myItem = connection.QuerySingle <whit1>(qryItem.selectItem, new { ItemCode }); } catch (Exception) { throw; } finally { connection.Close(); } return(myItem); }
public static bool SaveBarCodeItem(whit1 Item) { var connection = ApiService.dbConnection; int afRecCnt = 0; try { connection.Open(); string storeProcName; int itemCnt = connection.ExecuteScalar <int>(qryItem.selectItemCount, new { ItemCode = Item.ItemCode }); if (itemCnt <= 0) { Item.WorkStation = ApiService.HostName; Item.StatusCode = Item.StatusCode; Item.CreateBy = ApiService.UserId; Item.CreateDateTime = ApiService.ClientDate; Item.UpdateBy = ApiService.UserId; Item.UpdateDateTime = ApiService.ClientDate; storeProcName = qryItem.insertItem; } else { Item.WorkStation = ApiService.HostName; Item.UpdateBy = ApiService.UserId; Item.UpdateDateTime = ApiService.ClientDate; storeProcName = qryItem.updateItem; } var param = connection.GetStoreProcParams(storeProcName, Item); afRecCnt = connection.Execute(storeProcName, param, null, null, CommandType.StoredProcedure); } catch (Exception) { throw; } finally { connection.Close(); } return(afRecCnt > 0 ? true : false); }
async Task <bool> LoadItemDetail(string itemRefNo) { whit1 myItem = await GrnBarCodeService.GetItem(itemRefNo); if (myItem == null) { ResetItemInfo(); DependencyService.Get <IAudio>().PlayWavFail(); await DisplayAlert("Scan Result", "Invalid Item Ref No!", "OK"); return(false); } DependencyService.Get <IAudio>().PlayWavSuccess(); decimal?length, width, height, weight, volume, space; int? qty; string uom; switch (myItem.DimensionFlag) { case "P": length = myItem.PackingLength; width = myItem.PackingWidth; height = myItem.PackingHeight; weight = myItem.PackingWeight; volume = myItem.PackingVolume; space = myItem.PackingSpaceArea; qty = myItem.PackingQty; uom = myItem.PackingUomCode; break; case "W": length = myItem.WholeLength; width = myItem.WholeWidth; height = myItem.WholeHeight; weight = myItem.WholeWeight; volume = myItem.WholeVolume; space = myItem.WholeSpaceArea; qty = myItem.WholeQty; uom = myItem.WholeUomCode; break; default: length = myItem.LooseLength; width = myItem.LooseWidth; height = myItem.LooseHeight; weight = myItem.LooseWeight; volume = myItem.LooseVolume; space = myItem.LooseSpaceArea; qty = myItem.LooseQty; uom = myItem.LooseUomCode; break; } string strLength = length.HasValue ? length.Value.ToString("F2") : ""; string strWidth = width.HasValue ? width.Value.ToString("F2") : ""; string strHeight = height.HasValue ? height.Value.ToString("F2") : ""; string strVolume = volume.HasValue ? volume.Value.ToString("F4") : ""; string strSpace = space.HasValue ? space.Value.ToString("F4") : ""; string strQty = qty.HasValue ? qty.Value.ToString("F2") : ""; string strUom = !string.IsNullOrEmpty(uom) ? uom : ""; string strDim = ""; switch (myItem.DimensionFlag) { case "P": strDim = "PACKING"; break; case "W": strDim = "WHOLE"; break; default: strDim = "LOOSE"; break; } lastItemDetail = new whbi2 { TrxNo = 0, TablePrefix = "GRN", ItemCode = myItem.ItemCode, ItemName = myItem.ItemName, DimensionFlag = myItem.DimensionFlag, Qty = qty, UomCode = uom, Length = length, Width = width, Height = height, Weight = weight, Volume = volume, SpaceArea = space }; lblItem.Text = string.Format("Item - ({0}) {1}", myItem.ItemCode, myItem.ItemName); lblQty.Text = string.Format("Dim - {0}, Qty - {1} ({2})", strDim, strQty, strUom); lblSize.Text = string.Format("Size(cm) - {0} x {1} x {2}", strLength, strWidth, strHeight); lblCapacity.Text = string.Format("Vol - {0}, Space - {1}", strVolume, strSpace); return(true); }
public static int SaveItem(whit1 Item) { var connection = ApiService.dbConnection; int afRecCnt = 0; string ItemCode = Item.ItemCode; string ItemName = Item.ItemName; string BrandName = Item.BrandName; string CountryOfOrigin = Item.CountryOfOrigin; string SupplierCode = Item.SupplierCode; string DgIndicator = Item.DgIndicator; string DimensionFlag = Item.DimensionFlag; string IssueMethod = Item.IssueMethod; decimal?LooseHeight = Item.LooseHeight; decimal?LooseLength = Item.LooseLength; int? LooseQty = Item.LooseQty; decimal?LooseSpaceArea = Item.LooseSpaceArea; string LooseUomCode = Item.LooseUomCode; decimal?LooseVolume = Item.LooseVolume; decimal?LooseWeight = Item.LooseWeight; decimal?LooseWidth = Item.LooseWidth; string Model = Item.Model; decimal?PackingHeight = Item.PackingHeight; decimal?PackingLength = Item.PackingLength; int? PackingQty = Item.PackingQty; decimal?PackingSpaceArea = Item.PackingSpaceArea; string PackingUomCode = Item.PackingUomCode; decimal?PackingVolume = Item.PackingVolume; decimal?PackingWeight = Item.PackingWeight; decimal?PackingWidth = Item.PackingWidth; string ItemClassCode = Item.ItemClassCode; string ItemRefNo = Item.ItemRefNo; string Remark = Item.Remark; decimal?WholeHeight = Item.WholeHeight; decimal?WholeLength = Item.WholeLength; decimal?WholeQty = Item.WholeQty; decimal?WholeSpaceArea = Item.WholeSpaceArea; string WholeUomCode = Item.WholeUomCode; decimal?WholeVolume = Item.WholeVolume; decimal?WholeWeight = Item.WholeWeight; decimal?WholeWidth = Item.WholeWidth; string WorkStation = ApiService.HostName; string StatusCode = Item.StatusCode; string CreateBy = ApiService.UserId; string UpdateBy = ApiService.UserId; try { connection.Open(); int itemCnt = connection.ExecuteScalar <int>(qryItem.selectItemCount, new { ItemCode = Item.ItemCode }); if (itemCnt <= 0) { afRecCnt = connection.Execute(qryItem.insertItem, new { ItemCode, ItemName, BrandName, CountryOfOrigin, SupplierCode, DgIndicator, DimensionFlag, IssueMethod, LooseHeight, LooseLength, LooseQty, LooseSpaceArea, LooseUomCode, LooseVolume, LooseWeight, LooseWidth, Model, PackingHeight, PackingLength, PackingQty, PackingSpaceArea, PackingUomCode, PackingVolume, PackingWeight, PackingWidth, ItemClassCode, ItemRefNo, Remark, WholeHeight, WholeLength, WholeQty, WholeSpaceArea, WholeUomCode, WholeVolume, WholeWeight, WholeWidth, WorkStation, StatusCode, CreateBy, UpdateBy }, null, null, CommandType.StoredProcedure); } else { afRecCnt = connection.Execute(qryItem.updateItem, new { ItemCode, ItemName, BrandName, CountryOfOrigin, SupplierCode, DgIndicator, DimensionFlag, IssueMethod, LooseHeight, LooseLength, LooseQty, LooseSpaceArea, LooseUomCode, LooseVolume, LooseWeight, LooseWidth, Model, PackingHeight, PackingLength, PackingQty, PackingSpaceArea, PackingUomCode, PackingVolume, PackingWeight, PackingWidth, ItemClassCode, ItemRefNo, Remark, WholeHeight, WholeLength, WholeQty, WholeSpaceArea, WholeUomCode, WholeVolume, WholeWeight, WholeWidth, WorkStation, StatusCode, UpdateBy }, null, null, CommandType.StoredProcedure); } } catch (Exception) { throw; } finally { connection.Close(); } return(afRecCnt); }