public List <Reminder> GetByStatus(ReminderType reminderType, int month, int year)
{
List <Reminder> reminders = new List <Reminder>();
using (var conn = new SqlCeConnection(Store.ConnectionString))
{
conn.Open();
string sql = "SELECT * FROM " + tableName + " WHERE DATEPART(month,DueDate)=@Month "
+ "AND DATEPART(year,DueDate)=@Year AND Status=@Status";
var cmd = new SqlCeCommand(sql, conn);
cmd.Parameters.Add("@Month", SqlDbType.Int).Value = month;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = year;
cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = reminderType.ToString();
using (var rdr = cmd.ExecuteReader())
{
reminders = Mapper.MapList <Reminder>(rdr, new ReminderMapper());
}
}
return(reminders);
}
