public void ReIssueSernos(string originalPartNumber, string newPartNumber, int serialNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.reissue_sernos", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new OracleParameter("p_orig_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = originalPartNumber, Size = 14 }); cmd.Parameters.Add(new OracleParameter("p_new_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 14, Value = newPartNumber }); cmd.Parameters.Add(new OracleParameter("p_serial_number", OracleDbType.Int32) { Direction = ParameterDirection.InputOutput, Value = serialNumber }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); }
public void GetSerialNumberBoxes(string partNumber, out int numberOfSerialNumbers, out int numberOfBoxes) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.GET_SERNOS_BOXES", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = partNumber }); var serialNumberQtyParameter = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.InputOutput }; cmd.Parameters.Add(serialNumberQtyParameter); var boxesQtyParameter = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.InputOutput }; cmd.Parameters.Add(boxesQtyParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); numberOfSerialNumbers = int.Parse(serialNumberQtyParameter.Value.ToString()); numberOfBoxes = int.Parse(boxesQtyParameter.Value.ToString()); }
public bool SerialNumbersRequired(string partNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.SERIAL_NOS_REQD_WRAPPER", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 2000 }; cmd.Parameters.Add(result); var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = partNumber }; cmd.Parameters.Add(partNumberParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString() == "SUCCESS"); }
public int GetNumberOfSernos(string partNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.num_of_sernos", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.ReturnValue }; cmd.Parameters.Add(result); cmd.Parameters.Add(new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = partNumber }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(((OracleDecimal)result.Value).IsNull ? 0 : int.Parse(result.Value.ToString())); }
public string CanRaiseWorksOrder(string partNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("CAN_RAISE_WORKS_ORDER_WRAPPER", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 2000 }; cmd.Parameters.Add(result); var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 14, Value = partNumber }; cmd.Parameters.Add(partNumberParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString()); }
public bool SerialNumberExists(int serialNumber, string partNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.serial_number_exists_sql", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.ReturnValue }; cmd.Parameters.Add(result); cmd.Parameters.Add(new OracleParameter("p_serial_number", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = serialNumber }); cmd.Parameters.Add(new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = partNumber }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString() == "1"); }
public int GetNextBatch(string partNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("get_next_batch", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.ReturnValue }; cmd.Parameters.Add(result); var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 14, Value = partNumber }; cmd.Parameters.Add(partNumberParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(int.Parse(result.Value.ToString())); }
public string GetProductGroup(string partNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.get_product_group", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 20 }; cmd.Parameters.Add(result); cmd.Parameters.Add(new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = partNumber }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value?.ToString()); }
public OracleFunctionCall(string functionName) { this.connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); this.cmd = new OracleCommand(functionName, connection) { CommandType = CommandType.StoredProcedure }; if (typeof(T) == typeof(string)) { this.result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 2000 }; } else if (typeof(T) == typeof(int)) { this.result = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.ReturnValue, }; } this.cmd.Parameters.Add(result); }
public OracleProcCall(string functionName) { this.connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); this.cmd = new OracleCommand(functionName, this.connection) { CommandType = CommandType.StoredProcedure }; }
public string GetLabelData(string labelTypeCode, int?serialNumber, string articleNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("GET_LABEL_DATA", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 4000 }; cmd.Parameters.Add(result); cmd.Parameters.Add(new OracleParameter("p_lt_code", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = labelTypeCode, Size = 30 }); cmd.Parameters.Add(new OracleParameter("p_product_id", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = serialNumber }); cmd.Parameters.Add(new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = articleNumber, Size = 14 }); cmd.Parameters.Add(new OracleParameter("p_label_type", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = string.Empty, Size = 30 }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString()); }
public void WorksOrderLabels(int orderNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("BARTENDER.WO_LABELS", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new OracleParameter("p_wo", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = orderNumber }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); }
public string SernosMessage() { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.SERNOS_MESS", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 50 }; cmd.Parameters.Add(result); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString()); }
public string ReturnPackageMessage() { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("BARTENDER.RETURN_PACKAGE_MESSAGE", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 2000 }; cmd.Parameters.Add(result); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString()); }
public string ReissueSerialNumber( string sernosGroup, int serialNumber, int?newSerialNumber, string articleNumber, string newArticleNumber, string comments, int?createdBy) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_RENUM_PACK.REISSUE_SERNOS", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Varchar2) { Direction = ParameterDirection.ReturnValue, Size = 200 }; cmd.Parameters.Add(result); var sernosGroupParameter = new OracleParameter("p_sernos_group", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 10, Value = sernosGroup }; cmd.Parameters.Add(sernosGroupParameter); var serialNumberParameter = new OracleParameter("p_orig_serial_number", OracleDbType.Decimal) { Direction = ParameterDirection.Input, Value = serialNumber }; cmd.Parameters.Add(serialNumberParameter); var newSerialNumberParameter = new OracleParameter("p_new_serial_number", OracleDbType.Decimal) { Direction = ParameterDirection.InputOutput, Value = newSerialNumber }; cmd.Parameters.Add(newSerialNumberParameter); var articleNumberParameter = new OracleParameter("p_orig_article_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 14, Value = articleNumber }; cmd.Parameters.Add(articleNumberParameter); var newArticleNumberParameter = new OracleParameter("p_new_article_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 14, Value = newArticleNumber }; cmd.Parameters.Add(newArticleNumberParameter); var commentsParameter = new OracleParameter("p_comments", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 200, Value = comments }; cmd.Parameters.Add(commentsParameter); var createdByParameter = new OracleParameter("p_user_number", OracleDbType.Decimal) { Direction = ParameterDirection.Input, Value = createdBy }; cmd.Parameters.Add(createdByParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString()); }
public bool PrintLabels( string fileName, string printer, int qty, string template, string data, ref string message) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("BARTENDER.PRINT_LABELS_WRAPPER", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.ReturnValue, Size = 2000 }; cmd.Parameters.Add(result); cmd.Parameters.Add(new OracleParameter("p_filename", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = fileName }); cmd.Parameters.Add(new OracleParameter("p_printer", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 100, Value = printer }); cmd.Parameters.Add(new OracleParameter("p_qty", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = qty }); cmd.Parameters.Add(new OracleParameter("p_template", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 100, Value = template }); cmd.Parameters.Add(new OracleParameter("p_data", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 4000, Value = data }); cmd.Parameters.Add(new OracleParameter("p_message", OracleDbType.Varchar2) { Direction = ParameterDirection.InputOutput, Size = 500, Value = message }); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(result.Value.ToString() == "1"); }
public void IssueSernos( int documentNumber, string docType, int docLine, string partNumber, int createdBy, int quantity, int?firstSernosNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.ISSUE_SERNOS", connection) { CommandType = CommandType.StoredProcedure }; var documentNumberParameter = new OracleParameter("p_document_number", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = documentNumber }; cmd.Parameters.Add(documentNumberParameter); var documentTypeParameter = new OracleParameter("p_doc_type", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = docType, Size = 2 }; cmd.Parameters.Add(documentTypeParameter); var docLineParameter = new OracleParameter("p_doc_line", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = docLine }; cmd.Parameters.Add(docLineParameter); var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Size = 50, Value = partNumber }; cmd.Parameters.Add(partNumberParameter); var raisedByParameter = new OracleParameter("p_raised_by", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = createdBy }; cmd.Parameters.Add(raisedByParameter); var quantityParameter = new OracleParameter("p_qty", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = quantity }; cmd.Parameters.Add(quantityParameter); var firstSernosNumberParameter = new OracleParameter("p_first_sernos_number", OracleDbType.Int32) { Direction = ParameterDirection.InputOutput, Value = firstSernosNumber }; cmd.Parameters.Add(firstSernosNumberParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); }
public OracleConnection GetConnection() { return(new OracleConnection(ConnectionStrings.ManagedConnectionString())); }
public bool BuildSernos( int documentNumber, string docType, string partNumber, int docLine, int fromSerial, int toSerial, int userNumber) { var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString()); var cmd = new OracleCommand("SERNOS_PACK_V2.BUILD_SERNOS_WRAPPER", connection) { CommandType = CommandType.StoredProcedure }; var result = new OracleParameter(null, OracleDbType.Int32) { Direction = ParameterDirection.ReturnValue }; cmd.Parameters.Add(result); var documentNumberParameter = new OracleParameter("p_document_number", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = documentNumber }; cmd.Parameters.Add(documentNumberParameter); var documentTypeParameter = new OracleParameter("p_doc_type", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = docType, Size = 2 }; cmd.Parameters.Add(documentTypeParameter); var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2) { Direction = ParameterDirection.Input, Value = partNumber }; cmd.Parameters.Add(partNumberParameter); var firstSernosParameter = new OracleParameter("p_first_sernos", OracleDbType.Int32) { Direction = ParameterDirection.Input, Size = 50, Value = fromSerial }; cmd.Parameters.Add(firstSernosParameter); var lastSernosParameter = new OracleParameter("p_last_sernos", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = toSerial }; cmd.Parameters.Add(lastSernosParameter); var raisedByParameter = new OracleParameter("p_raised_by", OracleDbType.Int32) { Direction = ParameterDirection.Input, Value = userNumber }; cmd.Parameters.Add(raisedByParameter); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); return(int.Parse(result.Value.ToString()) == 1); }