public async Task <ActionResultDto> Execute(ContextDto context)
{
try
{
validate();
var chucnang = new Entity.MSSQL_QLDN_MAIN.Entity.ChucNang();
chucnang.MaChucNang = MaChucNang;
chucnang.TenChucNang = TenChucNang;
chucnang.MoTa = MoTa;
chucnang.NgayTaoDT = DateTime.Now;
chucnang.NgaySuaDT = DateTime.Now;
ChucNangRepository repo = new ChucNangRepository(context);
await repo.Insert(chucnang);
return(returnActionResult(HttpStatusCode.OK, chucnang, 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)
{
try
{
init();
validate();
var count = 0;
var repo = new ChucNangRepository(context);
for (int i = 0; i < _listId.Count; i++)
{
if (_listId[i] > 0 && await repo.Delete(_listId[i]))
{
count++;
}
}
return(returnActionResult(HttpStatusCode.OK, count, 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)
{
var _result = new ActionResultDto();
try
{
init();
validate();
var repo = new ChucNangRepository(context);
var chucNang = await repo.GetById(_ChucNangId);
if (chucNang == null)
{
return(returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy ChucNangId '{0}'", _ChucNangId)));
}
return(returnActionResult(HttpStatusCode.OK, chucNang, 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)
{
try
{
init();
validate();
var whereClause = string.Format("MaChucNang LIKE N'%{0}%' OR TenChucNang LIKE N'%{0}%'", search);
var orderClause = sortName + " " + sortDir;
var total = 0;
ChucNangRepository repo = new ChucNangRepository(context);
IEnumerable <dynamic> listChucNang = await repo.SelectAllByCriteriaProjection(fields, whereClause, orderClause, _start, _length);
total = await repo.SelectAllByCriteriaCount(whereClause);
dynamic _metaData = new System.Dynamic.ExpandoObject();
_metaData.draw = _draw;
_metaData.total = total;
return(returnActionResult(listChucNang, _metaData));
}
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)
{
try
{
/* kiểm tra input */
var _error = validate();
if (_error.code > 0)
{
return(returnActionError(HttpStatusCode.BadRequest, _error.message));
}
/* convert input */
var _chucNangId = Protector.Int(ChucNangId);
var _CtrVersion = Protector.Int(CtrVersion);
var repo = new ChucNangRepository(context);
var fields = new string[] {
nameof(Entity.MSSQL_QLDN_MAIN.Entity.ChucNang.ChucNangId),
nameof(Entity.MSSQL_QLDN_MAIN.Entity.ChucNang.MaChucNang),
nameof(Entity.MSSQL_QLDN_MAIN.Entity.ChucNang.TenChucNang),
nameof(Entity.MSSQL_QLDN_MAIN.Entity.ChucNang.MoTa),
nameof(Entity.MSSQL_QLDN_MAIN.Entity.ChucNang.NgaySuaDT)
};
var chucNang = new Entity.MSSQL_QLDN_MAIN.Entity.ChucNang();
chucNang.ChucNangId = _chucNangId;
chucNang.MaChucNang = MaChucNang;
chucNang.TenChucNang = TenChucNang;
chucNang.MoTa = MoTa;
chucNang.NgaySuaDT = DateTime.Now;
chucNang.CtrVersion = _CtrVersion;
chucNang = await repo.UpdatePartial(chucNang, fields);
if (chucNang == null)
{
return(returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy ChucNangId '{0}'", _chucNangId)));
}
return(returnActionResult(HttpStatusCode.OK, chucNang, null));
}
catch (Exception ex)
{
return(returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message));
}
}
