public async Task <ActionResultDto> Execute(ContextDto context) { try { init(); validate(); var count = 0; var repo = new DuAnRepository(context); for (int i = 0; i < _listId.Count; i++) { if (_listId[i] > 0 && await repo.Delete(_listId[i])) { count++; InsertLuocSuAction ls = new InsertLuocSuAction(); ls.InsertLuocSu(context, "ListDuAn", _listId[i], "Delete", 0); } } 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) { try { var duan = new Entity.MSSQL_QLDN_QLNS.Entity.DuAn(); duan.TenDuAn = TenDuAn; duan.MoTa = MoTa; duan.MaTrangThai = MaTrangThai; duan.PhongBan = Protector.Int(PhongBan); duan.QuanLy = Protector.Int(QuanLy); if (NgayBatDau != "" && NgayBatDau != null) { duan.NgayBatDau = DateTime.ParseExact(NgayBatDau, "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")); } if (NgayThatSuBatDau != null && NgayThatSuBatDau != "") { duan.NgayThatSuBatDau = DateTime.ParseExact(NgayThatSuBatDau, "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")); } if (NgayKetThuc != null && NgayKetThuc != "") { duan.NgayKetThuc = DateTime.ParseExact(NgayKetThuc, "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")); } if (NgayThatSuKetThuc != null && NgayThatSuKetThuc != "") { duan.NgayThatSuKetThuc = DateTime.ParseExact(NgayThatSuKetThuc, "dd/MM/yyyy", CultureInfo.GetCultureInfo("fr-FR")); } duan.NguoiTao = Protector.Int(NguoiTao); duan.NgayTao = DateTime.Now; duan.XoaYN = "N"; duan.CtrVersion = 1; DuAnRepository repo = new DuAnRepository(context); await repo.Insert(duan); InsertLuocSuAction ls = new InsertLuocSuAction(); ls.InsertLuocSu(context, "DuAn", duan.DuAnId, "Insert", duan.NguoiTao); if (NhanVien != "" && NhanVien != null) { var nvda = new Entity.MSSQL_QLDN_QLNS.Entity.NhanVienDuAn(); var nvids = NhanVien.Split('|'); foreach (var nv in nvids) { nvda.DuAnId = duan.DuAnId; nvda.XoaYN = "N"; nvda.NhanVienId = Protector.Int(nv); await repo.InsertNV(nvda); } } return(returnActionResult(HttpStatusCode.OK, duan, 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 DuAnRepository(context); await repo.UpdatePartial(this, nameof(TenDuAn), nameof(MoTa), nameof(MaTrangThai), nameof(PhongBan), nameof(QuanLy), nameof(NgayBatDau), nameof(NgayThatSuBatDau), nameof(NgayKetThuc), nameof(CtrVersion), nameof(NgayThatSuKetThuc) ); result.data = this; InsertLuocSuAction ls = new InsertLuocSuAction(); ls.InsertLuocSu(context, "DuAn", DuAnId, "Update", NguoiTao); Data.QLNS.DuAn.DeleteOneNhanVienDuAnDac dac = new Data.QLNS.DuAn.DeleteOneNhanVienDuAnDac(context); dac.DuAnId = DuAnId.ToString(); await dac.Execute(); if (NhanVien != null && NhanVien != "") { var nvda = new Entity.MSSQL_QLDN_QLNS.Entity.NhanVienDuAn(); var nvids = NhanVien.Split('|'); foreach (var nv in nvids) { nvda.DuAnId = DuAnId; nvda.XoaYN = "N"; nvda.NhanVienId = Protector.Int(nv); await repo.InsertNV(nvda); } } return(returnActionResult(this, null)); } catch (FormatException ex) { return(returnActionError(HttpStatusCode.BadRequest, ex.Message)); } catch (Exception ex) { return(returnActionError(HttpStatusCode.InternalServerError, ex.Message)); } }
public async Task <dynamic> Execute(ContextDto context) { try { init(); validate(); var repo = new DuAnRepository(context); if (_DuAn != null) { var duanEntity = new Entity.MSSQL_QLDN_QLNS.Entity.DuAn(); duanEntity.DuAnId = _DuAn.DuAnId; duanEntity.CtrVersion = _DuAn.CtrVersion; duanEntity.XoaYN = "Y"; duanEntity = await repo.UpdatePartial(duanEntity, nameof(Entity.MSSQL_QLDN_QLNS.Entity.DuAn.XoaYN) ); _DuAn.XoaYN = duanEntity.XoaYN; if (_DuAn.NhanVienDa.Length > 0) { var nvda = new Entity.MSSQL_QLDN_QLNS.Entity.NhanVienDuAn(); var nvids = _DuAn.NhanVienDa.Split('|'); foreach (var nv in nvids) { nvda.DuAnId = _DuAn.DuAnId; nvda.NhanVienId = Protector.Int(nv); nvda.XoaYN = "Y"; nvda = await repo.UpdatePartialNV(nvda, nameof(Entity.MSSQL_QLDN_QLNS.Entity.NhanVienDuAn.XoaYN) ); } } } else { if (_listDuAn != null && _listDuAn.Count > 0) { foreach (var duanModel in _listDuAn) { if (duanModel.DuAnId > 0) { var duanEntity = new Entity.MSSQL_QLDN_QLNS.Entity.DuAn(); duanEntity.DuAnId = duanModel.DuAnId; duanEntity.CtrVersion = duanModel.CtrVersion; duanEntity.XoaYN = "Y"; duanEntity = await repo.UpdatePartial(duanEntity, nameof(Entity.MSSQL_QLDN_QLNS.Entity.DuAn.XoaYN) ); duanModel.XoaYN = duanEntity.XoaYN; if (duanModel.NhanVienDa != null) { var nvda = new Entity.MSSQL_QLDN_QLNS.Entity.NhanVienDuAn(); var nvids = duanModel.NhanVienDa.Split('|'); foreach (var nv in nvids) { nvda.DuAnId = duanModel.DuAnId; nvda.NhanVienId = Protector.Int(nv); nvda.XoaYN = "Y"; nvda = await repo.UpdatePartialNV(nvda, nameof(Entity.MSSQL_QLDN_QLNS.Entity.NhanVienDuAn.XoaYN) ); } } } } } } return(ActionHelper.returnActionResult(HttpStatusCode.OK, _listDuAn, null)); } catch (FormatException ex) { return(ActionHelper.returnActionError(HttpStatusCode.BadRequest, ex.Message)); } catch (Exception ex) { return(ActionHelper.returnActionError(HttpStatusCode.InternalServerError, ex.Message)); } }