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