public static ObservableCollection <AddedBook> GetAllListAddedBook(int id)
{
ObservableCollection <AddedBook> result = null;
try
{
var reader = DataConnector.ExecuteQuery("select MaPhieuNhap,MaSach,SoLuong from ChiTietPhieuNhap where MaPhieuNhap = " + id);
if (reader != null)
{
result = new ObservableCollection <AddedBook>();
while (reader.Read())
{
var ID = reader.GetInt32(0);
var item = new AddedBook(ID);
item.BeginInit();
item.Book = BookAdapter.GetBook(reader.GetInt32(1));
item.Number = reader.GetInt32(2);
item.EndInit();
result.Add(item);
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}
public static ObservableCollection <BillItem> GetBillItems(int billid)
{
ObservableCollection <BillItem> result = null;
try
{
var reader = DataConnector.ExecuteQuery("select MaSach, SoLuong, DonGia from ChiTietHoaDon where MaHoaDon = " + billid);
if (reader != null)
{
result = new ObservableCollection <BillItem>();
while (reader.Read())
{
var item = new BillItem(BookAdapter.GetBook(reader.GetInt32(0)), reader.GetInt32(1), reader.GetInt32(2));
result.Add(item);
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}
public static ObservableCollection <BillItem> GetAllBeforeDate(DateTime date)
{
ObservableCollection <BillItem> result = null;
try
{
var reader = DataConnector.ExecuteQuery(string.Format("select ct.MaSach, ct.SoLuong, ct.DonGia from ChiTietHoaDon ct, HoaDon hd where ct.MaHoaDon = hd.MaHoaDon and DATEDIFF(day, '{0}', hd.NgayLap) <= 0", date));
if (reader != null)
{
result = new ObservableCollection <BillItem>();
while (reader.Read())
{
var item = new BillItem(BookAdapter.GetBook(reader.GetInt32(0)), reader.GetInt32(1), reader.GetInt32(2));
result.Add(item);
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}