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);
}
}
}
private void InitializeManualCode()
{
this.AcceptButton = btnOK;
FContactAttributeTableDV =
TDataCache.TMPartner.GetCacheableMailingTable(TCacheableMailingTablesEnum.ContactAttributeList).DefaultView;
FContactAttributeTableDV.Sort = PContactAttributeTable.GetContactAttributeCodeDBName() + " ASC";
FContactAttributeDetailTableDV =
TDataCache.TMPartner.GetCacheableMailingTable(TCacheableMailingTablesEnum.ContactAttributeDetailList).DefaultView;
FContactAttributeDetailTableDV.Sort = PContactAttributeDetailTable.GetContactAttributeCodeDBName() + " ASC, " +
PContactAttributeDetailTable.GetContactAttrDetailCodeDBName() + " ASC";
CreateTempTable();
grdContactAttributes.MouseClick += new MouseEventHandler(this.GrdContactAttributes_Click);
grdContactAttributes.SpaceKeyPressed += new TKeyPressedEventHandler(this.GrdContactAttributes_SpaceKeyPressed);
grdContactAttributes.EnterKeyPressed += new TKeyPressedEventHandler(this.GrdContactAttributes_EnterKeyPressed);
}
/// <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);
}
/// <summary>
/// Performs checks to determine whether a deletion of the current row is permissable
/// </summary>
/// <param name="ARowToDelete">the currently selected row to be deleted</param>
/// <param name="ADeletionQuestion">can be changed to a context-sensitive deletion confirmation question</param>
/// <returns>true if user is permitted and able to delete the current row</returns>
private bool PreDeleteManual(PContactAttributeDetailRow ARowToDelete, ref string ADeletionQuestion)
{
// If the last Row in the Grid is to be deleted: check if there are added 'Detail' Rows in *other* 'Master' Rows,
// and if any of those 'Master' Rows was added too, tell the user that data needs to be saved first before deletion
// of the present 'Detail' Row can go ahead.
// The reason for that is that the deletion of that last 'Detail' Row will cause the OnNoMoreDetailRecords Event to
// be raised by the UserControl, which in turn will cause the Form to call the 'SaveChanges' Method of the
// UserControl before the Form saves its own data. While this in itself is OK, saving in the 'SaveChanges' Method
// of the UserControl would fail as a 'Master' Row itself was newly added AND it wouldn't be in the DB yet!
return(TDeleteGridRows.MasterDetailFormsSpecialPreDeleteCheck(this.Count,
FContactAttributeDT, FMainDS.PContactAttributeDetail,
PContactAttributeTable.GetContactAttributeCodeDBName(), PContactAttributeDetailTable.GetContactAttrDetailCodeDBName()));
}
