public IHttpActionResult SaveBarcodeItem(whbi1 Item)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
bool isValid = BarCodeItemHelper.SaveBarCodeItem(Item);
if (!isValid)
{
return(InternalServerError());
}
return(Ok());
}
public static bool SaveBarCodeItem(whbi1 item)
{
int afRecCnt = 0;
using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
{
try
{
connection.Open();
int barcodeItemCnt = connection.ExecuteScalar <int>(qryBarCodeItem.SelectTrxNoCnt,
new
{
TrxNo = item.TrxNo,
TablePrefix = "GRN"
});
if (barcodeItemCnt > 0)
{
connection.Execute(qryBarCodeItem.DeleteBarcodeItem,
new
{
TrxNo = item.TrxNo,
TablePrefix = "GRN"
});
}
item.CreateBy = ApiService.UserId;
item.CreateDateTime = ApiService.ClientDate;
afRecCnt = connection.Execute(qryBarCodeItem.InsertBarcodeItem, item);
}
catch (Exception) { throw; }
finally { connection.Close(); }
}
return(afRecCnt > 0 ? true : false);
}
