public List <Date> Read()
{
string command = "Select * from Date";
var db = new DataAccess.DataBaseManager();
var result = db.GetData(command);
var karbarList = new Karbar().Read();
var booktyoelist = new BookType().Read();
List <Date> lstResult = new List <Date>();
foreach (DataRow r in result.Rows)
{
Date date = new Date();
date.ID = Convert.ToInt32(r["ID"]);
date.EntranceDate = Convert.ToDateTime(r["EntranceDate"]);
Date daate = new Date();
daate.ID = Convert.ToInt32(r["ID"]);
daate.EntranceDate = Convert.ToDateTime(r["bargasht"]);
//User
Karbar karbar = new Karbar();
var karbarID = Convert.ToInt64(r["KarbarId"]);
date.Karbar = karbarList.FirstOrDefault(a => a.ID == karbarID);
//CarType
BookType bookType = new BookType();
var BookTypeID = Convert.ToInt64(r[" BookTypeID"]);
date.BookType = booktyoelist.FirstOrDefault(a => a.ID == BookTypeID);
lstResult.Add(date);
}
return(lstResult);
}
public List <BookType> Read()
{
string command = "Select * from BookType";
var db = new DataAccess.DataBaseManager();
var result = db.GetData(command);
List <BookType> lstResult = new List <BookType>();
foreach (DataRow r in result.Rows)
{
BookType book = new BookType();
book.ID = Convert.ToInt32(r["ID"]);
book.BookName = r["BookName"].ToString();
lstResult.Add(book);
}
return(lstResult);
}