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