public void LoadCoverage()
{
// create and execute query
t = new DataTable();
t.Columns.Add("id");
t.Columns.Add("Provider");
t.Columns.Add("%");
t.Columns.Add("Amount");
t.Columns.Add(new DataColumn("Delete", typeof(Image)));
Image delete = new Bitmap(Properties.Resources.Cancel_16);
foreach (ItemCoverage j in GenericCollection.itemCoverage)
{
try
{
string coverage = "";
coverage = Coverage.Select(j.CoverageID).Name;
t.Rows.Add(new object[] { j.Id, coverage, j.Percentage, j.Amount, delete });
}
catch (Exception m)
{
MessageBox.Show("" + m.Message);
Helper.Exceptions(m.Message, "Viewing Coverage {each coverage item in the coverage list }" + j.ItemID);
}
}
VariableTotal = Convert.ToDouble(amountTxt.Text) - GenericCollection.itemCoverage.Sum(r => r.Amount);
TotalCoverage = GenericCollection.itemCoverage.Sum(r => r.Amount);
TotalSelf = Convert.ToDouble(amountTxt.Text) - TotalCoverage;
selfTxt.Text = TotalSelf.ToString();
dtGrid.DataSource = t;
dtGrid.AllowUserToAddRows = false;
// dtGrid.Columns["View"].DefaultCellStyle.BackColor = Color.LightGreen;
// dtGrid.Columns["Delete"].DefaultCellStyle.BackColor = Color.Red;
dtGrid.Columns["id"].Visible = false;
}
