public static string PrependToList(this string str, IEnumerable<string> set)
{
var builder = new StringBuilder();
set.ToList().ForEach(x => builder.AppendFormat("{0}{1}, ", str, x));
return builder.TrimTail(2).ToString();
}
public static string AppendToList(this string str, IEnumerable<string> set)
{
var builder = new StringBuilder();
set.ToList().ForEach(x => builder.AppendFormat("{0}{1}", x, str));
return builder.TrimTail(str.Length).ToString();
}
public static String AddFormatParameters(this string str, int count, string enclosingChars = "")
{
var builder = new StringBuilder();
for (var i = 0; i < count; i++)
{
builder.AppendFormat("{0}{1}{2}{3}{4}, ", enclosingChars, "{", i, "}", enclosingChars);
}
return str + builder.TrimTail(2).ToString();
}
public static async Task<bool> Add(this SubscribersContext ctx, Subscriber subscriber)
{
var parameters = new []
{
new SqlParameter("@send", subscriber.send),
new SqlParameter("@insertionDate", SqlDbType.DateTime) { Value = subscriber.insertionDate },
new SqlParameter("@updateDate", SqlDbType.DateTime) { Value = subscriber.updateDate.Value },
new SqlParameter("@firstName", subscriber.firstName),
new SqlParameter("@lastName", subscriber.lastName),
new SqlParameter("@email", subscriber.email),
new SqlParameter("@MD5_email", SqlDbType.VarBinary, 16) { Value = subscriber.MD5_email },
new SqlParameter("@domainName", subscriber.domainName),
new SqlParameter("@category", SqlDbType.SmallInt) { Value = 0 },
new SqlParameter("@frequency", 1),
}.ToList();
var builder = new StringBuilder();
parameters.ForEach(x => builder.AppendFormat("{0}, ", x.ParameterName.Replace("@", String.Empty)));
var columnNames = builder.TrimTail(2).ToString();
builder.Clear();
parameters.ForEach(x => builder.AppendFormat("{0}, ", x.ParameterName));
var parameterNames = builder.TrimTail(2).ToString();
var statement = string.Format("INSERT INTO [{0}] ({1}) VALUES ({2})", ctx.TableName, columnNames, parameterNames);
var result = await ctx.Database.ExecuteSqlCommandAsync(statement, parameters.ToArray());
return result != 0;
}
