public static List <TruckDriverDetails> GetAllTruckDriverDetails()
{
List <TruckDriverDetails> clist = new List <TruckDriverDetails>();
IDbConnection conn = new MySqlConnection();
conn.ConnectionString = connectionString;
string qery = "select * from truck_driver_details";
IDbCommand cmd = new MySqlCommand();
cmd.CommandText = qery;
cmd.Connection = conn;
MySqlDataAdapter ad = new MySqlDataAdapter(cmd as MySqlCommand);
DataSet ds = new DataSet();
try
{
ad.Fill(ds);
DataRowCollection rows = ds.Tables[0].Rows;
foreach (DataRow row in rows)
{
TruckDriverDetails thetruckdriverdetails = new TruckDriverDetails();
thetruckdriverdetails.truckId = int.Parse(row["truck_id"].ToString());
thetruckdriverdetails.truckDriverName = row["truck_driver_name"].ToString();
thetruckdriverdetails.DriverContactNumber = long.Parse(row["driver_contact_number"].ToString());
thetruckdriverdetails.truckRegnoNumber = row["truck_reg_num"].ToString();
clist.Add(thetruckdriverdetails);
}
}
catch (MySqlException e)
{
string message = e.Message;
}
return(clist);
}
public static void UpdateTruckDriverDetails(TruckDriverDetails exitsTruckDriverDetails)
{
TruckDriverDBmanager.UpdateTruckDriverDetails(exitsTruckDriverDetails.DriverContactNumber, exitsTruckDriverDetails.truckId);
}
