public static int SaveBarCodeItemDetail(whbi2 itemDetail)
{
using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
{
try
{
connection.Open();
itemDetail.LineItemNo = connection.ExecuteScalar <int>(qryBarCodeItem.SelectNewLineItemNo,
new
{
TrxNo = itemDetail.TrxNo,
TablePrefix = itemDetail.TablePrefix
});
itemDetail.WorkStation = ApiService.HostName;
itemDetail.CreateBy = ApiService.UserId;
itemDetail.CreateDateTime = ApiService.ClientDate;
connection.Execute(qryBarCodeItem.InsertBarcodeItemDetail, itemDetail);
}
catch (Exception) { throw; }
finally { connection.Close(); }
}
return(itemDetail.LineItemNo);
}
public IHttpActionResult SaveBarcodeItemDetail(whbi2 itemDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
int lineItemNo = BarCodeItemHelper.SaveBarCodeItemDetail(itemDetail);
if (lineItemNo <= 0)
{
return(InternalServerError());
}
var myHub = GlobalHost.ConnectionManager.GetHubContext <BarcodeHub>();
myHub.Clients.All.addNewBarcodeItemDetail(itemDetail);
return(Ok());
}
public void DeleteBarcodeItemDetail(whbi2 itemDetail)
{
Clients.All.deleteBarcodeItemDetail(itemDetail);
}
public void AddNewBarcodeItemDetail(whbi2 itemDetail)
{
Clients.All.addNewBarcodeItemDetail(itemDetail);
}
public static async Task <bool> SaveItem(whbi2 item)
{
bool isValid = await Settings.ApiHelper.PostAsync("api/goodsreceiptnote/saveBarcodeItemDetail", item);
return(isValid);
}
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);
}
async Task <bool> SaveItemDetail(whbi2 itemDetail)
{
bool isValid = await GrnBarCodeService.SaveItem(itemDetail);
return(isValid);
}
