public BindableCollection <ReceiptsAndExpenses> Get_AllReceName(string ID)
{
ListReceName.Clear();
sql = $"SELECT * FROM THUCHI WHERE MACD={ID} ";
DataTable dt = Connection.GetALL_Data(sql);
foreach (DataRow row in dt.Rows)
{
ReceiptsAndExpenses RAE = new ReceiptsAndExpenses();
RAE.TripID = row["MACD"].ToString();
RAE.ExpensesName = row["TENKHOANCHI"].ToString();
string cost = row["TIEN"].ToString();
RAE.Cost = 0;
if (cost != "")
{
RAE.Cost = Double.Parse(cost, System.Globalization.NumberStyles.Any);
}
ListReceName.Add(RAE);
}
return(ListReceName);
}
public BindableCollection <ReceiptsAndExpenses> Get_AllReceAndExpenTrip(string ID)
{
ListReceAndExpen.Clear();
sql = $"SELECT TV.MACD,TV.MATV,TV.HOTEN,TV.SDT,TC.TENKHOANCHI,TC.TIEN FROM THANHVIEN AS TV LEFT JOIN THUCHI AS TC ON TV.MATV=TC.MATV AND TV.MACD = TC.MACD WHERE TV.MACD={ID} ";
DataTable dt = Connection.GetALL_Data(sql);
foreach (DataRow row in dt.Rows)
{
ReceiptsAndExpenses RAE = new ReceiptsAndExpenses();
RAE.TripID = row["MACD"].ToString();
RAE.MemberID = row["MATV"].ToString();
RAE.MemberName = row["HOTEN"].ToString();
RAE.Telephone = row["SDT"].ToString();
RAE.ExpensesName = row["TENKHOANCHI"].ToString();
string cost = row["TIEN"].ToString();
RAE.Cost = 0;
if (cost != "")
{
RAE.Cost = Double.Parse(cost, System.Globalization.NumberStyles.Any);
}
ListReceAndExpen.Add(RAE);
}
return(ListReceAndExpen);
}
