public SqlServerDatabase(string ip, string port, string nameDataBase, string serverInstance, string username, string password, Integration integration = null)
{
this.ip = ip;
this.port = (port == string.Empty) ? null : "," + port;
this.nameDataBase = nameDataBase;
this.serverInstance = (serverInstance == string.Empty) ? null : "\\" + serverInstance;
this.username = username;
this.password = password;
this.integration = integration;
}
public MySqlDatabase(string ip, string nameDatabase, string serverInstance, string username, string password, string port, Integration integration)
{
this.Ip = ip;
this.nameDatabase = nameDatabase;
this.serverInstance = serverInstance;
this.username = username;
this.password = password;
this.port = port;
this.integration = integration;
connectionStringDatabase();
}
public void sendMail(string smtpUser, string smtpPassword, string smtpServer, string smtpPort, string from, string destination, string subject, string body, string Attachment, string pathLog, Integration integration)
{
try
{
MailMessage mail = new MailMessage(from, destination, subject, body);
SmtpClient smtp = new SmtpClient();
Attachment data = new Attachment(Attachment, MediaTypeNames.Application.Octet);
Attachment data2 = new Attachment(pathLog, MediaTypeNames.Application.Octet);
mail.Attachments.Add(data);
mail.Attachments.Add(data2);
smtp.Host = smtpServer;
smtp.Port = Convert.ToInt32(smtpPort);
smtp.Credentials = new NetworkCredential(smtpUser, smtpPassword);
smtp.EnableSsl = true;
smtp.Send(mail);
}
catch (System.ArgumentException e)
{
string message = e.Message;
message = message.Replace("'", "");
string queryToLog2 = "insert into SystemLogs (Description,ErrorDate, IntegrationId) values('Class Send Mails: " + message + "','" + DateTime.Now + "'," + integration.integrationId + ")";
integration.insertLog(queryToLog2);
}
catch (System.IO.IOException e)
{
string message = e.Message;
message = message.Replace("'", "");
string queryToLog2 = "insert into SystemLogs (Description,ErrorDate, IntegrationId) values('Class Send Mails: " + message + "','" + DateTime.Now + "'," + integration.integrationId + ")";
integration.insertLog(queryToLog2);
}
}
public InterfaceDatabase createInstanceDataBase(string ip, string port, string nameDataBase, string serverInstance, string username, string password, string engine, Integration integration)
{
if (engine == "SQLSERVER")
{
return(new SqlServerDatabase(ip, port, nameDataBase, serverInstance, username, password, integration));
}
else
{
return(new MySqlDatabase(ip, nameDataBase, serverInstance, username, password, port, integration));
}
}
private void executeIntegrationManual(int integrationId)
{
ClassLibrary.Integration integration = new ClassLibrary.Integration();
integration.executeIntegration(integrationId);
}
public string writeFileinFlatFile(string resultQuery, string locationToSave, string nameIntegration, Integration integration)
{
string nameFile = nameIntegration + "-" + returnDatetimeNow() + ".txt";
string path = locationToSave + "/" + nameFile;
try
{
FileStream fs = new FileStream(path, FileMode.Append);
using (StreamWriter file = new StreamWriter(fs, Encoding.UTF8))
{
string[] resultParse = resultQuery.Split('%');
for (int i = 0; i < resultParse.Length; i++)
{
file.WriteLine(resultParse[i]);
}
file.Close();
}
}
catch (DirectoryNotFoundException e)
{
string message = e.Message;
message = message.Replace("'", "");
string query = "insert into SystemLogs (Description,ErrorDate, IntegrationId) values('Class WriteFile: " + message + "','" + DateTime.Now + "'," + integration.integrationId + ")";
integration.insertLog(query);
}
return(path + "|" + nameFile);
}
