public Keep AddKeep([FromBody] AddKeepModel addKeep) { if (ModelState.IsValid) { Keep keep = _db.AddKeep(addKeep); if (keep != null) { return(keep); } } return(null); }
public Keep AddKeep(AddKeepModel addKeep) { try { Guid g = Guid.NewGuid(); string id = g.ToString(); Keep keep = new Keep() { Id = id, Name = addKeep.Name, Description = addKeep.Description, Pic = addKeep.Pic, Private = addKeep.Private, userId = addKeep.userId, keepCount = addKeep.keepCount, shareCount = addKeep.shareCount, viewCount = addKeep.viewCount }; var success = _db.Execute(@" INSERT INTO keeps( id, name, description, pic, private, userId, keepCount, shareCount, viewCount ) VALUES ( @Id, @Name, @Description, @Pic, @Private, @userId, @keepCount, @shareCount, @viewCount )", keep); if (success < 1) { throw new Exception("KEEP ALREADY EXISTS"); } return(keep); } catch (MySqlException e) { Console.WriteLine("ERROR: " + e.Message); return(null); } }