private void SaveAssessmentEntry(int patientId, List <clsAssessmentModel> assessment)
{
int assessmentId = 0;
foreach (var item in assessment)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertAssessmentEntry;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", patientId));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assdate", item.AssessmentDate));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
if (GetByPatientId(patientId).Count == 0)
{
throw new Exception("Fail to save assessment");
}
var mentByPatientId = GetByPatientId(patientId)
.OrderByDescending(x => x.AssessementId)
.First();
if (mentByPatientId != null)
{
assessmentId = mentByPatientId.AssessementId;
}
if (assessmentId != 0)
{
SaveAssessmentDetails(assessmentId, item);
}
}
}
public clsPrescriptionModel GetByPatientId(int selectedPatient)
{
clsPrescriptionModel result = new clsPrescriptionModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetPrescriptionByPatientId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", selectedPatient));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
result = new clsPrescriptionModel()
{
PrescriptionId = Convert.ToInt32(dataTable.Rows[0][0].ToString()),
Advise = dataTable.Rows[0][2].ToString(),
Prescription = dataTable.Rows[0][3].ToString()
};
}
return(result);
}
public List <clsAssessmentModel> GetDetailsByAssessmentId(int assessmentId)
{
List <clsAssessmentModel> result = new List <clsAssessmentModel>();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetAssessementDetailsByAssessmentId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assess", assessmentId));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow item in dataTable.Rows)
{
clsAssessmentModel data = new clsAssessmentModel()
{
AssessmentDetailsId = Convert.ToInt32(item[0]),
AssessementId = Convert.ToInt32(item[1]),
};
ProcessJointPartType(data, item);
result.Add(data);
}
}
return(result);
}
public clsPatientDetailsModel GetByPatientId(int patientId)
{
clsPatientDetailsModel result = new clsPatientDetailsModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetPatientDetailsByPatientId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", patientId));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable != null || dataTable.Rows.Count > 0)
{
result = new clsPatientDetailsModel()
{
Name = dataTable.Rows[0][1].ToString(),
Surname = dataTable.Rows[0][2].ToString(),
Tel = dataTable.Rows[0][3].ToString(),
Mobile1 = dataTable.Rows[0][4].ToString(),
Mobile2 = dataTable.Rows[0][5].ToString(),
DOB = string.IsNullOrWhiteSpace(dataTable.Rows[0][6].ToString())? DateTime.Now: Convert.ToDateTime(dataTable.Rows[0][6].ToString()),
Age = string.IsNullOrWhiteSpace(dataTable.Rows[0][7].ToString())? 0: Convert.ToInt32(dataTable.Rows[0][7].ToString()),
Occupation = dataTable.Rows[0][8].ToString()
};
}
return(result);
}
public int Save(clsPatientDetailsModel patientDetails)
{
int patientId = 0;
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertPatientDetails;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@na", patientDetails.Name));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@sur", patientDetails.Surname));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@tel", patientDetails.Tel));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob1", patientDetails.Mobile1));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob2", patientDetails.Mobile2));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@dob", patientDetails.DOB));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@age", patientDetails.Age));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@occup", patientDetails.Occupation));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
patientId = GetMaxPatientId();
if (patientId == 0)
{
throw new Exception("Unable to save patient Id");
}
return(patientId);
}
public clsDateEntryModel GetbyPatientId(int selectedPatient)
{
clsDateEntryModel result = new clsDateEntryModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetDateEntryByPatientId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", selectedPatient));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
result = new clsDateEntryModel()
{
EntryId = Convert.ToInt32(dataTable.Rows[0][0].ToString()),
EntryDate = string.IsNullOrWhiteSpace(dataTable.Rows[0][2].ToString()) ? DateTime.Now : Convert.ToDateTime(dataTable.Rows[0][2].ToString()),
};
}
return(result);
}
/// <summary>
/// Select process method and sub method include get by patientId or assesssmentid
/// </summary>
/// <param name="assessmentId"></param>
/// <returns></returns>
private clsPatientModel GetByAssessmentId(int assessmentId)
{
clsPatientModel result = new clsPatientModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetAssessementEntryByAssessmentId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assessment", assessmentId));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
result.PatientId = Convert.ToInt32(dataTable.Rows[0][1]);
result.Assessment = new List <clsAssessmentModel>()
{
new clsAssessmentModel()
{
AssessementId = Convert.ToInt32(dataTable.Rows[0][0]),
AssessmentDate = Convert.ToDateTime(dataTable.Rows[0][2])
}
};
}
return(result);
}
public clsPatientMedicalRecordModel GetByPatientId(int selectedPatient)
{
clsPatientMedicalRecordModel result = new clsPatientMedicalRecordModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetMedicalRecordByPatientId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", selectedPatient));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
result = new clsPatientMedicalRecordModel()
{
MedicalId = Convert.ToInt32(dataTable.Rows[0][0].ToString()),
Diagnosis = dataTable.Rows[0][2].ToString(),
BriefHistory = dataTable.Rows[0][3].ToString(),
PastMedicalHistory = dataTable.Rows[0][4].ToString(),
Swelling = Convert.ToBoolean(dataTable.Rows[0][5].ToString()),
Tenderness = Convert.ToBoolean(dataTable.Rows[0][6].ToString()),
Sensation = Convert.ToBoolean(dataTable.Rows[0][7].ToString()),
SensationDetails = dataTable.Rows[0][8].ToString(),
};
}
return(result);
}
private List <clsAssessmentModel> GetAssessmentEntry(int selectedPatient)
{
List <clsAssessmentModel> result = new List <clsAssessmentModel>();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.GetAssessementEntryByPatientId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", selectedPatient));
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
foreach (DataRow item in dataTable.Rows)
{
result.Add(new clsAssessmentModel()
{
AssessementId = Convert.ToInt32(item[0]),
AssessmentDate = Convert.ToDateTime(item[2])
});
}
}
return(result);
}
private void DeletelAssessmentDetails(int selectedAssessmentId)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.DeleteAssessmentDetailsByAssessmentId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assessment", selectedAssessmentId));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void DeleteByAppointmentId(int selectedAppointmentId)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.DeleteAppointmentByAppointmentId;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@appointment", selectedAppointmentId));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void Update(int patientId, clsPrescriptionModel prescription)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = string.Format(clsQuery.UpdatePrescription, patientId);
connect.cmd.Parameters.AddWithValue("@advise", prescription.Advise);
connect.cmd.Parameters.AddWithValue("@prescription", prescription.Prescription);
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void Save(int patientId, clsDateEntryModel dateEntry)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertDateEntry;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@pa", patientId));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@da", dateEntry.EntryDate));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void Save(int patientId, DateTime newAppointment)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertAppointment;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patientId", patientId));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@newAppointment", newAppointment));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void Save(int patientId, clsPrescriptionModel prescription)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertPrescription;
connect.cmd.Parameters.AddWithValue("@pa", patientId);
connect.cmd.Parameters.AddWithValue("@advise", prescription.Advise);
connect.cmd.Parameters.AddWithValue("@prescription", prescription.Prescription);
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
private void SaveAssessment(int assessmentId, int jointPartType, int jointType, int motionType, string leftValue = "EMPTY", string rightValue = "EMPTY", string otherAssessment = "EMPTY")
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.InsertAssessmentDetails;
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assess", assessmentId));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@jpt", (int)jointPartType));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@jt", (int)jointType));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mt", (int)motionType));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@rv", rightValue));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@lv", leftValue));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@oa", otherAssessment));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void Update(int patientId, clsPatientMedicalRecordModel medicalRecords)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = string.Format(clsQuery.UpdateMedicalRecord, patientId);
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@diag", medicalRecords.Diagnosis));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@bh", medicalRecords.BriefHistory));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@pmh", medicalRecords.PastMedicalHistory));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@swel", medicalRecords.Swelling));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@ten", medicalRecords.Tenderness));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@sen", medicalRecords.Sensation));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@sendet", medicalRecords.SensationDetails));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
public void Update(int patientId, clsPatientDetailsModel patientDetails)
{
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = string.Format(clsQuery.UpdatePatientDetails, patientId);
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@na", patientDetails.Name));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@sur", patientDetails.Surname));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@tel", patientDetails.Tel));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob1", patientDetails.Mobile1));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@mob2", patientDetails.Mobile2));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@dob", patientDetails.DOB));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@age", patientDetails.Age));
connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@occup", patientDetails.Occupation));
connect.cmd.ExecuteNonQuery();
connect.con.Close();
}
private int GetMaxPatientId()
{
int result = 0;
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.PatientDetailsSelectMaxPatientId;
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable.Rows.Count > 0)
{
result = Convert.ToInt32(dataTable.Rows[0][0]);
}
return(result);
}
public List <clsPatientModel> Retrieve()
{
List <clsPatientModel> result = new List <clsPatientModel>();
clsPatientModel data = new clsPatientModel();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.RetrievePatientDetails;
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable != null || dataTable.Rows.Count > 0)
{
foreach (DataRow item in dataTable.Rows)
{
data = new clsPatientModel()
{
PatientId = Convert.ToInt32(item[0]),
PatientDetails = new clsPatientDetailsModel()
{
Name = item[1].ToString(),
Surname = item[2].ToString(),
Tel = item[3].ToString(),
Mobile1 = item[4].ToString(),
Mobile2 = item[5].ToString(),
DOB = string.IsNullOrWhiteSpace(item[6].ToString()) ? DateTime.Now : Convert.ToDateTime(item[6].ToString()),
Age = string.IsNullOrWhiteSpace(item[7].ToString()) ? 0 : Convert.ToInt32(item[7].ToString()),
Occupation = item[8].ToString()
}
};
result.Add(data);
}
}
return(result);
}
public List <clsPatientModel> Retrieve()
{
List <clsPatientModel> result = new List <clsPatientModel>();
DataTable dataTable = new DataTable();
connect = new clsConnectorData();
connect.Link();
connect.con.Open();
connect.cmd.CommandText = clsQuery.RetrieveAppointment;
connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd);
connect.dta.Fill(dataTable);
connect.con.Close();
if (dataTable != null || dataTable.Rows.Count > 0)
{
foreach (DataRow item in dataTable.Rows)
{
clsPatientModel patient = new clsPatientModel()
{
PatientId = Convert.ToInt32(item[1]),
Appointments = new List <clsAppointmentModel>()
{
new clsAppointmentModel()
{
AppointmentId = Convert.ToInt32(item[0]),
HasAppointment = true,
Appointment = Convert.ToDateTime(item[2])
}
}
};
result.Add(patient);
}
}
return(result);
}
