private void FormCoordinatorSponsors_Load(object sender, EventArgs e)
{
timerMarathon.Start();
try
{
int fullCost = 0;
connectionSql.Open();
dataAdapter = new SqlDataAdapter("SELECT Charity.CharityLogo, Charity.CharityName, SUM(Registration.SponsorshipTarget) as Amount FROM Charity, Registration WHERE Charity.CharityId = Registration.CharityId GROUP BY Charity.CharityName, Charity.CharityLogo", connectionSql);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
SponsorSort[] control = new SponsorSort[dataSet.Tables[0].Rows.Count];
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
control[i] = new SponsorSort();
control[i].Image = Bitmap.FromFile(@"C:\Users\Ренат\Desktop\Дистант 3 курс\2 семестр\УП 1\WSR 2017Программные решения для бизнеса\TP09_resources\WSR2016_TP09_общие_ресурсы\marathon-skills-2016-charity-data\marathon-skills-2016-charity-data\" + dataSet.Tables[0].Rows[i][0].ToString());
control[i].Organization = dataSet.Tables[0].Rows[i][1].ToString();
control[i].Amount = dataSet.Tables[0].Rows[i][2].ToString();
flowLayoutPanel.Controls.Add(control[i]);
fullCost += Convert.ToInt32(dataSet.Tables[0].Rows[i][2]);
}
organizationNummberLabel.Text = control.Count().ToString();
moneyNumberLabel.Text = "$" + fullCost;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
connectionSql.Close();
}
}
private void refreshButton_Click(object sender, EventArgs e)
{
string orderBy = "";
if (statusComboBox.SelectedIndex == 0)
{
orderBy = "CharityName";
}
else
{
orderBy = "Amount";
}
try
{
connectionSql.Open();
dataAdapter = new SqlDataAdapter($"SELECT Charity.CharityLogo, Charity.CharityName, SUM(Registration.SponsorshipTarget) as Amount FROM Charity, Registration WHERE Charity.CharityId = Registration.CharityId GROUP BY Charity.CharityName, Charity.CharityLogo order by {orderBy} desc", connectionSql);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
SponsorSort[] control = new SponsorSort[dataSet.Tables[0].Rows.Count];
flowLayoutPanel.Controls.Clear();
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
control[i] = new SponsorSort();
control[i].Image = Bitmap.FromFile(@"C:\Users\Ренат\Desktop\Дистант 3 курс\2 семестр\УП 1\WSR 2017Программные решения для бизнеса\TP09_resources\WSR2016_TP09_общие_ресурсы\marathon-skills-2016-charity-data\marathon-skills-2016-charity-data\" + dataSet.Tables[0].Rows[i][0].ToString());
control[i].Organization = dataSet.Tables[0].Rows[i][1].ToString();
control[i].Amount = dataSet.Tables[0].Rows[i][2].ToString();
flowLayoutPanel.Controls.Add(control[i]);
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
connectionSql.Close();
}
}