public List <AuthServerInfo> GetSmtpsList()
{
List <AuthServerInfo> list = new List <AuthServerInfo>();
MySqlDataReader sqlReader = GetQueryReader(
@"SELECT Id,Host,Port,Login,Password,UseSSL,Name,Email
FROM smtpservers");
while (sqlReader.Read())
{
AuthServerInfo smtpServ = new AuthServerInfo();
smtpServ.Id = sqlReader.GetInt32(0); // id
smtpServ.Host = sqlReader.GetString(1); // host
smtpServ.Port = sqlReader.GetInt32(2); // port
smtpServ.UseSSL = sqlReader.GetBoolean(5); // SSL
if (!sqlReader.IsDBNull(3)) // login
{
smtpServ.Login = sqlReader.GetString(3); // login
smtpServ.Password = sqlReader.GetString(4); // pass
}
if (!sqlReader.IsDBNull(6)) // name
{
smtpServ.FromName = sqlReader.GetString(6);
}
smtpServ.FromAddr = sqlReader.GetString(7);
list.Add(smtpServ);
}
sqlReader.Close();
return(list);
}
public void AddSmtp(AuthServerInfo smtp)
{
string user, pass;
user = pass = "******";
if (!String.IsNullOrEmpty(smtp.Login))
{
user = "******" + smtp.Login + "'";
if (smtp.Password == null)
{
smtp.Password = "";
}
pass = "******" + smtp.Password + "'";
}
string fname =
smtp.FromName == null ? "NULL" : "'{3}'";
SendQuery(string.Format("INSERT smtpservers " +
"SET Host='{0}',Port={1}," +
"Login="******",Password="******",UseSSL={2},Name=" + fname + ",Email='{4}'",
smtp.Host, smtp.Port,
smtp.UseSSL ? 1 : 0, smtp.FromName, smtp.FromAddr));
}
public AuthServerInfo GetSmtpServerById(int id)
{
MySqlDataReader sqlReader = GetQueryReader(selectSmtpByIdQuery + id.ToString());
if (sqlReader != null)
{
if (sqlReader.Read())
{
AuthServerInfo servInf = new AuthServerInfo();
servInf.Id = id;
servInf.Host = sqlReader.GetString(0); // Host
servInf.Port = sqlReader.GetInt32(1); // Port
servInf.Login = sqlReader.GetString(2); // login
servInf.Password = sqlReader.GetString(3); // Password
servInf.UseSSL = sqlReader.GetBoolean(4); // UseSSL
if (!sqlReader.IsDBNull(5))
{
servInf.FromName = sqlReader.GetString(5); // name
}
servInf.FromAddr = sqlReader.GetString(6); // e-mail
sqlReader.Close();
return(servInf);
}
}
throw new Exception("Smtp server data with id " + id.ToString() + " cannot be found");
}
public AuthServerInfo GetAnySmtp()
{
MySqlDataReader sqlReader = GetQueryReader(
@"SELECT Host,Port,Login,Password,UseSSL,Name,Email
FROM smtpservers
ORDER BY RAND() LIMIT 1;");
if (sqlReader != null)
{
if (sqlReader.Read())
{
AuthServerInfo serverInfo = new AuthServerInfo(
sqlReader.GetString(0),
sqlReader.GetInt32(1),
sqlReader.GetString(2),
sqlReader.GetString(3),
sqlReader.GetBoolean(4));
if (!sqlReader.IsDBNull(5))
{
serverInfo.FromName = sqlReader.GetString(5);
}
serverInfo.FromAddr = sqlReader.GetString(6);
sqlReader.Close();
return(serverInfo);
}
}
throw new Exception("Failed to aquire SMTP server parameters from database");
}
public Robot(int Id, string IP)
{
this.IP = IP;
this.Id = Id;
this.SmtpId = 0;
this.SmtpServer = null;
}
public Robot(string IP, int SmtpId, AuthServerInfo SmtpServer)
{
this.Id = 0;
this.IP = IP;
this.SmtpId = SmtpId;
this.SmtpServer = SmtpServer;
}
public bool EqualsNoId(object obj)
{
if (obj is AuthServerInfo)
{
AuthServerInfo asi = obj as AuthServerInfo;
if (asi.Host != this.Host)
{
return(false);
}
if (asi.Port != this.Port)
{
return(false);
}
if (asi.Login != this.Login)
{
return(false);
}
if (asi.Password != this.Password)
{
return(false);
}
if (asi.UseSSL != this.UseSSL)
{
return(false);
}
if (asi.FromAddr != this.FromAddr)
{
return(false);
}
if (asi.FromName != this.FromName)
{
return(false);
}
return(true);
}
return(false);
}