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