private void Process_Pawn_Locks() { OracleDataAccessor DA = GlobalDataAccessor.Instance.OracleDA; string RecordType = cbRecordType.Text; string ShopNbr = txtShop.Text.PadLeft(5, '0'); string TicketNbr = txtDetail.Text; Point mdsePoint = new Point(); string LblSearchName; bool RetVal; string msg; string TempStatus; string ErrorCode; DialogResult frmResult; Int32 nTicketNbr; mdsePoint.X = 29; mdsePoint.Y = 162; LblSearchName = "Shop / Ticket Number:"; try { nTicketNbr = Convert.ToInt32(TicketNbr); } catch { MessageBox.Show("Invalid Ticket Number"); return; } //create input parameters List <OracleProcParam> iParams = new List <OracleProcParam>(); iParams.Add(new OracleProcParam("p_shop_number", ShopNbr)); iParams.Add(new OracleProcParam("p_ticket_nbr", nTicketNbr)); iParams.Add(new OracleProcParam("o_temp_status", OracleDbType.Varchar2, DBNull.Value, ParameterDirection.Output, 20)); //execute stored procedure DataSet OutDataSet; try { RetVal = DA.issueSqlStoredProcCommand( "ccsowner", "pawn_support_locks", "get_pawnlock_record", iParams, null, "o_return_code", "o_return_text", out OutDataSet); } catch (OracleException oEx) { msg = string.Format("Invocation of get_mdse_record stored proc failed{0}{1}{0}{2}", Environment.NewLine, oEx.Message, Smsg); MessageBox.Show(msg, "Error"); return; } if (RetVal == false) { msg = DA.ErrorDescription; ErrorCode = DA.ErrorCode; if (ErrorCode == "1") { MessageBox.Show("No record found matching this search criteria.", "No Data Found", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } MessageBox.Show(msg, "Error"); return; } RetVal = OracleUtilities.GetProcedureOutput(OutDataSet, 0, out TempStatus); if (TempStatus == "null") { MessageBox.Show("No temp lock found.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } var frmClearStatus2 = new FrmClearTempStatus2( TempStatus, RecordType, // "Pawn Loan" LblSearchName, // "Shop / Ticket Number:" mdsePoint, // Screen Locaton ShopNbr, // store number TicketNbr // ticket number ); frmResult = frmClearStatus2.ShowDialog(); if (frmResult == DialogResult.Cancel) { this.Close(); } }
private void FindButton_Click(object sender, EventArgs e) { bool RetVal; string msg; //string StoreGuid; //HardwareConfig.Hardware_Config.StoreNumber = txtShop.Text; StoreNumber = txtShop.Text.PadLeft(5, '0'); if (!txtShop.isValid) // for empty string validation { MessageBox.Show(txtShop.ErrorMessage); txtShop.Select(); return; } else { OracleDataAccessor DA = GlobalDataAccessor.Instance.OracleDA; // call oracle procedure to get store guid //create input parameters var iParams = new List <OracleProcParam>(); iParams.Add(new OracleProcParam("p_shop_number", StoreNumber)); iParams.Add(new OracleProcParam("o_store_guid", OracleDbType.Varchar2, DBNull.Value, ParameterDirection.Output, 50)); //execute stored procedure DataSet OutDataSet; try { RetVal = DA.issueSqlStoredProcCommand( "ccsowner", "pawn_support_gen_procs", "get_store_guid", iParams, null, "o_return_code", "o_return_text", out OutDataSet); } catch (OracleException oEx) { msg = string.Format("Invocation of get_store_guid stored proc failed{0}{1}{0}{2}", Environment.NewLine, oEx.Message, Smsg); MessageBox.Show(msg, "Error"); return; } if (RetVal == false) { msg = DA.ErrorDescription; // error description that should show only. string ErrorCode = DA.ErrorCode; if (ErrorCode == "1") { MessageBox.Show(msg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); txtShop.Select(); return; } MessageBox.Show(msg + " -- " + ErrorCode, "Error. Please Contact Support."); return; } RetVal = OracleUtilities.GetProcedureOutput(OutDataSet, 0, out StoreGuid); if (StoreGuid == "null") { MessageBox.Show("Error Retrieving Store GUID. Please contact support.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } } //Hardware.StoreID = StoreGuid; //Hardware_Config.Instance.StoreID = StoreGuid; this.DialogResult = DialogResult.OK; this.Close(); }