Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        public void FillPanelUsers(INSTITUTION objectInstitution)
        {
            List <HelpClassUsers> byInstitutionNew = new UsersDAL().GetUsersPermissionsByInstitutionNew(true, objectInstitution);

            this.PanelUsers.Controls.Clear();
            foreach (HelpClassUsers helpClassUsers in byInstitutionNew)
            {
                if (helpClassUsers.Type == 2)
                {
                    Label label = new Label();
                    this.PanelUsers.Controls.Add((Control) new LiteralControl("<p>"));
                    label.ID       = "LabelU" + (object)helpClassUsers.ID;
                    label.Text     = helpClassUsers.NameSurname;
                    label.CssClass = "lblpanelsinfo";
                    this.PanelUsers.Controls.Add((Control)label);
                    LinkButton linkButton = new LinkButton();
                    linkButton.ID       = "LinkU" + (object)helpClassUsers.ID;
                    linkButton.Text     = " Повеќе...";
                    linkButton.CssClass = "linkpanelsinfo";
                    linkButton.Click   += new EventHandler(this.LinkU_Click);
                    this.PanelUsers.Controls.Add((Control)linkButton);
                    this.PanelUsers.Controls.Add((Control) new LiteralControl("</p>"));
                }
            }
        }
Esempio n. 3
0
        public List <WEBSERVICE> GetServicesByIstitution(INSTITUTION inst)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
            List <WEBSERVICE>       allActiveDeleted    = this.GetAllActiveDeleted(true);
            List <WEBSERVICE>       list = new List <WEBSERVICE>();

            using (List <WEBSERVICE> .Enumerator enumerator = allActiveDeleted.GetEnumerator())
            {
                while (enumerator.MoveNext())
                {
                    WEBSERVICE c = enumerator.Current;
                    IQueryable <PERMISSION> source = Queryable.Where <PERMISSION>((IQueryable <PERMISSION>)classes1DataContext.PERMISSIONs, (Expression <Func <PERMISSION, bool> >)(p => p.Active == true && p.INSTITUTION.ID == inst.ID && p.ID_WS == c.ID && p.WEBSERVICE.Active == true));
                    try
                    {
                        if (Queryable.Count <PERMISSION>(source) != 0)
                        {
                            list.Add(c);
                        }
                    }
                    catch
                    {
                    }
                }
            }
            return(list);
        }
Esempio n. 4
0
        public List <HelpClassUsers> GetUsersByInstitution(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.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)
            {
                list.Add(new HelpClassUsers()
                {
                    ID          = user.ID,
                    Name        = user.Name,
                    Surname     = user.Surname,
                    ID_Cert     = Convert.ToInt64((object)user.ID_CERT),
                    NameSurname = user.Name + " " + user.Surname,
                    Email       = user.email,
                    Active      = user.Active,
                    CreatedOn   = user.CreateOn,
                    user        = user.username,
                    pass        = user.password,
                    Type        = user.Type,
                    UserObj     = user,
                    ip          = user.IpAdress
                });
            }
            return(list);
        }
Esempio n. 5
0
        public void Update(INSTITUTION inst, USER user, WEBSERVICE ws, int?use, bool?active, DateTime?created, long id)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
            PERMISSION permission = Queryable.Single <PERMISSION>((IQueryable <PERMISSION>)classes1DataContext.PERMISSIONs, (Expression <Func <PERMISSION, bool> >)(p => p.ID == id));

            if (inst != null)
            {
                permission.INSTITUTION = inst;
            }
            if (user != null)
            {
                permission.USER = user;
            }
            if (ws != null)
            {
                permission.WEBSERVICE = ws;
            }
            if (use.HasValue)
            {
                permission.Usage = Convert.ToInt32((object)use);
            }
            if (active.HasValue)
            {
                permission.Active = Convert.ToBoolean((object)active);
            }
            if (created.HasValue)
            {
                permission.CreatedOn = Convert.ToDateTime((object)created);
            }
            classes1DataContext.SubmitChanges();
        }
