public async Task <IActionResult> Claim([FromBody] PoClaim claim)
{
PoClaim response;
if (claim.claim_type == ClaimerType.InspectClaimer)
{
response = await _claimRepository.ClaimInspect(claim.po_id, claim.inspect_claimer ?? 0);
}
else
{
response = await _claimRepository.ClaimPublish(claim.po_id, claim.publish_claimer ?? 0);
}
return(Ok(response));
}
public async Task <PoClaim> RemoveClaimPublish(int poId, int userId)
{
var poClaim = new PoClaim
{
publish_claimer = null,
po_id = poId,
publish_claimed_at = _common.GetTimeStemp()
};
using (IDbConnection conn = Connection)
{
var result = await conn.ExecuteAsync($"UPDATE po_claim set publish_claimer=NULL,publish_claimed_at='{poClaim.publish_claimed_at}'" +
$" where po_id={poId}");
return(await GetClaim(poId));
}
}
public async Task <IActionResult> RemoveClaim([FromBody] PoClaim claim)
{
try
{
PoClaim response;
if (claim.claim_type == ClaimerType.InspectClaimer)
{
response = await _claimRepository.RemoveClaimInspect(claim.po_id, claim.inspect_claimer ?? 0);
}
else
{
response = await _claimRepository.RemoveClaimPublish(claim.po_id, claim.publish_claimer ?? 0);
}
return(Ok(response));
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
public async Task <PoClaim> ClaimInspect(int poId, int userId)
{
var poClaim = new PoClaim
{
inspect_claimer = userId,
po_id = poId,
inspect_claimed_at = _common.GetTimeStemp()
};
string query = string.Format(@"INSERT INTO po_claim (po_id,inspect_claimer,inspect_claimed_at) VALUES ({0},{1},{2})
ON DUPLICATE KEY UPDATE inspect_claimer = {1}, inspect_claimed_at = {2}"
, poClaim.po_id, poClaim.inspect_claimer, poClaim.inspect_claimed_at);
using (IDbConnection conn = Connection)
{
var result = await conn.ExecuteAsync(query);
// poClaim.inspect_claimer_name = await GetUsernameByClaim(poId, ClaimerType.InspectClaimer);
}
return(await GetClaim(poId));
}
