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); }