Esempio n. 6
0
        protected void btn_promeni_Click(object sender, EventArgs e)
        {
            INSTITUTION inst  = (INSTITUTION)this.Application["Institution"];
            bool        flag1 = false;

            if (this.CheckBoxPTrue.Checked)
            {
                flag1 = true;
            }
            bool flag2 = false;

            if (!flag1)
            {
                List <HelpClassUsers> usersByInstitution   = new UsersDAL().GetUsersByInstitution(inst);
                List <WEBSERVICE>     servicesByIstitution = new WebservicesDAL().GetServicesByIstitution(inst);
                if (usersByInstitution.Count != 0 || servicesByIstitution.Count != 0)
                {
                    string str = "Не е дозволено бришење! Зависност од следниве објекти<br />";
                    if (usersByInstitution.Count != 0)
                    {
                        str += "<br />Корисници:<br />";
                        foreach (HelpClassUsers helpClassUsers in usersByInstitution)
                        {
                            str = str + "   " + helpClassUsers.NameSurname + "<br />";
                        }
                    }
                    if (servicesByIstitution.Count != 0)
                    {
                        str += "<br />Сервиси:<br />";
                        foreach (WEBSERVICE webservice in servicesByIstitution)
                        {
                            str = str + "   " + webservice.Tittle + "<br />";
                        }
                    }
                    this.diverror.Visible = true;
                    this.Literal1.Text    = str;
                }
                else
                {
                    flag2 = true;
                }
            }
            else
            {
                flag2 = true;
            }
            if (flag2)
            {
                new InstitutionsDAL().Update(this.txtPName.Text, this.txtPDescription.Text, new bool?(flag1), new DateTime?(), inst.ID);
                string old    = inst.Tittle + ";" + inst.Description + ";" + inst.Active.ToString();
                string newone = this.txtPName.Text + ";" + this.txtPDescription.Text + ";" + flag1.ToString();
                new LOGDAL().Insert(Enumerable.Single <KeyValuePair <int, string> >((IEnumerable <KeyValuePair <int, string> >)InteropDAL.TablesDictionary, (Func <KeyValuePair <int, string>, bool>)(p => p.Value == "INSTITUTIONS")).Key, (USER)this.Session["user"], inst.ID.ToString(), 2, DateTime.Now, old, newone);
                this.Application["ListInstitutions"] = (object)new InstitutionsDAL().GetAllActiveDeleted(true);
                this.InstitutionsGridView.DataSource = (object)(List <INSTITUTION>) this.Application["ListInstitutions"];
                this.InstitutionsGridView.DataBind();
            }
            this.PanelEditUser.CssClass = "content-box column-right closed-box";
            this.PanelNewUser.CssClass  = "content-box column-left closed-box";
        }
Esempio n. 7
0
        protected void PanelServices_Load(object sender, EventArgs e)
        {
            INSTITUTION objectInstitution = (INSTITUTION)this.Session["SelectedInstitution"];

            this.Label1.Text = objectInstitution.Tittle;
            this.Label2.Text = objectInstitution.Description;
            this.FillPanelServices(objectInstitution);
        }
Esempio n. 8
0
        public void FillPanelServices(INSTITUTION objectInstitution)
        {
            List <HelpClassWebServices> servicesPermissions = new WebservicesDAL().GetUsersWebServicesPermissions(true, (USER)this.Session["user"]);
            INSTITUTION       institution = (INSTITUTION)this.Session["LocalSelectedInstitution"];
            List <WEBSERVICE> list        = new List <WEBSERVICE>();

            foreach (HelpClassWebServices classWebServices in servicesPermissions)
            {
                if (classWebServices.IDInstitution == institution.ID)
                {
                    list.Add(classWebServices.WSObj);
                }
            }
            this.PanelServices.Controls.Clear();
            foreach (WEBSERVICE webservice in list)
            {
                Label label = new Label();
                this.PanelServices.Controls.Add((Control) new LiteralControl("<p>"));
                label.ID = "LabelWS" + (object)webservice.ID;
                string str = webservice.Tittle;
                if (str == "Imoten List")
                {
                    str = "Имотен Лист";
                }
                else if (str == "Drzavjanstvo")
                {
                    str = "Државјанство";
                }
                else if (str == "Edinstven Danocen Broj Na Subjektot")
                {
                    str = "Единствен Даночен Број На Субјектот";
                }
                else if (str == "Podatoci za MBPL za potrebite na AKN")
                {
                    str = "Податоци за ЕМБС за потребите на АКН";
                }
                else if (str == "Podatoci za MBPL za potrebite na CU")
                {
                    str = "Податоци за ЕМБС за потребите на ЦУ";
                }
                else if (str == "Podatoci za parceli")
                {
                    str = "Податоци за Парцели";
                }
                label.Text     = str;
                label.CssClass = "lblpanelsinfo";
                this.PanelServices.Controls.Add((Control)label);
                LinkButton linkButton = new LinkButton();
                linkButton.ID       = "LinkWS" + (object)webservice.ID;
                linkButton.Text     = "Пребарај...";
                linkButton.CssClass = "linkpanelsinfo";
                linkButton.Click   += new EventHandler(this.LinkWS_Click);
                this.PanelServices.Controls.Add((Control)linkButton);
                this.PanelServices.Controls.Add((Control) new LiteralControl("</p>"));
            }
        }
Esempio n. 9
0
        protected void PanelUsers_Load(object sender, EventArgs e)
        {
            INSTITUTION       objectInstitution = (INSTITUTION)this.Session["LocalSelectedInstitution"];
            List <PERMISSION> permisionsByUser  = new PermissionsDAL().GetPermisionsByUser((USER)this.Session["user"]);

            if (objectInstitution.ID != permisionsByUser[0].INSTITUTION.ID)
            {
                return;
            }
            this.FillPanelUsers(objectInstitution);
        }
