private async Task <WM_Schedule> GetCurrentSchedule()
{
DateTime baseDate = DateTime.Now;
var thisWeekStart = baseDate.AddDays(-(int)baseDate.DayOfWeek);
var thisWeekEnd = thisWeekStart.AddDays(7).AddSeconds(-1);
var timeStart = thisWeekStart.ToString("yyyy-MM-dd");
var timeEnd = thisWeekEnd.AddDays(1).ToString("yyyy-MM-dd");
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'DateCreated': {");
query.AppendLine(" '$gte': ISODate('" + timeStart + "T00:00:00.000+07:00') ");
query.AppendLine(", '$lt': ISODate('" + timeEnd + "T00:00:00.000+07:00') ");
query.AppendLine("}");
query.AppendLine("}");
var data = await _WM_ScheduleRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString()));
return(data.FirstOrDefault());
}
public async Task <List <WM_Schedule> > GetCurrentWeekSchedule(DateTime DateStart, DateTime DateEnd)
{
var timeStart = DateStart.ToString("yyyy-MM-dd");
var timeEnd = DateEnd.AddDays(1).ToString("yyyy-MM-dd");
var query = new StringBuilder();
query.AppendLine("{");
query.AppendLine("'DateCreated': {");
query.AppendLine(" '$gte': ISODate('" + timeStart + "T00:00:00.000+07:00') ");
query.AppendLine(", '$lt': ISODate('" + timeEnd + "T00:00:00.000+07:00') ");
query.AppendLine("}");
query.AppendLine("}");
return(await _WM_ScheduleRepository.GetManyToList(MongoHelper.ConvertQueryStringToDocument(query.ToString())));
}
