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 _TamUngId = Protector.Int(TamUngId);
GetListTamUngByCriteraBiz biz = new GetListTamUngByCriteraBiz(context);
biz.TamUngId = TamUngId;
biz.FieldsField = "A.*";
biz.OrderClause = "A.TamUngId asc";
var TamUng = await biz.Execute();
if (TamUng == null)
{
return(returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy TamUngId '{0}'", _TamUngId)));
}
_result.ReturnCode = HttpStatusCode.OK;
_result.ReturnData = new
{
data = TamUng
};
return(_result);
}
catch (Exception ex)
{
return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message));
}
}
public async Task <ActionResultDto> Execute(ContextDto context)
{
GetListTamUngByCriteraBiz biz = new GetListTamUngByCriteraBiz(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) ? "TamUngId" : 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.DenNgay = "";
}
if (search.Split('|')[2].Length > 0)
{
biz.TheLoai = search.Split('|')[2].Substring(0, search.Split('|')[2].Length - 1);
}
biz.NhanVien = search.Split('|')[3];
}
}
var orderClause = sortName + " " + sortDir;
var total = 0;
biz.LoginId = LoginId;
biz.FieldsField = fields;
biz.OrderClause = orderClause;
biz.Skip = _start;
biz.Take = _length;
IEnumerable <dynamic> listTamUng = await biz.Execute();
if (listTamUng.Count() > 0)
{
var obj = listTamUng.FirstOrDefault();
total = Protector.Int(obj.MAXCNT);
}
dynamic _metaData = new System.Dynamic.ExpandoObject();
_metaData.draw = _draw;
_metaData.total = total;
return(ActionHelper.returnActionResult(HttpStatusCode.OK, listTamUng, _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);
}
}
