/// <summary>
/// Inserts the visit.
/// </summary>
/// <param name="visit">The visit.</param>
/// <returns></returns>
public override VisitData InsertVisit(VisitData visit)
{
VisitData visitLocal = base.InsertVisit(visit);
if (visitLocal != null) {
if (visitBuffer != null) {
visitBuffer.Add(visitLocal); // Add new visit also to buffer
}
return visitLocal;
} else {
return null;
}
}
/// <summary>
/// Updates the visit.
/// </summary>
/// <param name="visitData">The visit data.</param>
/// <returns></returns>
public virtual bool UpdateVisit(VisitData visitData)
{
IVisit visitDB = Database.CreateVisit();
return visitDB.Update(visitData);
}
/// <summary>
/// Updates the visit.
/// </summary>
/// <param name="visitData">The visit data.</param>
/// <returns></returns>
public override bool UpdateVisit(VisitData visitData)
{
bool ok = base.UpdateVisit(visitData);
if (ok && visitBuffer != null) { // update in buffer as well
visitBuffer.Remove(visitData);
visitBuffer.Add(visitData);
}
return ok;
}
public void VisitFindByPatientTest()
{
IVisit visitDB = Database.CreateVisit();
VisitData visit1 = new VisitData(0, "good Cause", "lokkkalis", "extra Diagnossses", "procedurrre", "extratherapie", pID, DateTime.Now, "anest...", "ultrasound", "blooood", "Todo", "Radiodiagnasdn");
long vID1 = visitDB.Insert(visit1);
VisitData visitWithID1 = new VisitData(vID1, visit1.Cause, visit1.Localis, visit1.ExtraDiagnosis, visit1.Procedure, visit1.ExtraTherapy, pID, visit1.VisitDate, visit1.Anesthesiology, visit1.Ultrasound, visit1.Blooddiagnostic, visit1.Todo, visit1.Radiodiagnostics);
VisitData visit2 = new VisitData(0, "asdfg", "nkjbjhbhj", "ejhij", "aölsdfjöasj", "laksdjalksd", pID, new DateTime(2007, 12, 01), "ikouhz...", "döner", "kljhg", "asdas", "asdasfd");
long vID2 = visitDB.Insert(visit2);
VisitData visitWithID2 = new VisitData(vID2, visit2.Cause, visit2.Localis, visit2.ExtraDiagnosis, visit2.Procedure, visit2.ExtraTherapy, pID, visit2.VisitDate, visit2.Anesthesiology, visit2.Ultrasound, visit2.Blooddiagnostic, visit2.Todo, visit2.Radiodiagnostics);
VisitData visit3 = new VisitData(0, "öloiu", "kjhsbdklsw", "üüpüpü", "asüdkpasüd", "+*a", pID, new DateTime(2007, 12, 02), "pooip", "saddsf", "bloooodüüü", "todoooo", "Radioooo");
long vID3 = visitDB.Insert(visit3);
VisitData visitWithID3 = new VisitData(vID3, visit3.Cause, visit3.Localis, visit3.ExtraDiagnosis, visit3.Procedure, visit3.ExtraTherapy, pID, visit3.VisitDate, visit3.Anesthesiology, visit3.Ultrasound, visit3.Blooddiagnostic, visit3.Todo, visit3.Radiodiagnostics);
IList<VisitData> visits = visitDB.FindByPatientID(pID);
Assert.AreEqual(3, visits.Count);
foreach (VisitData visit in visits) {
Assert.IsTrue(visitDB.Delete(visit.Id));
}
visits = visitDB.FindByPatientID(pID);
Assert.AreEqual(0, visits.Count);
}
/// <summary>
/// Inserts the visit.
/// </summary>
/// <param name="visit">The visit.</param>
/// <returns></returns>
public virtual VisitData InsertVisit(VisitData visit)
{
IVisit visitDB = Database.CreateVisit();
long id = visitDB.Insert(visit);
if (id != 0) {
visit.Id = id;
return visit;
} else {
return null;
}
}
/// <summary>
/// Adds the visit.
/// </summary>
/// <param name="visit">The visit.</param>
public void addVisit(VisitData visit)
{
if (visits == null) {
visits = new List<VisitData>();
}
visits.Add(visit);
}
public bool Update(VisitData visit)
{
try {
long tstart = DateTime.Now.Ticks;
DbUtil.OpenConnection();
if (updateByIdCmd == null) {
updateByIdCmd = DbUtil.CreateCommand(SQL_UPDATE_BY_ID, DbUtil.CurrentConnection);
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@cause", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@localis", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@extradiagnosis", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@prozedure", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@extratherapy", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@anesthesiology", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@ultrasound", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@blooddiagnostic", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@todo", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@radiodiagnostics", DbType.String));
updateByIdCmd.Parameters.Add(DbUtil.CreateParameter("@VisitID", DbType.Int64));
}
((IDataParameter)updateByIdCmd.Parameters["@cause"]).Value = visit.Cause;
((IDataParameter)updateByIdCmd.Parameters["@localis"]).Value = visit.Localis;
((IDataParameter)updateByIdCmd.Parameters["@extradiagnosis"]).Value = visit.ExtraDiagnosis;
((IDataParameter)updateByIdCmd.Parameters["@prozedure"]).Value = visit.Procedure;
((IDataParameter)updateByIdCmd.Parameters["@extratherapy"]).Value = visit.ExtraTherapy;
((IDataParameter)updateByIdCmd.Parameters["@anesthesiology"]).Value = visit.Anesthesiology;
((IDataParameter)updateByIdCmd.Parameters["@ultrasound"]).Value = visit.Ultrasound;
((IDataParameter)updateByIdCmd.Parameters["@blooddiagnostic"]).Value = visit.Blooddiagnostic;
((IDataParameter)updateByIdCmd.Parameters["@todo"]).Value = visit.Todo;
((IDataParameter)updateByIdCmd.Parameters["@radiodiagnostics"]).Value = visit.Radiodiagnostics;
((IDataParameter)updateByIdCmd.Parameters["@VisitID"]).Value = visit.Id;
bool ok = updateByIdCmd.ExecuteNonQuery() == 1;
long tend = DateTime.Now.Ticks;
log.Info("Update Visit: " + visit.Id + " " + ok + " " + ((tend - tstart) / 10000) + "ms");
return ok;
} catch (Exception e) {
log.Error(e.Message);
throw e;
} finally {
DbUtil.CloseConnection();
}
}
/// <summary>
/// Compares the visits by date.
/// </summary>
/// <param name="x">The VisitData 1</param>
/// <param name="y">The VisitData 2</param>
/// <returns></returns>
private static int CompareVisitsByDate(VisitData x, VisitData y)
{
if (x == null) {
if (y == null) {
return 0;
} else {
return -1;
}
} else {
if (y == null) {
return 1;
} else {
int comp = x.VisitDate.CompareTo(y.VisitDate);
if (comp == 0) {
return x.Id.CompareTo(y.Id);
} else {
return comp;
}
}
}
}
private VisitData createRandomVisit(long pId)
{
VisitData visit = new VisitData();
visit.PatientId = pId;
visit.Anesthesiology = getRandomString(10, 50, true);
visit.Blooddiagnostic = getRandomString(5, 40, true);
visit.Cause = getRandomString(10, 45, true);
visit.ExtraDiagnosis = getRandomString(15, 60, true);
visit.ExtraTherapy = getRandomString(15, 60, true);
visit.Localis = getRandomString(5, 30, true);
visit.Procedure = getRandomString(3, 45, true);
visit.Radiodiagnostics = getRandomString(10, 40, true);
visit.Todo = getRandomString(0, 50, true);
visit.Ultrasound = getRandomString(10, 20, true);
visit.VisitDate = new DateTime(DateTime.Now.Year - 8 + rand.Next(0,9), rand.Next(1, 13), rand.Next(1, 28));
return visit;
}
/// <summary>
/// Parses the Visits.
/// </summary>
/// <param name="jsonVisits">The json visits.</param>
/// <returns></returns>
private static IList<VisitData> parseVisits(ArrayList jsonVisits)
{
IList<VisitData> visitList = new List<VisitData>();
foreach (Hashtable htvisit in jsonVisits) {
VisitData visit = new VisitData();
if (htvisit.ContainsKey(visit_VisitID)) {
visit.Id = Convert.ToInt64(htvisit[visit_VisitID]);
}
if (htvisit.ContainsKey(visit_cause)) {
visit.Cause = Convert.ToString(htvisit[visit_cause]);
}
if (htvisit.ContainsKey(visit_localis)) {
visit.Localis = Convert.ToString(htvisit[visit_localis]);
}
if (htvisit.ContainsKey(visit_extradiagnosis)) {
visit.ExtraDiagnosis = Convert.ToString(htvisit[visit_extradiagnosis]);
}
if (htvisit.ContainsKey(visit_prozedure)) {
visit.Procedure = Convert.ToString(htvisit[visit_prozedure]);
}
if (htvisit.ContainsKey(visit_extratherapy)) {
visit.ExtraTherapy = Convert.ToString(htvisit[visit_extratherapy]);
}
if (htvisit.ContainsKey(visit_patientid)) {
visit.PatientId = Convert.ToInt64(htvisit[visit_patientid]);
}
if (htvisit.ContainsKey(visit_visitdate)) {
visit.VisitDate = DateTime.Parse(Convert.ToString(htvisit[visit_visitdate]), DateTimeFormatInfo.InvariantInfo);
}
if (htvisit.ContainsKey(visit_anesthesiology)) {
visit.Anesthesiology = Convert.ToString(htvisit[visit_anesthesiology]);
}
if (htvisit.ContainsKey(visit_ultrasound)) {
visit.Ultrasound = Convert.ToString(htvisit[visit_ultrasound]);
}
if (htvisit.ContainsKey(visit_blooddiagnostic)) {
visit.Blooddiagnostic = Convert.ToString(htvisit[visit_blooddiagnostic]);
}
if (htvisit.ContainsKey(visit_radiodiagnostics)) {
visit.Radiodiagnostics = Convert.ToString(htvisit[visit_radiodiagnostics]);
}
visitList.Add(visit);
}
return visitList;
}
/// <summary>
/// Initializes a new instance of the <see cref="VisitChangeEventArgs"/> class.
/// </summary>
/// <param name="visit">The visit.</param>
public VisitChangeEventArgs(VisitData visit)
{
this.visit = visit;
}
/// <summary>
///
/// </summary>
/// <param name="visit"> the visit</param>
/// <param name="nextScreen">next screen</param>
public NewVisitStoreEventArgs(VisitData visit, NextScreen nextScreen)
{
this.visit = visit;
this.nextScreen = nextScreen;
}
/// <summary>
/// Initts the specified visit.
/// </summary>
/// <param name="visit">The visit.</param>
public void Init(VisitData visit)
{
this.visit = visit;
this.Clear();
if ((visit != null) && (currentPatient != null)){
if (currentPatient.Id != visit.PatientId){
MessageBox.Show("Fehler im Programm bitte Gassi melden!!");
}
}
if (currentPatient != null) {
labelPatientInfo.Text = currentPatient.Id + " " +
currentPatient.FirstName + " " +
currentPatient.SurName;
} else {
labelPatientInfo.Text = "";
}
if (visit != null){
textBoxCauseOfVisit.Text = visit.Cause;
textBoxDiagnosis.Text = visit.ExtraDiagnosis;
textBoxTherapy.Text = visit.ExtraTherapy;
textBoxStatusLocalis.Text = visit.Localis;
textBoxProcedure.Text = visit.Procedure;
textBoxAnesthesiology.Text = visit.Anesthesiology;
textBoxUltrasound.Text = visit.Ultrasound;
textBoxBlooddiagnostic.Text = visit.Blooddiagnostic;
textBoxTodo.Text = visit.Todo;
textBoxRadiodiagnostics.Text = visit.Radiodiagnostics;
}else{
}
}
private VisitData fillVisitData(IDataReader rdr)
{
VisitData visit = new VisitData();
visit.Id = Convert.ToInt64(rdr["VisitID"]);
visit.Cause = Convert.ToString(rdr["cause"]);
visit.Localis = Convert.ToString(rdr["localis"]);
visit.ExtraDiagnosis = Convert.ToString(rdr["extradiagnosis"]);
visit.Procedure = Convert.ToString(rdr["prozedure"]);
visit.ExtraTherapy = Convert.ToString(rdr["extratherapy"]);
visit.PatientId = Convert.ToInt64(rdr["patientid"]);
visit.VisitDate = DateTime.Parse((string)rdr["visitdate"], DateTimeFormatInfo.InvariantInfo);
visit.Anesthesiology = Convert.ToString(rdr["anesthesiology"]);
visit.Ultrasound = Convert.ToString(rdr["ultrasound"]);
visit.Blooddiagnostic = Convert.ToString(rdr["blooddiagnostic"]);
visit.Todo = Convert.ToString(rdr["todo"]);
visit.Radiodiagnostics = Convert.ToString(rdr["radiodiagnostics"]);
return visit;
}
/// <summary>
/// Inserts the visit.
/// </summary>
/// <param name="visit">The visit.</param>
/// <returns></returns>
public VisitData InsertVisit(VisitData visit)
{
using (ChannelFactory<ISPDBL> cf = new ChannelFactory<ISPDBL>(binding,endpointAddress)) {
ISPDBL spdBL = cf.CreateChannel();
return spdBL.InsertVisit(visit);
}
}
public void VisitInsertTest()
{
IVisit visitDB = Database.CreateVisit();
VisitData visit = new VisitData(0, "good Cause", "lokkkalis", "extra Diagnossses", "procedurrre", "extratherapie", pID, DateTime.Now, "anest...", "ultrasound", "blooood", "ToDo", "Radiodiagnostic");
long vID = visitDB.Insert(visit);
VisitData visitWithID = new VisitData(vID, visit.Cause, visit.Localis, visit.ExtraDiagnosis, visit.Procedure, visit.ExtraTherapy, pID, visit.VisitDate, visit.Anesthesiology, visit.Ultrasound, visit.Blooddiagnostic, visit.Todo, visit.Radiodiagnostics);
visit = visitDB.FindByID(vID);
Assert.AreEqual(visit.Anesthesiology, visitWithID.Anesthesiology);
Assert.AreEqual(visit.Blooddiagnostic, visitWithID.Blooddiagnostic);
Assert.AreEqual(visit.Cause, visitWithID.Cause);
Assert.AreEqual(visit.ExtraDiagnosis, visitWithID.ExtraDiagnosis);
Assert.AreEqual(visit.ExtraTherapy, visitWithID.ExtraTherapy);
Assert.AreEqual(visit.Id, vID);
Assert.AreEqual(visit.Localis, visitWithID.Localis);
Assert.AreEqual(visit.PatientId, pID);
Assert.AreEqual(visit.Procedure, visitWithID.Procedure);
Assert.AreEqual(visit.Ultrasound, visitWithID.Ultrasound);
Assert.AreEqual(visit.VisitDate.ToShortDateString(), visitWithID.VisitDate.ToShortDateString());
Assert.AreEqual(visit.VisitDate.ToShortTimeString(), visitWithID.VisitDate.ToShortTimeString());
Assert.AreEqual(visit.Todo, visitWithID.Todo);
Assert.AreEqual(visit.Radiodiagnostics, visitWithID.Radiodiagnostics);
Assert.IsTrue(visitDB.Delete(vID));
Assert.IsNull(visitDB.FindByID(vID));
}
/// <summary>
/// Updates the visit.
/// </summary>
/// <param name="visitData">The visit data.</param>
/// <returns></returns>
public bool UpdateVisit(VisitData visitData)
{
using (ChannelFactory<ISPDBL> cf = new ChannelFactory<ISPDBL>(binding,endpointAddress)) {
ISPDBL spdBL = cf.CreateChannel();
return spdBL.UpdateVisit(visitData);
}
}
public void VisitUpdateTest()
{
IVisit visitDB = Database.CreateVisit();
VisitData visit = new VisitData(0, "good Cause", "lokkkalis", "extra Diagnossses", "procedurrre", "extratherapie", pID, DateTime.Now, "anest...", "ultrasound", "blooood", "ToDo", "Radiodiagnostic");
long vID = visitDB.Insert(visit);
VisitData visitWithID = new VisitData(vID, visit.Cause, visit.Localis, visit.ExtraDiagnosis, visit.Procedure, visit.ExtraTherapy, pID, visit.VisitDate, visit.Anesthesiology, visit.Ultrasound, visit.Blooddiagnostic, visit.Todo, visit.Radiodiagnostics);
visit = visitDB.FindByID(vID);
Assert.AreEqual(visit.Anesthesiology, visitWithID.Anesthesiology);
Assert.AreEqual(visit.Blooddiagnostic, visitWithID.Blooddiagnostic);
Assert.AreEqual(visit.Cause, visitWithID.Cause);
Assert.AreEqual(visit.ExtraDiagnosis, visitWithID.ExtraDiagnosis);
Assert.AreEqual(visit.ExtraTherapy, visitWithID.ExtraTherapy);
Assert.AreEqual(visit.Id, vID);
Assert.AreEqual(visit.Localis, visitWithID.Localis);
Assert.AreEqual(visit.PatientId, pID);
Assert.AreEqual(visit.Procedure, visitWithID.Procedure);
Assert.AreEqual(visit.Ultrasound, visitWithID.Ultrasound);
Assert.AreEqual(visit.VisitDate.ToShortDateString(), visitWithID.VisitDate.ToShortDateString());
Assert.AreEqual(visit.VisitDate.ToShortTimeString(), visitWithID.VisitDate.ToShortTimeString());
Assert.AreEqual(visit.Todo, visitWithID.Todo);
Assert.AreEqual(visit.Radiodiagnostics, visitWithID.Radiodiagnostics);
visit.Anesthesiology = "new ana";
visit.Blooddiagnostic = "New Blood diag";
visit.Cause = "new cause";
visit.ExtraDiagnosis = "New Extra Diagnoses";
visit.ExtraTherapy = "new Extra Therapy";
visit.Localis = "new localis";
visit.Procedure = "new procedure";
visit.Radiodiagnostics = "new Radiodiagnostics";
visit.Todo = "new TODO";
visit.Ultrasound = "new Ultrasound";
visit.VisitDate = DateTime.MaxValue;
visitDB.Update(visit);
VisitData visitchanged = visitDB.FindByID(vID);
Assert.AreEqual(visit.Anesthesiology, visitchanged.Anesthesiology);
Assert.AreEqual(visit.Blooddiagnostic, visitchanged.Blooddiagnostic);
Assert.AreEqual(visit.Cause, visitchanged.Cause);
Assert.AreEqual(visit.ExtraDiagnosis, visitchanged.ExtraDiagnosis);
Assert.AreEqual(visit.ExtraTherapy, visitchanged.ExtraTherapy);
Assert.AreEqual(visit.Id, vID);
Assert.AreEqual(visit.Localis, visitchanged.Localis);
Assert.AreEqual(visit.PatientId, pID);
Assert.AreEqual(visit.Procedure, visitchanged.Procedure);
Assert.AreEqual(visit.Ultrasound, visitchanged.Ultrasound);
//Visit Date cannot be updated!!
//Assert.AreEqual(visit.VisitDate.ToShortDateString(), visitchanged.VisitDate.ToShortDateString());
//Assert.AreEqual(visit.VisitDate.ToShortTimeString(), visitchanged.VisitDate.ToShortTimeString());
Assert.AreEqual(visit.Todo, visitchanged.Todo);
Assert.AreEqual(visit.Radiodiagnostics, visitchanged.Radiodiagnostics);
Assert.IsTrue(visitDB.Delete(vID));
Assert.IsNull(visitDB.FindByID(vID));
}
private static String visitTherapy(VisitData visit)
{
if (visit == null || String.IsNullOrEmpty(visit.ExtraTherapy)) {
return String.Empty;
}
return "<tr><td class='what' valign='top'><nobr>Visit-Therapy: </nobr></td><td colspan='7'>" + visit.ExtraTherapy + "</td></tr>" + Environment.NewLine;
}
public long Insert(VisitData visit)
{
try {
long tstart = DateTime.Now.Ticks;
DbUtil.OpenConnection();
if (insertByIdCmd == null) {
insertByIdCmd = DbUtil.CreateCommand(SQL_INSERT_BY_ID + DbUtil.GetAppendix("VisitID"), DbUtil.CurrentConnection);
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@cause", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@localis", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@extradiagnosis", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@prozedure", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@extratherapy", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@patientid", DbType.Int64));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@visitdate", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@anesthesiology", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@ultrasound", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@blooddiagnostic", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@todo", DbType.String));
insertByIdCmd.Parameters.Add(DbUtil.CreateParameter("@radiodiagnostics", DbType.String));
}
string visitDate = visit.VisitDate.ToString("G", DateTimeFormatInfo.InvariantInfo);
((IDataParameter)insertByIdCmd.Parameters["@cause"]).Value = visit.Cause;
((IDataParameter)insertByIdCmd.Parameters["@localis"]).Value = visit.Localis;
((IDataParameter)insertByIdCmd.Parameters["@extradiagnosis"]).Value = visit.ExtraDiagnosis;
((IDataParameter)insertByIdCmd.Parameters["@prozedure"]).Value = visit.Procedure;
((IDataParameter)insertByIdCmd.Parameters["@extratherapy"]).Value = visit.ExtraTherapy;
((IDataParameter)insertByIdCmd.Parameters["@patientid"]).Value = visit.PatientId;
((IDataParameter)insertByIdCmd.Parameters["@visitdate"]).Value = visitDate;
((IDataParameter)insertByIdCmd.Parameters["@anesthesiology"]).Value = visit.Anesthesiology;
((IDataParameter)insertByIdCmd.Parameters["@ultrasound"]).Value = visit.Ultrasound;
((IDataParameter)insertByIdCmd.Parameters["@blooddiagnostic"]).Value = visit.Blooddiagnostic;
((IDataParameter)insertByIdCmd.Parameters["@todo"]).Value = visit.Todo;
((IDataParameter)insertByIdCmd.Parameters["@radiodiagnostics"]).Value = visit.Radiodiagnostics;
//bool ok = insertByIdCmd.ExecuteNonQuery() == 1;
Object insertRet = insertByIdCmd.ExecuteScalar();
long tend = DateTime.Now.Ticks;
log.Info("Insert Visit: " + insertRet + " " + ((tend - tstart) / 10000) + "ms");
return DbUtil.getGeneratedId((IDbCommand)insertByIdCmd, lastInsertedRowCmd, insertRet);
} catch (Exception e) {
log.Error(e.Message);
throw e;
} finally {
DbUtil.CloseConnection();
}
}
