public async Task <bool> savePurchasesStage(PurchasesStage purchasesStage)
{
using (var con = new SqlConnection(_configuration.GetConnectionString("DatabaseConnection")))
{
con.Open();
var sqlTransaction = con.BeginTransaction();
var paramater = new DynamicParameters();
paramater.Add("@PurchasesStageID", purchasesStage.PurchasesStageID);
paramater.Add("@PurchasesStageTypeID", purchasesStage.PurchasesStageTypeID);
paramater.Add("@PurchaseID", purchasesStage.PurchaseID);
paramater.Add("@UserID", purchasesStage.UserID);
paramater.Add("@IsApproved", purchasesStage.IsApproved);
paramater.Add("@IsRejected", purchasesStage.IsRejected);
paramater.Add("@Justification", purchasesStage.Justification);
int result = con.Execute("[ess].UpdatePurchasesStageInfo", paramater, sqlTransaction, 0, CommandType.StoredProcedure);
if (result > 0)
{
sqlTransaction.Commit();
return(true);
}
else
{
sqlTransaction.Rollback();
return(false);
}
return(false);
}
}
public async Task <IActionResult> ActionPurchasesStage([FromBody] PurchasesStage purchasesStage)
{
if (!ModelState.IsValid)
{
return(BadRequest("Bad purchases"));
}
try
{
var userId = Convert.ToInt32(this.User.FindFirstValue(ClaimTypes.NameIdentifier));
purchasesStage.UserID = userId;
var result = await _purchasesRepository.savePurchasesStage(purchasesStage);
if (result)
{
return(Ok(result));
}
else
{
return(BadRequest("Not saved"));
}
}
catch (Exception ex)
{
//ModelState.AddModelError("error", ex.Message);
return(BadRequest(ex.Message));
}
}
