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