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()); } }