public void UpdateFirm(RegistryFirm registryFirm) { try { using (MySqlCommand dbComm = new MySqlCommand()) { dbComm.CommandType = CommandType.Text; dbComm.CommandText = SQL.RegistryScripts.UpdateFirm; dbComm.Parameters.AddWithValue("desc", registryFirm.desc_azienda); dbComm.Parameters.AddWithValue("id", registryFirm.id_azienda); dbComm.Connection = new MySqlConnection(DAFconnection.GetConnectionType()); dbComm.Connection.Open(); dbComm.ExecuteNonQuery(); dbComm.Connection.Close(); } } catch (MySqlException err) { throw new Exception(err.Message); } catch (Exception err) { throw new Exception(err.Message); } }
public RegistryFirmList GetRegistryFirmList() { try { using (MySqlDataAdapter dbAdaptar = new MySqlDataAdapter()) { dbAdaptar.SelectCommand = new MySqlCommand(); dbAdaptar.SelectCommand.Connection = new MySqlConnection(DAFconnection.GetConnectionType()); dbAdaptar.SelectCommand.CommandType = CommandType.Text; dbAdaptar.SelectCommand.CommandText = SQL.RegistryScripts.GetRegistryFirmList; DataTable dt = new DataTable(); dbAdaptar.Fill(dt); RegistryFirmList RFL = new RegistryFirmList(); foreach (DataRow dr in dt.Rows) { RegistryFirm RF = new RegistryFirm(); RF.id_azienda = dr.Field <uint>("id_azienda"); RF.desc_azienda = dr.Field <string>("desc_azienda"); RFL.Add(RF); } return(RFL); } } catch (MySqlException err) { throw new Exception(err.Message); } catch (Exception err) { throw new Exception(err.Message); } }