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