protected void btnMenuAdd_Click(object sender, EventArgs e)
{
int _temp;
EntityLayers.Menu _entityMenuObj = new EntityLayers.Menu()
{
_menuTypeID = int.Parse(ddlMenuType.SelectedValue),
_menuDescription = txtMenuDesc.Text,
_menuPrice = decimal.Parse(txtMenuPrice.Text),
_menuItem = txtMenuItem.Text
};
_temp = _svcObj.AddMenuIns(_entityMenuObj);
try
{
if (_temp == -1)
{
Response.Write("<script>alert('Problem with the server register again')</script>");
}
else if (_temp == 1)
{
Response.Write("<script>alert(' Menu Successfully added')</script>");
Response.Redirect("AdminHome.aspx");
}
}
finally
{
Response.Write("<script>alert(' Menu Successfully added')</script>");
}
}
public List <EntityLayers.Menu> DeleteMenuList()
{
try
{
SqlCommand _cmd = new SqlCommand("select MenuID from Menu", _conobj);
_conobj.Open();
SqlDataReader dr = _cmd.ExecuteReader();
List <EntityLayers.Menu> _listMenuObj = new List <EntityLayers.Menu>();
if (dr.HasRows)
{
while (dr.Read())
{
EntityLayers.Menu _menuDelObj = new EntityLayers.Menu()
{
_menuID = int.Parse(dr[0].ToString())
};
_listMenuObj.Add(_menuDelObj);
}
}
return(_listMenuObj);
}
catch (Exception)
{
throw;
}
finally
{
_conobj.Close();
}
}
protected void ddlMenuID_SelectedIndexChanged(object sender, EventArgs e)
{
UtilityOperation _utilObj = new UtilityOperation();
List <EntityLayers.Menu> _listObj1 = new List <EntityLayers.Menu>();
_listObj1 = _utilObj.RetreiveModifyMenu(ddlMenuID.SelectedValue);
EntityLayers.Menu _menuObj = new EntityLayers.Menu();
txtMenuItem.Text = _listObj1[0]._menuItem;
txtMenuPrice.Text = _listObj1[0]._menuPrice.ToString();
txtMenuDescription.Text = _listObj1[0]._menuDescription;
}
protected void btnModify_Click(object sender, EventArgs e)
{
try
{
AdminOperation _addMenuObj = new AdminOperation();
EntityLayers.Menu _entityMenuObj = new EntityLayers.Menu()
{
_menuDescription = txtMenuDescription.Text,
_menuID = int.Parse(ddlMenuID.SelectedValue),
_menuPrice = decimal.Parse(txtMenuPrice.Text),
_menuItem = txtMenuItem.Text
};
_addMenuObj.ModifyRoomLinqToSql(_entityMenuObj);
Response.Write("<script>alert(' Successfully Modified Menu') </script> ");
Response.Redirect("AdminHome.aspx");
}
catch (Exception)
{
throw;
}
}
//ADD MENU method for Admin to ADD MENU ITEMS
public int AddMenuIns(EntityLayers.Menu _menuObj)
{
//Connection String
//SqlConnection _conObj = new SqlConnection("Data Source=.;Initial Catalog=HotelDB;Integrated Security=True");
SqlCommand _cmd;
int _result;
try
{
_conObj.Open();
_cmd = new SqlCommand();
_cmd.CommandText = "sp_AddMenu";
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Connection = _conObj;
_cmd.Parameters.AddWithValue("@MenuTypeID", _menuObj._menuTypeID);
_cmd.Parameters.AddWithValue("@MenuDesc", _menuObj._menuDescription);
_cmd.Parameters.AddWithValue("@MenuPrice", _menuObj._menuPrice);
_cmd.Parameters.AddWithValue("@MenuItem", _menuObj._menuItem);
_result = _cmd.ExecuteNonQuery();
return(_result);
}
catch (Exception)
{
throw;
}
finally
{
_conObj.Close();
}
}
public int AddMenuIns(EntityLayers.Menu _menuObj)
{
return(base.Channel.AddMenuIns(_menuObj));
}
