static public Spending FinfSpending(int id)
{
Spending find = new Spending();
for (int i = 0; i < spendingList.Count; i++)
{
if (spendingList[i].ID == id)
{
Console.WriteLine(spendingList[i].Value + " расход ");
Console.WriteLine(spendingList[i].Quantity + " количество ");
return(spendingList[i]);
}
}
return(find);
}
private async void MainForm_Load(object sender, EventArgs e)
{
DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
dtpBegin.Value = date;
dtpEnd.Value = date;
label4.Text = "";
try
{
sqlConnection = new SqlConnection(Properties.Settings.Default.conString);
await sqlConnection.OpenAsync();//открываем соединение с базой данных
}
catch (Exception ezp)
{
MessageBox.Show(ezp.Message);
}
SqlDataReader sqlReader = null;
SqlCommand command = new SqlCommand("SELECT * FROM [Category]", sqlConnection);
try {
sqlReader = await command.ExecuteReaderAsync();
while (await sqlReader.ReadAsync())
{
string toAdd = Convert.ToString(sqlReader["Name"]).Trim();
// Financier.Categories.Add(Convert.ToString(sqlReader["Name"]));
Financier.Categories.Add(toAdd);
MessageBox.Show(Convert.ToString(sqlReader["Name"]));
}
sqlReader.Close();
sqlReader = null;
command = new SqlCommand("SELECT * FROM [Spending]", sqlConnection);
sqlReader = await command.ExecuteReaderAsync();
while (await sqlReader.ReadAsync())
{
Spending newSpending = new Spending();
newSpending.SetId(Convert.ToInt32(sqlReader["id"]));
newSpending.Value = Convert.ToString(sqlReader["Name"]).Trim();
newSpending.Summ = float.Parse(Convert.ToString(sqlReader["Summ"]));
newSpending.Quantity = float.Parse(Convert.ToString(sqlReader["Quantity"]));
newSpending.SetCategory(Convert.ToString(sqlReader["Category"]).Trim());
newSpending.Date = Convert.ToDateTime(sqlReader["Date"]);
Financier.spendingList.Add(newSpending);
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
}
FillSpendingTable();
FillComboBoxItem();
FillCategoryTable();
}
