public void AddShare(RegistryShare registryShare) { try { using (MySqlCommand dbComm = new MySqlCommand()) { dbComm.Connection = new MySqlConnection(DAFconnection.GetConnectionType()); dbComm.CommandType = CommandType.Text; dbComm.CommandText = SQL.RegistryScripts.AddShare; foreach (var property in registryShare.GetType().GetProperties()) { if (property.Name == "id_titolo") { dbComm.Parameters.AddWithValue("id_titolo", null); } else { dbComm.Parameters.AddWithValue(property.Name, property.GetValue(registryShare)); } } 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 RegistryShare GetShareById(uint id) { try { using (MySqlDataAdapter dbAdapter = new MySqlDataAdapter()) { dbAdapter.SelectCommand = new MySqlCommand(); dbAdapter.SelectCommand.Connection = new MySqlConnection(DAFconnection.GetConnectionType()); dbAdapter.SelectCommand.CommandType = CommandType.Text; dbAdapter.SelectCommand.CommandText = SQL.RegistryScripts.GetShareById; dbAdapter.SelectCommand.Parameters.AddWithValue("id_titolo", id); DataTable dt = new DataTable(); dbAdapter.Fill(dt); RegistryShare registryShare = new RegistryShare(); foreach (var property in registryShare.GetType().GetProperties()) { property.SetValue(registryShare, dt.Rows[0].Field <object>(property.Name)); } return(registryShare); } } catch (MySqlException err) { throw new Exception(err.Message); } catch (Exception err) { throw new Exception(err.Message); } }
public RegistryShareList GetRegistryShareList() { 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.GetRegistryShareList; DataTable dt = new DataTable(); dbAdaptar.Fill(dt); RegistryShareList RSL = new RegistryShareList(); foreach (DataRow dr in dt.Rows) { RegistryShare RS = new RegistryShare(); foreach (var property in RS.GetType().GetProperties()) { property.SetValue(RS, dr.Field <object>(property.Name)); } RSL.Add(RS); } return(RSL); } } catch (MySqlException err) { throw new Exception(err.Message); } catch (Exception err) { throw new Exception(err.Message); } }
public RegistryShareList GetSharesByFirms(int[] id_aziende) { try { string where = ""; foreach (int x in id_aziende) { where += string.Format(" id_azienda = {0} OR ", x); } where = where.Remove(where.Length - 3, 3); using (MySqlDataAdapter dbAdaptar = new MySqlDataAdapter()) { dbAdaptar.SelectCommand = new MySqlCommand(); dbAdaptar.SelectCommand.Connection = new MySqlConnection(DAFconnection.GetConnectionType()); dbAdaptar.SelectCommand.CommandType = CommandType.Text; dbAdaptar.SelectCommand.CommandText = string.Format(SQL.RegistryScripts.GetSharesByFirms, where); DataTable dt = new DataTable(); dbAdaptar.Fill(dt); RegistryShareList RSL = new RegistryShareList(); foreach (DataRow dr in dt.Rows) { RegistryShare RS = new RegistryShare(); foreach (var property in RS.GetType().GetProperties()) { property.SetValue(RS, dr.Field <object>(property.Name)); } RSL.Add(RS); } return(RSL); } } catch (MySqlException err) { throw new Exception(err.Message); } catch (Exception err) { throw new Exception(err.Message); } }