private void btn_RefreshUsers_Click(object sender, EventArgs e)
{
olv_PRDUSERS.ClearObjects();
olv_ACCUSERS.ClearObjects();
Prd_Users = SynapseUser.Load();
Acc_Users = ACCSynapseUser.Load();
Prd_UserProfiles = SynapseUser_Profile.Load();
Acc_UserProfiles = ACCSynapseUser_Profile.Load();
olv_ACCUSERS.SetObjects(Acc_Users.OrderBy(au => au.UserID));
olv_PRDUSERS.SetObjects(Prd_Users.OrderBy(pu => pu.UserID));
}
private void btn_SyncUserDB_Click(object sender, EventArgs e)
{
foreach (ACCSynapseUser auser in Acc_Users)
{
SynapseUser puser = SynapseUser.LoadByUserID(auser.UserID);
if (puser.UserID != auser.UserID)
{
puser = new SynapseUser();
puser.CULTURE = auser.CULTURE;
puser.FIRSTNAME = auser.FIRSTNAME;
puser.LASTNAME = auser.LASTNAME;
puser.UserID = auser.UserID;
puser.save();
}
}
foreach (SynapseUser puser in Prd_Users)
{
ACCSynapseUser auser = ACCSynapseUser.LoadByUserID(puser.UserID);
if (puser.UserID != auser.UserID)
{
auser = new ACCSynapseUser();
auser.CULTURE = puser.CULTURE;
auser.FIRSTNAME = puser.FIRSTNAME;
auser.LASTNAME = puser.LASTNAME;
auser.UserID = puser.UserID;
auser.save();
}
}
AccToPrdID = ACCTOPRD.Load("WHERE PRDID<>0");
foreach (ACCSynapseUser auser in Acc_Users)
{
SynapseUser puser = SynapseUser.LoadByUserID(auser.UserID);
if (puser == null)
{
ACCTOPRD lnk = AccToPrdID.Where(a => a.ACCID == auser.ID && a.PRDID == puser.ID && a.OBJECTTYPE == typeof(ACCSynapseUser).Name).FirstOrDefault();
if (lnk == null)
{
lnk = new ACCTOPRD();
lnk.OBJECTTYPE = typeof(ACCSynapseUser).Name;
lnk.ACCID = auser.ID;
lnk.PRDID = puser.ID;
}
}
}
}
private void btn_analyse_Click(object sender, EventArgs e)
{
Presentation.Clear();
string[] ids = (from id in olv_Modules.CheckedObjects.Cast <SynapseModule>() select id.ID.ToString()).ToArray();
string str_id = string.Join(",", ids);
Prd_Users = SynapseUser.Load();
Acc_Users = ACCSynapseUser.Load();
obj_sync pr = new obj_sync();
pr.Name = typeof(SynapseUser).FullName;
pr.PrdCnt = Prd_Users.Count;
pr.AccCnt = Acc_Users.Count;
pr.Link = (from l in AccToPrdID where l.OBJECTTYPE == typeof(ACCSynapseUser).Name select l).Count();
Presentation.Add(pr);
Prd_Profiles = SynapseProfile.Load("WHERE FK_MODULEID in (" + str_id + ")");
Acc_Profiles = ACCSynapseProfile.Load("WHERE FK_MODULEID in (" + str_id + ")");
pr = new obj_sync();
pr.Name = typeof(SynapseProfile).FullName;
pr.PrdCnt = Prd_Profiles.Count;
pr.AccCnt = Acc_Profiles.Count;
IList <Int64> Acc_Profiles_IDs = (from i in Acc_Profiles select i.ID).ToList();
pr.Link = (from l in AccToPrdID where l.OBJECTTYPE == typeof(ACCSynapseProfile).Name && Acc_Profiles_IDs.Contains(l.ACCID) select l).Count();
Presentation.Add(pr);
string Prd_ProfilesID = string.Join(",", (from p in Prd_Profiles select p.ID.ToString()).ToArray());
string Acc_ProfilesID = string.Join(",", (from p in Acc_Profiles select p.ID.ToString()).ToArray());
Prd_Controls = SynapseControl.Load("WHERE FK_MODULE_ID in (" + str_id + ")");
Acc_Controls = ACCSynapseControl.Load("WHERE FK_MODULE_ID in (" + str_id + ")");
pr = new obj_sync();
pr.Name = typeof(SynapseControl).FullName;
pr.PrdCnt = Prd_Controls.Count;
pr.AccCnt = Acc_Controls.Count;
IList <Int64> Acc_Controls_IDs = (from i in Acc_Controls select i.ID).ToList();
pr.Link = (from l in AccToPrdID where l.OBJECTTYPE == typeof(ACCSynapseControl).Name && Acc_Controls_IDs.Contains(l.ACCID) select l).Count();
Presentation.Add(pr);
string Prd_ControlsID = string.Join(",", (from c in Prd_Controls select c.ID.ToString()).ToArray());
string Acc_ControlsID = string.Join(",", (from c in Acc_Controls select c.ID.ToString()).ToArray());
if (Prd_ControlsID.Length <= 0)
{
Prd_ProfileControls = new List <SynapseProfile_Control>();
}
else
{
Prd_ProfileControls = SynapseProfile_Control.Load("WHERE FK_CONTROLID in (" + Prd_ControlsID + ")");
}
try
{
Acc_ProfileControls = ACCSynapseProfile_Control.Load("WHERE FK_CONTROLID in (" + Acc_ControlsID + ")");
}
catch
{
Acc_ProfileControls = new List <ACCSynapseProfile_Control>();
}
pr = new obj_sync();
pr.Name = typeof(SynapseProfile_Control).FullName;
pr.PrdCnt = Prd_ProfileControls.Count;
pr.AccCnt = Acc_ProfileControls.Count;
IList <Int64> Acc_ProfileControls_IDs = (from i in Acc_ProfileControls select i.ID).ToList();
pr.Link = (from l in AccToPrdID where l.OBJECTTYPE == typeof(ACCSynapseProfile_Control).Name && Acc_ProfileControls_IDs.Contains(l.ACCID) select l).Count();
Presentation.Add(pr);
if (Prd_ProfilesID.Length <= 0)
{
Prd_UserProfiles = new List <SynapseUser_Profile>();
}
else
{
Prd_UserProfiles = SynapseUser_Profile.Load("WHERE FK_SECURITY_PROFILE in (" + Prd_ProfilesID + ")");
}
Acc_UserProfiles = ACCSynapseUser_Profile.Load("WHERE FK_SECURITY_PROFILE in (" + Acc_ProfilesID + ")");
pr = new obj_sync();
pr.Name = typeof(SynapseUser_Profile).FullName;
pr.PrdCnt = Prd_UserProfiles.Count;
pr.AccCnt = Acc_UserProfiles.Count;
IList <Int64> Acc_UserProfiles_IDs = (from i in Acc_UserProfiles select i.ID).ToList();
pr.Link = (from l in AccToPrdID where l.OBJECTTYPE == typeof(ACCSynapseUser_Profile).Name && Acc_UserProfiles_IDs.Contains(l.ACCID) select l).Count();
Presentation.Add(pr);
olv_analyse.SetObjects(Presentation);
}
