public List <FleetTripNature> GetFleetTripNature() { var listReturn = new List <FleetTripNature>(); using (var con = new MySqlConnection(ConnectionHelper.BaseConnection())) { con.Open(); using (var cmd = new MySqlCommand("SELECT * FROM fleet_trip_nature", con)) using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { listReturn.Add(new FleetTripNature { id = int.Parse(dr["id"].ToString()), nature = dr["nature"].ToString() }); } dr.Close(); } con.Close(); } return(listReturn); }
public List <FleetDriver> GetFleetDrivers(string driverId) { var listReturn = new List <FleetDriver>(); using (var con = new MySqlConnection(ConnectionHelper.BaseConnection())) { con.Open(); using (var cmd = new MySqlCommand("SELECT * FROM driver WHERE driver_id=@driver_id", con)) { cmd.Parameters.AddWithValue("@driver_id", driverId); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { listReturn.Add(new FleetDriver { id = int.Parse(dr["id"].ToString()), driver_id = dr["driver_id"].ToString(), driver_name = dr["name"].ToString(), code = int.Parse(dr["code"].ToString()), mobile = dr["mobile"].ToString() }); } dr.Close(); } con.Close(); } } return(listReturn); }
public List <FleetCars> GetFleetCars(string id) { var listReturn = new List <FleetCars>(); using (var con = new MySqlConnection(ConnectionHelper.BaseConnection())) { con.Open(); using (var cmd = new MySqlCommand("SELECT * FROM fleet WHERE id=@id", con)) { cmd.Parameters.AddWithValue("@id", id); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { var deliverDate = dr["deliver"].ToString(); listReturn.Add(new FleetCars { id = int.Parse(dr["id"].ToString()), car = dr["car"].ToString(), code = int.Parse(dr["code"].ToString()), deliver = DateTimeHelper.ValidateDateTime(deliverDate), model = dr["model"].ToString(), owner = dr["owner"].ToString(), plate = dr["plate"].ToString(), rate_one = int.Parse(dr["rate_one"].ToString()), rate_two = int.Parse(dr["rate_two"].ToString()), remarks = dr["remarks"].ToString(), }); } dr.Close(); } } con.Close(); } return(listReturn); }