public HelpClassUsers GetByIDPermisions(Guid id)
{
DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
try
{
USER user = Queryable.Single <USER>((IQueryable <USER>)classes1DataContext.USERs, (Expression <Func <USER, bool> >)(p => p.ID == id));
List <PERMISSION> permisionsByUser = new PermissionsDAL().GetPermisionsByUser(user);
HelpClassUsers helpClassUsers = new HelpClassUsers();
helpClassUsers.ID = user.ID;
helpClassUsers.Name = user.Name;
helpClassUsers.Surname = user.Surname;
helpClassUsers.NameSurname = user.Name + " " + user.Surname;
helpClassUsers.ID_Cert = Convert.ToInt64((object)user.ID_CERT);
helpClassUsers.Email = user.email;
helpClassUsers.Active = user.Active;
helpClassUsers.CreatedOn = user.CreateOn;
helpClassUsers.user = user.username;
helpClassUsers.pass = user.password;
helpClassUsers.Type = user.Type;
helpClassUsers.UserObj = user;
helpClassUsers.ip = user.IpAdress;
if (permisionsByUser.Count != 0)
{
helpClassUsers.IDInstitution = permisionsByUser[0].INSTITUTION.ID;
helpClassUsers.InstitutionName = permisionsByUser[0].INSTITUTION.Tittle;
}
helpClassUsers.PermissionList = permisionsByUser;
return(helpClassUsers);
}
catch
{
return((HelpClassUsers)null);
}
}
public List <HelpClassUsers> GetUsersByInstitutionLog(INSTITUTION inst)
{
IQueryable <USER> queryable = Queryable.Distinct <USER>(Queryable.Select <PERMISSION, USER>(Queryable.Where <PERMISSION>((IQueryable <PERMISSION>) new DataClasses1DataContext().PERMISSIONs, (Expression <Func <PERMISSION, bool> >)(p => p.Active == true && p.INSTITUTION.ID == inst.ID && p.USER.Active == true)), (Expression <Func <PERMISSION, USER> >)(p => p.USER)));
List <HelpClassUsers> list = new List <HelpClassUsers>();
foreach (USER user in (IEnumerable <USER>)queryable)
{
HelpClassUsers helpClassUsers = new HelpClassUsers();
helpClassUsers.ID = user.ID;
helpClassUsers.Name = user.Name;
helpClassUsers.Surname = user.Surname;
helpClassUsers.ID_Cert = Convert.ToInt64((object)user.ID_CERT);
helpClassUsers.NameSurname = user.Name + " " + user.Surname;
helpClassUsers.Email = user.email;
helpClassUsers.Active = user.Active;
helpClassUsers.CreatedOn = user.CreateOn;
helpClassUsers.user = user.username;
helpClassUsers.pass = user.password;
helpClassUsers.Type = user.Type;
helpClassUsers.UserObj = user;
helpClassUsers.ip = user.IpAdress;
if (helpClassUsers.Active)
{
list.Add(helpClassUsers);
}
}
return(list);
}
public List <HelpClassUsers> GetUsersPermissionsByInstitutionNew(bool active, INSTITUTION inst)
{
DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
List <HelpClassUsers> list = new List <HelpClassUsers>();
try
{
foreach (USER user in this.GetUsersByTypeActive(2, active))
{
HelpClassUsers helpClassUsers = new HelpClassUsers();
List <PERMISSION> permisionsByUser = new PermissionsDAL().GetPermisionsByUser(user);
helpClassUsers.ID = user.ID;
helpClassUsers.Name = user.Name;
helpClassUsers.Surname = user.Surname;
helpClassUsers.ID_Cert = Convert.ToInt64((object)user.ID_CERT);
helpClassUsers.NameSurname = user.Name + " " + user.Surname;
helpClassUsers.Email = user.email;
helpClassUsers.Active = user.Active;
helpClassUsers.CreatedOn = user.CreateOn;
helpClassUsers.user = user.username;
helpClassUsers.pass = user.password;
helpClassUsers.Type = user.Type;
helpClassUsers.UserObj = user;
helpClassUsers.ip = user.IpAdress;
if (permisionsByUser.Count != 0)
{
helpClassUsers.IDInstitution = permisionsByUser[0].INSTITUTION.ID;
helpClassUsers.InstitutionName = permisionsByUser[0].INSTITUTION.Tittle;
helpClassUsers.PermissionList = permisionsByUser;
if (helpClassUsers.IDInstitution == inst.ID)
{
list.Add(helpClassUsers);
}
}
}
return(list);
}
catch
{
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);
}
