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