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