public IHttpActionResult SavePoDetail(whpo2 poDetail)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
bool isValid = PoHelper.SavePoDetail(poDetail);
if (!isValid)
{
return(InternalServerError());
}
return(Ok());
}
public static whpo2 GetPoDetail(int TrxNo, int LineItemNo)
{
whpo2 poDetail = null;
using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
{
try
{
connection.Open();
poDetail = connection.QuerySingleOrDefault <whpo2>(qryPurchaseOrder.selectPoDetail, new { TrxNo, LineItemNo });
}
catch (Exception) { throw; }
finally { connection.Close(); }
}
return(poDetail);
}
public static bool SavePoDetail(whpo2 poDetail)
{
int afRecCnt = 0;
string storeProcName;
using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
{
try
{
connection.Open();
int poDetailCnt = connection.ExecuteScalar <int>(qryPurchaseOrder.selectPoDetailCount,
new
{
TrxNo = poDetail.TrxNo,
LineItemNo = poDetail.LineItemNo
});
if (poDetailCnt > 0)
{
storeProcName = qryPurchaseOrder.updatePoDetail;
}
else
{
storeProcName = qryPurchaseOrder.insertPoDetail;
}
var myParams = connection.GetStoreProcParams(storeProcName, poDetail);
afRecCnt = connection.Execute(storeProcName, myParams, null, null, CommandType.StoredProcedure);
}
catch (Exception) { throw; }
finally { connection.Close(); }
}
return(afRecCnt > 0 ? true : false);
}
