/// <summary>
/// Update an entry in the database
/// </summary>
/// <param name="Id"></param>
/// <param name="Name"></param>
/// <param name="Price"></param>
public void UpdateMenuItem(int Id, string Name, decimal Price)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GetConnectionString.CnnVal("Menu")))
{
MenuItemModel menuItem = new MenuItemModel();
menuItem.Id = Id;
menuItem.Price = Price;
menuItem.Name = Name;
connection.Execute("dbo.UpdateMenuItem @Id, @Price, @Name", menuItem);
}
}
/// <summary>
/// Removes an entry from the database
/// </summary>
/// <param name="anId"></param>
public void RemoveMenuItem(int anId)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GetConnectionString.CnnVal("Menu")))
{
MenuItemModel menuItem = new MenuItemModel();
menuItem.Id = anId;
connection.Execute("dbo.RemoveMenuItem @Id", menuItem);
}
}
/// <summary>
/// Returns a list of menu items specified by the argument (starter, main, drink etc)
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public List <MenuItemModel> GetItemsFromCategory(string category)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GetConnectionString.CnnVal("Menu")))
{
var output = connection.Query <MenuItemModel>("dbo.GetItemsFromCategory @Category", new { Category = category }).ToList();
return(output);
}
}
/// <summary>
/// Add a new database entry
/// </summary>
/// <param name="name"></param>
/// <param name="price"></param>
/// <param name="category"></param>
public void AddMenuItem(string name, decimal price, string category)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GetConnectionString.CnnVal("Menu")))
{
MenuItemModel menuItem = new MenuItemModel();
menuItem.Name = name;
menuItem.Price = price;
menuItem.Category = category;
connection.Execute("dbo.AddMenuItem @Name, @Price, @Category", menuItem);
}
}
/// <summary>
/// Pulls all the data from the SQL server
/// </summary>
/// <returns>A list of ContactModel</returns>
public List <MenuItemModel> Startup()
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GetConnectionString.CnnVal("Menu")))
{
var output = connection.Query <MenuItemModel>("dbo.Startup").ToList();
return(output);
}
}