public CDataResults <CWmtSoilMoistureListDto> GetWmtSoilMoisture(CWmtSoilMoistureInput input) { //Check Ip & customer if (!checkIPandCustomer(input.customerId)) { AddVisitRecord(input.customerId, Entities.VisitRecordFlag.Black); return(new CDataResults <CWmtSoilMoistureListDto>() { IsSuccess = false, ErrorMessage = "Validation failed.", Data = null }); } //Extract data from DB var query = this._wmtSoilMoistureRepository.GetAll(); if (input.pageNumber.HasValue && input.pageNumber.Value > 0 && input.pageSize.HasValue) { query = query.OrderBy(r => r.Id).Take(input.pageSize.Value * input.pageNumber.Value).Skip(input.pageSize.Value * (input.pageNumber.Value - 1)); } var result = query.ToList().MapTo <List <CWmtSoilMoistureListDto> >(); //Add visit record AddVisitRecord(input.customerId, Entities.VisitRecordFlag.White); return(new CDataResults <CWmtSoilMoistureListDto>() { IsSuccess = true, ErrorMessage = null, Data = result }); }
public CDataResults <CWmtSoilMoistureDetailListDto> GetWmtSoilMoistureDetail(CWmtSoilMoistureInput input) { //Check Ip & customer if (!checkIPandCustomer(input.customerId)) { AddVisitRecord(input.customerId, Entities.VisitRecordFlag.Black); return(new CDataResults <CWmtSoilMoistureDetailListDto>() { IsSuccess = false, ErrorMessage = "Validation failed.", Data = null }); } //Extract data from DB var query = from r in _wmtSoilMoistureRepository.GetAll() join s in _stnInfoBRepository.GetAll() on r.stcd equals s.areaCode join res in _relationReposity.GetAll() on s.Id equals res.site_id where res.customer_id == input.customerId orderby r.collecttime select new CWmtSoilMoistureDetailListDto { areaCode = s.areaCode, areaName = s.areaName, stcd = r.stcd, paravalue = r.paravalue, collecttime = r.collecttime, systemtime = r.systemtime, uniquemark = r.uniquemark, gentm = r.gentm }; if (input.fromTime != null) { query = query.Where(r => r.collecttime > input.fromTime); } if (input.toTime != null) { query = query.Where(r => r.collecttime < input.toTime); } if (!string.IsNullOrEmpty(input.stcd)) { query = query.Where(r => r.stcd == input.stcd); } if (input.pageNumber.HasValue && input.pageNumber.Value > 0 && input.pageSize.HasValue) { query = query.OrderByDescending(r => r.collecttime).Take(input.pageSize.Value * input.pageNumber.Value).Skip(input.pageSize.Value * (input.pageNumber.Value - 1)); } var result = query.ToList(); //Add visit record AddVisitRecord(input.customerId, Entities.VisitRecordFlag.White); return(new CDataResults <CWmtSoilMoistureDetailListDto>() { IsSuccess = true, ErrorMessage = null, Data = result, Total = query.Count() }); }