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(); }