private void FillTempTable() { DataView UnselectedContactAttributeTableDV; DataRow TheNewRow; Int16 RowCounter; FGridTable.Rows.Clear(); FGridTable.AcceptChanges(); UnselectedContactAttributeTableDV = FContactAttributeDetailTableDV; // first add Contact Attributes which are already selected for partner for (RowCounter = 0; RowCounter < FSelectedContactAttributeTableDV.Count; RowCounter++) { TheNewRow = FGridTable.NewRow(); TheNewRow["Checked"] = (System.Object)true; TheNewRow["AttributeCode"] = FSelectedContactAttributeTableDV[RowCounter][PPartnerContactAttributeTable.GetContactAttributeCodeDBName()]; TheNewRow["AttributeDescription"] = ContactAttributesLogic.GetContactAttributeDesciption( FSelectedContactAttributeTableDV[RowCounter][PPartnerContactAttributeTable.GetContactAttributeCodeDBName()].ToString(), FContactAttributeTableDV); TheNewRow["AttributeDetailCode"] = FSelectedContactAttributeTableDV[RowCounter][PPartnerContactAttributeTable.GetContactAttrDetailCodeDBName()]; TheNewRow["AttributeDetailDescription"] = ContactAttributesLogic.GetContactAttributeDetailDesciption( FSelectedContactAttributeTableDV[RowCounter][PPartnerContactAttributeTable.GetContactAttributeCodeDBName()].ToString(), FSelectedContactAttributeTableDV[RowCounter][PPartnerContactAttributeTable.GetContactAttrDetailCodeDBName()].ToString(), FContactAttributeDetailTableDV); FGridTable.Rows.Add(TheNewRow); } // second add the rest of the Special Types in db for (RowCounter = 0; RowCounter < UnselectedContactAttributeTableDV.Count; RowCounter++) { // only add row if it has not already been added as a checked row if (FSelectedContactAttributeTableDV.Find(new object[] { UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttributeCodeDBName()], UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttrDetailCodeDBName()] }) == -1) { TheNewRow = FGridTable.NewRow(); TheNewRow["Checked"] = (System.Object)false; TheNewRow["AttributeCode"] = UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttributeCodeDBName()]; TheNewRow["AttributeDescription"] = ContactAttributesLogic.GetContactAttributeDesciption( UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttributeCodeDBName()].ToString(), FContactAttributeTableDV); TheNewRow["AttributeDetailCode"] = UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttrDetailCodeDBName()]; TheNewRow["AttributeDetailDescription"] = ContactAttributesLogic.GetContactAttributeDetailDesciption( UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttributeCodeDBName()].ToString(), UnselectedContactAttributeTableDV[RowCounter][PContactAttributeDetailTable.GetContactAttrDetailCodeDBName()].ToString(), FContactAttributeDetailTableDV); FGridTable.Rows.Add(TheNewRow); } } }
/// <summary> /// Setups the contact attributes grid (used on the following screens: Contact Log tab, Contacts with Partners and Extract by Contact Log. /// </summary> /// <param name="AGrid">Grid to be set up</param> /// <param name="AAttributes">Attributes to be included in the grid</param> /// <param name="AIncludeDescription">Include columns that display the attribute descriptions</param> /// <param name="AContactLogIDFilter">Filter grid to only show rows for given contact log if</param> public static DataView SetupContactAttributesGrid(ref TSgrdDataGridPaged AGrid, DataTable AAttributes, bool AIncludeDescription, Int64 AContactLogIDFilter = -1) { DataView ContactAttributeTableDV = TDataCache.TMPartner.GetCacheableMailingTable(TCacheableMailingTablesEnum.ContactAttributeList).DefaultView; ContactAttributeTableDV.Sort = PContactAttributeTable.GetContactAttributeCodeDBName() + " ASC"; DataView ContactAttributeDetailTableDV = TDataCache.TMPartner.GetCacheableMailingTable(TCacheableMailingTablesEnum.ContactAttributeDetailList).DefaultView; ContactAttributeDetailTableDV.Sort = PContactAttributeDetailTable.GetContactAttributeCodeDBName() + " ASC, " + PContactAttributeDetailTable.GetContactAttrDetailCodeDBName() + " ASC"; DataTable DT = new PPartnerContactAttributeTable(); if ((AAttributes != null) && (AAttributes.Rows.Count > 0)) { DT = AAttributes.Copy(); } if (AIncludeDescription) { DT.Columns.Add("AttributeDescription", System.Type.GetType("System.String")); DT.Columns.Add("AttributeDetailDescription", System.Type.GetType("System.String")); // add descriptions to new table foreach (DataRow Row in DT.Rows) { if (Row.RowState != DataRowState.Deleted) { Row["AttributeDescription"] = GetContactAttributeDesciption( Row[PPartnerContactAttributeTable.GetContactAttributeCodeDBName()].ToString(), ContactAttributeTableDV); Row["AttributeDetailDescription"] = GetContactAttributeDetailDesciption( Row[PPartnerContactAttributeTable.GetContactAttributeCodeDBName()].ToString(), Row[PPartnerContactAttributeTable.GetContactAttrDetailCodeDBName()].ToString(), ContactAttributeDetailTableDV); } } } AGrid.Columns.Clear(); AGrid.AddTextColumn("Attribute Code", DT.Columns[PPartnerContactAttributeTable.GetContactAttributeCodeDBName()]); if (AIncludeDescription) { AGrid.AddTextColumn("Description", DT.Columns["AttributeDescription"]); } AGrid.AddTextColumn("Detail Code", DT.Columns[PPartnerContactAttributeTable.GetContactAttrDetailCodeDBName()]); if (AIncludeDescription) { AGrid.AddTextColumn("Description", DT.Columns["AttributeDetailDescription"]); } DataView GridTableDV = DT.DefaultView; GridTableDV.AllowNew = false; GridTableDV.AllowEdit = false; GridTableDV.AllowDelete = false; if (AContactLogIDFilter != -1) { GridTableDV.RowFilter = PPartnerContactAttributeTable.GetContactIdDBName() + " = " + AContactLogIDFilter; } // DataBind the DataGrid AGrid.DataSource = new DevAge.ComponentModel.BoundDataView(GridTableDV); AGrid.AutoResizeGrid(); return(GridTableDV); }
private Boolean PerformContactAttributeAddOrRemoval(DataRow AChangingRow, out Boolean AIsRemoval) { Boolean ReturnValue = false; AIsRemoval = false; try { String AttributeCode = AChangingRow["AttributeCode"].ToString(); String AttributeDetailCode = AChangingRow["AttributeDetailCode"].ToString(); DataRow ExistingDataRow = FSelectedContactAttributeTable.Rows.Find(new object[] { FContactID, AttributeCode, AttributeDetailCode }); if (ExistingDataRow == null) { /* * Add Contact Attribute */ DataRow DeletedRow = null; // check that this contact attribute hasn't previously been deleted foreach (DataRow Row in FSelectedContactAttributeTable.Rows) { if ((Row.RowState == DataRowState.Deleted) && (Convert.ToInt64(Row[PPartnerContactAttributeTable.GetContactIdDBName(), DataRowVersion.Original]) == FContactID) && (Row[PPartnerContactAttributeTable.GetContactAttributeCodeDBName(), DataRowVersion.Original].ToString() == AttributeCode) && (Row[PPartnerContactAttributeTable.GetContactAttrDetailCodeDBName(), DataRowVersion.Original].ToString() == AttributeDetailCode)) { DeletedRow = Row; } } if (DeletedRow != null) { // undelete the previously deleted row DeletedRow.RejectChanges(); } else { // Check: is this Contact Attribute assignable PContactAttributeRow ContactAttribute = (PContactAttributeRow)FContactAttributeTableDV.Table.Rows.Find(new Object[] { AttributeCode }); PContactAttributeDetailRow ContactAttributeDetail = (PContactAttributeDetailRow)FContactAttributeDetailTableDV.Table.Rows.Find(new Object[] { AttributeCode, AttributeDetailCode }); // -1 means this is being used in a find screen and we can select inactive attributes if ((FContactID != -1) && (!ContactAttribute.Active || !ContactAttributeDetail.Active)) { MessageBox.Show( string.Format(Catalog.GetString("This Contact Attribute is inactive and cannot be added to this Contact Log."), AttributeCode), Catalog.GetString("Inactive Contact Attribute"), MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } // add new row to PartnerType table PPartnerContactAttributeRow TheNewRow = FSelectedContactAttributeTable.NewRowTyped(); TheNewRow.ContactId = FContactID; TheNewRow.ContactAttributeCode = AttributeCode; TheNewRow.ContactAttrDetailCode = AttributeDetailCode; FSelectedContactAttributeTable.Rows.Add(TheNewRow); } ReturnValue = true; AIsRemoval = false; } else { /* * Remove Special Type */ // Delete row if (ExistingDataRow.RowState == DataRowState.Added) { FAddedAttributeDeleted = true; } ExistingDataRow.Delete(); ReturnValue = true; AIsRemoval = true; } } catch (Exception E) { MessageBox.Show(E.ToString()); ReturnValue = false; } return(ReturnValue); }