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));
}
private void doneButtonClick()
{
if (TripName == null)
{
MessageBox.Show("Tên chuyến đi rỗng!!!");
}
else if (ImageSource == null)
{
MessageBox.Show("Image is empty", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
List <MemberInTripModel> tempMember = new List <MemberInTripModel>();
List <PlaceModel> tempPlace = new List <PlaceModel>();
List <ExpenseModel> tempExpenses = new List <ExpenseModel>();
for (int i = 0; i < MemberList.Count(); i++)
{
tempMember.Add(MemberList[i]);
}
for (int i = 0; i < PlaceList.Count(); i++)
{
tempPlace.Add(PlaceList[i]);
}
for (int i = 0; i < ExpensesList.Count(); i++)
{
tempExpenses.Add(ExpensesList[i]);
}
TripModel newTrip = DatabaseAccess.AddNewTrip(TripName, tempMember, tempExpenses, tempPlace);
//Thêm hình
if (ImageSource == null)
{
ImageSource = "";
}
var directory = AppDomain.CurrentDomain.BaseDirectory;
var locationDirectory = AppDomain.CurrentDomain.BaseDirectory;
directory += "Data\\Images\\TripsImage\\" + newTrip.ID + "\\Main";
locationDirectory += "Data\\Images\\TripsImage\\" + newTrip.ID + "\\Location";
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
if (!Directory.Exists(locationDirectory))
{
Directory.CreateDirectory(locationDirectory);
}
string fileName = "main.png";
string sourcePath = ImageSource;
string targetPath = directory;
//Combine file và đường dẫn
string sourceFile = System.IO.Path.Combine(sourcePath, "");
string destFile = System.IO.Path.Combine(targetPath, fileName);
//Copy file từ file nguồn đến file đích
System.IO.File.Copy(sourceFile, destFile, true);
MessageBox.Show("Thêm chuyến đi mới thành công!!!");
ICommand BackToHomePage = new UpdateMainViewCommand(MainViewModel);
BackToHomePage.Execute((object)"HomePage");
}
}
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);
}
