public List <DataClass.PatientClass> GetPatientList()
{
List <DataClass.PatientClass> result = new List <DataClass.PatientClass>();
using (SqlConnection conn = new SqlConnection(CommonFunctions.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand {
CommandText = "SelectPatientList", CommandType = System.Data.CommandType.StoredProcedure
})
{
try
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
DataClass.PatientClass pX = new DataClass.PatientClass();
pX.firstName = reader.GetString(reader.GetOrdinal("FirstName"));
pX.LastName = reader.GetString(reader.GetOrdinal("LastName"));
pX.dateOfBirth = reader.GetDateTime(reader.GetOrdinal("DateOfBirth"));
pX.pxID = reader.GetGuid(reader.GetOrdinal("PxID"));
result.Add(pX);
}
}
}
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
;
}
}
}
return(result);
}
public bool UpdatePatient(DataClass.PatientClass patient)
{
bool success = false;
using (SqlConnection conn = new SqlConnection(CommonFunctions.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand {
CommandText = "InsertPatient", CommandType = System.Data.CommandType.StoredProcedure
})
{
cmd.Parameters.AddWithValue("@PxID", patient.pxID);
cmd.Parameters.AddWithValue("@FirstName", patient.firstName);
cmd.Parameters.AddWithValue("@LastName", patient.LastName);
cmd.Parameters.AddWithValue("@DateOfBirth", patient.dateOfBirth);
try
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
;
int rowsUpdated = cmd.ExecuteNonQuery();
if (rowsUpdated > 0)
{
success = true;
}
;
}
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
;
}
}
}
return(success);
}