Esempio n. 10
0
        public List <HelpClassLogs> GetAllByAdminInstitution(USER user)
        {
            DataClasses1DataContext pom       = new DataClasses1DataContext();
            INSTITUTION             queryInst = (
                from i in pom.INSTITUTIONs
                from u in pom.USERs
                from p in pom.PERMISSIONs
                where i.ID == p.ID_INST && p.ID_USER == u.ID && p.Usage == 1 && u.ID == user.ID
                select i).First <INSTITUTION>();
            IQueryable <LOG> queryable =
                from l in pom.LOGs
                join u in pom.USERs on l.Id_User equals user.ID
                join p in pom.PERMISSIONs on u.ID equals p.ID_USER
                join i in pom.INSTITUTIONs on p.ID_INST equals i.ID
                where p.Usage == 1 && i.ID == queryInst.ID
                select l;
            List <HelpClassLogs> list = new List <HelpClassLogs>();

            foreach (LOG current in queryable)
            {
                HelpClassLogs helpClassLogs = new HelpClassLogs();
                helpClassLogs.ID              = current.ID;
                helpClassLogs.idTable         = (long)current.Id_Table;
                helpClassLogs.TittleTable     = InteropDAL.TablesDictionary[current.Id_Table];
                helpClassLogs.idUser          = current.Id_User.ToString();
                helpClassLogs.objUser         = new UsersDAL().GetByID(current.Id_User);
                helpClassLogs.NameSurnameUser = helpClassLogs.objUser.Name + " " + helpClassLogs.objUser.Surname;
                helpClassLogs.idItem          = current.Id_Item;
                helpClassLogs.Date            = current.DateTime;
                helpClassLogs.ActiveType      = current.ActiveType;
                helpClassLogs.Old             = current.Old;
                helpClassLogs.New             = current.New;
                switch (helpClassLogs.ActiveType)
                {
                case 1:
                    helpClassLogs.ActiveTypeName = "insert";
                    break;

                case 2:
                    helpClassLogs.ActiveTypeName = "update";
                    break;

                case 3:
                    helpClassLogs.ActiveTypeName = "delete";
                    break;

                default:
                    helpClassLogs.ActiveTypeName = "unknown";
                    break;
                }
                list.Add(helpClassLogs);
            }
            return(list);
        }
Esempio n. 11
0
 public long Insert(string title, string desc, bool active, DateTime created)
 {
   DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
   INSTITUTION entity = new INSTITUTION();
   entity.Tittle = title;
   entity.Description = desc;
   entity.Active = active;
   entity.CreatedOn = created;
   classes1DataContext.INSTITUTIONs.InsertOnSubmit(entity);
   classes1DataContext.SubmitChanges();
   return entity.ID;
 }
Esempio n. 12
0
 public void Update(string title, string desc, bool? active, DateTime? created, long id)
 {
   DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
   INSTITUTION institution = Queryable.Single<INSTITUTION>((IQueryable<INSTITUTION>) classes1DataContext.INSTITUTIONs, (Expression<Func<INSTITUTION, bool>>) (p => p.ID == id));
   if (title != null)
     institution.Tittle = Convert.ToString(title);
   if (desc != null)
     institution.Description = Convert.ToString(desc);
   if (active.HasValue)
     institution.Active = Convert.ToBoolean((object) active);
   if (created.HasValue)
     institution.CreatedOn = Convert.ToDateTime((object) created);
   classes1DataContext.SubmitChanges();
 }
Esempio n. 13
0
        public long Insert(INSTITUTION inst, USER user, WEBSERVICE ws, int use, bool active, DateTime created)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
            PERMISSION entity = new PERMISSION();

            entity.ID_INST   = inst.ID;
            entity.ID_USER   = user.ID;
            entity.ID_WS     = ws.ID;
            entity.Usage     = use;
            entity.Active    = active;
            entity.CreatedOn = created;
            classes1DataContext.PERMISSIONs.InsertOnSubmit(entity);
            classes1DataContext.SubmitChanges();
            return(entity.ID);
        }
Esempio n. 14
0
        public List <WEBSERVICE> GetAllOtherWebServices(INSTITUTION inst)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
            List <WEBSERVICE>       allActiveDeleted    = this.GetAllActiveDeleted(true);
            List <WEBSERVICE>       list = new List <WEBSERVICE>();

            using (List <WEBSERVICE> .Enumerator enumerator = allActiveDeleted.GetEnumerator())
            {
                while (enumerator.MoveNext())
                {
                    WEBSERVICE c = enumerator.Current;
                    if (Queryable.Count <PERMISSION>(Queryable.Where <PERMISSION>((IQueryable <PERMISSION>)classes1DataContext.PERMISSIONs, (Expression <Func <PERMISSION, bool> >)(p => p.Active == true && p.INSTITUTION.ID == inst.ID && p.Usage == 1 && p.ID_WS == c.ID))) == 0)
                    {
                        list.Add(c);
                    }
                }
            }
            return(list);
        }
