public static whar2 GetAsnOrderDetail(int TrxNo, int LineItemNo)
{
var connection = ApiService.dbConnection;
whar2 myAsnOrderDetail = null;
try
{
connection.Open();
myAsnOrderDetail = connection.QueryFirstOrDefault <whar2>(qryAsnOrder.selectAsnOrderDetail, new { TrxNo, LineItemNo });
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(myAsnOrderDetail);
}
public IHttpActionResult saveAsnOrderDetail(whar2 AsnOrderDetail)
{
// incorrect date issue
if (!ModelState.IsValid)
{
return(BadRequest());
}
int afRecCnt = AsnOrderHelper.SaveAsnOrderDetail(AsnOrderDetail);
if (afRecCnt <= 0)
{
return(BadRequest());
}
return(Ok());
}
public static int SaveAsnOrderDetail(whar2 AsnOrderDetail)
{
var connection = ApiService.dbConnection;
string storeProcName;
int afRecCnt = 0;
//int TrxNo = AsnOrderDetail.TrxNo;
//int LineItemNo = AsnOrderDetail.LineItemNo;
//string Description = AsnOrderDetail.Description;
//string DimensionFlag = AsnOrderDetail.DimensionFlag;
//DateTime? ExpiryDate = AsnOrderDetail.ExpiryDate.Value;
//decimal? Height = AsnOrderDetail.Height;
//decimal? Length = AsnOrderDetail.Length;
//decimal? Qty = AsnOrderDetail.Qty;
//DateTime? ManufactureDate = AsnOrderDetail.ManufactureDate;
//string ItemCode = AsnOrderDetail.ItemCode;
//decimal? SpaceArea = AsnOrderDetail.SpaceArea;
//string UomCode = AsnOrderDetail.UomCode;
//decimal? Volume = AsnOrderDetail.Volume;
//decimal? Weight = AsnOrderDetail.Weight;
//decimal? Width = AsnOrderDetail.Width;
try
{
connection.Open();
int recCnt = connection.ExecuteScalar <int>(qryAsnOrder.selectWhar2Count,
new
{
TrxNo = AsnOrderDetail.TrxNo,
LineItemNo = AsnOrderDetail.LineItemNo
});
if (recCnt <= 0)
{
storeProcName = qryAsnOrder.insertAsnOrderDetail;
//afRecCnt = connection.Execute(qryAsnOrder.insertAsnOrderDetail,
// new
// {
// TrxNo,
// LineItemNo,
// Description,
// DimensionFlag,
// ExpiryDate,
// Height,
// Length,
// Qty,
// ManufactureDate,
// ItemCode,
// SpaceArea,
// UomCode,
// Volume,
// Weight,
// Width
// },
// null, null, CommandType.StoredProcedure);
}
else
{
storeProcName = qryAsnOrder.updateAsnOrderDetail;
//afRecCnt = connection.Execute(qryAsnOrder.updateAsnOrderDetail,
// new
// {
// TrxNo,
// LineItemNo,
// Description,
// DimensionFlag,
// ExpiryDate,
// Height,
// Length,
// Qty,
// ManufactureDate,
// ItemCode,
// SpaceArea,
// UomCode,
// Volume,
// Weight,
// Width
// },
// null, null, CommandType.StoredProcedure);
}
var param = connection.GetStoreProcParams(storeProcName, AsnOrderDetail);
afRecCnt = connection.Execute(storeProcName, param, null, null, CommandType.StoredProcedure);
}
catch (Exception) { throw; }
finally { connection.Close(); }
return(afRecCnt);
}
