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