public static void DeleteAllCorporateRates()
{
if (FCorporateDS.ACorporateRateTable == null)
{
// we did not create one yet
return;
}
DataView dv = new DataView(FCorporateDS.ACorporateRateTable, null, null, DataViewRowState.CurrentRows);
for (int i = dv.Count - 1; i >= 0; i--)
{
// exists already
DataRowView row = dv[i];
row.Delete();
}
FCorporateDS.SaveChanges();
}
public static void CreateCorporateRate(string FromCurrencyCode, string ToCurrencyCode, DateTime EffectiveDate, decimal RateOfExchange)
{
FCorporateDS.LoadAll();
if (FCorporateDS.ACorporateRateTable.Rows.Find(new object[] { FromCurrencyCode, ToCurrencyCode, EffectiveDate }) != null)
{
// exists already
return;
}
ACorporateExchangeRateRow newRow = FCorporateDS.ACorporateRateTable.NewRowTyped(true);
newRow.FromCurrencyCode = FromCurrencyCode;
newRow.ToCurrencyCode = ToCurrencyCode;
newRow.TimeEffectiveFrom = 0;
newRow.DateEffectiveFrom = EffectiveDate;
newRow.RateOfExchange = RateOfExchange;
FCorporateDS.ACorporateRateTable.Rows.Add(newRow);
FCorporateDS.SaveChanges();
}
