} // 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()