private LabelProperitys GetDefaultLabelProperity(LabelTypes type)
{
LabelProperitys lp = new LabelProperitys();
lp.AssingedLabel = type;
lp.CustomerName = "AMC";
lp.LabelQuanity = 1;
return(lp);
}
// ja - new way ....
// TODO: ja - move to new class?
private void AssignLabelTypesFromDataBase()
{
string ConnectionString = ConfigValues.GetConnectionString();
SqlDataReader myReader = null;
SqlConnection TheConnection = null;
try
{
TheConnection = new SqlConnection(ConnectionString);
TheConnection.Open();
// ja - get the label information from the database view
SqlCommand myCommand = new SqlCommand("select * from label_Data where Part_Number = '" + PartNumber + "' and Part_Version = '" + PartVersion + "'", TheConnection);
myReader = myCommand.ExecuteReader();
// ja - loop through all of the assigned label types
while (myReader.Read())
{
// ja - get the information from the database
string sLocation = myReader["Location_Name"].ToString();
string sType = myReader["Label_Type_Name"].ToString();
string sQty = myReader["Print_Qty"].ToString();
string sCustomerName = myReader["Customer_Name"].ToString();
LabelTypes type = (LabelTypes)Enum.Parse(typeof(LabelTypes), sType);
PrinterArea area = (PrinterArea)Enum.Parse(typeof(PrinterArea), sLocation);
// ja - if the printer area matches the passed in area (Physical Printer) add to queue
if (area == ePrinterArea)
{
LabelProperitys lp = new LabelProperitys
{
CustomerName = sCustomerName,
LabelQuanity = Convert.ToInt32(sQty),
AssingedLabel = type
};
AssignedLabels.Add(lp);
}
}
myReader.Close();
TheConnection.Close();
}
catch (System.Exception ex)
{
Console.WriteLine(ex.ToString());
myReader.Close();
TheConnection.Close();
}
}
private void AssignLabelTypesFromOverride()
{
LabelProperitys lp = new LabelProperitys();
lp.CustomerName = "AMC";
lp.LabelQuanity = 1;
// ja - here we will use the override
lp.sConfigLabelName = ConfigValues.ConfigLabelName;
//lp.Overrides = ConfigValues.LabelOverride;
AssignedLabels.Add(lp);
}
