public HelpClassWebServices GetByIDPermisions(long id) { DataClasses1DataContext classes1DataContext = new DataClasses1DataContext(); try { WEBSERVICE ws = Queryable.Single <WEBSERVICE>((IQueryable <WEBSERVICE>)classes1DataContext.WEBSERVICEs, (Expression <Func <WEBSERVICE, bool> >)(p => p.ID == id)); HelpClassWebServices classWebServices = new HelpClassWebServices(); List <PERMISSION> permisionsByWs = new PermissionsDAL().GetPermisionsByWS(ws); classWebServices.ID = ws.ID; classWebServices.Tittle = ws.Tittle; classWebServices.Description = ws.Description; classWebServices.Note = ws.Note; classWebServices.URL = ws.URL; classWebServices.Active = ws.Active; classWebServices.CreatedOn = ws.CreatedOn; classWebServices.WSObj = ws; classWebServices.IDInstitution = 0L; classWebServices.InstitutionName = "x"; if (permisionsByWs.Count != 0) { classWebServices.IDInstitution = permisionsByWs[0].INSTITUTION.ID; classWebServices.InstitutionName = permisionsByWs[0].INSTITUTION.Tittle; } classWebServices.PermissionList = permisionsByWs; return(classWebServices); } catch { return((HelpClassWebServices)null); } }
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 <HelpClassWebServices> GetUsersWebServicesPermissions(bool active, USER user, INSTITUTION inst) { DataClasses1DataContext classes1DataContext = new DataClasses1DataContext(); List <HelpClassWebServices> list = new List <HelpClassWebServices>(); try { foreach (PERMISSION permission in new PermissionsDAL().GetPermisionsByUser(user)) { if (permission.WEBSERVICE.Active == active && permission.Active) { HelpClassWebServices classWebServices = new HelpClassWebServices(); List <PERMISSION> permisionsByWs = new PermissionsDAL().GetPermisionsByWS(permission.WEBSERVICE); classWebServices.ID = permission.WEBSERVICE.ID; classWebServices.Tittle = permission.WEBSERVICE.Tittle; classWebServices.Description = permission.WEBSERVICE.Description; classWebServices.Note = permission.WEBSERVICE.Note; classWebServices.URL = permission.WEBSERVICE.URL; classWebServices.Active = permission.WEBSERVICE.Active; classWebServices.CreatedOn = permission.WEBSERVICE.CreatedOn; classWebServices.WSObj = permission.WEBSERVICE; classWebServices.IDInstitution = 0L; classWebServices.InstitutionName = "x"; classWebServices.PermissionList = permisionsByWs; if (permisionsByWs.Count != 0) { classWebServices.IDInstitution = permisionsByWs[0].INSTITUTION.ID; classWebServices.InstitutionName = permisionsByWs[0].INSTITUTION.Tittle; if (classWebServices.IDInstitution == inst.ID) { list.Add(classWebServices); } } } } return(list); } catch { 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 <HelpClassWebServices> GetWebServicesInstitutionsPermissions(bool active) { DataClasses1DataContext classes1DataContext = new DataClasses1DataContext(); List <HelpClassWebServices> list = new List <HelpClassWebServices>(); try { foreach (WEBSERVICE ws in this.GetAllActiveDeleted(active)) { HelpClassWebServices classWebServices = new HelpClassWebServices(); List <PERMISSION> permisionsByWs = new PermissionsDAL().GetPermisionsByWS(ws); classWebServices.ID = ws.ID; classWebServices.Tittle = ws.Tittle; classWebServices.Description = ws.Description; classWebServices.Note = ws.Note; classWebServices.URL = ws.URL; classWebServices.Active = ws.Active; classWebServices.CreatedOn = ws.CreatedOn; classWebServices.WSObj = ws; classWebServices.IDInstitution = 0L; classWebServices.InstitutionName = "x"; if (permisionsByWs.Count != 0) { classWebServices.IDInstitution = permisionsByWs[0].INSTITUTION.ID; classWebServices.InstitutionName = permisionsByWs[0].INSTITUTION.Tittle; } classWebServices.PermissionList = permisionsByWs; list.Add(classWebServices); } return(list); } catch { return(list); } }