public Visit Get(VisitId visitId)
=> Get <Visit, Visit.VisitState>(visitId.Value,
state => new Visit(
state.Doctor,
state.Date,
state.Patient)
);
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (VisitId != null)
{
hashCode = hashCode * 59 + VisitId.GetHashCode();
}
if (Date != null)
{
hashCode = hashCode * 59 + Date.GetHashCode();
}
if (Price != null)
{
hashCode = hashCode * 59 + Price.GetHashCode();
}
if (RequiredActions != null)
{
hashCode = hashCode * 59 + RequiredActions.GetHashCode();
}
if (Status != null)
{
hashCode = hashCode * 59 + Status.GetHashCode();
}
if (AssignedEmployees != null)
{
hashCode = hashCode * 59 + AssignedEmployees.GetHashCode();
}
return(hashCode);
}
}
public override int GetHashCode()
{
int hash = 13;
hash += (hash * 43) + VisitId.GetHashCode();
return(hash);
}
static void Main(string[] args)
{
var visitId = VisitId.New();
var agg = new Visit(DoctorId.New(), DateTime.Now);
var rep = new VisitRepository();
var exists = rep.Get(new VisitId(Guid.Parse("b1e81cb1-0683-473a-94b6-666d9c1babe8")));
rep.Save(agg, visitId);
var vis = rep.Get(visitId);
vis.ReserveVisit(PatientId.New());
rep.Save(vis, visitId);
Console.WriteLine("Hello World!");
}
/// <summary>
/// Returns true if Visit instances are equal
/// </summary>
/// <param name="other">Instance of Visit to be compared</param>
/// <returns>Boolean</returns>
public bool Equals(Visit other)
{
if (ReferenceEquals(null, other))
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
VisitId == other.VisitId ||
VisitId != null &&
VisitId.Equals(other.VisitId)
) &&
(
Date == other.Date ||
Date != null &&
Date.Equals(other.Date)
) &&
(
Price == other.Price ||
Price != null &&
Price.Equals(other.Price)
) &&
(
RequiredActions == other.RequiredActions ||
RequiredActions != null &&
RequiredActions.SequenceEqual(other.RequiredActions)
) &&
(
Status == other.Status ||
Status != null &&
Status.Equals(other.Status)
) &&
(
AssignedEmployees == other.AssignedEmployees ||
AssignedEmployees != null &&
AssignedEmployees.SequenceEqual(other.AssignedEmployees)
));
}
public DataTable SavePatientRecord(Hashtable ht, Array arrIllness, Array arrReferredTo, Array arrAdhReason, Array arrARVReason4, DataTable theCustomFieldData)
{
//public int SavePatientRecord(Hashtable ht, Array arrIllness, Array arrReferredTo, Array arrAdhReason, Array arrARVReason4, strCustomField)
ClsObject PatientRecord = new ClsObject();
int retval = 0;
string VisitId;
DataTable dtresult;
// DateTime VisitDt;
// int theRowAffected = 0;
try
{
this.Connection = DataMgr.GetConnection();
this.Transaction = DataMgr.BeginTransaction(this.Connection);
PatientRecord.Connection = this.Connection;
PatientRecord.Transaction = this.Transaction;
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Mode", SqlDbType.VarChar, ht["Mode"].ToString());
ClsUtility.AddParameters("@LocationID", SqlDbType.VarChar, ht["LocationID"].ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, ht["UserID"].ToString());
ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.VarChar, ht["Ptn_Pk"].ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.VarChar, ht["VisitId"].ToString());
ClsUtility.AddParameters("@VisitDate", SqlDbType.VarChar, ht["VisitDate"].ToString());
ClsUtility.AddParameters("@TypeOfVisit", SqlDbType.VarChar, ht["TypeOfVisit"].ToString());
ClsUtility.AddParameters("@Height", SqlDbType.Int, ht["Height"].ToString());
ClsUtility.AddParameters("@Weight", SqlDbType.Decimal, ht["Weight"].ToString());
ClsUtility.AddParameters("@WHOStage", SqlDbType.Decimal, ht["WHOStage"].ToString());
ClsUtility.AddParameters("@OtherComplication", SqlDbType.VarChar, ht["OtherComplication"].ToString());
ClsUtility.AddParameters("@Pregnant", SqlDbType.Int, ht["Pregnant"].ToString());
ClsUtility.AddParameters("@EDD", SqlDbType.DateTime, ht["EDD"].ToString());
ClsUtility.AddParameters("@FuncStatus", SqlDbType.Int, ht["FuncStatus"].ToString());
ClsUtility.AddParameters("@TBStatus", SqlDbType.Int, ht["TBStatus"].ToString());
ClsUtility.AddParameters("@TBID", SqlDbType.VarChar, ht["TBID"].ToString());
ClsUtility.AddParameters("@NutritionalSupport", SqlDbType.Int, ht["NutritionalSupport"].ToString());
ClsUtility.AddParameters("@AppReason", SqlDbType.Int, ht["AppReason"].ToString());
ClsUtility.AddParameters("@AppDate", SqlDbType.VarChar, ht["AppDate"].ToString());
ClsUtility.AddParameters("@Signature", SqlDbType.Int, ht["Signature"].ToString());
ClsUtility.AddParameters("@CD4", SqlDbType.VarChar, ht["CD4"].ToString());
ClsUtility.AddParameters("@CD4Percent", SqlDbType.VarChar, ht["CD4Percent"].ToString());
ClsUtility.AddParameters("@TLC", SqlDbType.VarChar, ht["TLC"].ToString());
ClsUtility.AddParameters("@TLCPercent", SqlDbType.VarChar, ht["TLCPercent"].ToString());
ClsUtility.AddParameters("@OrderedBy", SqlDbType.VarChar, ht["OrderedBy"].ToString());
ClsUtility.AddParameters("@OrderedDate", SqlDbType.VarChar, ht["OrderedDate"].ToString());
ClsUtility.AddParameters("@ReportedBy", SqlDbType.VarChar, ht["ReportedBy"].ToString());
ClsUtility.AddParameters("@ReportedDate", SqlDbType.VarChar, ht["ReportedDate"].ToString());
ClsUtility.AddParameters("@Delivered", SqlDbType.VarChar, ht["Delivered"].ToString());
ClsUtility.AddParameters("@DOB", SqlDbType.VarChar, ht["DOB"].ToString());
ClsUtility.AddParameters("@PrevLABID", SqlDbType.VarChar, ht["PrevLABID"].ToString());
ClsUtility.AddParameters("@DQ", SqlDbType.VarChar, ht["DQ"].ToString());
ClsUtility.AddParameters("@EligibleReason", SqlDbType.Int, ht["EligibleReason"].ToString());
dtresult = (DataTable)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_Clinical_SavePatientRecordCTC_Constella", ClsUtility.ObjectEnum.DataTable);
//--------- Illness ----------
if (ht["Mode"].ToString() == "Add")
{
VisitId = dtresult.Rows[0][0].ToString();
}
else
{
VisitId = ht["VisitId"].ToString();
}
for (int i = 0; i < arrIllness.Length; i++)
{
if (arrIllness.GetValue(i) == null)
{
break;
}
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Mode", SqlDbType.VarChar, ht["Mode"].ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, ht["UserID"].ToString());
ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.VarChar, ht["Ptn_Pk"].ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.VarChar, VisitId.ToString());
ClsUtility.AddParameters("@SymptomID", SqlDbType.Int, arrIllness.GetValue(i).ToString());
retval = (int)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_Clinical_SavePatientRecordIllnessCTC_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
//--------- ReferredTo ----------
for (int i = 0; i < arrReferredTo.Length; i++)
{
if (arrReferredTo.GetValue(i, 0) == null)
{
break;
}
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Mode", SqlDbType.VarChar, ht["Mode"].ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, ht["UserID"].ToString());
ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.VarChar, ht["Ptn_Pk"].ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.VarChar, VisitId.ToString());
ClsUtility.AddParameters("@PatientRefID", SqlDbType.Int, arrReferredTo.GetValue(i, 0).ToString());
ClsUtility.AddParameters("@PatientRefDesc", SqlDbType.VarChar, arrReferredTo.GetValue(i, 1).ToString());
retval = (int)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_Clinical_SavePatientRecordReferredToCTC_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
//--------- arrAdhReason ----------
for (int i = 0; i < arrAdhReason.Length; i++)
{
if (arrAdhReason.GetValue(i, 0) == null)
{
break;
}
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Mode", SqlDbType.VarChar, ht["Mode"].ToString());
//ClsUtility.AddParameters("@LocationID", SqlDbType.VarChar, ht["LocationID"].ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, ht["UserID"].ToString());
ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.VarChar, ht["Ptn_Pk"].ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.VarChar, VisitId.ToString());
ClsUtility.AddParameters("@AdherenceReason", SqlDbType.Int, arrAdhReason.GetValue(i, 0).ToString());
ClsUtility.AddParameters("@AdherenceReasonOther", SqlDbType.VarChar, arrAdhReason.GetValue(i, 1).ToString());
retval = (int)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_Clinical_SavePatientRecordAdhReasonCTC_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
//--------- arrARVReason4 ----------
for (int i = 0; i < arrARVReason4.Length; i++)
{
if (arrARVReason4.GetValue(i, 0) == null)
{
break;
}
ClsUtility.Init_Hashtable();
ClsUtility.AddParameters("@Mode", SqlDbType.VarChar, ht["Mode"].ToString());
//ClsUtility.AddParameters("@LocationID", SqlDbType.VarChar, ht["LocationID"].ToString());
ClsUtility.AddParameters("@UserID", SqlDbType.VarChar, ht["UserID"].ToString());
ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.VarChar, ht["Ptn_Pk"].ToString());
ClsUtility.AddParameters("@VisitId", SqlDbType.VarChar, VisitId.ToString());
ClsUtility.AddParameters("@ARVReasonChange", SqlDbType.VarChar, arrARVReason4.GetValue(i, 0).ToString());
ClsUtility.AddParameters("@ARVReasonChangeOther", SqlDbType.VarChar, arrARVReason4.GetValue(i, 1).ToString());
ClsUtility.AddParameters("@ARVStatus", SqlDbType.Int, ht["ARVStatus"].ToString());
ClsUtility.AddParameters("@ARVReason", SqlDbType.Int, ht["ARVReason"].ToString());
ClsUtility.AddParameters("@EligibleReason", SqlDbType.Int, ht["EligibleReason"].ToString());
ClsUtility.AddParameters("@EligibleDate", SqlDbType.VarChar, ht["EligibleDate"].ToString());
ClsUtility.AddParameters("@ReadyDate", SqlDbType.VarChar, ht["ReadyDate"].ToString());
retval = (int)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_Clinical_SavePatientRecordARVReasonChangeCTC_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
//string[] mValues = strCustomField.Split(new char[] { '!' });
//foreach (string str in mValues)
//{
// if (str.ToString() != "")
// {
// string sqlStrNew = str.Replace("77777", dtresult.Rows[0][0].ToString());
// string sqlStrFinal = sqlStrNew.Replace("1900-01-01", dtresult.Rows[0][1].ToString());
// ClsUtility.Init_Hashtable();
// ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, sqlStrFinal);
// theRowAffected = (int)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery);
// }
// if (theRowAffected == 0)
// {
// MsgBuilder theMsg = new MsgBuilder();
// theMsg.DataElements["MessageText"] = "Error in Saving Custom Fields. Try Again..";
// AppException.Create("#C1", theMsg);
// }
//}
//// Custom Fields //////////////
////////////PreSet Values Used/////////////////
/// #99# --- Ptn_Pk
/// #88# --- LocationId
/// #77# --- Visit_Pk
/// #66# --- Visit_Date
/// #55# --- Ptn_Pharmacy_Pk
/// #44# --- OrderedByDate
/// #33# --- LabId
/// #22# --- TrackingId
/// #11# --- CareEndedId
/// #00# --- HomeVisitId
///////////////////////////////////////////////
//ClsObject theCustomManager = new ClsObject();
for (Int32 i = 0; i < theCustomFieldData.Rows.Count; i++)
{
ClsUtility.Init_Hashtable();
string theQuery = theCustomFieldData.Rows[i]["Query"].ToString();
theQuery = theQuery.Replace("#99#", ht["Ptn_Pk"].ToString());
theQuery = theQuery.Replace("#88#", ht["LocationID"].ToString());
theQuery = theQuery.Replace("#77#", dtresult.Rows[0][0].ToString());
theQuery = theQuery.Replace("#66#", "'" + dtresult.Rows[0][1].ToString() + "'");
ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery);
int RowsAffected = (Int32)PatientRecord.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery);
}
DataMgr.CommitTransaction(this.Transaction);
DataMgr.ReleaseConnection(this.Connection);
return(dtresult);
}
catch
{
DataMgr.RollBackTransation(this.Transaction);
throw;
}
finally
{
PatientRecord = null;
if (this.Connection != null)
{
DataMgr.ReleaseConnection(this.Connection);
}
}
//return Convert.ToInt32(VisitId); 05May09
//return dtresult;
}
public void Save(Visit visit, VisitId visitId) => Save(visit.State, visitId.Value);
public void add_visit(string visitId, string doctorId, string date, string parentId = null)
{
_visitId = new VisitId(new Guid(visitId));
_doctorId = new DoctorId(new Guid(doctorId));
_visit = new Visit(_doctorId, DateTime.Parse(date));
}
