/*public string MaPhongBan { get; set; } * public string TenPhongBan { get; set; } * public string GhiChu { get; set; } */ #endregion public async Task <ActionResultDto> Execute(ContextDto context) { try { validate(); var phongban = new Entity.MSSQL_QLDN_QLNS.Entity.PhongBan(); phongban.MaPhongBan = MaPhongBan; phongban.TenPhongBan = TenPhongBan; phongban.GhiChu = GhiChu; PhongBanRepository repo = new PhongBanRepository(context); await repo.Insert(phongban); return(returnActionResult(HttpStatusCode.OK, phongban, 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 PhongBanRepository(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 <dynamic> Execute(ContextDto context) { try { dynamic result = new System.Dynamic.ExpandoObject(); var repo = new PhongBanRepository(context); await repo.UpdatePartial(this, nameof(PhongBan.MaPhongBan), nameof(PhongBan.TenPhongBan), nameof(PhongBan.GhiChu), nameof(PhongBan.XoaYN) ); result.data = this; return(result); } catch (FormatException ex) { return(returnActionError(HttpStatusCode.BadRequest, ex.Message)); } catch (Exception ex) { return(returnActionError(HttpStatusCode.InternalServerError, ex.Message)); } }
public async Task <ActionResultDto> Execute(ContextDto context) { GetListPhongBanByCriteriaBiz biz = new GetListPhongBanByCriteriaBiz(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) ? "PhongBanId" : sortName; sortDir = string.IsNullOrEmpty(sortDir) ? "asc" : sortDir; _length = _length < 1 ? 10 : _length; fields = string.IsNullOrEmpty(fields) ? "PhongBanId,TenPhongBan,MaPhongBan,GhiChu,NgayTao,NguoiTao,CtrVersion" : fields; var whereClause = string.Format("MaPhongBan LIKE N'%{0}%' OR TenPhongBan 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; PhongBanRepository repo = new PhongBanRepository(context); IEnumerable <dynamic> listPhongBan = await biz.Execute(); if (listPhongBan.Count() > 0) { var obj = listPhongBan.FirstOrDefault(); total = Protector.Int(obj.MAXCNT); } dynamic _metaData = new System.Dynamic.ExpandoObject(); _metaData.draw = _draw; _metaData.total = total; return(ActionHelper.returnActionResult(HttpStatusCode.OK, listPhongBan, _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 PhongBanRepository(context); await repo.Delete(Id); result.data = await repo.Delete(Id); return(result); }
public ActionResult ExportExcel() { try { var webRoot = _env.WebRootPath; DataTable dt = new DataTable(); QuanLyCongVanContext db = new QuanLyCongVanContext(); var paht = System.IO.Path.Combine(webRoot, "Content/TempExcel/PhongBan.xlsx"); Workbook wb = new Workbook(); //Cell Cells = char.Parse(new Cell["A3"].ToString()); Worksheet ws = wb.Worksheets[0]; dt.Columns.Add("Mã phòng"); dt.Columns.Add("Tên");; dt.Columns.Add("Điện thoại"); dt.Columns.Add("Fax"); dt.Columns.Add("Mã nhân sự"); List <PhongBan> listpb = new List <PhongBan>(); listpb = db.PhongBan.ToList(); string listpbs = ""; if (listpb.Count > 0) { listpbs = String.Join(",", listpb.Select(x => x.ToString()).ToArray()); } var ob = new PhongBanRepository(); var data = ob.GetAll(); foreach (PhongBan item in data) { dt.Rows.Add(item.MaPhong, item.TenPhong, item.DienThoai, item.Fax, item.MaNhanSu); } string filename = "DanhSachPhongBan" + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + ".xlsx"; string folderName = "/assets/Excel/"; var file = System.IO.Path.Combine(webRoot + folderName + filename); if (!System.IO.Directory.Exists(folderName)) { System.IO.Directory.CreateDirectory(folderName); } ws.Cells.ImportDataTable(dt, false, 2, 0); wb.Save(file); return(Json(folderName + filename)); } catch (Exception ex) { throw ex; } }
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 _PhongBanId = Protector.Int(PhongBanId); var repo = new PhongBanRepository(context); var PhongBan = await repo.GetById(_PhongBanId); if (PhongBan == null) { return returnActionError(HttpStatusCode.BadRequest, string.Format("Không tìm thấy PhongBanId '{0}'", _PhongBanId)); } _result.ReturnCode = HttpStatusCode.OK; _result.ReturnData = new { data = PhongBan }; return _result; } catch (Exception ex) { return returnActionError(HttpStatusCode.InternalServerError, ex.InnerException != null ? ex.InnerException.Message : ex.Message); } }
public PhongBanController(PhongBanRepository repository) { _repository = repository ?? throw new ArgumentNullException(nameof(repository)); }
public PhongBanService(PhongBanRepository phongBanRepository) { _phongBanRepository = phongBanRepository; }