public async Task <FeedbackDateModel> UpsertFeedbackDate(FeedbackDateModel feedbackDate)
{
FeedbackDate feedbackDateRequest = feedbackDate.Adapt <FeedbackDate>();
int feedbackDateResponseId = await _feedbackRepository.UpsertFeedbackDates(feedbackDateRequest);
return(new FeedbackDateModel(
(feedbackDateResponseId != 0) ? feedbackDateResponseId : feedbackDate.Id,
feedbackDate.LabId,
feedbackDate.Date
));
}
public async Task <int> UpsertFeedbackDates(FeedbackDate feedbackDate)
{
using (SqlConnection connection = new SqlConnection(_settings.DefaultConnectionString))
{
int id = await connection.ExecuteScalarAsync <int>(
"UpsertFeedbackDate",
new
{
Id = feedbackDate.Id,
Date = feedbackDate.Date.Date,
LabId = feedbackDate.LabId
},
commandType : CommandType.StoredProcedure
);
return(id);
}
}
