public IList<MenuInfo> SelectAll()
{
using (EinsteinEntities entities = new EinsteinEntities())
{
return entities.MenuInfo.ToList<MenuInfo>();
}
}
public void Add(MenuInfo info)
{
using (EinsteinEntities entities = new EinsteinEntities())
{
entities.MenuInfo.AddObject(info);
entities.SaveChanges();
}
}
public MenuInfo SelectByMenuID(string menuID)
{
using (EinsteinEntities entities = new EinsteinEntities())
{
var query = entities.MenuInfo.Where(c => c.MenuID == menuID);
return query.First<MenuInfo>();
}
}
public void Update(string menuID, string menuName)
{
using (EinsteinEntities entities = new EinsteinEntities())
{
foreach(var item in entities.MenuInfo.Where(c=>c.MenuID == menuID))
{
item.MenuName = menuName;
}
entities.SaveChanges();
}
}
public void Remove(string menuID)
{
using (EinsteinEntities context = new EinsteinEntities())
{
foreach (var item in context.MenuInfo.Where(c => c.MenuID == menuID))
{
context.DeleteObject(item);
}
context.SaveChanges();
}
}
