static void Main(string[] args)
{
//Utilities.updateTime();
//Utilities.UploadStandardTime();
string lineDesc = "BBRLED-1000-80-35-RG-35'-W-UNV-DP-1-DF";
lineDesc = "SKPLED-22-4000-80-35-0.5-W-UNV-DP-1-TB9";
string DWConnectiontring = "metadata = res://*/DBConnection.csdl|res://*/DBConnection.ssdl|res://*/DBConnection.msl;provider=System.Data.SqlClient;provider connection string='Data Source=VAULT\\DRIVEWORKS;Initial Catalog=\"AXIS Automation\";Integrated Security=True;MultipleActiveResultSets=True'";
using (AXISAutomation.Tools.DBConnection.AXIS_AutomationEntities _AutomationEntities = new AXISAutomation.Tools.DBConnection.AXIS_AutomationEntities(DWConnectiontring))
{
_Fixture fixture = new AXISAutomation.FixtureConfiguration._Fixture(lineDesc, _AutomationEntities);
fixture.SPM.ConfigureAll();
var Time = new TimeCalculator(fixture, 4);
}
using (var db = new DWModel())
{
//string codeid = "BBRLED";
//string optionName = "Standard";
//string workStation = "Cutting Extrusion";
//string CategoryName = "Length";
//string parameter = "8";
//var time = db.Timing_Option.First(r => r.Fixture.Code == codeid
//&& r.Name == optionName && r.Timing_WorkStations.Name == workStation
//&& r.Categories.Any( t => t.Name == CategoryName)
//&& r.Parameters.Any(e => e.Code == parameter));
//int optionID = 72636;
//var time2 = db.Timing_Option.Where(r => r.OptionID == optionID).FirstOrDefault();
//time2.Time = (decimal)1.40;
//db.SaveChanges();
}
}
public ProductClass(string ProductCode)
{
var DriveWorkdb = new AXISAutomation.Tools.DBConnection.AXIS_AutomationEntities();
this.BOM = new _BOM(ProductCode, DriveWorkdb);
bool morepage;
var BO = UD30BO.GetRows(string.Format("Key1 = 'PRODUCTID' and key2 = '{0}'", this.BOM.GetselectedproductID_Category), "", 0, 0, out morepage);
this.productCode = BO.UD03[0]["Key2"].ToString();
this.fixtureCode = BO.UD03[0]["Character03"].ToString();
this.ProdFamCode = BO.UD03[0]["Key3"].ToString();
string optic = this.BOM.GetSelectedOpticsDirect_Category.ToString();
string mounting = this.BOM.GetSelectedMounting_Category.ToString();
string driver = this.BOM.GetSelectedDriver_Category;
string defaultMounting = "-";
var x = (this.BOM.GetSelectedLength_Category.ToString()).Replace("'", "");
int length = Int32.Parse(x);
lengthParam.Add(null);
List <string> sectionType = new List <string>();
if (length < 12)
{
lengthParam.Add(length);
sectionType.Add("Complete Section");
using (var db = new TimeContext())
{
int dummy;
var lengthtest = db.Options.Where(r => r.OptionName == "Length" && r.sectionLength == length).FirstOrDefault();
var cartridge = (from row in lengthtest.Params where !int.TryParse(row.ParamValue, out dummy) select row.ParamValue).ToList();
sectionType.AddRange(cartridge);
}
}
else
{
using (var db = new TimeContext())
{
int dummy;
var lengthtest = db.Options.Where(r => r.OptionName == "Length" && r.sectionLength == length).FirstOrDefault();
var cartridge = (from row in lengthtest.Params where !int.TryParse(row.ParamValue, out dummy) select row.ParamValue).ToList();
List <int> Length = (from row in lengthtest.Params where int.TryParse(row.ParamValue, out dummy) select Int32.Parse(row.ParamValue)).ToList();
sectionType.AddRange(cartridge);
var newList = Length.Select(i => (int?)i).ToList();
lengthParam.AddRange(newList);
}
}
ParamValue.AddRange(new List <string>
{
optic,
mounting,
defaultMounting,
driver, //Driver
});
ParamValue.AddRange(sectionType);
this.Initial();
this.retrieveTime();
}
