internal DbCombo Delete(DbCombo burgerToDelete) { string sql = "DELETE FROM burgers WHERE id = @Id"; _db.Execute(sql, burgerToDelete); return(burgerToDelete); }
internal DbCombo Delete(int id) { DbCombo burgerToDelete = Get(id); _repo.Delete(burgerToDelete); return(burgerToDelete); }
internal DbCombo Edit(DbCombo editDbCombo) { DbCombo original = Get(editDbCombo.Id); original.Price = editDbCombo.Price > 0 ? editDbCombo.Price : original.Price; _repo.Edit(original); return(original); }
internal DbCombo Get(int id) { DbCombo found = _repo.GetById(id); if (found == null) { throw new Exception("Invalid DbCombo Id"); } return(found); }
[HttpPost] // POST public ActionResult <DbCombo> Create([FromBody] DbCombo newCombo) { try { return(Ok(_comboService.Create(newCombo))); } catch (Exception e) { return(BadRequest(e.Message)); } }
[HttpPut("{id}")] // PUT public ActionResult <DbCombo> Edit([FromBody] DbCombo editCombo, int id) { try { editCombo.Id = id; return(Ok(_comboService.Edit(editCombo))); } catch (Exception e) { return(BadRequest(e.Message)); } }
internal DbCombo Edit(DbCombo original) { string sql = @" UPDATE burgers SET name = @Name, price = @Price, description = @Description WHERE id = @Id; SELECT * FROM burgers WHERE id = @Id; "; return(_db.QueryFirstOrDefault <DbCombo>(sql, original)); }
internal DbCombo Create(DbCombo newDbCombo) { string sql = @" INSERT INTO burgers (name, price, description) VALUES (@Name, @Price, @Description); SELECT LAST_INSERT_ID(); "; int id = _db.ExecuteScalar <int>(sql, newDbCombo); newDbCombo.Id = id; return(newDbCombo); }
/// <summary> /// AsyncMethod /// </summary> /// <param name="MyDbCombo"></param> public void AsyncMethod(DbCombo MyDbCombo) { try { if (!MyDbCombo.NewVersionAvailable) { net.dbcombo.www.wsLatestBuild service = new net.dbcombo.www.wsLatestBuild(); string s = service.GetLatestBuild(1); string[] sAry = s.Split('.'); int major = int.Parse(sAry[0]); int minor = int.Parse(sAry[1]); int build = int.Parse(sAry[2]); bool laterBuild = false; if (major>Assembly.GetExecutingAssembly().GetName().Version.Major) laterBuild = true; else if (major==Assembly.GetExecutingAssembly().GetName().Version.Major) if (minor>Assembly.GetExecutingAssembly().GetName().Version.Minor) laterBuild = true; else if (minor==Assembly.GetExecutingAssembly().GetName().Version.Minor) if (build>Assembly.GetExecutingAssembly().GetName().Version.Build) laterBuild = true; if (laterBuild) { MyDbCombo.NewVersionAvailable=true; MyDbCombo.ulbNewVersionDiv.Visible=true; MyDbCombo.ulbNewVersionDiv.InnerHtml="There is a newer version of DbCombo<br>available. Go to www.dbcombo.net to<br>upgrade to v"+s; this.UpdateDesignTimeHtml(); } } } catch//(Exception e) { //System.Windows.Forms.MessageBox.Show(e.Message+"\n"+e.StackTrace); } }
/// <summary> /// StartAsync /// </summary> /// <param name="MyDbCombo"></param> protected void StartAsync(DbCombo MyDbCombo) { AsyncMethodDelegate func = new AsyncMethodDelegate(AsyncMethod); IAsyncResult iar = func.BeginInvoke(MyDbCombo, null, null); }
internal DbCombo Create(DbCombo newDbCombo) { _repo.Create(newDbCombo); return(newDbCombo); }