public static Group GetGroup(MoveCommandEnum _moveCommand,Group _crGroup) { Sec_Groups dbGroup = null; NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); switch (_moveCommand) { case MoveCommandEnum.MoveFirst: dbGroup = newAppsCnn.Sec_Groups.FirstOrDefault(); break; case MoveCommandEnum.MovePrev: if (_crGroup != null) dbGroup = (from g in newAppsCnn.Sec_Groups where g.GroupID.CompareTo(_crGroup.GroupID) < 0 orderby g.GroupID descending select g).FirstOrDefault(); break; case MoveCommandEnum.MoveNext: if (_crGroup != null) dbGroup = (from g in newAppsCnn.Sec_Groups where g.GroupID.CompareTo(_crGroup.GroupID) > 0 orderby g.GroupID ascending select g).FirstOrDefault(); break; case MoveCommandEnum.MoveLast: dbGroup = (from g in newAppsCnn.Sec_Groups orderby g.GroupID descending select g).FirstOrDefault(); break; case MoveCommandEnum.Refresh: if (_crGroup != null) dbGroup = (from g in newAppsCnn.Sec_Groups where g.GroupID == _crGroup.GroupID select g).FirstOrDefault(); break; } if (dbGroup != null) { Group group = new Group(); group.FromDbGroup(dbGroup); group.LoadGroupUsers(dbGroup); return group; } else return null; }
public static Group GetGroupByID(string groupID) { NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString); var dbGroup = (from g in newAppsCnn.Sec_Groups where g.GroupID == groupID select g).FirstOrDefault(); if (dbGroup != null) { Group group = new Group(); group.FromDbGroup(dbGroup); group.LoadGroupUsers(dbGroup); return group; } else return null; }