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);
}
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 void Post(CareVisit careVisit)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Pets"].ConnectionString))
{
connection.Open();
try
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.Parameters.AddWithValue("ID", careVisit.ID);
command.Parameters.AddWithValue("IsComplete", careVisit.IsComplete);
command.Parameters.AddWithValue("CompletedByPersonID", careVisit.CompletedByPersonID);
command.CommandText = "Update dbo.CareVisit Set IsComplete = @IsComplete, CompletedByPersonID = @CompletedByPersonID, DateCompleted = GetUTCDate() Where ID = @ID;";
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public List <CareVisit> Get(string userName, bool?isComplete = null)
{
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("dbo.GetCareVisits", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("userName", userName);
command.Parameters.AddWithValue("isComplete", isComplete == null ? DBNull.Value : (object)isComplete);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
visit = new CareVisit();
visit.ID = ((int)reader["ID"]);
visit.VisitDateTime = ((DateTime)reader["VisitDateTime"]);
visit.Customer = new Customer((string)reader["CustomerName"]);
visit.PetNames = ((string)reader["PetNames"]);
visit.CareProvider = new CareProvider((string)reader["CareProviderName"]);
visits.Add(visit);
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
return(visits);
}
