public string InitializeTimelinesQuickCount()
{
var db = new edayRoomEntities();
db.ClearQuickCount();
var centros = db.Centroes.Include("Movilizadors").Include("TestigoExitPolls").Where(c => c.quickCountActive ?? false).ToList();
var tlQuickCount = new List<QuickCountTimeline>();
foreach (var c in centros)
{
if (c.quickCountActive ?? false)
{
tlQuickCount.Add(new QuickCountTimeline
{
activa = true,
id_centro = c.id,
fecha = DateTime.Now,
id_parent = null
});
}
}
using (
var con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnSimple"].ConnectionString)
)
{
con.Open();
#region QuickCount Timeline
using (var tran = con.BeginTransaction())
{
var bc = new SqlBulkCopy(con,
SqlBulkCopyOptions.CheckConstraints |
SqlBulkCopyOptions.FireTriggers |
SqlBulkCopyOptions.KeepNulls, tran) { BatchSize = 1000, DestinationTableName = "quickcountTimeline" };
bc.WriteToServer(tlQuickCount.AsDataReader());
tran.Commit();
}
#endregion
con.Close();
}
return "todo inicializado, bien";
}