public IEnumerable <CarWashingSchedule> SearchCarWashings(SearchCarWashingSchedule item) { return(repository.Find(x => (item.WashManId == -1 || x.WashManId == item.WashManId) && (string.IsNullOrEmpty(item.CarNumber) || x.CarNumber.Contains(item.CarNumber)) && (item.WashingType == WashingType.All || item.WashingType == null || x.WashingType == item.WashingType) && (!item.IsMonth || (item.IsMonth && SqlFunctions.DatePart("month", x.BookedTime) == item.Month)) && (!item.IsYear || (item.IsYear && SqlFunctions.DatePart("year", x.BookedTime) == item.Year)) && (!item.IsDate || (item.IsDate && EntityFunctions.TruncateTime(x.BookedTime) == EntityFunctions.TruncateTime(item.BookedTime.Date))))); }
public async void SearchSchedule(SearchCarWashingSchedule schedule) { using (var client = new HttpClient()) { var serializedProduct = JsonConvert.SerializeObject(schedule); var content = new StringContent(serializedProduct, Encoding.UTF8, "application/json"); var result = await client.PostAsync(string.Format("{0}/{1}", Common.CARWASHING_URI, "SearchCarWashings"), content); if (result.IsSuccessStatusCode) { var productJsonString = await result.Content.ReadAsStringAsync(); var data = JsonConvert.DeserializeObject <CarWashingSchedule[]>(productJsonString).ToList(); if (data != null) { dgrid_Schedule.DataSource = data.OrderByDescending(x => x.BookedTime).ToList(); } } else { Console.WriteLine("Search Schedule fail :" + result.StatusCode.ToString()); } } }