public Ratings()
{
InitializeComponent();
InitializeCustomComponents();
TableUtility tableUtility = new TableUtility();
tableUtility.CreateTable(Rating.GetDefaultValue());
tableUtility.CreateTable(RatingAgency.GetDefaultValue());
ratingAgenciesRowIndex = 0;
LoadRatingAgencies();
}
private void DataGridRatingAgenciesMouseDown(object sender, MouseEventArgs e)
{
DataGridView dataGridView = sender as DataGridView;
ratingAgenciesRowIndex = FormUtility.DataGridViewMouseDownContextMenu(dataGridView, e);
if (ratingAgenciesRowIndex < 0)
{
return;
}
currentRatingAgency = FormUtility.GetBindingSource(dataGridViewRatingAgencies)[ratingAgenciesRowIndex] as RatingAgency;
}
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);
}
public void OnSubmit(List <string> passedValue, string reference)
{
dataGridViewRatingAgencies.ClearSelection();
TableUtility tableUtility = new TableUtility();
RatingAgency ratingAgency = new RatingAgency(passedValue[0]);
tableUtility.InsertTableRow(ratingAgency);
int index = FormUtility.GetBindingSource(dataGridViewRatingAgencies).Add(ratingAgency);
dataGridViewRatingAgencies.Rows[index].Selected = true;
currentRatingAgency = ratingAgency;
ratingAgenciesRowIndex = index;
LoadRatings(ratingAgenciesRowIndex);
}
private void DeleteRatingAgencyClick(object sender, EventArgs e)
{
TableUtility tableUtility = new TableUtility();
RatingAgency ratingAgencyToDelete = dataGridViewRatingAgencies.Rows[ratingAgenciesRowIndex].DataBoundItem as RatingAgency;
List <Rating> ratingsToDelete = tableUtility.ConvertRangesToObjects <Rating>(tableUtility.ReadTableRow(Rating.GetDefaultValue(), new Dictionary <string, string>
{
{ "Agency", ratingAgencyToDelete.GetIndex().ToString() }
}, QueryOperator.OR));
foreach (Rating rating in ratingsToDelete)
{
tableUtility.DeleteTableRow(rating);
}
tableUtility.DeleteTableRow(ratingAgencyToDelete);
FormUtility.GetBindingSource(dataGridViewRatingAgencies).RemoveAt(ratingAgenciesRowIndex);
LoadRatings(ratingAgenciesRowIndex);
if (FormUtility.GetBindingSource(dataGridViewRatingAgencies).Count == 0)
{
currentRatingAgency = null;
}
}
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);
}
}
private void AgencySelected(object sender, DataGridViewCellStateChangedEventArgs e)
{
currentRatingAgency = dataGridViewRatingAgencies.Rows[e.Cell.RowIndex].DataBoundItem as RatingAgency;
}