public IActionResult Insert([Bind("IdDic,IdStatus,Note,Type")] DicHistoryUpload dic)
{
if (ModelState.IsValid)
{
var result = _repoHistory.Insert(dic);
var lastDic = _repoHistory.GetLastInserted();
var uri = Url.Action("Get", new { Id = lastDic.Id, Version = "1.0" });
return(Created(uri, lastDic));
}
return(BadRequest());
}
public bool Insert(DicHistoryUpload item)
{
using (IDbConnection db = new SqlConnection(ConnectionString))
{
Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;
if (db.State == ConnectionState.Closed)
{
db.Open();
}
int result = db.Execute(@"INSERT INTO DIC_HISTORY(ID_DIC, NOTE, DATE, ID_STATUS_DIC, TYPE)
VALUES(@IdDic, @Note, GETDATE(), @IdStatus, @Type)", item);
return(result > 0);
}
}
