private Dictionary <int, bool> GetRecipients(EmailParameters emailParameters, View userView)
{
HashSet <string> emails = new HashSet <string>();
foreach (string email in emailParameters.To)
{
if (!emails.Contains(email))
{
emails.Add(email);
}
}
Dictionary <int, bool> recipients = new Dictionary <int, bool>();
if (emails.Count >= 1)
{
Durados.Data.IDataAccess dal = userView.Database.GetDataAccess(userView.ConnectionString);
ISqlTextBuilder sqlBuilder = dal.GetSqlBuilder();
string emailString = emails.ToArray().Delimited("'", "'");
string sql = GetSelectPKStatement(userView, sqlBuilder, emailString);
using (IDbConnection connection = dal.GetConnection(userView.ConnectionString))// GetConnection(userView.ConnectionString))
{
connection.Open();
using (IDbCommand command = dal.GetCommand(connection, sql))
{
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int i = reader.GetOrdinal("ID");
if (!reader.IsDBNull(i))
{
recipients.Add(reader.GetInt32(i), false);
}
}
}
}
}
}
return(recipients);
}
protected override string GetPointForInsert(Field field, string columnName, ISqlTextBuilder sqlTextBuilder)
{
return("GeomFromText(" + sqlTextBuilder.DbParameterPrefix + columnName.ReplaceNonAlphaNumeric() + ")" + comma);
}
protected override string GetPointUpdateSetColumn(Field field, string columnName, ISqlTextBuilder sqlTextBuilder)
{
return(sqlTextBuilder.EscapeDbObject(columnName) + sqlTextBuilder.DbEquals + "GeomFromText(" + sqlTextBuilder.DbParameterPrefix + columnName.ReplaceNonAlphaNumeric() + ")" + comma);
}
protected virtual string GetSelectPKStatement(View userView, ISqlTextBuilder sqlBuilder, string emailString)
{
return("SELECT " + sqlBuilder.EscapeDbObjectStart + userView.DataTable.PrimaryKey[0].ColumnName + sqlBuilder.EscapeDbObjectEnd + " FROM " + sqlBuilder.EscapeDbObjectStart + userView.DataTable.TableName + sqlBuilder.EscapeDbObjectEnd + " where Email in (" + emailString + ")");
}
protected override string GetSql(SqlProduct sqlProduct)
{
ISqlTextBuilder builder = GetSqlTextBuilder(sqlProduct);
return("select count(*) from durados_User " + builder.WithNolock + " where Role = 'Admin' and " + GetExcludeEmailDomainsWhereStatement());
}
protected override string GetSelectStatement(Durados.View view, string viewName, string columnName, string whereCondition)
{
ISqlTextBuilder sqlTextBuilder = GetSqlTextBuilder(view);
return("select " + sqlTextBuilder.EscapeDbObject(viewName) + sqlTextBuilder.DbTableColumnSeperator + sqlTextBuilder.EscapeDbObject(columnName) + " from " + sqlTextBuilder.EscapeDbObject(viewName) + sqlTextBuilder.WithNolock + " where " + whereCondition);
}
protected override string GetPkColumnWhereStatement(Durados.View view, string tableName, string columnName)
{
ISqlTextBuilder sqlTextBuilder = GetSqlTextBuilder(view);
return(sqlTextBuilder.EscapeDbObject(tableName) + sqlTextBuilder.DbTableColumnSeperator + sqlTextBuilder.EscapeDbObject(columnName) + sqlTextBuilder.DbEquals + " @pk_" + columnName.ReplaceNonAlphaNumeric() + " " + sqlTextBuilder.DbAnd);
}
