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 List<Group> GetAllGroups()
{
List<Group> result = new List<Group>();
NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
var dbGroups = from g in newAppsCnn.Sec_Groups select g;
foreach (var dbGroup in dbGroups)
{
Group group = new Group();
group.FromDbGroup(dbGroup);
result.Add(group);
}
return result;
}
private void frmGroups_Delete(object sender, ref bool _status)
{
if (CrGroup == null || CrGroup.IsNew ==true )
{
_status = false;
return;
}
DataDeleteResult result= CrGroup.Delete();
if (result.DeleteStatus == false)
{
_status = false;
MessageBox.Show(result.ErrorMessage);
}
else
CrGroup = null;
}
private void frmGroups_DataMove(object sender, MoveCommandEnum _moveCommand)
{
Group group = null;
switch (_moveCommand)
{
case MoveCommandEnum.MoveFirst:
group = Group.GetGroup(BackOfficeBL.General.MoveCommandEnum.MoveFirst, CrGroup);
break;
case MoveCommandEnum.MovePrev:
group = Group.GetGroup(BackOfficeBL.General.MoveCommandEnum.MovePrev, CrGroup);
break;
case MoveCommandEnum.MoveNext:
group = Group.GetGroup(BackOfficeBL.General.MoveCommandEnum.MoveNext, CrGroup);
break;
case MoveCommandEnum.MoveLast:
group = Group.GetGroup(BackOfficeBL.General.MoveCommandEnum.MoveLast, CrGroup);
break;
}
if (group != null)
{
CrGroup = group;
ShowGUI();
}
}
private void frmGroups_AddNew(object sender, ref bool _status)
{
CrGroup = new Group();
}
private void frmGroups_Save(object sender, ref bool _status)
{
GetDataFromGUI();
DataSaveResult result = CrGroup.Save();
if (result.SaveStatus == false)
{
_status = false;
MessageBox.Show(result.ErrorMessage);
}
else
{
CrGroup = (Group)result.Data;
ShowGUI();
}
}
private void frmGroupRights_DataRefresh(object sender)
{
if (CrGroup != null)
{
Group group = null;
group = Group.GetGroup(BackOfficeBL.General.MoveCommandEnum.Refresh, CrGroup);
if (group != null)
{
CrGroup = group;
ShowGUI();
}
}
}
public void LoadDbUserGroups(Sec_Users _dbUser)
{
Groups.Clear();
foreach (var dbGroup in _dbUser.Sec_Groups)
{
Group group = new Group();
group.FromDbGroup(dbGroup);
this.Groups.Add(group);
}
}
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;
}
