public async Task <dynamic> Execute(ContextDto context)
{
try
{
dynamic result = new System.Dynamic.ExpandoObject();
var repo = new KhoNuocSanXuatRepository(context);
await repo.UpdatePartial(this,
nameof(MaNuoc),
nameof(TenNuoc),
nameof(MoTa)
);
result.data = this;
return(result);
}
catch (FormatException ex)
{
return(returnActionError(HttpStatusCode.BadRequest, ex.Message));
}
catch (Exception ex)
{
return(returnActionError(HttpStatusCode.InternalServerError, ex.Message));
}
}
/*public string MaKhoNuocSanXuat { get; set; }
* public string TenKhoNuocSanXuat { get; set; }
* public string GhiChu { get; set; } */
#endregion
public async Task <ActionResultDto> Execute(ContextDto context)
{
try
{
validate();
var nuocsx = new Entity.MSSQL_QLDN_QLNS.Entity.KhoNuocSanXuat();
nuocsx.MaNuoc = MaNuoc;
nuocsx.TenNuoc = TenNuoc;
nuocsx.MoTa = MoTa;
nuocsx.NguoiTao = NguoiTao;
nuocsx.NgayTao = DateTime.Now;
nuocsx.XoaYN = "N";
KhoNuocSanXuatRepository repo = new KhoNuocSanXuatRepository(context);
await repo.Insert(nuocsx);
return(returnActionResult(HttpStatusCode.OK, nuocsx, null));
}
catch (FormatException ex)
{
return(returnActionError(HttpStatusCode.BadRequest, ex.InnerException != null ? ex.InnerException.Message : ex.Message));
}
catch (Exception ex)
{
return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message));
}
}
public async Task <ActionResultDto> Execute(ContextDto context)
{
GetListKhoNuocSanXuatByCriteriaBiz biz = new GetListKhoNuocSanXuatByCriteriaBiz(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) ? "KhoNuocSanXuatId" : sortName;
sortDir = string.IsNullOrEmpty(sortDir) ? "asc" : sortDir;
_length = _length < 1 ? 10 : _length;
fields = string.IsNullOrEmpty(fields) ? "KhoNuocSanXuatId,TenKhoNuocSanXuat,MaKhoNuocSanXuat,GhiChu,NgayTao,NguoiTao,CtrVersion" : fields;
var whereClause = string.Format("MaNuoc LIKE N'%{0}%' OR TenNuoc LIKE N'%{0}%'", search);
var orderClause = sortName + " " + sortDir;
var total = 0;
biz.FieldsField = fields;
biz.WhereClause = whereClause;
biz.OrderClause = orderClause;
biz.Skip = _start;
biz.Take = _length;
KhoNuocSanXuatRepository repo = new KhoNuocSanXuatRepository(context);
IEnumerable <dynamic> listKhoNuocSanXuat = await biz.Execute();
if (listKhoNuocSanXuat.Count() > 0)
{
var obj = listKhoNuocSanXuat.FirstOrDefault();
total = Protector.Int(obj.MAXCNT);
}
dynamic _metaData = new System.Dynamic.ExpandoObject();
_metaData.draw = _draw;
_metaData.total = total;
return(ActionHelper.returnActionResult(HttpStatusCode.OK, listKhoNuocSanXuat, _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);
}
}
public async Task <dynamic> Execute(ContextDto context)
{
dynamic result = new System.Dynamic.ExpandoObject();
var repo = new KhoNuocSanXuatRepository(context);
await repo.Delete(Id);
result.data = await repo.Delete(Id);
return(result);
}
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 _KhoNuocSanXuatId = Protector.Int(KhoNuocSanXuatId);
var repo = new KhoNuocSanXuatRepository(context);
var KhoNuocSanXuat = await repo.GetById(_KhoNuocSanXuatId);
if (KhoNuocSanXuat == null)
{
return(returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy KhoNuocSanXuatId '{0}'", _KhoNuocSanXuatId)));
}
_result.ReturnCode = HttpStatusCode.OK;
_result.ReturnData = new
{
data = KhoNuocSanXuat
};
return(_result);
}
catch (Exception ex)
{
return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message));
}
}
