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 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>")); } } }
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); }
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); }
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(); }
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"; }
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); }
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>")); } }
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); }
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); }
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; }
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(); }
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); }
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); }
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); } }
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"; }
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 <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); }
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); }