public void UpdateMovementType(RegistryMovementType registryMovementType)
{
try
{
using (MySqlCommand dbComm = new MySqlCommand())
{
dbComm.CommandType = CommandType.Text;
dbComm.CommandText = SQL.RegistryScripts.UpdateMovementType;
dbComm.Parameters.AddWithValue("desc", registryMovementType.Desc_tipo_movimento);
dbComm.Parameters.AddWithValue("id", registryMovementType.Id_tipo_movimento);
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 RegistryMovementTypeList GetRegistryMovementTypesList()
{
try
{
using (MySqlDataAdapter dbAdapter = new MySqlDataAdapter())
{
dbAdapter.SelectCommand = new MySqlCommand();
dbAdapter.SelectCommand.CommandType = CommandType.Text;
dbAdapter.SelectCommand.CommandText = SQL.RegistryScripts.GetRegistryMovementTypeList;
dbAdapter.SelectCommand.Connection = new MySqlConnection(DAFconnection.GetConnectionType());
DataTable dt = new DataTable();
dbAdapter.Fill(dt);
RegistryMovementTypeList RMTL = new RegistryMovementTypeList();
foreach (DataRow dr in dt.Rows)
{
RegistryMovementType RMT = new RegistryMovementType();
RMT.Id_tipo_movimento = (int)dr.Field <uint>("id_tipo_movimento");
RMT.Desc_tipo_movimento = dr.Field <string>("desc_Movimento");
RMTL.Add(RMT);
}
return(RMTL);
}
}
catch (MySqlException err)
{
throw new Exception(err.Message);
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
