public List <PractitionerRecordsDirectory> SearchRecords(Guid patientId, int?year, int month)
{
List <PractitionerRecordsDirectory> result = new List <PractitionerRecordsDirectory>();
try
{
SqlConnection conn = new SqlConnection(ConstantHelper.DBAppSettings.FYP);
conn.Open();
SqlCommand cmd = new SqlCommand(ConstantHelper.StoredProcedure.PatientSearchRecords, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.AccId, patientId));
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.Year, year));
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.Month, month));
SqlDataReader records = cmd.ExecuteReader();
bool check = records.HasRows;
while (records.Read())
{
PractitionerRecordsDirectory record = new PractitionerRecordsDirectory();
record.RecordId = Guid.Parse(records[ConstantHelper.SQLColumn.GetRecordsDirectory.Id].ToString());
DateTime recordTime = Convert.ToDateTime(records[ConstantHelper.SQLColumn.GetRecordsDirectory.CreatedOn].ToString());
record.CreatedOn = recordTime.ToString("dd/MM/yyyy");
record.CreationTime = recordTime.ToString("hh:mm tt");
result.Add(record);
}
}
catch (Exception err)
{
new LogHelper().LogMessage("PatientData.SearchRecords :" + err);
}
return(result);
}
public List <PractitionerRecordsDirectory> GetRecordsDirectory(Guid patientId)
{
List <PractitionerRecordsDirectory> result = new List <PractitionerRecordsDirectory>();
try
{
using (var context = new ApplicationContext())
{
var query = from pt in context.RecordFile
where pt.PatientId.Equals(patientId)
select pt;
var records = query.OrderBy(x => x.CreatedOn).Select(x => x);
foreach (var record in records)
{
PractitionerRecordsDirectory row = new PractitionerRecordsDirectory();
row.RecordId = record.Id;
DateTime recordTime = Convert.ToDateTime(record.CreatedOn);
row.CreatedOn = recordTime.ToString("dd/MM/yyyy");
row.CreationTime = recordTime.ToString("hh:mm tt");
result.Add(row);
}
}
}
catch (Exception err)
{
new LogHelper().LogMessage("PatientData.GetRecordsDirectory : " + err);
}
return(result);
}
