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