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