public static ResultInfo.Result TestDatabaseConnection(SetupModels.DatabaseSetup dbModel)
{
try
{
SqlConnection con = new SqlConnection("Data Source=" + dbModel.Server + ";Initial Catalog=" + dbModel.DatabaseName + ";user id=" + dbModel.User + ";password="******";multipleactiveresultsets=True;application name=EntityFramework");
con.Open();
SqlCommand command = new SqlCommand("select * from DynSettings", con);
command.ExecuteScalar();
con.Close();
return(ResultInfo.GenerateOKResult());
}
catch (Exception ex)
{
return(ResultInfo.GenerateErrorResult(ex.Message));
}
}
public static ResultInfo.Result SetDatabaseConnection(SetupModels.DatabaseSetup dbModel)
{
try
{
var configuration = WebConfigurationManager.OpenWebConfiguration("~");
var section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
section.ConnectionStrings["DefaultConnection"].ConnectionString = "Data Source=" + dbModel.Server + ";Initial Catalog=" + dbModel.DatabaseName + ";user id=" + dbModel.User + ";password="******";multipleactiveresultsets=True;application name=EntityFramework";
string con2 = "metadata=res://*/;provider=System.Data.SqlClient;provider connection string='data source=" + dbModel.Server + ";initial catalog=" + dbModel.DatabaseName + ";user id=" + dbModel.User + ";password="******";multipleactiveresultsets=True;application name=EntityFramework'";
section.ConnectionStrings["DynThingsEntities"].ConnectionString = con2;
configuration.Save();
return(ResultInfo.GenerateOKResult("Saved"));
}
catch (Exception ex)
{
return(ResultInfo.GenerateErrorResult(ex.Message));
}
}
public static ResultInfo.Result SendMail(MailsConfig mailsConfig, string to, string subject, string body)
{
ResultInfo.Result result = ResultInfo.GenerateErrorResult("");
try
{
MailMessage mail = new MailMessage(mailsConfig.Sender, to);
SmtpClient client = new SmtpClient();
client.Port = mailsConfig.Port;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
client.Host = mailsConfig.Host;
mail.IsBodyHtml = false;
mail.Subject = subject;
mail.Body = body;
client.Send(mail);
result = ResultInfo.GenerateOKResult();
}
catch (Exception ex)
{
result = ResultInfo.GenerateErrorResult("Mail send Failed", ex.Message);
}
return(result);
}
