public static ObservableCollection <Author> GetAuthorsForBook(int bookid)
{
ObservableCollection <Author> result = null;
try
{
var reader = DataConnector.ExecuteQuery("select tg.MaTacGia, tg.TenTacGia from TacGia tg, ChiTietTacGiaSach ct where tg.MaTacGia = ct.MaTacGia and ct.MaSach = " + bookid);
if (reader != null)
{
result = new ObservableCollection <Author>();
while (reader.Read())
{
var item = new Author(reader.GetInt32(0));
item.BeginInit();
item.Name = (string)reader.GetValueDefault(1, null);
item.EndInit();
result.Add(item);
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}
public static ObservableCollection <Author> GetAll()
{
ObservableCollection <Author> result = null;
try
{
var reader = DataConnector.ExecuteQuery("select MaTacGia,TenTacGia from TacGia");
if (reader != null)
{
result = new ObservableCollection <Author>();
while (reader.Read())
{
var item = new Author(reader.GetInt32(0));
item.BeginInit();
item.Name = (string)reader.GetValueDefault(1, null);
item.EndInit();
result.Add(item);
}
}
}
catch (Exception ex)
{
ErrorManager.Current.DataCantBeRead.Call(ex.Message);
}
return(result);
}