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);
}
}
