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);
}
