public static Saint getSaints(DateTime date)
{
var saint = new Saint();
var saintTransformer = new SaintTransformer();
using (var dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn"].ConnectionString))
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
dbconn.Open();
using (var cmd = new SqlCommand("spGetSaintOfTheDay", dbconn))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dateofFeast", date.ToString("MMMM d, yyyy"));
var reader = cmd.ExecuteReader();
while (reader.Read())
{
saint = saintTransformer.Transform(reader);
}
}
catch (Exception)
{
// Ignored
}
}
}
return(saint);
}
public SaintReflectionService()
{
_saintReflectionTransformer = new SaintReflectionTransformer();
_saintTransformer = new SaintTransformer();
_userTransformer = new UserTransformer();
}
public SaintService()
{
_saintTransformer = new SaintTransformer();
}
