static void Main(string[] args)
{
foreach (string filepath in System.IO.Directory.EnumerateFiles(@"C:\Users\wildbillcat\Sync\WebSpecs\SKUs", "*.csv"))
{
using (var csv = new CsvReader(System.IO.File.OpenText(filepath)))
{
string[] datePieces = filepath.Split('\\').Last().Split('.')[0].Split('-');
DateTime SalesDate = new DateTime(int.Parse(datePieces[2]), int.Parse(datePieces[0]), int.Parse(datePieces[1]));
SalesDate.AddDays(-1 * (SalesDate.Day - 1));//Ensures Day of the first of the month
int MonthID = (12 * SalesDate.Year) + SalesDate.Month;
while (csv.Read())
{
using (var ctx = new InventoryForcast.Models.ApplicationDbContext())
{
int _sku = csv.GetField <int>(0);
System.Console.WriteLine(string.Concat("SKU: ", _sku, " Date: ", SalesDate));
int _qty_sold = csv.GetField <int>(1);
ctx.MonthlyTotals.Add(new MonthlyTotal()
{
SKU = _sku,
Quantity_Sold = _qty_sold,
Absolute_Quantity_Sold = MonthlyTotal.RemoveSeasonality(_qty_sold, SalesDate.Month),
Date = SalesDate,
Month_Id = MonthID
}
);
ctx.SaveChanges();
}
}
}
}
}
static void Main(string[] args)
{
foreach (string filepath in System.IO.Directory.EnumerateFiles(@"C:\Users\wildbillcat\Sync\WebSpecs\SKUs", "*.csv"))
{
using (var csv = new CsvReader(System.IO.File.OpenText(filepath)))
{
string[] datePieces = filepath.Split('\\').Last().Split('.')[0].Split('-');
DateTime SalesDate = new DateTime(int.Parse(datePieces[2]), int.Parse(datePieces[0]), int.Parse(datePieces[1]));
SalesDate.AddDays(-1 * (SalesDate.Day - 1));//Ensures Day of the first of the month
int MonthID = (12 * SalesDate.Year) + SalesDate.Month;
while (csv.Read())
{
using(var ctx = new InventoryForcast.Models.ApplicationDbContext())
{
int _sku = csv.GetField<int>(0);
System.Console.WriteLine(string.Concat("SKU: ", _sku, " Date: ", SalesDate));
int _qty_sold = csv.GetField<int>(1);
ctx.MonthlyTotals.Add(new MonthlyTotal()
{
SKU = _sku,
Quantity_Sold = _qty_sold,
Absolute_Quantity_Sold = MonthlyTotal.RemoveSeasonality(_qty_sold, SalesDate.Month),
Date = SalesDate,
Month_Id = MonthID
}
);
ctx.SaveChanges();
}
}
}
}
}