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