// Insert a new record
public bool InsertNewRecord(AppointmentRecord record)
{
SqlCommand command = new SqlCommand("AddAppointment", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@apptDate", record.AppointmentDate));
command.Parameters.Add(new SqlParameter("@apptTime", record.AppointmentTime));
command.Parameters.Add(new SqlParameter("@patient", record.PatientHCN));
return(ExecuteNonQueryProcedure(command));
}
// Retrieves appointments frmo the database and puts them into AppointmentRecord objects
private List <AppointmentRecord> GetAppointmentInfo(SqlCommand command)
{
List <AppointmentRecord> records = new List <AppointmentRecord>();
try
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
// Get ordinals for the columns required to fill the record
int p1Pos = reader.GetOrdinal("Patient_1");
int datePos = reader.GetOrdinal("Date");
int timePos = reader.GetOrdinal("Time");
int stPos = reader.GetOrdinal("Status");
if (reader.HasRows)
{
// Read each row, filling in the patient info
while (reader.Read())
{
AppointmentRecord rec = new AppointmentRecord();
rec.PatientHCN = GetSafeString(reader, p1Pos);
rec.AppointmentDate = GetSafeDateTime(reader, datePos);
rec.AppointmentTime = GetSafeTimeSpan(reader, timePos);
rec.Status = GetSafeStatus(reader, stPos);
// Add to list of records
records.Add(rec);
}
}
} // end using
connection.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
// this allows the exception to percolate...
connection.Close();
}
return(records);
}
static void Main(string[] args)
{
string testThis = "patient";
bool result;
if (testThis == "patient")
{
PatientRecordsAccessor pr = new PatientRecordsAccessor();
pr.Connect("ems_admin", "qwerty");
PatientRecord rec1 = new PatientRecord();
rec1.HealthCardNumber = "6408383104";
rec1.HeadOfHousehold = rec1.HealthCardNumber;
PatientRecord rec2 = new PatientRecord();
rec2.LastName = "Hernandez";
List <PatientRecord> list = pr.GetRecords(PatientRecordsAccessor.GETREQUEST.HEALTH_CARD_NUMBER, rec1.HealthCardNumber);
if (list.Count > 0)
{
Console.WriteLine(list[0].FirstName);
}
else
{
Console.WriteLine("Failed.");
}
List <PatientRecord> list2 = pr.GetRecords(PatientRecordsAccessor.GETREQUEST.LASTNAME, rec2.LastName);
if (list2 != null && list2.Count > 0)
{
Console.WriteLine(list2[0].FirstName);
}
else
{
Console.WriteLine("Failed.");
}
rec1.LastName = "NewLastName";
result = pr.UpdateRecords(rec1);
if (result)
{
Console.WriteLine("Update hoh new last name ok.");
}
else
{
Console.WriteLine("Update hoh new last name FAILED.");
}
rec2.FirstName = "Mary";
rec2.HealthCardNumber = "1234567890";
rec2.HeadOfHousehold = "1868176460";
//result = pr.InsertNewRecord(rec2);
//if (result)
//{
// Console.WriteLine("Insert non-hoh info ok.");
//}
//else
//{
// Console.WriteLine("Insert non-hoh info FAILED.");
//}
list = pr.GetRecords(PatientRecordsAccessor.GETREQUEST.HOH_REPORT, "1868176460");
for (int i = 0; i < list.Count; i++)
{
Console.WriteLine(list[i].LastName);
}
}
if (testThis == "appointment")
{
AppointmentRecordsAccessor ara = new AppointmentRecordsAccessor();
List <AppointmentRecord> lst = new List <AppointmentRecord>();
// Add a new appointment
AppointmentRecord app = new AppointmentRecord();
app.PatientHCN = "8028261884";
app.AppointmentDate = new DateTime(2019, 4, 5);
app.AppointmentTime = new TimeSpan(8, 0, 0);
result = ara.InsertNewRecord(app);
if (result)
{
Console.WriteLine("Added record.");
}
else
{
Console.WriteLine("Failed.");
}
// Cancel appointment
result = ara.CancelAppointment(app.PatientHCN);
if (result)
{
Console.WriteLine("Cancelled record.");
}
else
{
Console.WriteLine("Failed.");
}
// Cancel appointment
result = ara.CancelAppointment(app.AppointmentDate, app.AppointmentTime);
if (result)
{
Console.WriteLine("Cancelled record.");
}
else
{
Console.WriteLine("Failed.");
}
lst = ara.GetRecords(app.PatientHCN);
if (lst.Count > 0)
{
Console.WriteLine(lst[0].PatientHCN);
Console.WriteLine(lst[0].Status);
}
else
{
Console.WriteLine("Failed.");
}
}
else if (testThis == "billing")
{
}
Console.ReadKey();
}