public List <AdmDTO> Read()
{
MySqlDataReader dR = ReadDr();
List <AdmDTO> adms = new List <AdmDTO>();
try
{
if (dR != null)
{
do
{
AdmDTO adm = new AdmDTO();
adm.Login = dR["Login"].ToString();
adms.Add(adm);
} while (dR.Read());
}
if (adms.Count == 0)
{
return(null);
}
return(adms);
}
catch
{
return(null);
}
}
public bool NovoAdm(AdmDTO adm)
{
try
{
Insert(adm);
return(true);
}catch
{
return(false);
}
}
private void Update(AdmDTO adm)
{
try
{
cF = new ConnectionFactory();
cF.CreateConnection();
String comando = "Update Adm set Login = '******' where Login = '******'";
cF.SqlCommand(comando);
}
catch (Exception e)
{
throw new Exception("Erro: " + e.Message);
}
finally
{
cF = null;
}
}
//CRUD
private void Insert(AdmDTO adm)
{
try
{
cF = new ConnectionFactory();
cF.CreateConnection();
String comando = "Insert INTO Adm (Login) Values ('" + adm.Login + "')";
cF.SqlCommand(comando);
}
catch (Exception e)
{
throw new Exception("Erro: " + e.Message);
}
finally
{
cF = null;
}
}
