public async Task <ResponseModel> PositiveInsertion(PositiveInsert model)
{
try
{
var query = @"
INSERT INTO [Positive] (DispoId, Positive, DatePositive)
VALUES (@DispoId, @Positive, @DatePositive)";
var DatePositive = DateTime.Parse(model.DatePositive);
var rows = await _conn.ExecuteAsync(query, new { model.DispoId, model.Positive, DatePositive });
if (rows > 0)
{
return(new ResponseModel {
StatusCode = 200, Message = "Insertion executed"
});
}
else
{
return(new ResponseModel {
StatusCode = 500, Message = "Insertion Not completed during Query"
});
}
}
catch (Exception ex)
{
return(new ResponseModel {
StatusCode = 500, Message = ex.Message
});
}
}
public async Task <IActionResult> InsertPositive(PositiveInsert model)
{
var response = new ResponseModel();
try
{
if (ModelState.IsValid)
{
response = await _da.PositiveInsertion(model);
return(StatusCode(response.StatusCode, response));
}
response.StatusCode = 400;
response.Message = "One or more fields are not correct";
return(StatusCode(response.StatusCode, response));
}
catch (Exception ex)
{
response.StatusCode = 500;
response.Message = ex.Message;
return(StatusCode(response.StatusCode, response));
}
}