Esempio n. 15
0
        public List <HelpClassUsers> GetUsersPermissionsByInstitution(bool active, INSTITUTION inst)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
            List <HelpClassUsers>   list = new List <HelpClassUsers>();

            try
            {
                foreach (USER user in this.GetUsersByTypeActive(3, 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);
            }
        }
Esempio n. 16
0
        protected void InstitutionsGridView_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.ClearTxtBoxChange();
            int         row         = Convert.ToInt32(this.InstitutionsGridView.SelectedDataKey.Value);
            INSTITUTION institution = Enumerable.Single <INSTITUTION>((IEnumerable <INSTITUTION>) this.Application["ListInstitutions"], (Func <INSTITUTION, bool>)(p => p.ID == (long)row));

            this.Application["Institution"] = (object)institution;
            this.txtPName.Text        = institution.Tittle;
            this.txtPDescription.Text = institution.Description;
            if (institution.Active)
            {
                this.CheckBoxPTrue.Checked  = true;
                this.CheckBoxPFalse.Checked = false;
            }
            else
            {
                this.CheckBoxPFalse.Checked = true;
                this.CheckBoxPTrue.Checked  = false;
            }
            this.LinkButton3.Enabled    = true;
            this.PanelEditUser.CssClass = "content-box column-right";
            this.PanelNewUser.CssClass  = "content-box column-left closed-box";
        }
Esempio n. 17
0
        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);
            }
        }
Esempio n. 18
0
        public List <HelpClassLogs> GetAllByAdminInstitutionForDate(USER user, DateTime DateFrom, DateTime DateTo)
        {
            List <HelpClassLogs> result;

            try
            {
                DataClasses1DataContext pom = new DataClasses1DataContext();
                // USER u;
                INSTITUTION queryInst = (
                    from i in pom.INSTITUTIONs
                    from u in pom.USERs
                    from p in pom.PERMISSIONs
                    where i.ID == p.ID_INST && p.ID_USER == u.ID && p.Usage == 1 && u.ID == user.ID
                    select i).First <INSTITUTION>();
                IQueryable <USER> queryable = (
                    from u in pom.USERs
                    join p in pom.PERMISSIONs on u.ID equals p.ID_USER
                    join i in pom.INSTITUTIONs on p.ID_INST equals i.ID
                    where i.ID == queryInst.ID && u.Active == true && p.Active == true
                    select u).Distinct <USER>();
                List <HelpClassLogs> list = new List <HelpClassLogs>();
                foreach (USER u in queryable)
                {
                    IQueryable <LOG> queryable2 =
                        from l in pom.LOGs
                        where l.Id_User == u.ID && l.DateTime >= DateFrom && l.DateTime <= DateTo && u.Type != 1
                        select l;
                    foreach (LOG current in queryable2)
                    {
                        HelpClassLogs helpClassLogs  = new HelpClassLogs();
                        HelpClassLogs helpClassLogs2 = new HelpClassLogs();
                        helpClassLogs2.ID              = current.ID;
                        helpClassLogs2.idTable         = (long)current.Id_Table;
                        helpClassLogs2.TittleTable     = InteropDAL.TablesDictionary[current.Id_Table];
                        helpClassLogs2.idUser          = current.Id_User.ToString();
                        helpClassLogs2.objUser         = new UsersDAL().GetByID(current.Id_User);
                        helpClassLogs2.NameSurnameUser = helpClassLogs2.objUser.Name + " " + helpClassLogs2.objUser.Surname;
                        helpClassLogs2.idItem          = current.Id_Item;
                        helpClassLogs2.Date            = current.DateTime;
                        helpClassLogs2.ActiveType      = current.ActiveType;
                        helpClassLogs2.Old             = current.Old;
                        helpClassLogs2.New             = current.New;
                        switch (helpClassLogs2.ActiveType)
                        {
                        case 1:
                            helpClassLogs2.ActiveTypeName = "insert";
                            break;

                        case 2:
                            helpClassLogs2.ActiveTypeName = "update";
                            break;

                        case 3:
                            helpClassLogs2.ActiveTypeName = "delete";
                            break;

                        default:
                            helpClassLogs2.ActiveTypeName = "unknown";
                            break;
                        }
                        list.Add(helpClassLogs2);
                    }
                }
                result = list;
            }
            catch (Exception var_8_CB1)
            {
                result = null;
            }
            return(result);
        }
Esempio n. 19
0
        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);
        }