internal void EditKeep(Keeps keep) { _db.Execute(@"UPDATE keeps SET views = @Views, saves = @Saves, public = @Public WHERE id = @Id", keep); }
public Keeps AddKeeps(Keeps newKeeps) { _db.ExecuteScalar <string>(@" INSERT INTO keeps (url, name, description, userId) VALUES(@Url, @Name, @Description, @userId); SELECT LAST_INSERT_ID()", newKeeps); return(newKeeps); }
public Keeps Post([FromBody] Keeps newKeeps) { var userId = HttpContext.User.Identity.Name; newKeeps.userId = userId; if (ModelState.IsValid) { return(db.AddKeeps(newKeeps)); } return(null); }
public string Put(int id, [FromBody] Keeps keep) { db.EditKeep(keep); return("Updated"); }