public async Task<ActionResultDto> Execute(ContextDto context) { var _result = new ActionResultDto(); try { /* kiểm tra input */ var _error = validate(); if (_error.code > 0) { return returnActionError(HttpStatusCode.BadRequest, _error.message); } /* convert input */ var _KhoKhachHangId = Protector.Int(KhachHangId); GetListKhoKhachHangByCriteriaBiz biz = new GetListKhoKhachHangByCriteriaBiz(context); biz.KhachHang = KhachHangId; biz.FieldsField = "KhachHangId, A.Ma, A.Ten, A.Loai, A.DienThoai, A.DiDong, A.Email, A.TinhThanhPhoId, B.TenTT, A.QuanHuyenId, C.TenQuanHuyen, A.PhuongXaId, D.TenPhuongXa, A.DiaChi, A.AnyDesk, A.MaSoThue, A.GhiChu, A.CtrVersion"; biz.OrderClause = "A.KhachHangId asc"; var KhoKhachHang = await biz.Execute(); if (KhoKhachHang == null) { return returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy KhoKhachHangId '{0}'", _KhoKhachHangId)); } _result.ReturnCode = HttpStatusCode.OK; _result.ReturnData = new { data = KhoKhachHang }; return _result; } catch (Exception ex) { return returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message); } }
public async Task <ActionResultDto> Execute(ContextDto context) { GetListKhoKhachHangByCriteriaBiz biz = new GetListKhoKhachHangByCriteriaBiz(context); var result = new ActionResultDto(); try { var _draw = Protector.Int(draw); var _start = Protector.Int(start); var _length = Protector.Int(length); /* ========================= * fixed input * ========================= */ sortName = string.IsNullOrEmpty(sortName) ? "KhoKhachHangId" : sortName; sortDir = string.IsNullOrEmpty(sortDir) ? "asc" : sortDir; _length = _length < 1 ? 10 : _length; fields = string.IsNullOrEmpty(fields) ? "" : fields; if (search != null && search != "") { if (search.Split('|').Length > 1) { try { if (search.Split('|')[0] != "" && search.Split('|')[0] != "__/__/____") { biz.tungay = DateTime.ParseExact(search.Split('|')[0], "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")).ToString("yyyy-MM-dd"); } } catch { biz.tungay = ""; } try { if (search.Split('|')[1] != "" && search.Split('|')[1] != "__/__/____") { biz.denngay = DateTime.ParseExact(search.Split('|')[1], "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")).ToString("yyyy-MM-dd"); } } catch { biz.tungay = ""; } biz.KhachHang = search.Split('|')[2]; biz.Tinh = search.Split('|')[3]; if (search.Split('|')[4] != "") { biz.Loai = search.Split('|')[4].Substring(0, search.Split('|')[4].Length - 1); } } } if (fields != null && fields != "") { biz.quicksearch = string.Format(" (A.Ma LIKE N'%{0}%' OR A.Ten LIKE N'%{0}%')", fields); } var orderClause = sortName + " " + sortDir; var total = 0; biz.Ma_Form = "FL0033"; biz.FieldsField = "*"; biz.OrderClause = orderClause; biz.Skip = _start; biz.Take = _length; IEnumerable <dynamic> listKhoKhachHang = await biz.Execute(); if (listKhoKhachHang.Count() > 0) { var obj = listKhoKhachHang.FirstOrDefault(); total = Protector.Int(obj.MAXCNT); } dynamic _metaData = new System.Dynamic.ExpandoObject(); _metaData.draw = _draw; _metaData.total = total; return(ActionHelper.returnActionResult(HttpStatusCode.OK, listKhoKhachHang, _metaData)); } catch (Exception ex) { result.ReturnCode = HttpStatusCode.InternalServerError; result.ReturnData = new { error = new { code = HttpStatusCode.InternalServerError, type = HttpStatusCode.InternalServerError.ToString(), message = ex.InnerException != null ? ex.InnerException.Message : ex.Message } }; return(result); } }