public List <HelpClassUsers> GetUsersByWSLog()
{
DataClassesBAMDataContext classesBamDataContext = new DataClassesBAMDataContext();
DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
List <HelpClassUsers> list = new List <HelpClassUsers>();
Table <bam_UniversalServiceControlProduction_Completed> productionCompleteds = classesBamDataContext.bam_UniversalServiceControlProduction_Completeds;
Expression <Func <bam_UniversalServiceControlProduction_Completed, string> > selector = (Expression <Func <bam_UniversalServiceControlProduction_Completed, string> >)(log => log.UserID);
foreach (string g in (IEnumerable <string>)Queryable.Distinct <string>(Queryable.Select <bam_UniversalServiceControlProduction_Completed, string>((IQueryable <bam_UniversalServiceControlProduction_Completed>)productionCompleteds, selector)))
{
if (g != null)
{
USER byId = new UsersDAL().GetByID(new Guid(g));
list.Add(new HelpClassUsers()
{
ID = byId.ID,
Name = byId.Name,
Surname = byId.Surname,
ID_Cert = Convert.ToInt64((object)byId.ID_CERT),
NameSurname = byId.Name + " " + byId.Surname,
Email = byId.email,
Active = byId.Active,
CreatedOn = byId.CreateOn,
user = byId.username,
pass = byId.password,
Type = byId.Type,
UserObj = byId
});
}
}
return(list);
}
public List <HelpClassUsers> GetUsersByWSLogForLocalAdmin(INSTITUTION AdminInstitution)
{
List <WEBSERVICE> servicesByIstitution = new WebservicesDAL().GetServicesByIstitution(AdminInstitution);
List <string> list1 = new List <string>();
foreach (WEBSERVICE webservice in servicesByIstitution)
{
string tittle = webservice.Tittle;
list1.Add(tittle);
}
DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
DataClassesBAMDataContext classesBamDataContext = new DataClassesBAMDataContext();
List <HelpClassUsers> list2 = new List <HelpClassUsers>();
List <HelpClassUsers> list3 = new List <HelpClassUsers>();
using (List <string> .Enumerator enumerator1 = list1.GetEnumerator())
{
while (enumerator1.MoveNext())
{
string w = enumerator1.Current;
IQueryable <bam_UniversalServiceControlProduction_Completed> source1 = Queryable.Where <bam_UniversalServiceControlProduction_Completed>((IQueryable <bam_UniversalServiceControlProduction_Completed>)classesBamDataContext.bam_UniversalServiceControlProduction_Completeds, (Expression <Func <bam_UniversalServiceControlProduction_Completed, bool> >)(log => log.WSTittle == w && log.InstitutionTittle == AdminInstitution.Tittle));
Expression <Func <bam_UniversalServiceControlProduction_Completed, string> > selector1 = (Expression <Func <bam_UniversalServiceControlProduction_Completed, string> >)(log => log.UserID);
using (IEnumerator <string> enumerator2 = Queryable.Distinct <string>(Queryable.Select <bam_UniversalServiceControlProduction_Completed, string>(source1, selector1)).GetEnumerator())
{
while (enumerator2.MoveNext())
{
string b = enumerator2.Current;
IQueryable <PERMISSION> source2 = Queryable.Where <PERMISSION>((IQueryable <PERMISSION>)classes1DataContext.PERMISSIONs, (Expression <Func <PERMISSION, bool> >)(p => p.ID_USER.ToString() == b));
Expression <Func <PERMISSION, USER> > selector2 = (Expression <Func <PERMISSION, USER> >)(p => p.USER);
foreach (USER user in (IEnumerable <USER>)Queryable.Distinct <USER>(Queryable.Select <PERMISSION, USER>(source2, selector2)))
{
HelpClassUsers helpClassUsers1 = new HelpClassUsers();
helpClassUsers1.ID = user.ID;
helpClassUsers1.Name = user.Name;
helpClassUsers1.Surname = user.Surname;
helpClassUsers1.ID_Cert = Convert.ToInt64((object)user.ID_CERT);
helpClassUsers1.NameSurname = user.Name + " " + user.Surname;
helpClassUsers1.Email = user.email;
helpClassUsers1.Active = user.Active;
helpClassUsers1.CreatedOn = user.CreateOn;
helpClassUsers1.user = user.username;
helpClassUsers1.pass = user.password;
helpClassUsers1.Type = user.Type;
helpClassUsers1.UserObj = user;
if (list3.Count != 0)
{
foreach (HelpClassUsers helpClassUsers2 in list3)
{
if (helpClassUsers2.ID == helpClassUsers1.ID)
{
list2.Add(helpClassUsers1);
}
}
}
list3.Add(helpClassUsers1);
}
}
}
if (list2.Count != 0)
{
foreach (HelpClassUsers helpClassUsers in list2)
{
list3.Remove(helpClassUsers);
}
}
}
}
return(list3);
}
