/** * prompting the user to save their work (curently loaded patient) * */ public void saveChanges( ) { if (currentPatient != null) { DatabaseConverter manager = new DatabaseConverter(dbCon); DialogResult result; result = MessageBox.Show("Save changes for current patient?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { manager.insertPatientNote(currentPatient, notes); } if (result == System.Windows.Forms.DialogResult.No) { } notes.Clear( ); } else { } }
/** * This button (View this patient details) loads in selected patient details on the page * */ public void loadCurrentPatient( ) { cleanAll( ); if (currentPatient != null) { DatabaseConverter convert = new DatabaseConverter(dbCon, currentPatient); convert.loadList( ); history = convert.HistoryData( ); if (isDoctor == true) { prescriptionList = convert.GetPrescription( ); prescriptions = convert.PrescriptionData( ); testresultsList = convert.getTestResults( ); testresults = convert.TestResults( ); ListBoxWriter(testresults, testResultsListBox); } ListBoxWriter(prescriptions, prescriptiptionsListBox); textBoxWriter(history, historyBox); detailsBox.Text = currentPatient.FirstName + " " + currentPatient.LastName + " " + currentPatient.DOB.ToShortDateString( ) + "\nGender: " + currentPatient.Gender + "\nNext of kin: " + currentPatient.NextOfKin + "\nAddress " + currentPatient.Address; initCurrentPatientOnPrescriptionForm(currentPatient); } else { MessageBox.Show("Select patient"); } }
protected void Convert() { PaymentsManager manager = new PaymentsManager(); var xmlStream = Helper.GetResource("BodyArchitect.UnitTests.DbConverter.V4V5.BAPoints.xml"); DatabaseConverter converter = new DatabaseConverter(new BACallbackMock(), manager.Load(xmlStream)); converter.Convert(); }
public void TestMethod1() { DBConnection con = new DBConnection(); DatabaseConverter test = new DatabaseConverter(con, new Patient()); Patient p = test.findPatientByName("as", "as"); Assert.AreEqual(p.ID, 210); }
/** * initialises constructor * include time,database components * */ public void Init(DBConnection dbCon) { this.dbCon = dbCon; infoFac = new PatientFactory(dbCon); Timer timer1 = new Timer(); timer1.Start( ); converter = new DatabaseConverter(dbCon); prescriptonForm = new AddPrescription(dbCon, this); }
protected void uxUpdateConfigOnlyButton_Click(object sender, EventArgs e) { WidgetDirector widgetDirector = new WidgetDirector(); SystemConfig.UpdateNewConfigValue(widgetDirector.WidgetConfigurationCollection); DatabaseConverter convert = new DatabaseConverter(); convert.UpdateStoreConfigurations(); AdminUtilities.ClearAllCache(); uxMessageLabel.ForeColor = System.Drawing.Color.Green; uxMessageLabel.Text = "<strong>Update Config Completed</storng>"; }
public string ExecuteScalarString(IDbCommand command) { if (AutoOpenClose) { Open(); } command.Connection = SqlConnection; command.CommandTimeout = CommandTimeout; string result = DatabaseConverter.ToString(command.ExecuteScalar()); if (AutoOpenClose) { Close(); } return(result); }
public int ExecuteScalarInteger(IDbCommand command) { if (AutoOpenClose) { Open(); } command.Connection = SqlConnection; command.CommandTimeout = CommandTimeout; int result = DatabaseConverter.ToInteger(command.ExecuteScalar()); if (AutoOpenClose) { Close(); } return(result); }
public decimal ExecuteScalarDecimal(IDbCommand command) { if (AutoOpenClose) { Open(); } command.Connection = SqlConnection; command.CommandTimeout = CommandTimeout; decimal result = DatabaseConverter.ToDecimal(command.ExecuteScalar()); if (AutoOpenClose) { Close(); } return(result); }
public bool ExecuteScalarBoolean(IDbCommand command) { if (AutoOpenClose) { Open(); } command.Connection = SqlConnection; command.CommandTimeout = CommandTimeout; bool result = DatabaseConverter.ToBoolean(command.ExecuteScalar()); if (AutoOpenClose) { Close(); } return(result); }
public Guid ExecuteScalarGuid(IDbCommand command) { if (AutoOpenClose) { Open(); } command.Connection = SqlConnection; command.CommandTimeout = CommandTimeout; Guid result = DatabaseConverter.ToGuid(command.ExecuteScalar()); if (AutoOpenClose) { Close(); } return(result); }
/// <summary> /// savescreate and save a prescription into the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void prescribeButton_Click(object sender, EventArgs e) { DatabaseConverter manager = new DatabaseConverter(dbCon); DialogResult result; result = MessageBox.Show("Do you want to prescribe this medication ?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { createNewPrescription(medications[index].ScientificName.ToString()); this.Hide(); controlGP.loadCurrentPatient( ); controlGP.refreshPrescriptionList( ); } if (result == System.Windows.Forms.DialogResult.No) { } }
protected void uxExecuteButton_Click(object sender, EventArgs e) { try { if (uxExecuteText.Text != "") { AdminUtilities.RemoveAllCacheInMemory(); DatabaseConverter databaseConverter = new DatabaseConverter(); databaseConverter.OnScriptExecuting(); DataAccess.ExecuteNonQueryNoParameter(uxExecuteText.Text.Trim()); databaseConverter.OnScriptExecuted(); // Update configurations DataAccessContext.ClearConfigurationCache(); ConfigurationHelper.ApplyConfigurations(); databaseConverter.Convert(); AdminUtilities.RemoveAllCacheInMemory(); // Set up PaymentModule // PaymentModuleSetup paymentModule = new PaymentModuleSetup(); // paymentModule.ProcessDatabaseConnected(); uxMessageLabel.ForeColor = System.Drawing.Color.Green; uxMessageLabel.Text = "<strong>Upgrade Completed</storng>"; } else { DisplatError("No command to execute."); } } catch (Exception ex) { DisplatError(ex.Message); } }
public DateTime ExecuteDataTableDateTime(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? DateTime.MinValue : DatabaseConverter.ToDateTime(dataTable.Rows[0][0])); }
public bool ExecuteDataTableBoolean(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? false : DatabaseConverter.ToBoolean(dataTable.Rows[0][0])); }
public decimal ExecuteDataTableDecimal(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? 0 : DatabaseConverter.ToDecimal(dataTable.Rows[0][0])); }
public Guid ExecuteDataTableGuid(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? Guid.Empty : DatabaseConverter.ToGuid(dataTable.Rows[0][0])); }
public string ExecuteDataTableString(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? string.Empty : DatabaseConverter.ToString(dataTable.Rows[0][0])); }
public long ExecuteDataTableLong(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? 0 : DatabaseConverter.ToLong(dataTable.Rows[0][0])); }
public int ExecuteDataTableInteger(IDbCommand command) { DataTable dataTable = ExecuteDataTable(command); return(!HasRows(dataTable) ? 0 : DatabaseConverter.ToInteger(dataTable.Rows[0][0])); }