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