public string GetMonthlySchedule(int year, int month)
{
using (ScheduleDataContext db = new ScheduleDataContext(Config.LIFENAVConnectionString))
{
List<MonthlySchedule> schedules = new List<MonthlySchedule>();
DateTime startDate = new DateTime(year, month, 1);
var query = db.LIFENAV_GetMonthlySchedule(startDate);
foreach (LIFENAV_GetMonthlyScheduleResult data in query) {
schedules.Add(new MonthlySchedule(data.Year, data.Month, data.Day, data.Appointments));
}
string JSONSchedules = JavaScriptConvert.SerializeObject(schedules);
return JSONSchedules;
}
}
public string GetMonthlySchedule(int year, int month)
{
using (ScheduleDataContext db = new ScheduleDataContext(Config.LIFENAVConnectionString))
{
List <MonthlySchedule> schedules = new List <MonthlySchedule>();
DateTime startDate = new DateTime(year, month, 1);
var query = db.LIFENAV_GetMonthlySchedule(startDate);
foreach (LIFENAV_GetMonthlyScheduleResult data in query)
{
schedules.Add(new MonthlySchedule(data.Year, data.Month, data.Day, data.Appointments));
}
string JSONSchedules = JavaScriptConvert.SerializeObject(schedules);
return(JSONSchedules);
}
}
