} // 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()
} // LoadProduct()
/// <summary>
/// Load product parameters from table to database.
/// </summary>
public static void LoadProductParameters(DataTable table)
{
var parameterList = table.AsEnumerable().Select(Row => new ProductParameters
{
PLU = Convert.ToInt32(Row.Field <string>("PLU")),
Grade = StringToEnumConverter.StringNumToStoreGrade(Row.Field <string>("Grade")),
Min = Convert.ToInt16(Row.Field <string>("Min")),
Max = Convert.ToInt16(Row.Field <string>("Max")),
Cover = Convert.ToInt16(Row.Field <string>("Cover"))
}).ToList();
MainWindowViewModel.Context.ProductParameters.AddRange(parameterList);
MainWindowViewModel.SaveContext();
} // LoadProductParameters()
