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 _KhachHangId = Protector.Int(KhachHangId);
GetListKhachHangByCriteriaBiz biz = new GetListKhachHangByCriteriaBiz(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.CtrVersion";
biz.OrderClause = "A.KhachHangId asc";
var KhachHang = await biz.Execute();
if (KhachHang == null)
{
return(returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy KhachHangId '{0}'", _KhachHangId)));
}
_result.ReturnCode = HttpStatusCode.OK;
_result.ReturnData = new
{
data = KhachHang
};
return(_result);
}
catch (Exception ex)
{
return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message));
}
}
public async Task <ActionResultDto> Execute(ContextDto context)
{
GetListKhachHangByCriteriaBiz biz = new GetListKhachHangByCriteriaBiz(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) ? "KhachHangId" : 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 = "FL0003";
biz.FieldsField = "*";
biz.OrderClause = orderClause;
biz.Skip = _start;
biz.Take = _length;
IEnumerable <dynamic> listKhachHang = await biz.Execute();
if (listKhachHang.Count() > 0)
{
var obj = listKhachHang.FirstOrDefault();
total = Protector.Int(obj.MAXCNT);
}
dynamic _metaData = new System.Dynamic.ExpandoObject();
_metaData.draw = _draw;
_metaData.total = total;
return(ActionHelper.returnActionResult(HttpStatusCode.OK, listKhachHang, _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);
}
}
