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