internal static void AddJobToPrintQueue(BarcodeLabel item) { try { SqlParameter pWSNumber = new SqlParameter(); pWSNumber.ParameterName = "WSNumber"; pWSNumber.Value = item.WSNumber; SqlParameter pUserName = new SqlParameter(); pUserName.ParameterName = "userName"; pUserName.Value = item.UserName; SqlParameter pLineID = new SqlParameter(); pLineID.ParameterName = "lineID"; pLineID.Value = item.LineID; SqlParameter pItemID = new SqlParameter(); pItemID.ParameterName = "itemID"; pItemID.Value = item.ItemID; SQLHelper.ExecuteStoredProcedure(StoredProcedures.AddJobToPrintQueue, pWSNumber, pLineID, pItemID, pUserName); } catch (Exception ex) { throw; } }
public bool PrintBarcodeLabel(BarcodeLabel item) { bool isValidItem = false; try { isValidItem = BusinessLogic.IsValidWorksheetLineItem(item); if (isValidItem) { BusinessLogic.AddJobToPrintQueue(item); } } catch (Exception ex) { throw; } return isValidItem; //GlassProductManager.BarcodePrinter.PrintLineItem(item.WSNumber, item.LineID, item.ItemID); }
internal static bool IsValidWorksheetLineItem(BarcodeLabel item) { bool isValidWSItem = false; try { SqlParameter pWSNumber = new SqlParameter(); pWSNumber.ParameterName = "WSNumber"; pWSNumber.Value = item.WSNumber; SqlParameter pLineID = new SqlParameter(); pLineID.ParameterName = "lineID"; pLineID.Value = item.LineID; SqlParameter pItemID = new SqlParameter(); pItemID.ParameterName = "itemID"; pItemID.Value = item.ItemID; var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.IsValidWorksheetLineItem, pWSNumber, pLineID, pItemID); if (result == null || result.Tables == null || result.Tables.Count == 0 || result.Tables[0].Rows.Count == 0) { return isValidWSItem; } isValidWSItem = bool.Parse(result.Tables[0].Rows[0][ColumnNames.Status].ToString()); } catch (Exception ex) { throw; } return isValidWSItem; }
internal static ObservableCollection<BarcodeLabel> GetPrintJobQueue() { ObservableCollection<BarcodeLabel> printJobqueue = null; try { var result = SQLHelper.ExecuteStoredProcedure(StoredProcedures.GetPrintJobQueue); if (result == null || result.Tables == null || result.Tables.Count == 0 || result.Tables[0].Rows.Count == 0) return printJobqueue; printJobqueue = new ObservableCollection<BarcodeLabel>(); BarcodeLabel item = new BarcodeLabel(); for (int rowIndex = 0; rowIndex < result.Tables[0].Rows.Count; rowIndex++) { item = new BarcodeLabel(); item.ID = int.Parse(result.Tables[0].Rows[rowIndex][ColumnNames.ID].ToString()); item.LineID = int.Parse(result.Tables[0].Rows[rowIndex][ColumnNames.LineID].ToString()); item.ItemID = int.Parse(result.Tables[0].Rows[rowIndex][ColumnNames.ItemID].ToString()); item.WSNumber = result.Tables[0].Rows[rowIndex][ColumnNames.WSNumber].ToString(); item.UserName = result.Tables[0].Rows[rowIndex][ColumnNames.UserName].ToString(); printJobqueue.Add(item); } } catch (Exception ex) { Logger.LogException(ex); } return printJobqueue; }