public static bool GetTeamsAddress(List <TeamsAddressQuarantineInfo> teamsAddressQuarantineInfoCollector)
{
try
{
if (teamsAddressQuarantineInfoCollector == null)
{
throw new ArgumentNullException(nameof(teamsAddressQuarantineInfoCollector));
}
string sqlConnectionString = Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process);
if (!String.IsNullOrEmpty(sqlConnectionString))
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("GetAllTeamsAddress", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
TeamsAddressQuarantineInfo teamsAddressQuarantineInfo = new TeamsAddressQuarantineInfo();
teamsAddressQuarantineInfo.UserId = reader["UserId"].ToString();
teamsAddressQuarantineInfo.TeamsAddress = reader["TeamsAddress"].ToString();
teamsAddressQuarantineInfoCollector.Add(teamsAddressQuarantineInfo);
}
return(true);
}
return(false);
}
}
}
}
string errorMsg = "Error: SQL Connection Parameters not found in Configuration";
throw new ArgumentNullException(errorMsg);
}
catch (SqlException sqlEx)
{
throw new Exception(sqlEx.Message);
}
catch (ArgumentNullException argNullEx)
{
throw new ArgumentNullException(argNullEx.Message);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static async Task <bool> GetTeamsAddress(List <string> memberList, List <TeamsAddressQuarantineInfo> teamsAddressQuarantineInfoCollector)
{
var conStr = System.Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process);
using (SqlConnection conn = new SqlConnection(conStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
var sql_query = "select ui.UserId, ui.TeamsAddress, si.QuarantineRequired from UserInfo as ui left join ScreeningInfo as si on(si.UserId = ui.UserId) where ui.UserId IN(";
for (int i = 0; i < memberList.Count - 1; i++)
{
sql_query = sql_query + "'" + memberList[i] + "',";
}
sql_query = sql_query + "'" + memberList[memberList.Count - 1] + "')";
//var sql_conditions = ") AND si.QuarantineRequired = 0";
//cmd.CommandText = "SELECT TeamsAddress FROM UserInfo where UserId = " + "'" + UserId + "'";
cmd.CommandText = sql_query;
cmd.Connection = conn;
reader = cmd.ExecuteReader();
if (reader != null)
{
while (reader.Read())
{
TeamsAddressQuarantineInfo teamsAddressQuarantineInfo = new TeamsAddressQuarantineInfo();
teamsAddressQuarantineInfo.UserId = reader["UserId"].ToString();
teamsAddressQuarantineInfo.TeamsAddress = reader["TeamsAddress"].ToString();
if (reader.IsDBNull("QuarantineRequired"))
{
teamsAddressQuarantineInfo.QuarantineRequired = false;
}
else
{
teamsAddressQuarantineInfo.QuarantineRequired = (bool)reader["QuarantineRequired"];
}
teamsAddressQuarantineInfoCollector.Add(teamsAddressQuarantineInfo);
}
return(true);
}
return(false);
}
}
public static bool GetTeamsAddress(List <TeamsAddressQuarantineInfo> teamsAddressQuarantineInfoCollector)
{
try
{
if (teamsAddressQuarantineInfoCollector == null)
{
throw new ArgumentNullException(nameof(teamsAddressQuarantineInfoCollector));
}
var sqlConnectionString = Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process);
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
string spName = @"dbo.[GetAllTeamsAddress]";
using (SqlCommand cmd = new SqlCommand(spName, connection))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
TeamsAddressQuarantineInfo teamsAddressQuarantineInfo = new TeamsAddressQuarantineInfo();
teamsAddressQuarantineInfo.UserId = reader["UserId"].ToString();
teamsAddressQuarantineInfo.TeamsAddress = reader["TeamsAddress"].ToString();
teamsAddressQuarantineInfoCollector.Add(teamsAddressQuarantineInfo);
}
return(true);
}
return(false);
}
}
}
}
catch (Exception ex)
{
throw new ArgumentNullException("SqlConnectionString not found in Configuration", ex.Message);
}
}
