public List <ExeEnt> GetAll()
{
var exeEnt = new List <ExeEnt>();
var sql = "select * from CarList";
var dt = DataAccess.GetDataTable(sql);
for (int index = 0; index < dt.Rows.Count; index++)
{
ExeEnt k = ConvertToEntity(dt.Rows[index]);
exeEnt.Add(k);
}
return(exeEnt);
}
public ExeEnt ConvertToEntity(DataRow row)
{
if (row == null)
{
return(null);
}
var k = new ExeEnt();
k.id = Convert.ToInt32(row["id"].ToString());
k.CarSeatNumber = row["CarSeatNumber"].ToString();
k.CarNumber = row["CarNumber"].ToString();
k.CarStatus = row["CarStatus"].ToString();
k.DriverName = row["DriverName"].ToString();
return(k);
}
