public PowerCord(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
wiresQty = row.Field <string>("Wires Qty"),
Workcenter = row.Field <string>("Work Center")
} into grp
select new
{
workcenter = grp.Key.Workcenter,
wires = grp.Key.wiresQty,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
foreach (var row in newSort)
{
ParametersTB.AddInstance("WiresQty", row.wires);
OptionTB.AddInstance(optionName, row.Sum);
OptionTB.AddParam(optionName, row.Sum, "WiresQty", row.wires);
using (var db = new TimeContext())
{
foreach (var fixture in db.Fixtures)
{
FixtureTB.AddOption(fixture.FxCode, row.workcenter, optionName, row.Sum);
}
}
}
}
public Nightlight(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>("Fixture Type"),
Workcenter = row.Field <string>("Work Center")
} into grp
//orderby grp.Key
select new
{
Fixture = grp.Key.ID,
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)
{
FixtureTB.AddInstance(row.Fixture, row.workcenter);
OptionTB.AddInstance(optionName, row.Sum);
FixtureTB.AddOption(row.Fixture, row.workcenter, optionName, row.Sum);
}
}
}
public Remo(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
Workcenter = row.Field <string>("Work Center")
} into grp
select new
{
workcenter = grp.Key.Workcenter,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time(min)")))
}).ToList();
foreach (var row in newSort)
{
using (var db = new TimeContext())
{
foreach (var fixture in db.Fixtures.Where(r => r.WorkCenter == row.workcenter))
{
FixtureTB.AddOption(fixture.FxCode, row.workcenter, optionName, row.Sum);
}
}
}
}
public DustCover(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
Length = row.Field <string>("Length"),
Workcenter = row.Field <string>("Work Center")
} into grp
//orderby grp.Key
select new
{
length = Int32.Parse(grp.Key.Length),
workcenter = grp.Key.Workcenter,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
foreach (var row in newSort)
{
OptionTB.AddInstance(optionName, row.Sum, row.length);
using (var db = new TimeContext())
{
foreach (var fixture in db.Fixtures)
{
FixtureTB.AddOption(fixture.FxCode, row.workcenter, optionName, row.Sum, row.length);
}
}
}
}
public CB(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>("Fixture Type"),
Workcenter = row.Field <string>("Work Center"),
LampQty = row.Field <string>("Lamp Qty")
} into grp
//orderby grp.Key
select new
{
ID = grp.Key.ID,
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)
{
FixtureTB.AddInstance(row.ID, row.workcenter);
OptionTB.AddInstance(optionName, row.Sum);
ParametersTB.AddInstance("LampQty", row.LampQty);
OptionTB.AddParam(optionName, row.Sum, "LampQty", row.LampQty);
FixtureTB.AddOption(row.ID, row.workcenter, optionName, row.Sum);
}
}
public ExitW(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>("Fixture Type"),
Section = row.Field <string>("Section"),
Circtuit = row.Field <string>("Circuit"),
Ballast = row.Field <string>("Kind Of Ballast/Driver"),
Workcenter = row.Field <string>("Work Center")
} into grp
select new
{
fixture = grp.Key.ID,
Section = grp.Key.Section,
Circtuit = grp.Key.Circtuit,
workcenter = grp.Key.Workcenter,
Ballast = grp.Key.Ballast,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
foreach (var row in newSort)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("Section", row.Section);
parameters.Add("Circuit", row.Circtuit);
parameters.Add("Ballast", row.Ballast);
FixtureTB.AddInstance(row.fixture, row.workcenter);
OptionTB.AddInstance(optionName, row.Sum);
foreach (var instace in parameters)
{
ParametersTB.AddInstance(instace.Key, instace.Value);
OptionTB.AddParam(optionName, row.Sum, instace.Key, instace.Value);
}
FixtureTB.AddOption(row.fixture, row.workcenter, optionName, row.Sum);
}
}
public PowerC(string paramFilePath)
{
string optionName = this.GetType().Name;
var dt = ConvertCSVtoDataTable(paramFilePath);
var newSort = (from row in dt.AsEnumerable()
group row by new
{
Section = row.Field <string>("Section"),
Circtuit = row.Field <string>("Circuit"),
Ballast = row.Field <string>("Kind Of Ballast/Driver"),
length = row.Field <string>("Length"),
Workcenter = row.Field <string>("Work Center")
} into grp
select new
{
Section = grp.Key.Section,
Circtuit = grp.Key.Circtuit,
workcenter = grp.Key.Workcenter,
Ballast = grp.Key.Ballast,
length = grp.Key.length,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Total Time (min)")))
}).ToList();
foreach (var row in newSort)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("Section", row.Section);
parameters.Add("Circuit", row.Circtuit);
parameters.Add("Ballast", row.Ballast);
int length = Int32.Parse(row.length);
OptionTB.AddInstance(optionName, row.Sum, length);
foreach (var instace in parameters)
{
ParametersTB.AddInstance(instace.Key, instace.Value);
OptionTB.AddParam(optionName, row.Sum, instace.Key, instace.Value, length);
}
using (var db = new TimeContext())
{
foreach (var fixture in db.Fixtures.Where(r => r.WorkCenter == row.workcenter))
{
FixtureTB.AddOption(fixture.FxCode, row.workcenter, optionName, row.Sum, length);
}
}
}
}
public OpTest(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>("Fixture Type"),
light = row.Field <string>("Lighting"),
citcuit = row.Field <string>("Circuit"),
LampQty = row.Field <string>("Lamp/Cartridge Qty"),
Length = row.Field <string>("Length"),
Workcenter = row.Field <string>("Work Center")
} into grp
//orderby grp.Key
select new
{
Fixture = grp.Key.ID,
light = grp.Key.light,
circuit = grp.Key.citcuit,
lampQty = grp.Key.LampQty,
length = Int32.Parse(grp.Key.Length),
workcenter = grp.Key.Workcenter,
Sum = grp.Sum(r => Double.Parse(r.Field <string>("Time (min)")))
}).ToList();
foreach (var row in newSort)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
FixtureTB.AddInstance(row.Fixture, row.workcenter);
OptionTB.AddInstance(optionName, row.Sum, row.length);
parameters.Add("Circuit", row.circuit);
parameters.Add("LampQty", row.lampQty);
parameters.Add("Light", row.light);
foreach (var value in parameters)
{
ParametersTB.AddInstance(value.Key, value.Value);
OptionTB.AddParam(optionName, row.Sum, value.Key, value.Value, row.length);
}
FixtureTB.AddOption(row.Fixture, row.workcenter, optionName, row.Sum);
}
}
