public async Task <HouseholdResponse> InsertHousehold(HouseholdInsertRequest household)
{
return(await asyncConnection(async db =>
{
HouseholdResponse insertedHousehold = await db.QueryFirstOrDefaultAsync <HouseholdResponse>(
sql: "[Houses].[Households_Insert]",
param: household,
commandType: CommandType.StoredProcedure
);
return insertedHousehold;
}));
}
public async Task <HouseholdResponse> UpdateHousehold(HouseholdUpdateRequest household)
{
return(await asyncConnection(household.ModifiedBy, household.OccupantId, async db =>
{
HouseholdResponse rowsUpdated = await db.QueryFirstOrDefaultAsync <HouseholdResponse>(
sql: "[Houses].[Households_Update]",
param: household,
commandType: CommandType.StoredProcedure
);
return rowsUpdated;
}));
}
public void PostHousehold()
{
var request = new RestRequest("/households");
_householdRequest = new HouseholdRequest()
{
Name = "asdd",
Title = "dsaa",
Author = "asdd",
Isbn = "10",
PublicationDate = "2020-25-06"
};
var HouseInJson = Newtonsoft.Json.JsonConvert.SerializeObject(_householdRequest);
request.AddParameter("application/json", HouseInJson, ParameterType.RequestBody);
var response = _restClient.Post(request);
_householdResponse = Newtonsoft.Json.JsonConvert.DeserializeObject <HouseholdResponse>(response.Content);
Thread.Sleep(500);
}
