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);
}
