public bool UpdateMenuItemRow(MenuItemModel model)
{
bool success = false;
conn.Open();
using (IDbTransaction trans = conn.BeginTransaction())
{
string sql = @"UPDATE `halifaxdine`.`menu_item`
SET
`MENU_PRICE` = @Menu_Price,
`MENU_DESC` = @Menu_Desc,
`MENU_NAME` = @Menu_Name
WHERE `MENU_ID` = @Menu_Id
";
try
{
success = 1 == conn.Execute(sql, new { model.Menu_Id, model.Menu_Price, model.Menu_Name, model.Menu_Desc });
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
}
}
conn.Close();
return(success);
}
public bool DeleteMenuItemRow(MenuItemModel model)
{
bool success = false;
conn.Open();
using (IDbTransaction trans = conn.BeginTransaction())
{
string sql = @"delete from `halifaxdine`.`menu_item`
WHERE `MENU_ID` = @Menu_Id
";
try
{
success = 1 == conn.Execute(sql, new { model.Menu_Id });
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
}
}
conn.Close();
return(success);
}
public bool InsertMenuItemRow(MenuItemModel model)
{
bool success = false;
conn.Open();
using (IDbTransaction trans = conn.BeginTransaction())
{
string sql = @"INSERT INTO `halifaxdine`.`menu_item`
(`MENU_ID`,
`MENU_PRICE`,
`MENU_DESC`,
`MENU_NAME`)
VALUES
(Default,
@Menu_Price,
@Menu_Desc,
@Menu_Name)";
try
{
success = 1 == conn.Execute(sql, new { model.Menu_Price, model.Menu_Name, model.Menu_Desc });
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
}
}
conn.Close();
return(success);
}