public async Task <HttpResponseModel> Billing_TransOthers_Set(TransOthersForCreateUpdate model)
{
var result = await _repo.Billing_TransOthers_Set(model);
var modelForReturn = new HttpResponseModel();
switch (result)
{
case 1:
modelForReturn.HttpStatusCode = _response.Created;
modelForReturn.ResponseModel = _response.ShowHttpResponse(_response.Created);
modelForReturn.Remarks = "successfully added.";
break;
case 2:
modelForReturn.HttpStatusCode = _response.Updated;
modelForReturn.ResponseModel = _response.ShowHttpResponse(_response.Updated);
modelForReturn.Remarks = "successfully updated.";
break;
default:
modelForReturn.HttpStatusCode = _response.BadRequest;
modelForReturn.ResponseModel = _response.ShowHttpResponse(_response.BadRequest);
modelForReturn.Remarks = "error processing request.";
break;
}
return(modelForReturn);
}
public async Task <IActionResult> TransAddItem([FromBody] TransOthersForCreateUpdate model)
{
var result = await _service.Billing_TransOthers_Set(model);
if (result != null)
{
return(StatusCode(result.HttpStatusCode, new { response = result.ResponseModel, remaks = result.Remarks }));
}
return(BadRequest());
}
public async Task <int?> Billing_TransOthers_Set(TransOthersForCreateUpdate model)
{
using (var con = GetDbConnection(_options.Value.DevHubDBConn))
{
var result = await con.QueryAsync <int?>("dbo.DevHub_Billing_TransOthers_Set",
new
{
@iIntTranOtherID = model.TranOtherID,
@iIntTimeTrackerId = model.TimeTrackerId,
@iIntProductID = model.ProductID,
@iDecSRP = model.SRP,
@iDecQuantity = model.Quantity,
@iBitIsPaid = model.IsPaid
},
commandType : CommandType.StoredProcedure);
return(result.FirstOrDefault());
}
}
