public BaseResponse <DoctorEvalRec> SaveDocEvalRecData(DoctorEvalRec request) { //request.CreateBy = SecurityHelper.CurrentPrincipal.EmpNo; request.CreateBy = "1"; request.CreateDate = DateTime.Now; return(base.Save <LTC_DOCTOREVALREC, DoctorEvalRec>(request, (q) => q.ID == request.Id)); }
public IHttpActionResult post(DoctorEvalRec request) { request.CreateBy = SecurityHelper.CurrentPrincipal.EmpNo; request.CreateDate = DateTime.Now; request.OrgId = SecurityHelper.CurrentPrincipal.OrgId; var response = service.SaveDocEvalRecData(request); return(Ok(response.Data)); }
public BaseResponse <IList <DoctorEvalRec> > QueryDocEvalRecData(BaseRequest <DoctorEvalRecFilter> request) { //var response = base.Query<LTC_DOCTOREVALREC, DoctorEvalRec>(request, (q) => //{ // q = q.Where(m => m.FEENO == request.Data.FeeNo); // q = q.OrderByDescending(m => m.FEENO); // return q; //}); //return response; BaseResponse <IList <DoctorEvalRec> > response = new BaseResponse <IList <DoctorEvalRec> >(); var q = from n in unitOfWork.GetRepository <LTC_DOCTOREVALREC>().dbSet join e in unitOfWork.GetRepository <LTC_EMPFILE>().dbSet on n.DOCNAME equals e.EMPNO into res from re in res.DefaultIfEmpty() select new { DoctorEvalRec = n, EmpName = re.EMPNAME }; q = q.Where(m => m.DoctorEvalRec.FEENO == request.Data.FeeNo); q = q.OrderByDescending(m => m.DoctorEvalRec.ID); response.RecordsCount = q.Count(); Action <IList> mapperResponse = (IList list) => { response.Data = new List <DoctorEvalRec>(); foreach (dynamic item in list) { DoctorEvalRec newItem = Mapper.DynamicMap <DoctorEvalRec>(item.DoctorEvalRec); newItem.DocActName = item.EmpName; response.Data.Add(newItem); } }; if (request != null && request.PageSize > 0) { var list = q.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize).ToList(); response.PagesCount = GetPagesCount(request.PageSize, response.RecordsCount); mapperResponse(list); } else { var list = q.ToList(); mapperResponse(list); } return(response); }