internal static List <CareVisit> GetList(int careRequestID) { List <CareVisit> visits = new List <CareVisit>(); CareVisit visit; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Pets"].ConnectionString)) { try { connection.Open(); using (SqlCommand command = new SqlCommand("Select * From dbo.CareVisit Where CareRequestID = @careRequestID Order By VisitDateTime;", connection)) { command.Parameters.AddWithValue("careRequestID", careRequestID); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { visit = new CareVisit(); visit.ID = ((int)reader["ID"]); visit.CareProvider = new CareProvider((int)reader["CareProviderID"]); visit.VisitDateTime = ((DateTime)reader["VisitDateTime"]); visit.IsComplete = ((bool)reader["IsComplete"]); visit.Tasks = CareVisitTaskController.GetList((int)visit.ID); visits.Add(visit); } } } return(visits); } catch (Exception ex) { throw new Exception(ex.Message); } } }
public CareVisit Get(int id) { CareVisit visit = new CareVisit(); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Pets"].ConnectionString)) { try { connection.Open(); using (SqlCommand command = new SqlCommand("Select * From dbo.vwCareVisit Where ID = @id", connection)) { command.Parameters.AddWithValue("id", id); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); visit.ID = ((int)reader["ID"]); visit.VisitDateTime = ((DateTime)reader["VisitDateTime"]); visit.CareProvider = new CareProvider((int)reader["CareProviderID"], (string)reader["CareProviderName"]); visit.Customer = CustomerController.FindByID((int)reader["CustomerID"]); visit.Tasks = CareVisitTaskController.GetList(id); } } } } catch (Exception ex) { throw new Exception(ex.Message); } } return(visit); }