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