Exemplo n.º 1
0
        private void SaveData(string Priori9SecurityGroupID, string i9PriorAgencyID)
        {
            DataView lPrioriSecurityGroupPersonnelDV = new DataView(m_PageDataSet.Tables["i9SecurityGroupPersonnel"]);

            lPrioriSecurityGroupPersonnelDV.RowFilter = " i9SecurityGroupID = '" + Priori9SecurityGroupID + "' AND i9AgencyID = '" + i9PriorAgencyID + "' ";

            //Loop Through the i9SysPersonnel Table
            foreach (DataRowView SysPersonnelDRV in m_i9SysPersonnelDV)
            {
                bool Found = false;

                //Loop through the i9SecurityGroupPersonnel table checking for the i9syspersonnelid
                foreach (DataRowView SecGrpModuleDRV in lPrioriSecurityGroupPersonnelDV)
                {
                    if (SysPersonnelDRV["i9SysPersonnelID"].ToString().ToUpper().Trim() == SecGrpModuleDRV["i9SysPersonnelID"].ToString().ToUpper().Trim())
                    {
                        if (SysPersonnelDRV["Enabled"].ToString().ToUpper() == "TRUE")
                        {
                            //Do Nothing
                        }
                        else
                        {
                            SecGrpModuleDRV.Delete();
                        }
                        Found = true;
                        continue;
                    }
                }

                //If not found in the i9SecurityGroupPersonnel table then add it.
                if (Found == false)
                {
                    if (SysPersonnelDRV["Enabled"].ToString().ToUpper() == "TRUE")
                    {
                        DataRow NewRow = m_PageDataSet.Tables["i9SecurityGroupPersonnel"].NewRow();
                        NewRow["i9SecurityGroupPersonnelID"] = Guid.NewGuid();
                        NewRow["i9SecurityGroupID"]          = Priori9SecurityGroupID;
                        NewRow["i9AgencyID"]       = i9PriorAgencyID;
                        NewRow["i9SysPersonnelID"] = SysPersonnelDRV["i9SysPersonnelID"];
                        m_PageDataSet.Tables["i9SecurityGroupPersonnel"].Rows.Add(NewRow);
                    }
                }
            }
        }
Exemplo n.º 2
0
        private void SaveGroupModulesData(string PriorSecurityGroupName, string i9PriorAgencyID)
        {
            DataView lPrioriSecurityGroupModulesDV = new DataView(mSecurityDS.Tables["i9SecurityGroupModule"]);

            lPrioriSecurityGroupModulesDV.RowFilter = " SecurityGroupName = '" + PriorSecurityGroupName + "' AND i9AgencyID = '" + i9PriorAgencyID + "' ";

            //List<DataRowView> NewRowsList = new List<DataRowView>();
            foreach (DataRowView ModuleDRV in mi9ModuleDV)
            {
                bool Found = false;
                foreach (DataRowView SecGrpModuleDRV in lPrioriSecurityGroupModulesDV)
                {
                    if (ModuleDRV["ModuleName"].ToString().ToUpper().Trim() == SecGrpModuleDRV["ModuleName"].ToString().ToUpper().Trim())
                    {
                        if (ModuleDRV["Enabled"].ToString().ToUpper() == "TRUE")
                        {
                            //Do Nothing
                        }
                        else
                        {
                            SecGrpModuleDRV.Delete();
                        }
                        Found = true;
                    }
                }

                if (Found == false)
                {
                    if (ModuleDRV["Enabled"].ToString().ToUpper() == "TRUE")
                    {
                        DataRow NewRow = mSecurityDS.Tables["i9SecurityGroupModule"].NewRow();
                        NewRow["i9SecurityGroupModuleID"] = Guid.NewGuid();
                        NewRow["SecurityGroupName"]       = PriorSecurityGroupName;
                        NewRow["i9AgencyID"] = i9PriorAgencyID;
                        NewRow["ModuleName"] = ModuleDRV["ModuleName"];
                        mSecurityDS.Tables["i9SecurityGroupModule"].Rows.Add(NewRow);
                    }
                }
            }
        }