public Ratings()
{
InitializeComponent();
InitializeCustomComponents();
TableUtility tableUtility = new TableUtility();
tableUtility.CreateTable(Rating.GetDefaultValue());
tableUtility.CreateTable(RatingAgency.GetDefaultValue());
ratingAgenciesRowIndex = 0;
LoadRatingAgencies();
}
public void OnSubmit(List<string> passedValue, string reference)
{
TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook);
RatingAgency ratingAgency = new RatingAgency(passedValue[0]);
tableUtility.CreateMissingTable(RatingAgency.GetDefaultValue());
tableUtility.InsertTableRow(ratingAgency, new List<string>
{
passedValue[0]
});
ratingAgencyBindingSource.Add(ratingAgency);
}
private void LoadRatingAgencies()
{
TableUtility tableUtility = new TableUtility();
List <RatingAgency> agencyList = tableUtility.ConvertRangesToObjects <RatingAgency>(tableUtility.ReadAllRows(RatingAgency.GetDefaultValue()));
foreach (RatingAgency agency in agencyList)
{
FormUtility.GetBindingSource(dataGridViewRatingAgencies).Add(agency);
}
}
private void LoadRatingAgencies()
{
TableUtility tableUtility = new TableUtility(Globals.WatchdogAddIn.Application.ActiveWorkbook);
List<RatingAgency> agencyList = tableUtility.ConvertRangesToObjects<RatingAgency>(tableUtility.ReadAllRows(RatingAgency.GetDefaultValue().GetTableName()));
foreach (RatingAgency agency in agencyList)
{
ratingAgencyBindingSource.Add(agency);
}
}
