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