private void parseProcedureStmt(TStoredProcedureSqlStatement procedureStmt)
{
if (procedureStmt.StoredProcedureName == null)
{
return;
}
ProcedureMetaData procedureMetaData = getProcedureMetaData(procedureStmt.StoredProcedureName);
procedureMetaData = getProcedureMetaData(procedureMetaData, true);
TObjectName procedureName = procedureStmt.StoredProcedureName;
procedure procedure = new procedure();
procedure.name = procedureMetaData.DisplayName;
procedure.owner = getOwnerString(procedureMetaData);
procedure.coordinate = procedureName.startToken.lineNo + "," + procedureName.startToken.columnNo;
procedure.highlightInfo = procedureName.startToken.offset + "," + (procedureName.endToken.offset - procedureName.startToken.offset + procedureName.endToken.astext.Length);
List <procedure> procedureList = getProcedureList(procedures.Item1);
procedureList.Add(procedure);
procedures.Item1.procedures = procedureList.ToArray();
parseProcedureLineage(procedureStmt, procedureMetaData, procedure);
}
public Procedures(procedure i_procedure)
{
Procedure = i_procedure;
Value = "0";
IsEnabled = true;
IsChecked = false;
}
public async Task <ActionResult> Create([Bind(Include = "ProcedureID,LongName,ShortName,VideoSource,Description")] procedure procedure)
{
HttpResponseMessage response = await client.PostAsJsonAsync(urlPath, procedure);
response.EnsureSuccessStatusCode();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "ProcedureID,LongName,ShortName,VideoSource,Description")] procedure procedure)
{
HttpResponseMessage response = await client.PutAsJsonAsync(String.Format("{0}/{1}", urlPath, procedure.ProcedureID.ToString()), procedure);
response.EnsureSuccessStatusCode();
return(RedirectToAction("Index"));
}
/// <summary>
/// Description: Limpia cada uno de los valores del procedimiento
/// </summary>
private void _clearButton_btn_Click(object sender, RoutedEventArgs e)
{
Procedures procedures = SelectFailsProcedures.Where <Procedures>(wprocedure => wprocedure.Procedure.name == "Weight and Balance").First();
procedure procedure = procedures.Procedure;
//Logic clear procedures
_textZone1_txt.Text = "";
_textZone2_txt.Text = "";
_textZone3_txt.Text = "";
_textZone4_txt.Text = "";
_textZone5_txt.Text = "";
_textZone6_txt.Text = "";
_textZoneA_txt.Text = "";
_textZoneB_txt.Text = "";
_textZoneC_txt.Text = "";
_textZoneD_txt.Text = "";
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Pounds cleared",
OkButtonContent = "Ok",
Owner = this
});
}
public static procedure FindProcedure(string procID)
{
procedure toReturn = new procedure();
DataTable results = toReturn.Search("SELECT * FROM procedures WHERE externalid = '" + procID + "'");
if (results.Rows.Count > 0)
{
toReturn.Load(results.Rows[0]);
}
return(toReturn);
}
public DataSet GetData(procedure type)
{
DataSet dsReport = new DataSet();
string strOut = string.Empty;
AseConnection oCon = new AseConnection(strCon);
try
{
string strHandler = Convert.ToString(GetFromSession("Handler"));
int intTimeout;
AseCommand oCmd = null;
if (type.Equals(procedure.FLSH_RPT))
{
oCmd = new AseCommand("FLSH_RPT", oCon);
}
if (type.Equals(procedure.DISTINCT_DTC))
{
oCmd = new AseCommand("DISTINCT_DTC", oCon);
}
oCmd.CommandType = CommandType.StoredProcedure;
intTimeout = oCmd.CommandTimeout;
oCmd.CommandTimeout = 0;
AseParameter oParam1 = new AseParameter("@recon_handle", AseDbType.VarChar, 25);
oParam1.Value = strHandler;
oCmd.Parameters.Add(oParam1);
AseDataAdapter oAseAdp = new AseDataAdapter(oCmd);
oAseAdp.Fill(dsReport);
oCmd.CommandTimeout = intTimeout;
oCmd.Dispose();
oCon.Close();
oCon.Dispose();
oCmd = null;
oCon = null;
}
catch (Exception ex)
{
log.Info("Exception occured-GetData():", ex);
oCon.Close();
oCon.Dispose();
oCon = null;
if (ex.Message == "No Flash Record found")
{
dsReport = null;
return dsReport;
}
throw;
}
return dsReport;
}
/// <summary>
/// Description: Activa el procedimiento correspondiente con el parametro digitado
/// </summary>
private void _textZone1_txt_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
if (_textZone1_txt.Text != "")
{
float value = 0;
if (float.TryParse(_textZone1_txt.Text, out value) == false)
{
_textZone1_txt.Text = "0";
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Incorrect pounds",
OkButtonContent = "Ok",
Owner = this
});
}
else
{
Procedures procedures = SelectFailsProcedures.Where <Procedures>(wprocedure => wprocedure.Procedure.name == "Weight and Balance").First();
procedure procedure = procedures.Procedure;
//Logic send procedure Zone1
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Pounds sent",
OkButtonContent = "Ok",
Owner = this
});
Keyboard.ClearFocus();
}
}
else
{
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Complete field and send Pounds",
OkButtonContent = "Ok",
Owner = this
});
}
}
}
public async Task <ActionResult> DetailsJson(int?id)
{
procedure procInfo = new procedure();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HttpResponseMessage response = await client.GetAsync(String.Format("{0}/{1}", urlPath, id.ToString()));
if (response.IsSuccessStatusCode)
{
var responseDetail = response.Content.ReadAsStringAsync().Result;
return(Json(responseDetail, JsonRequestBehavior.AllowGet));
}
return(null);
}
public async Task <ActionResult> Delete(int?id)
{
procedure procInfo = new procedure();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HttpResponseMessage response = await client.GetAsync(String.Format("{0}/{1}", urlPath, id.ToString()));
if (response.IsSuccessStatusCode)
{
var responseDetail = response.Content.ReadAsStringAsync().Result;
procInfo = JsonConvert.DeserializeObject <procedure>(responseDetail);
}
return(View(procInfo));
}
/// <summary>
/// Description: Envía el procedimiento de perdida de combustible en el tanque seleccionado
/// </summary>
private void _comboParameter_com_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Procedures procedures = SelectFailsProcedures.Where <Procedures>(wprocedure => wprocedure.Procedure.name == "Fuel leak").First();
procedures.IsChecked = true;
procedure procedure = procedures.Procedure;
//Logic send procedure
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Value sent",
OkButtonContent = "Ok",
Owner = this
});
}
private void _clearAllButton_btn_Click(object sender, RoutedEventArgs e)
{
foreach (Procedures procedures in SelectFailsProcedures)
{
procedure procedure = procedures.Procedure;
if (procedure != null)
{
//Logic clear procedures
}
}
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Values cleared",
OkButtonContent = "Ok",
Owner = this
});
}
private void RadButton_Click(object sender, RoutedEventArgs e)
{
string nameProcedure = (sender as Button).Tag.ToString();
string valueProcedure = (sender as Button).Content.ToString();
Procedures procedures = SelectFailsProcedures.Where <Procedures>(wprocedure => wprocedure.Procedure.name == nameProcedure).First();
procedure procedure = procedures.Procedure;
if (procedure != null)
{
//Logic procedure
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Value sent",
OkButtonContent = "Ok",
Owner = this
});
}
}
public static void GoImport()
{
claim workingClaim = new claim();
DataTable importData = new DataTable();
DataTable importDataSecondaries = new DataTable();
DataTable importDataPredeterms = new DataTable();
DataTable importDataSecondaryPredeterms = new DataTable();
system_options.SetImportFlag(true);
primaryClaimCount = 0;
secondaryClaimCount = 0;
predetermClaimCount = 0;
secondaryPredetermClaimCount = 0;
closedClaimCount = 0;
OleDbConnection oConnect;
//UpdateProgressBar(50, "Initiating Remote Connection...");
#region Initiate Connection, Get Data
try
{
oConnect = new OleDbConnection(dms.GetConnectionString(true));
}
catch (Exception err)
{
CreateLogFile(err.ToString());
Updateimporterror(true);
DeleteDirectoryFromTemp();
//LoggingHelper.Log("An error occurred getting the connection string for a new connection in frmImportData.Import", LogSeverity.Error, err, false);
//e.Cancel = true;
CancelImport();
return;
}
OleDbDataAdapter oAdapter;
// Use Connection object for the DataAdapter to retrieve all tables from selected Database
try
{
oConnect.Open();
}
catch (Exception err)
{
CreateLogFile(err.ToString());
Updateimporterror(true);
DeleteDirectoryFromTemp();
//LoggingHelper.Log("Could not connect to the database in frmImportdata.Import", LogSeverity.Error, err, false);
//e.Cancel = true;
CancelImport();
return;
}
try
{
//UpdateProgressBar(50, "Querying remote database (Standard)...");
// ************* Standard Claims
oAdapter = new OleDbDataAdapter(PrepareSQL(dms.sqlstatement, changesOnly), oConnect);
oAdapter.SelectCommand.CommandTimeout = System.Convert.ToInt32(dataTimeout);
oAdapter.Fill(importData);
//UpdateProgressBar(10, "Querying remote database (Secondary)...");
// ************** Secondaries
if (dms.sqlstatementsecondaries != "")
{
oAdapter = new OleDbDataAdapter(PrepareSQL(dms.sqlstatementsecondaries, changesOnly), oConnect);
oAdapter.SelectCommand.CommandTimeout = System.Convert.ToInt32(dataTimeout);
oAdapter.Fill(importDataSecondaries);
}
//UpdateProgressBar(10, "Querying remote database (Predeterms)...");
// *************** Predeterms
if (dms.sqlstatementpredeterms != "")
{
oAdapter = new OleDbDataAdapter(PrepareSQL(dms.sqlstatementpredeterms, changesOnly), oConnect);
oAdapter.SelectCommand.CommandTimeout = System.Convert.ToInt32(dataTimeout);
oAdapter.Fill(importDataPredeterms);
}
//UpdateProgressBar(10, "Querying remote database (Secondary Predeterms)...");
// *************** Predeterms
if (dms.sqlstatementsecondarypredeterms != "")
{
oAdapter = new OleDbDataAdapter(PrepareSQL(dms.sqlstatementsecondarypredeterms, changesOnly), oConnect);
oAdapter.SelectCommand.CommandTimeout = System.Convert.ToInt32(dataTimeout);
oAdapter.Fill(importDataSecondaryPredeterms);
}
}
catch (Exception err)
{
CreateLogFile(err.ToString());
Updateimporterror(true);
DeleteDirectoryFromTemp();
//LoggingHelper.Log("Error with SQL statement or connection in frmImportData.Import", LogSeverity.Error, err);
//MessageBox.Show(this, "There was an error with your SQL statement or with your connection.\n\n" + err.Message,
// "Error retrieving data");
CancelImport();
return;
}
#endregion
data_mapping_schema_data dmsd = new data_mapping_schema_data();
dmsd.schema_id = dms.id;
DataTable dataForSchema = dmsd.Search();
// Generate our list of objects one time, and then use them for each iteration of rows
List <data_mapping_schema_data> allMappedSchemaData = new List <data_mapping_schema_data>();
foreach (DataRow aMapping in dataForSchema.Rows)
{
// For every row, need to get the data for every field
dmsd = new data_mapping_schema_data();
dmsd.Load(aMapping);
allMappedSchemaData.Add(dmsd);
}
// UpdateProgressBar(100, "Importing data...");
if (okToZap)
{
company cmp = new company();
cmp.Zap();
workingClaim.Zap();
call aCall = new call();
aCall.Zap();
company_contact_info info = new company_contact_info();
info.Zap();
procedure p = new procedure();
p.Zap();
choice c = new choice();
c.Zap();
notes n = new notes();
n.Zap();
claim_batch cb = new claim_batch();
cb.Zap();
batch_claim_list bcl = new batch_claim_list();
bcl.Zap();
}
else
{
if (!changesOnly)
{
workingClaim.MarkAllImportsUpdated(false);
}
}
// Apply incremental updates to progress bar
int currentRow = 0;
totalRows = importData.Rows.Count + importDataSecondaries.Rows.Count + importDataPredeterms.Rows.Count + importDataSecondaryPredeterms.Rows.Count;
decimal exactIncrementAmount;
if (totalRows > 0)
{
exactIncrementAmount = 500m / totalRows;
}
else
{
exactIncrementAmount = 500m;
}
decimal incrementCounter = 0;
int increment;
if (exactIncrementAmount < 1)
{
increment = 1;
}
else
{
increment = Convert.ToInt32(Math.Truncate(exactIncrementAmount));
}
string lastClaimID = "";
claim aClaim = new claim();
company aCompany = new company();
company_contact_info anInfo = new company_contact_info();
procedure aProcedure = new procedure();
for (int p = 0; p < 4; p++)
{
claim.ClaimTypes ct;
DataTable thisImport;
switch (p)
{
case 0:
thisImport = importData;
ct = claim.ClaimTypes.Primary;
//UpdateLabels(0);
break;
case 1:
thisImport = importDataSecondaries;
ct = claim.ClaimTypes.Secondary;
//UpdateLabels(1);
break;
case 2:
thisImport = importDataPredeterms;
ct = claim.ClaimTypes.Predeterm;
//UpdateLabels(2);
break;
default:
thisImport = importDataSecondaryPredeterms;
//UpdateLabels(3);
ct = claim.ClaimTypes.SecondaryPredeterm;
break;
}
// Have data at this point, need to tie them to the internal mapping schema data
foreach (DataRow anImportRow in thisImport.Rows)
{
string newID = anImportRow[dms.claim_id_column].ToString();
string newDB = anImportRow[dms.claim_db_column].ToString();
bool isOnlyProcedureData;
if (newID == lastClaimID)
{
// We're only dealing with the import of "some" data
isOnlyProcedureData = true;
}
else
{
if (ct == claim.ClaimTypes.Primary)
{
primaryClaimCount++;
}
else if (ct == claim.ClaimTypes.Secondary)
{
secondaryClaimCount++;
}
else if (ct == claim.ClaimTypes.Predeterm)
{
predetermClaimCount++;
}
else
{
secondaryPredetermClaimCount++;
}
//UpdateTypeCount();
aClaim = FindClaim(anImportRow, ct);
aCompany = FindCompany(anImportRow[dms.company_namecolumn].ToString());
anInfo = FindContactInfo(anImportRow["Ins_Co_Street1"].ToString(), aCompany.id, anImportRow["Ins_Co_Phone"].ToString());
lastClaimID = newID;
aClaim.ClearClaimProcedures();
isOnlyProcedureData = false;
// Check for "X" in provider field
try
{
if (aClaim.doctor_provider_id.StartsWith("X"))
{
AddStatus(string.Format("The claim for patient {0} on {1} uses an X provider ({2})", aClaim.PatientName, aClaim.DatesOfServiceString(), aClaim.doctor_provider_id), true, true);
}
}
catch (Exception err)
{
CreateLogFile(err.ToString());
Updateimporterror(true);
DeleteDirectoryFromTemp();
//LoggingHelper.Log(err, false);
}
}
aProcedure = FindProcedure(anImportRow["PROC_LOGID"].ToString());
if (CommonFunctions.DBNullToString(anImportRow["DATERECEIVED"]) == "")
{
aClaim.open = 1;
}
else if (((DateTime)anImportRow["DATERECEIVED"]).Year == 1753)
{
aClaim.open = 1;
}
else
{
aClaim.open = 0;
UpdateStatusHistory(aClaim);
}
foreach (data_mapping_schema_data aMappedData in allMappedSchemaData)
{
// We do a check for is only procedure data to speed up processing
// It makes the code a little messier.
if (isOnlyProcedureData)
{
// If we're only importing the procedure data, none of the other information is important
if ((aMappedData.LinkedField.table_name == "claims") ||
(aMappedData.LinkedField.table_name == "companies") ||
(aMappedData.LinkedField.table_name == "company_contact_info"))
{
// Ignore
}
else if (aMappedData.LinkedField.table_name == "procedures")
{
if (aMappedData.LinkedField.field_name == "surf_string")
{
aProcedure[aMappedData.LinkedField.field_name] = CommonFunctions.RemoveNonPrintableCharacters(anImportRow[aMappedData.mapped_to_text].ToString());
}
else if (aMappedData.LinkedField.field_name == "claim_id")
{
aProcedure["claim_id"] = lastClaimID;
}
else
{
aProcedure[aMappedData.LinkedField.field_name] = anImportRow[aMappedData.mapped_to_text];
}
}
else
{
//LoggingHelper.Log("Uninitialized table name in frmImportData.Import", LogSeverity.Critical,
// new Exception("Uninitialized table name in import procedure."), true);
}
}
else
{
// This is a new claim - we need to get the data for every field
if (aMappedData.LinkedField.table_name == "claims")
{
aClaim[aMappedData.LinkedField.field_name] = anImportRow[aMappedData.mapped_to_text];
}
else if (aMappedData.LinkedField.table_name == "companies")
{
if (aMappedData.mapped_to_text != dms.company_namecolumn)
{
aCompany[aMappedData.LinkedField.field_name] = anImportRow[aMappedData.mapped_to_text];
}
}
else if (aMappedData.LinkedField.table_name == "company_contact_info")
{
anInfo[aMappedData.LinkedField.field_name] = anImportRow[aMappedData.mapped_to_text];
}
else if (aMappedData.LinkedField.table_name == "procedures")
{
if (aMappedData.LinkedField.field_name == "surf_string")
{
aProcedure[aMappedData.LinkedField.field_name] = CommonFunctions.RemoveNonPrintableCharacters(anImportRow[aMappedData.mapped_to_text].ToString());
}
else
{
aProcedure[aMappedData.LinkedField.field_name] = anImportRow[aMappedData.mapped_to_text];
}
}
else
{
//LoggingHelper.Log("Uninitialized table name in frmImport.Import", LogSeverity.Critical);
//throw new Exception("Uninitialized table name in import procedure.");
}
}
}
aCompany.Save();
anInfo.company_id = aCompany.id;
if (CommonFunctions.DBNullToZero(anInfo["order_id"]) == 0)
{
anInfo.order_id = anInfo.GetNextOrderID();
}
anInfo.Save();
aClaim.company_id = aCompany.id;
aClaim.company_address_id = anInfo.order_id;
aClaim["import_update_flag"] = true;
aClaim.Save();
if (p == 0 || p == 2 || p == 3) // Only update the id if this is the primary claim or a predeterm
{
aProcedure.claim_id = aClaim.id;
}
aProcedure.Save();
currentRow++;
if (Math.Truncate(incrementCounter + exactIncrementAmount) != Math.Truncate(incrementCounter))
{
//UpdateProgressBar(increment, string.Format("{0} / {1} procedures completed...", currentRow, totalRows), false);
}
incrementCounter += exactIncrementAmount;
}
}
if (changesOnly)
{
// Grab all the deleted claims and mark them as closed here
// Add a note that they have been deleted, I guess
string deletedClaimsSQL = "SELECT CLAIMID, CLAIMDB " +
"FROM AUDIT_DDB_CLAIM " +
"WHERE N_CLAIMID is null " +
"AND CLAIMID is not null AND CLAIMDB is not null " +
"AND date_changed >= '" + lastWrite.ToString("G") + "'";
DataTable deletedClaims = new DataTable();
OleDbCommand cmd = new OleDbCommand(deletedClaimsSQL, oConnect);
cmd.CommandTimeout = 90;
oAdapter = new OleDbDataAdapter(cmd);
oAdapter.Fill(deletedClaims);
//UpdateProgressBar(5, "Updating Local Status for Deleted Claims...");
foreach (DataRow aDeletedClaim in deletedClaims.Rows)
{
// Close the claims
DataTable matches = aClaim.Search("SELECT * FROM claims WHERE claimidnum = '" + aDeletedClaim["claimid"] +
"' and claimdb = '" + aDeletedClaim["claimdb"] + "'");
if (matches.Rows.Count > 0)
{
// This should honestly not load every claim
aClaim = new claim();
aClaim.Load(matches.Rows[0]);
aClaim.open = 0;
aClaim.Save();
UpdateStatusHistory(aClaim);
closedClaimCount++;
}
}
}
else
{
closedClaimCount = workingClaim.CloseClaimsWithoutUpdate();
}
//UpdateLabels(4);
workingClaim.FixRevisitDateAfterImport();
system_options.SetLastImportDate(DateTime.Now);
ShowLastImportDate();
AddStatus("The import completed successfully! " + totalRows + " rows were imported.");
AddReportMessage(string.Format("The import completed successfully!\nPrimary: {0}\nSecondary: {1}\n" +
"Predeterm: {2}\nSecondary Predeterm: {3}\nTotal Open Claims: {4}", primaryClaimCount, secondaryClaimCount, predetermClaimCount, secondaryPredetermClaimCount,
primaryClaimCount + secondaryClaimCount + predetermClaimCount + secondaryPredetermClaimCount));
try
{
string importFileName = Application.StartupPath + "\\Imports\\" + DateTime.Now.ToString("yyyy-MM-dd hh-mm-ss") + " import.rtf";
//Directory.CreateDirectory(Path.GetDirectoryName(importFileName));
//rtxtReport.SaveFile(importFileName);
saveFileFromTemp();
DeleteDirectoryFromTemp();
CreateLogFile("Import Successfully.");
Updateimporterror(false);
}
catch (Exception ex) {
CreateLogFile(ex.ToString());
Updateimporterror(true);
DeleteDirectoryFromTemp();
//LoggingHelper.Log("Error creating import report file.", LogSeverity.Error, ex, false);
}
}
public void ExecuteData(procedure type, string flashAcctNum, string dtcAcctNum)
{
AseConnection oCon = new AseConnection(strCon);
try
{
string strHandler = Convert.ToString(GetFromSession("Handler"));
int intTimeout;
AseCommand oCmd=null;
if (type.Equals(procedure.ADD_FLSH))
{
oCmd = new AseCommand("ADD_FLSH", oCon);
AseParameter oParam0 = new AseParameter("@recon_handle", AseDbType.VarChar, 25);
oParam0.Value = strHandler;
oCmd.Parameters.Add(oParam0);
}
if (type.Equals(procedure.RemoveMapping))
{
oCmd = new AseCommand("RemoveMapping", oCon);
AseParameter oParam0 = new AseParameter("@recon_handle", AseDbType.VarChar, 25);
oParam0.Value = strHandler;
oCmd.Parameters.Add(oParam0);
}
oCmd.CommandType = CommandType.StoredProcedure;
intTimeout = oCmd.CommandTimeout;
oCmd.CommandTimeout = 0;
AseParameter oParam1 = new AseParameter("@flash_number", AseDbType.VarChar, 25);
oParam1.Value = flashAcctNum;
oCmd.Parameters.Add(oParam1);
AseParameter oParam2 = new AseParameter("@dtc_number", AseDbType.VarChar, 25);
oParam2.Value = dtcAcctNum;
oCmd.Parameters.Add(oParam2);
oCon.Open();
oCmd.ExecuteNonQuery();
oCmd.CommandTimeout = intTimeout;
oCmd.Dispose();
oCon.Close();
oCon.Dispose();
oCmd = null;
oCon = null;
}
catch (Exception ex)
{
log.Info("Exception occured-ExeuteData():", ex);
oCon.Close();
oCon.Dispose();
oCon = null;
throw;
}
}
private void parseProcedureLineage(TStoredProcedureSqlStatement procedureStmt, ProcedureMetaData procedureMetaData, procedure sourceProcedure)
{
functionVisitor fv = new functionVisitor(this, procedureMetaData, sourceProcedure);
procedureStmt.acceptChildren(fv);
}
public functionVisitor(ProcedureRelationScanner outerInstance, ProcedureMetaData parentProcedure, procedure procedure)
{
this.outerInstance = outerInstance;
this.parentProcedure = parentProcedure;
this.targetProcedure = new targetProcedure();
targetProcedure.coordinate = procedure.coordinate;
targetProcedure.highlightInfo = procedure.highlightInfo;
targetProcedure.name = procedure.name;
targetProcedure.owner = procedure.owner;
List <targetProcedure> targetProcedureList = getTargetProcedureList(outerInstance.procedures.Item1);
targetProcedureList.Add(targetProcedure);
outerInstance.procedures.Item1.targetProcedures = targetProcedureList.ToArray();
}
/// <summary>
/// Description: Envía el valor configurado para el procedimiento
/// </summary>
private void _textValue_tex_KeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
if (_textValue_tex.Text != "")
{
float fuelQty = 0;
if (float.TryParse(_textValue_tex.Text, out fuelQty) == false)
{
_textValue_tex.Text = "0";
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Incorrect value",
OkButtonContent = "Ok",
Owner = this
});
}
else
{
if (fuelQty <= 160)
{
Procedures procedures = SelectFailsProcedures.Where <Procedures>(wprocedure => wprocedure.Procedure.name == "Fuel Qty").First();
procedure procedure = procedures.Procedure;
if (_leftCheckbox_che.IsChecked == true)
{
procedures.IsChecked = true;
procedures.Value = _textValue_tex.Text;
//Logic send procedure Left
}
else
{
if (_rightCheckbox_che.IsChecked == true)
{
procedures.IsChecked = true;
procedures.Value = _textValue_tex.Text;
//Logic send procedure Right
}
else
{
if (_bothCheckbox_che.IsChecked == true)
{
procedures.IsChecked = true;
procedures.Value = _textValue_tex.Text;
//Logic send procedure Both
}
else
{
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Select a option and send Value",
OkButtonContent = "Ok",
Owner = this
});
}
}
}
if (_leftCheckbox_che.IsChecked == true || _rightCheckbox_che.IsChecked == true || _bothCheckbox_che.IsChecked == true)
{
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Value sent",
OkButtonContent = "Ok",
Owner = this
});
Keyboard.ClearFocus();
}
}
else
{
_textValue_tex.Text = "0";
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "160 gal max",
OkButtonContent = "Ok",
Owner = this
});
}
}
}
else
{
RadWindow.Alert(new DialogParameters
{
Header = "Alert",
Content = "Complete value field and send Value",
OkButtonContent = "Ok",
Owner = this
});
}
}
}
public DataSet GetData(procedure type, string flashAcctNum,string dtcAcctNum)
{
DataSet dsReport = new DataSet();
string strOut = string.Empty;
string strCon = ConfigurationSettings.AppSettings["ConnectionSybaseMCM_STAGE"];
AseConnection oCon = new AseConnection(strCon);
try
{
string strHandler = Convert.ToString(GetFromSession("Handler"));
int intTimeout;
AseCommand oCmd = null;
if (type.Equals(procedure.SEARCH_FLSH_SINGLE))//Equity trades
{
oCmd = new AseCommand("SEARCH_FLSH_SINGLE", oCon);
AseParameter oParam2 = new AseParameter("@flash_number", AseDbType.VarChar, 25);
oParam2.Value = flashAcctNum;
oCmd.Parameters.Add(oParam2);
AseParameter oParam1 = new AseParameter("@dtc_number", AseDbType.VarChar, 25);
oParam1.Value = dtcAcctNum;
oCmd.Parameters.Add(oParam1);
}
if (type.Equals(procedure.SEARCH_NONACTIVE))//Equity trades
{
oCmd = new AseCommand("SEARCH_NotActive", oCon);
AseParameter oParam2 = new AseParameter("@flash_number", AseDbType.VarChar, 25);
oParam2.Value = flashAcctNum;
oCmd.Parameters.Add(oParam2);
AseParameter oParam1 = new AseParameter("@dtc_number", AseDbType.VarChar, 25);
oParam1.Value = dtcAcctNum;
oCmd.Parameters.Add(oParam1);
}
oCmd.CommandType = CommandType.StoredProcedure;
intTimeout = oCmd.CommandTimeout;
oCmd.CommandTimeout = 0;
AseParameter oParam0 = new AseParameter("@recon_handle", AseDbType.VarChar, 25);
oParam0.Value = strHandler;
oCmd.Parameters.Add(oParam0);
AseDataAdapter oAseAdp = new AseDataAdapter(oCmd);
oAseAdp.Fill(dsReport);
oCmd.CommandTimeout = intTimeout;
oCmd.Dispose();
oCon.Close();
oCon.Dispose();
oCmd = null;
oCon = null;
}
catch (Exception ex)
{
log.Info("Exception occured-GetData():", ex);
oCon.Close();
oCon.Dispose();
oCon = null;
if (ex.Message == "No Flash Record found")
{
dsReport = null;
return dsReport;
}
throw;
}
return dsReport;
}
public void ExecuteData(procedure type, string forFlashValue, string dtcTicket, string flashTicket, string updatedDtcValue)
{
AseConnection oCon = new AseConnection(strCon);
try
{
string strHandler = Convert.ToString(GetFromSession("Handler"));
int intTimeout;
AseCommand oCmd = null;
if (type.Equals(procedure.UpdateMappingBoth))
{
oCmd = new AseCommand("UpdateMappingForBoth", oCon);
AseParameter oParam3 = new AseParameter("@newFlash_number", AseDbType.VarChar, 25);
oParam3.Value = flashTicket;
oCmd.Parameters.Add(oParam3);
AseParameter oParam4 = new AseParameter("@newDtc_number", AseDbType.VarChar, 25);
oParam4.Value = updatedDtcValue;
oCmd.Parameters.Add(oParam4);
}
oCmd.CommandType = CommandType.StoredProcedure;
intTimeout = oCmd.CommandTimeout;
oCmd.CommandTimeout = 0;
AseParameter oParam1 = new AseParameter("@flash_number", AseDbType.VarChar, 25);
oParam1.Value = forFlashValue;
oCmd.Parameters.Add(oParam1);
AseParameter oParam2 = new AseParameter("@dtc_number", AseDbType.VarChar, 25);
oParam2.Value = dtcTicket;
oCmd.Parameters.Add(oParam2);
oCon.Open();
oCmd.ExecuteNonQuery();
oCmd.CommandTimeout = intTimeout;
oCmd.Dispose();
oCon.Close();
oCon.Dispose();
oCmd = null;
oCon = null;
}
catch (Exception ex)
{
log.Info("Exception occured-Exeute Data():", ex);
oCon.Close();
oCon.Dispose();
oCon = null;
throw;
}
}
