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