private int GetChangedRecordCountManual(out string AMessage)
{
// For GL Batch we will get some mix of batches, journals and transactions
// Only check relevant tables.
List <string> TablesToCheck = new List <string>();
TablesToCheck.Add(FMainDS.ABatch.TableName);
TablesToCheck.Add(FMainDS.AJournal.TableName);
TablesToCheck.Add(FMainDS.ATransaction.TableName);
TablesToCheck.Add(FMainDS.ATransAnalAttrib.TableName);
List <Tuple <string, int> > TableAndCountList = new List <Tuple <string, int> >();
int AllChangesCount = 0;
if (FMainDS.HasChanges())
{
// Work out how many changes in each table
foreach (DataTable dt in FMainDS.GetChanges().Tables)
{
string currentTableName = dt.TableName;
if ((dt != null) &&
TablesToCheck.Contains(currentTableName) &&
(dt.Rows.Count > 0))
{
int tableChangesCount = 0;
DataTable dtChanges = dt.GetChanges();
foreach (DataRow dr in dtChanges.Rows)
{
if (DataUtilities.DataRowColumnsHaveChanged(dr))
{
tableChangesCount++;
AllChangesCount++;
}
}
if (tableChangesCount > 0)
{
TableAndCountList.Add(new Tuple <string, int>(currentTableName, tableChangesCount));
}
}
}
}
// Now build up a sensible message
AMessage = String.Empty;
if (TableAndCountList.Count > 0)
{
int nBatches = 0;
int nJournals = 0;
int nTransactions = 0;
foreach (Tuple <string, int> TableAndCount in TableAndCountList)
{
if (TableAndCount.Item1.Equals(ABatchTable.GetTableName()))
{
nBatches = TableAndCount.Item2;
}
else if (TableAndCount.Item1.Equals(AJournalTable.GetTableName()))
{
nJournals = TableAndCount.Item2;
}
else if (TableAndCount.Item2 > nTransactions)
{
nTransactions = TableAndCount.Item2;
}
}
AMessage = Catalog.GetString(" You have made changes to ");
string strBatches = String.Empty;
string strJournals = String.Empty;
string strTransactions = String.Empty;
if (nBatches > 0)
{
strBatches = String.Format("{0} {1}",
nBatches,
Catalog.GetPluralString("batch", "batches", nBatches));
}
if (nJournals > 0)
{
strJournals = String.Format("{0} {1}",
nJournals,
Catalog.GetPluralString("journal", "journals", nJournals));
}
if (nTransactions > 0)
{
strTransactions = String.Format("{0} {1}",
nTransactions,
Catalog.GetPluralString("transaction", "transactions", nTransactions));
}
bool bGotAll = (nBatches > 0) && (nJournals > 0) && (nTransactions > 0);
if (nBatches > 0)
{
AMessage += strBatches;
}
if (nJournals > 0)
{
if (bGotAll)
{
AMessage += ", ";
}
else if (nBatches > 0)
{
AMessage += " and ";
}
AMessage += strJournals;
}
if (nTransactions > 0)
{
if ((nBatches > 0) || (nJournals > 0))
{
AMessage += " and ";
}
AMessage += strTransactions;
}
AMessage += Environment.NewLine + Catalog.GetString("(some of the changes may include related background items)");
AMessage += Environment.NewLine;
AMessage += String.Format(TFrmPetraEditUtils.StrConsequenceIfNotSaved, Environment.NewLine);
}
return(AllChangesCount);
}
private int GetChangedRecordCountManual(out string AMessage)
{
// For GL Batch we will get some mix of batches, journals and transactions
List <Tuple <string, int> > TableAndCountList = new List <Tuple <string, int> >();
int allChangesCount = 0;
// Work out how many changes in each table
foreach (DataTable dt in FMainDS.Tables)
{
if (dt != null)
{
int tableChangesCount = 0;
foreach (DataRow dr in dt.Rows)
{
if (dr.RowState != DataRowState.Unchanged)
{
tableChangesCount++;
allChangesCount++;
}
}
if (tableChangesCount > 0)
{
TableAndCountList.Add(new Tuple <string, int>(dt.TableName, tableChangesCount));
}
}
}
// Now build up a sensible message
AMessage = String.Empty;
if (TableAndCountList.Count > 0)
{
int nBatches = 0;
int nJournals = 0;
int nTransactions = 0;
foreach (Tuple <string, int> TableAndCount in TableAndCountList)
{
if (TableAndCount.Item1.Equals(ABatchTable.GetTableName()))
{
nBatches = TableAndCount.Item2;
}
else if (TableAndCount.Item1.Equals(AJournalTable.GetTableName()))
{
nJournals = TableAndCount.Item2;
}
else if (TableAndCount.Item2 > nTransactions)
{
nTransactions = TableAndCount.Item2;
}
}
AMessage = Catalog.GetString(" You have made changes to ");
string strBatches = String.Empty;
string strJournals = String.Empty;
string strTransactions = String.Empty;
if (nBatches > 0)
{
strBatches = String.Format("{0} {1}",
nBatches,
Catalog.GetPluralString("batch", "batches", nBatches));
}
if (nJournals > 0)
{
strJournals = String.Format("{0} {1}",
nJournals,
Catalog.GetPluralString("journal", "journals", nJournals));
}
if (nTransactions > 0)
{
strTransactions = String.Format("{0} {1}",
nTransactions,
Catalog.GetPluralString("transaction", "transactions", nTransactions));
}
bool bGotAll = (nBatches > 0) && (nJournals > 0) && (nTransactions > 0);
if (nBatches > 0)
{
AMessage += strBatches;
}
if (nJournals > 0)
{
if (bGotAll)
{
AMessage += ", ";
}
else if (nBatches > 0)
{
AMessage += " and ";
}
AMessage += strJournals;
}
if (nTransactions > 0)
{
if ((nBatches > 0) || (nJournals > 0))
{
AMessage += " and ";
}
AMessage += strTransactions;
}
AMessage += Environment.NewLine;
AMessage += String.Format(TFrmPetraEditUtils.StrConsequenceIfNotSaved, Environment.NewLine);
}
return(allChangesCount);
}