public Optic(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
ID = row.Field <string>("Family Product"),
Optic = row.Field <string>("Optic"),
Length = row.Field <string>("Length"),
Workcenter = row.Field <string>("Work Center")
} into grp
select new
{
ProdFam = grp.Key.ID,
Optic = grp.Key.Optic,
Length = grp.Key.Length,
workcenter = grp.Key.Workcenter,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
using (var db = new TimeContext())
{
foreach (var row in newSort)
{
ProdFamTB.AddInstance(row.ProdFam, row.workcenter);
int length = Int32.Parse(row.Length);
OptionTB.AddInstance(optionName, row.Sum, length);
ParametersTB.AddInstance("Optic", row.Optic);
OptionTB.AddParam(optionName, row.Sum, "Optic", row.Optic);
ProdFamTB.AddOption(row.ProdFam, row.workcenter, optionName, row.Sum, length);
db.SaveChanges();
}
}
}
public LightC(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
ID = row.Field <string>("Family Product"),
citcuit = row.Field <string>("Nb Circuit"),
Length = row.Field <string>("Length"),
Workcenter = row.Field <string>("Work Center"),
LampQty = row.Field <string>("Lamp/Cartridge Qty")
} into grp
select new
{
ProdFam = grp.Key.ID,
circuit = grp.Key.citcuit,
Length = grp.Key.Length,
LampQty = grp.Key.LampQty,
workcenter = grp.Key.Workcenter,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
foreach (var row in newSort)
{
ProdFamTB.AddInstance(row.ProdFam, row.workcenter);
int length = Int32.Parse(row.Length);
OptionTB.AddInstance(optionName, row.Sum, length);
OptionTB.AddParam(optionName, row.Sum, "LampQty", row.LampQty);
OptionTB.AddParam(optionName, row.Sum, "Circuit", row.circuit);
ProdFamTB.AddOption(row.ProdFam, row.workcenter, optionName, row.Sum, length);
}
//}
}
