public static void addWorkstations() { using (var db = new SSRS()) { //var wks = db.ProdTBs.ToList(); var wks = db.ProdTBs.Select(x => new { x.WorkCenter, x.OpCode }).Distinct().ToList(); foreach (var item in wks) { if (item.OpCode != null) { var wk = new Timing_WorkStations() { Name = item.WorkCenter, OpCode = item.OpCode }; using (var DWdb = new DWModel()) { DWdb.Timing_WorkStations.Add(wk); DWdb.SaveChanges(); } } } } }
public static Timing_Option addTimeOptionCustom(Fixture fixture, Category Category, Parameter Parameter, Timing_WorkStations workStations, string OptionName, decimal OptionValue) { Timing_Option Input = new Timing_Option() { Name = OptionName, Time = OptionValue, Fixture = fixture, Timing_WorkStations = workStations }; //Input.Categories.Add(Category); Input.Parameters.Add(Parameter); return(Input); }
public static Timing_Option addTimeOptionCustom(Fixture fixture, List <Category> Categories, List <Parameter> Parameters, Timing_WorkStations workStations, string OptionName, decimal OptionValue) { Timing_Option Input = new Timing_Option() { Name = OptionName, Time = OptionValue, Fixture = fixture, Categories = Categories, Parameters = Parameters, Timing_WorkStations = workStations }; return(Input); }