public MailServiceOutBo execute()
{
MailServiceOutBo outBo = new MailServiceOutBo();
MyRepository rep = new MyRepository();
UserMst fromUser = rep.FindUserMstByUserId(BaseForm.UserInfo.userId);
UserMst toUser = rep.FindMailingListUser();
string body = "承認者：" + fromUser.user_name + System.Environment.NewLine + this.inBo.messageBody;
System.Net.Mail.MailMessage msg = new MailMessage();
System.Net.Mail.SmtpClient sc = new System.Net.Mail.SmtpClient();
try
{
msg = new System.Net.Mail.MailMessage(fromUser.mail_address, toUser.mail_address, this.inBo.messageSubject, body);
sc.Host = "localhost";
sc.Port = 25;
sc.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
sc.Credentials = new System.Net.NetworkCredential(fromUser.mail_address, fromUser.password);
sc.Send(msg);
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(ex.Message);
sb.AppendLine("TO・・・" + "ユーザー名：" + toUser.user_name + "、メールアドレス：" + toUser.mail_address);
sb.AppendLine("FROM・・・" + "ユーザー名：" + fromUser.user_name + "、メールアドレス：" + fromUser.mail_address);
outBo.errorMessage = sb.ToString();
}
finally
{
msg.Dispose();
sc.Dispose();
}
return(outBo);
}
private void sqliteTestConnectBtn_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("Data Source=" + this.sqliteDbFilePath.Text);
sb.Append(";foreign keys=true;");
CommonFunction common = new CommonFunction();
string dbConnectionString = common.getDbConnectionString();
string dbProviderName = common.getDbProviderName();
try
{
using (SQLiteConnection cn = new SQLiteConnection(sb.ToString()))
{
cn.Open();
SQLiteCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT * FROM WORD_DIC";
cmd.ExecuteReader();
common.setSqliteDbContextPath(sb.ToString());
MyRepository rep = new MyRepository();
UserMst fromUser = rep.FindUserMstByUserId(999);
MessageBox.Show("DB接続に成功しました！！");
this.sqliteConnectableDbPath.Text = sb.ToString();
this.sqliteSaveBtn.Visible = true;
this.sqliteDbFilePath.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("DB接続失敗");
common.resetDbContextPath(dbConnectionString, dbProviderName);
}
}
