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();
}
