public IHttpActionResult SavePo(whpo1 po)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
int trxNo = PoHelper.SavePo(po);
if (trxNo <= 0)
{
return(InternalServerError());
}
return(Ok(trxNo));
}
public static whpo1 GetPo(int TrxNo)
{
whpo1 myPo = null;
using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
{
try
{
connection.Open();
myPo = connection.QuerySingleOrDefault <whpo1>(qryPurchaseOrder.selectPo, new { TrxNo });
}
catch (Exception) { throw; }
finally { connection.Close(); }
}
return(myPo);
}
public static int SavePo(whpo1 po)
{
int trxNo = 0;
using (var connection = new ConnectionProvider(ApiService.Site).CreateDbConnection())
{
try
{
string storeProcName;
if (po.TrxNo <= 0)
{
// set audit values
po.WorkStation = ApiService.HostName;
po.CreateBy = ApiService.UserId;
po.CreateDateTime = ApiService.ClientDate;
po.UpdateBy = ApiService.UserId;
po.UpdateDateTime = ApiService.ClientDate;
// set insert store procedure
storeProcName = qryPurchaseOrder.insertPo;
}
else
{
// set audit values
po.WorkStation = ApiService.HostName;
po.UpdateBy = ApiService.UserId;
po.UpdateDateTime = ApiService.ClientDate;
// set update store procedure
storeProcName = qryPurchaseOrder.updatePo;
}
connection.Open();
var param = connection.GetStoreProcParams(storeProcName, po);
trxNo = connection.ExecuteScalar <int>(storeProcName, param, null, null, CommandType.StoredProcedure);
}
catch (Exception) { throw; }
finally { connection.Close(); }
}
return(trxNo);
}
