public MasterMenuGroupView GetInfo(string code)
{
using (var ctx = new ConXContext())
{
MenuFunctionGroup model = ctx.MenuFunctionGroups
.Where(z => z.menuFunctionGroupId == code).SingleOrDefault();
return(new MasterMenuGroupView
{
menuFunctionGroupId = model.menuFunctionGroupId,
menuFunctionGroupName = model.menuFunctionGroupName,
iconName = model.iconName,
orderDisplay = model.orderDisplay,
menuGroup = model.menuGroup
});
}
}
public void Update(MasterMenuGroupView model)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
MenuFunctionGroup updateObj = ctx.MenuFunctionGroups.Where(z => z.menuFunctionGroupId == model.menuFunctionGroupId).SingleOrDefault();
updateObj.menuFunctionGroupId = model.menuFunctionGroupId;
updateObj.menuFunctionGroupName = model.menuFunctionGroupName;
updateObj.iconName = model.iconName;
updateObj.orderDisplay = model.orderDisplay;
updateObj.menuGroup = model.menuGroup;
ctx.SaveChanges();
scope.Complete();
}
}
}
public bool CheckDupplicate(string code)
{
using (var ctx = new ConXContext())
{
MenuFunctionGroup model = ctx.MenuFunctionGroups
.Where(x => (x.menuFunctionGroupId == code))
.SingleOrDefault();
bool isDup = model != null;
//if (model != null)
//{
// MenuFunctionGroup oldModel = ctx.MenuFunctionGroups.Where(z => z.branchGroupId == id).SingleOrDefault();
// isDup = code != oldModel.branchGroupCode;
//}
return(isDup);
}
}
public void Create(MasterMenuGroupView model)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
MenuFunctionGroup newObj = new MenuFunctionGroup()
{
menuFunctionGroupId = model.menuFunctionGroupId,
menuFunctionGroupName = model.menuFunctionGroupName,
iconName = model.iconName,
orderDisplay = model.orderDisplay,
//menuGroup = model.menuGroup
menuGroup = "A"
};
ctx.MenuFunctionGroups.Add(newObj);
ctx.SaveChanges();
scope.Complete();
}
}
}
