public static void SynchronizeViewPermission( )
{
GEPermissionViewsController permissionCtrl = new GEPermissionViewsController();
String strQuery = String.Format(@"DELETE FROM GEPermissionViews WHERE FK_GEPermissionID NOT IN (SELECT GEPermissionID FROM GEPermissions)");
BusinessObjectController.RunQuery(strQuery);
#region Init Views
STViewsController viewCtrl = new STViewsController();
Dictionary <Guid, STViewsInfo> lstSTViews = new Dictionary <Guid, STViewsInfo>();
DataSet ds = viewCtrl.GetDataSetAllObjects();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
STViewsInfo viewInfo = viewCtrl.GetObjectFromDataRow(dr) as STViewsInfo;
if (lstSTViews.ContainsKey(viewInfo.STViewID) == false)
{
lstSTViews.Add(viewInfo.STViewID, viewInfo);
}
}
}
#endregion
foreach (GEPermissionsInfo permission in new GEPermissionsController().GetListAllObjects())
{
#region View
Dictionary <Guid, GEPermissionViewsInfo> lstGroupViews = new Dictionary <Guid, GEPermissionViewsInfo>();
foreach (GEPermissionViewsInfo viewInfo in permissionCtrl.GetListByForeignKey("FK_GEPermissionID", permission.GEPermissionID).Cast <GEPermissionViewsInfo>().ToList())
{
if (viewInfo.FK_STViewID.HasValue && lstGroupViews.ContainsKey(viewInfo.FK_STViewID.Value) == false)
{
if (lstSTViews.ContainsKey(viewInfo.FK_STViewID.Value))
{
lstGroupViews.Add(viewInfo.FK_STViewID.Value, viewInfo);
}
else
{
permissionCtrl.DeleteObject(viewInfo);
}
}
}
foreach (Guid strViewID in lstSTViews.Keys)
{
if (lstGroupViews.ContainsKey(strViewID) == false)
{
GEPermissionViewsInfo viewInfo = new GEPermissionViewsInfo();
viewInfo.FK_STViewID = lstSTViews[strViewID].STViewID;
if (lstSTViews[strViewID].FK_STViewGroupID.HasValue)
{
viewInfo.ViewGroup = GetViewGroupCaption(lstSTViews[strViewID].FK_STViewGroupID.Value);
}
viewInfo.FK_GEPermissionID = permission.GEPermissionID;
viewInfo.AllowView = true;
viewInfo.IsHomePage = false;
permissionCtrl.CreateObject(viewInfo);
lstGroupViews.Add(viewInfo.FK_STViewID.Value, viewInfo);
}
}
#endregion
}
}
