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