private void addExpensesButtonClick()
{
if (ExpensesNameData != null && ExpensesMoneyData != null && Helper.HelperFunctions.isNumericString(ExpensesMoneyData) == true)
{
ExpenseModel temp = new ExpenseModel();
temp.Name = ExpensesNameData;
if (ExpensesMoneyData != null)
{
temp.AmountMoney = Int32.Parse(ExpensesMoneyData);
}
else
{
temp.AmountMoney = 0;
}
ExpensesList.Add(temp);
}
else if (Helper.HelperFunctions.isNumericString(ExpensesMoneyData) == false)
{
MessageBox.Show("Số tiền chỉ nhận giá trị số");
}
else
{
MessageBox.Show("Vui lòng nhập đủ thông tin trước khi thêm!!!");
}
ExpensesNameData = null;
ExpensesMoneyData = null;
OnPropertyChanged(nameof(ExpensesList));
OnPropertyChanged(nameof(ExpensesMoneyData));
OnPropertyChanged(nameof(ExpensesNameData));
}
public static ExpensesList GetExpenses()
{
ExpensesList expensesList;
using (MySqlConnection conn = new MySqlConnection(connString))
{
string query = @"SELECT id_purchase, date_purchase, amount_purchase, category_purchase, info_purchase, notes_purchase, type_purchase
FROM purchase
ORDER BY id_purchase DESC;";
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
cmd.Connection = conn;
conn.Open();
expensesList = new ExpensesList();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int id;
DateTime date;
decimal amount;
string category;
string info;
string notes = null;
string type;
while (reader.Read())
{
id = (int)reader["id_purchase"];
date = (DateTime)reader["date_purchase"];
amount = (decimal)reader[2];
category = reader[3] as string;
info = reader[4] as string;
notes = reader.IsDBNull(5) ? null : reader[5] as string;
type = reader[6] as string;
expensesList.Add(new Expenses()
{
Id = id,
Date = date,
Amount = amount,
Category = category,
Information = info,
Notes = notes,
Type = type
});
}
}
}
}
return(expensesList);
}
