public void SendGroupEmail(PAMGroupEmailParameter param) { try { OutboxEmailServices svcOutboxEmail = new OutboxEmailServices(); svcOutboxEmail.AppConfig = this.AppConfig; svcOutboxEmail.InsertPAMGroupEmail(param); } catch (Exception ex) { this.Logger.Error(ex); throw; } }
public void InsertPAMGroupEmail(PAMGroupEmailParameter param) { string conStringIIF = this.AppConfig.IIFConnectionString; using (SqlConnection con = new SqlConnection(conStringIIF)) { con.Open(); using (SqlTransaction tran = con.BeginTransaction()) { string querySelect = "[dbo].[PAM_ListApproval_SP]"; List <string> listUserFQN = new List <string>(); using (SqlCommand cmd = con.CreateCommand()) { cmd.Transaction = tran; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = querySelect; cmd.Parameters.Add(this.NewSqlParameter("PAMId", SqlDbType.BigInt, param.PAMId)); cmd.Parameters.Add(this.NewSqlParameter("MRoleId", SqlDbType.Int, param.MRoleId)); using (SqlDataReader dr = cmd.ExecuteReader()) { int indexOf_UserFQN = dr.GetOrdinal("UserFQN"); while (dr.Read()) { string userFQN = dr.GetString(indexOf_UserFQN); listUserFQN.Add(userFQN); } } } this.InsertGroupEmail(con, tran, param, listUserFQN, "PAM-" + param.PAMId.ToString()); tran.Commit(); } con.Close(); } }