} // ExportToDatabase()
/// <summary>
/// Load product from table to database.
/// </summary>
/// <param name="table"></param>
static public void LoadProducts(DataTable table)
{
var productList = table.AsEnumerable().Select(Row => new Product
{
PLU = Convert.ToInt32(Row.Field <string>("PLU")),
Name = Row.Field <string>("Name"),
GroupName = StringToEnumConverter.StringNumToGroup(Row.Field <string>("GroupName")),
SubGroup = StringToEnumConverter.StringNumToSubGroup(Row.Field <string>("SubGroup")),
Color = Row.Field <string>("Color"),
Price = Convert.ToSingle(Row.Field <string>("Price")),
PackSize = Convert.ToInt16(Row.Field <string>("PackSize")),
Promotion = Row.Field <string>("Promotion"),
WarehouseFreeQty = Convert.ToInt16(Row.Field <string>("WarehouseFreeQty")),
StoresBelowMinimum = Convert.ToInt16(Row.Field <string>("StoresBelowMinimum")),
StoresEffectiveCover = Convert.ToSingle(Row.Field <string>("StoresEffectiveCover")),
MondayDistribution = StringToBoolConverter.StringToBool(Row.Field <string>("Mon")),
TuesdayDistribution = StringToBoolConverter.StringToBool(Row.Field <string>("Tue")),
WednesdayDistribution = StringToBoolConverter.StringToBool(Row.Field <string>("Wed")),
ThursdayDistribution = StringToBoolConverter.StringToBool(Row.Field <string>("Thu")),
FridayDistribution = StringToBoolConverter.StringToBool(Row.Field <string>("Fri")),
MethodOfDistribution = StringToEnumConverter.StringNumToMethodOfDistribution(Row.Field <string>("MethodOfDistribution"))
}).ToList();
MainWindowViewModel.Context.Products.AddRange(productList);
MainWindowViewModel.SaveContext();
} // LoadProduct()
} //LoadCurvesAndWeeks()
public static void UpdateCurvesData(DataTable table)
{
var curvesList = table.AsEnumerable().Select(Row => new GroupCurve
{
Group = StringToEnumConverter.StringNumToGroup(Row.Field <string>("Group")),
Week = Convert.ToInt32(Row.Field <string>("Week")),
Value = Convert.ToSingle(Row.Field <string>("Value"))
}).ToList();
MainWindowViewModel.Context.GroupCurve.AddRange(curvesList);
MainWindowViewModel.SaveContext();
} // UpdateCurvesData()
} // LoadProductParameters()
public static void LoadStoreGrades(DataTable table)
{
var storeGradeList = table.AsEnumerable().Select(Row => new StoreGrade
{
StoreNumber = Convert.ToInt16(Row.Field <string>("StoreNumber")),
Group = StringToEnumConverter.StringNumToGroup(Row.Field <string>("Group")),
Grade = StringToEnumConverter.StringNumToStoreGrade(Row.Field <string>("Grade"))
}).ToList();
MainWindowViewModel.Context.StoresGrades.AddRange(storeGradeList);
MainWindowViewModel.SaveContext();
} // LoadStoreGrades()
