public async Task <IActionResult> PutSys_Dm_Company(int id, Sys_Dm_Company sys_Dm_Company) { if (id != sys_Dm_Company.Id) { return(BadRequest()); } _context.Entry(sys_Dm_Company).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Sys_Dm_CompanyExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <IEnumerable <CV_QT_MyWork> > > r2AddFLowDeadline() { try { var model = JsonConvert.DeserializeObject <Dtos_FlowWorkPheDuyetTH>(Request.Form["model"]); RequestToken token = CommonData.GetDataFromToken(User); // lưu quy trình luân chuyển công việc phê duyệt công việc CV_QT_WorkFlow wflow = WorksCommon.objWorkFlow(_context, model.CV_QT_WorkFlow.MyWorkId, token.UserID, model.CV_QT_WorkFlow.UserDeliverId, model.CV_QT_WorkFlow.TypeFlow, "CV_MYWORK", model.CV_QT_WorkFlow.ParentId, model.CV_QT_WorkFlow.Note, model.CV_QT_WorkFlow.Require, 1); if (model.CV_QT_WorkFlow.TypeFlow == 2) { var myWork = await _context.CV_QT_MyWork.FindAsync(model.CV_QT_WorkFlow.MyWorkId); myWork.EndDate = model.ChangeDate; } _context.CV_QT_WorkFlow.Add(wflow); if (Request.Form.Files.Count != 0) { foreach (var item in Request.Form.Files) { CV_QT_WorkFlowFile obj = new CV_QT_WorkFlowFile(); var file = item; var folderName = Path.Combine("Resources", "WorkFlows", "Deadlines"); var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName); if (!Directory.Exists(pathToSave)) { Directory.CreateDirectory(pathToSave); } if (model != null) { if (file.Length > 0) { var fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"'); var fullPath = Path.Combine(pathToSave, fileName); var dbPath = Path.Combine(folderName, fileName); obj.Extension = Path.GetExtension(fileName); obj.Path = dbPath; using (var stream = new FileStream(fullPath, FileMode.Create)) { file.CopyTo(stream); } } } obj.Name = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"'); obj.WorkFlowId = wflow.Id; obj.Size = file.Length / 1048576; _context.CV_QT_WorkFlowFile.Add(obj); } } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_User> > > r1AddDataSysDmUser(UserGroupRole userGroupRole) { try { RequestToken token = CommonData.GetDataFromToken(User); var userLogin = await _context.Sys_Dm_User.FindAsync(token.UserID); if (_context.Sys_Dm_User.Count(x => x.Code == userGroupRole.sys_Dm_User.Code) > 0) { return(new ObjectResult(new { error = 2, ms = "Mã nhân viên đã tồn tại trong hệ thống." })); } var department = await _context.Sys_Dm_Department.FindAsync(userLogin.DepartmentId); var nest = await _context.Sys_Dm_Department.FindAsync(userGroupRole.sys_Dm_User.NestId); Nullable <int> NestId = null; if (nest != null) { NestId = nest.Id; } var position = await _context.Sys_Dm_Position.FindAsync(userGroupRole.sys_Dm_User.PositionId); if (position == null) { return(new ObjectResult(new { error = 2, ms = "Chưa chọn chức vụ cho nhân viên mới." })); } string PasswordEn = Helper.Encrypt(userGroupRole.sys_Dm_User.Username, userGroupRole.sys_Dm_User.Password); userGroupRole.sys_Dm_User.Password = PasswordEn; userGroupRole.sys_Dm_User.PositionName = position.Name; userGroupRole.sys_Dm_User.DepartmentName = department.Name; userGroupRole.sys_Dm_User.UserCreateId = token.UserID; userGroupRole.sys_Dm_User.CreateDate = DateTime.Now; userGroupRole.sys_Dm_User.NestId = NestId; _context.Sys_Dm_User.Add(userGroupRole.sys_Dm_User); await _context.SaveChangesAsync(); var user = _context.Sys_Dm_User.FirstOrDefault(x => x.Code == userGroupRole.sys_Dm_User.Code); foreach (var item in userGroupRole.GroupRoles) { Sys_Cog_UsersGroup obj = new Sys_Cog_UsersGroup(); obj.UserId = user.Id; obj.GroupRoleId = item.Id; _context.Sys_Cog_UsersGroup.Add(obj); } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_User> > > ChangePassword(ChangePass change) { try { RequestToken token = CommonData.GetDataFromToken(User); var user = await _context.Sys_Dm_User.FindAsync(token.UserID); string passwordOld = Helper.Encrypt(user.Username, change.PassOld); string passwordNew = Helper.Encrypt(user.Username, change.PassNew); if (passwordOld == user.Password) { user.Password = passwordNew; } else { return(new ObjectResult(new { error = 1 })); } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_User> > > ChangePassword(ChangePass change) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var user = await _context.Sys_Dm_User.FindAsync(userId); string passwordOld = Helper.Encrypt(user.Username, change.PassOld); string passwordNew = Helper.Encrypt(user.Username, change.PassNew); if (passwordOld == user.Password) { user.Password = passwordNew; } else { return(new ObjectResult(new { error = 1 })); } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_User> > > r1AddDataSysDmUser(UserGroupRole userGroupRole) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var userLogin = await _context.Sys_Dm_User.FindAsync(userId); if (_context.Sys_Dm_User.Count(x => x.Code == userGroupRole.sys_Dm_User.Code) > 0) { return(new ObjectResult(new { error = 2, ms = "Mã nhân viên đã tồn tại trong hệ thống." })); } var department = await _context.Sys_Dm_Department.FindAsync(userLogin.ParentDepartId); var position = await _context.Sys_Dm_Position.FindAsync(userGroupRole.sys_Dm_User.PositionId); if (position == null) { return(new ObjectResult(new { error = 2, ms = "Chưa chọn chức vụ cho nhân viên mới." })); } string PasswordEn = Helper.Encrypt(userGroupRole.sys_Dm_User.Username, userGroupRole.sys_Dm_User.Password); userGroupRole.sys_Dm_User.Password = PasswordEn; userGroupRole.sys_Dm_User.PositionName = position.Name; userGroupRole.sys_Dm_User.DepartmentName = department.Name; userGroupRole.sys_Dm_User.UserCreateId = userId; userGroupRole.sys_Dm_User.CreateDate = DateTime.Now; _context.Sys_Dm_User.Add(userGroupRole.sys_Dm_User); await _context.SaveChangesAsync(); var user = _context.Sys_Dm_User.FirstOrDefault(x => x.Code == userGroupRole.sys_Dm_User.Code); foreach (var item in userGroupRole.GroupRoles) { Sys_Cog_UsersGroup obj = new Sys_Cog_UsersGroup(); obj.UserId = user.Id; obj.GroupRoleId = item.Id; _context.Sys_Cog_UsersGroup.Add(obj); } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_Company> > > r1PostUpdateThongBao(OptionId thongbao) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var tables = await _context.Sys_QT_ThongBao.FindAsync(thongbao.Id); tables.DaDoc = true; tables.NgayDoc = DateTime.Now; await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <CV_DM_Error> > > r2PostAddWorkCV_DM_Error(CV_DM_Error data) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var user = await _context.Sys_Dm_User.FindAsync(userId); data.DepartmentId = user.DepartmentId ?? 0; _context.CV_DM_Error.Add(data); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, ms = "Thêm mới lỗi đánh giá công việc thành công!" })); } catch (Exception) { return(new ObjectResult(new { error = 1, ms = "Thêm mới lỗi đánh giá công việc không thành công!" })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_GroupRole> > > r1AddDataGroupRole(Sys_Dm_GroupRole sys_Dm_Group) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); sys_Dm_Group.UserCreateId = userId; sys_Dm_Group.CreateDate = DateTime.Now; sys_Dm_Group.RankRole = GetRankRole(sys_Dm_Group); _context.Sys_Dm_GroupRole.Add(sys_Dm_Group); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_Company> > > r1PostUpdateThongBao(OptionId thongbao) { try { RequestToken token = CommonData.GetDataFromToken(User); var tables = await _context.Sys_QT_ThongBao.FindAsync(thongbao.Id); tables.DaDoc = true; tables.NgayDoc = DateTime.Now; await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <Sys_Dm_GroupRole> > > r1AddDataGroupRole(Sys_Dm_GroupRole sys_Dm_Group) { try { RequestToken token = CommonData.GetDataFromToken(User); sys_Dm_Group.UserCreateId = token.UserID; sys_Dm_Group.CreateDate = DateTime.Now; sys_Dm_Group.RankRole = GetRankRole(sys_Dm_Group); _context.Sys_Dm_GroupRole.Add(sys_Dm_Group); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <CV_DM_Error> > > r2PostAddWorkCV_DM_Error(CV_DM_Error data) { try { RequestToken token = CommonData.GetDataFromToken(User); var user = await _context.Sys_Dm_User.FindAsync(token.UserID); data.DepartmentId = user.DepartmentId ?? 0; _context.CV_DM_Error.Add(data); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, ms = "Thêm mới lỗi đánh giá công việc thành công!" })); } catch (Exception) { return(new ObjectResult(new { error = 1, ms = "Thêm mới lỗi đánh giá công việc không thành công!" })); } }
public async Task SaveNotifiAsync(int QuyTrinhId, string MaLenh, string TenNguoiGui, string NoiDung, int NguoiNhanId, int TrangThaixl, string router) { Sys_QT_ThongBao sys_QT_ThongBao = new Sys_QT_ThongBao() { QuyTrinhId = QuyTrinhId, MaLenh = MaLenh, TenNguoiGui = TenNguoiGui, NoiDung = NoiDung, NgayGui = DateTime.Now, NgayDoc = null, DaDoc = false, RouterLink = router, NguoiNhanId = NguoiNhanId, TrangThaiXuLy = TrangThaixl, TrangThai = getTrangThaiXuLy(TrangThaixl, QuyTrinhId), IsNotifi = true }; NotifyContent notifyContent = new NotifyContent() { TenNguoiGui = sys_QT_ThongBao.TenNguoiGui, TrangThai = sys_QT_ThongBao.TrangThai, Ngay = DateTime.Now, NoiDung = sys_QT_ThongBao.NoiDung }; var connect = await _context.Sys_Dm_Connection.FirstOrDefaultAsync(x => x.UserId == NguoiNhanId); if (connect != null) { int[] typeflow = { 2, 3, 5, 6, 16, 15 }; if (QuyTrinhId == 2 && typeflow.Contains(TrangThaixl)) { int[] pushtypef = { TrangThaixl }; HubService.Instance.PushTypeFlow(pushtypef, connect.ConnectionId); } HubService.Instance.CallHub(notifyContent, connect.ConnectionId); } else { sys_QT_ThongBao.IsNotifi = false; } _context.Sys_QT_ThongBao.Add(sys_QT_ThongBao); await _context.SaveChangesAsync(); }
public static async Task saveDateChangeMyWork(humanDbContext dbContext, string MyWorkId, DateTime DateEnd, DateTime DateStart, int UserId) { CV_QT_MyWorkChangeDate myWorkChangeDate = new CV_QT_MyWorkChangeDate() { MyWorkId = MyWorkId, EndDate = DateEnd, StartDate = DateStart, CreatedBy = UserId }; dbContext.CV_QT_MyWorkChangeDate.Add(myWorkChangeDate); await dbContext.SaveChangesAsync(); }
public async Task <ActionResult <IEnumerable <VB_QT_QuyTrinh> > > r2AddListDataBuocLenh(QuyTrinhVB options) { try { if (_context.VB_QT_BuocLenhTuongTac.Count(x => x.LenhTuongTacId == options.LenhTuongTacId && x.BuocId == options.BuocId) > 0) { return(new ObjectResult(new { error = 2 })); } VB_QT_BuocLenhTuongTac obj = new VB_QT_BuocLenhTuongTac(); obj.BuocId = options.BuocId ?? 1; obj.LenhTuongTacId = options.LenhTuongTacId ?? 1; obj.IsOrder = _context.VB_QT_BuocLenhTuongTac.Count() + 1; _context.VB_QT_BuocLenhTuongTac.Add(obj); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <CV_DM_DefaultTask> > > r1PostAddWorkDefault(CV_DM_DefaultTask defaultTask) { try { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var user = await _context.Sys_Dm_User.FindAsync(userId); defaultTask.Id = Helper.GenKey(); defaultTask.Frequency = 1; defaultTask.PointTask = getPointTask(defaultTask.LevelTask, 1); defaultTask.PointTime = getPointTask(defaultTask.LevelTime, 2); defaultTask.DepartmentId = user.ParentDepartId; _context.CV_DM_DefaultTask.Add(defaultTask); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, ms = "Thêm mới công việc thường xuyên thành công!" })); } catch (Exception) { return(new ObjectResult(new { error = 1, ms = "Thêm mới công việc thường xuyên không thành công!" })); } }
public async Task <ActionResult <IEnumerable <CV_DM_DefaultTask> > > r1PostAddWorkDefault(CV_DM_DefaultTask defaultTask) { try { RequestToken token = CommonData.GetDataFromToken(User); var user = await _context.Sys_Dm_User.FindAsync(token.UserID); defaultTask.Id = Helper.GenKey(); defaultTask.Frequency = 1; defaultTask.PointTask = getPointTask(defaultTask.LevelTask, 1); defaultTask.PointTime = getPointTask(defaultTask.LevelTime, 2); defaultTask.DepartmentId = user.ParentDepartId; _context.CV_DM_DefaultTask.Add(defaultTask); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, ms = "Thêm mới công việc thường xuyên thành công!" })); } catch (Exception) { return(new ObjectResult(new { error = 1, ms = "Thêm mới công việc thường xuyên không thành công!" })); } }
public async Task <ActionResult <IEnumerable <VB_QT_LuanChuyenVanBan> > > r2ThuHoiQuyTrinhVanBan(VB_QT_LuanChuyenVanBan vB_QT_LuanChuyenVanBan) { var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var tables = _context.VB_QT_LuanChuyenVanBan.Where(b => b.MaLenh == "VB_XNHT" && b.NguoiGuiId == userId && b.VbMoiSoHoaId == vB_QT_LuanChuyenVanBan.VbMoiSoHoaId); if (tables == null) { return(new ObjectResult(new { error = 1 })); } foreach (var item in tables) { item.MaLenh = "VB_THUHOI"; item.NgayXuLy = DateTime.Now; item.NoiDung = vB_QT_LuanChuyenVanBan.NoiDung; } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, })); }
public async Task <ActionResult <IEnumerable <VB_QT_LuanChuyenVanBan> > > r2ThuHoiQuyTrinhVanBan(VB_QT_LuanChuyenVanBan vB_QT_LuanChuyenVanBan) { RequestToken token = CommonData.GetDataFromToken(User); var tables = _context.VB_QT_LuanChuyenVanBan.Where(b => b.MaLenh == "VB_XNHT" && b.NguoiGuiId == token.UserID && b.VbMoiSoHoaId == vB_QT_LuanChuyenVanBan.VbMoiSoHoaId); if (tables == null) { return(new ObjectResult(new { error = 1 })); } foreach (var item in tables) { item.MaLenh = "VB_THUHOI"; item.NgayXuLy = DateTime.Now; item.NoiDung = vB_QT_LuanChuyenVanBan.NoiDung; } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, })); }
public async Task <ActionResult <IEnumerable <Sys_Cog_Permission> > > r2AddDataModel(MenuPermissionCom options) { try { if (options.NestId > 0) { options.DepartmentId = options.NestId; } RequestToken token = CommonData.GetDataFromToken(User); var menuThree = await _context.Sys_Dm_Menu.FindAsync(options.MenuId); var menuComThree = _context.Sys_Cog_Permission.Count(x => x.MenuId == menuThree.Id && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); if (menuComThree == 0) { var menuTwo = await _context.Sys_Dm_Menu.FindAsync(menuThree.ParentId); var menuComTwo = _context.Sys_Cog_Permission.Count(x => x.MenuId == menuThree.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); if (menuComTwo == 0) { var menuOne = await _context.Sys_Dm_Menu.FindAsync(menuTwo.ParentId); var menuComOne = _context.Sys_Cog_Permission.Count(x => x.MenuId == menuTwo.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); if (menuComOne == 0) { Sys_Cog_Permission objOne = new Sys_Cog_Permission(); objOne.MenuId = menuOne.Id; objOne.GroupRoleId = options.GroupRoleId; objOne.DepartmentId = options.DepartmentId; objOne.CompanyId = options.CompanyId; objOne.IsActive = true; objOne.AddPer = options.AddPer ?? false; objOne.ViewPer = options.ViewPer ?? false; objOne.EditPer = options.EditPer ?? false; objOne.ExportPer = options.ExportPer ?? false; objOne.DelPer = options.DelPer ?? false; objOne.UserCreateId = token.UserID; objOne.CreatDate = DateTime.Now; objOne.ParentId = null; _context.Sys_Cog_Permission.Add(objOne); Sys_Cog_Permission objTwo = new Sys_Cog_Permission(); objTwo.MenuId = menuTwo.Id; objTwo.GroupRoleId = options.GroupRoleId; objTwo.CompanyId = options.CompanyId; objTwo.DepartmentId = options.DepartmentId; objTwo.IsActive = true; objTwo.AddPer = options.AddPer ?? false; objTwo.ViewPer = options.ViewPer ?? false; objTwo.EditPer = options.EditPer ?? false; objTwo.ExportPer = options.ExportPer ?? false; objTwo.DelPer = options.DelPer ?? false; objTwo.UserCreateId = token.UserID; objTwo.CreatDate = DateTime.Now; objTwo.ParentId = menuOne.Id; _context.Sys_Cog_Permission.Add(objTwo); Sys_Cog_Permission objThree = new Sys_Cog_Permission(); objThree.MenuId = options.MenuId; objThree.GroupRoleId = options.GroupRoleId; objThree.DepartmentId = options.DepartmentId; objThree.CompanyId = options.CompanyId; objThree.IsActive = true; objThree.AddPer = options.AddPer ?? false; objThree.ViewPer = options.ViewPer ?? false; objThree.EditPer = options.EditPer ?? false; objThree.ExportPer = options.ExportPer ?? false; objThree.DelPer = options.DelPer ?? false; objThree.UserCreateId = token.UserID; objThree.CreatDate = DateTime.Now; objThree.ParentId = menuTwo.Id; _context.Sys_Cog_Permission.Add(objThree); } else { Sys_Cog_Permission objTwo = new Sys_Cog_Permission(); objTwo.MenuId = menuTwo.Id; objTwo.GroupRoleId = options.GroupRoleId; objTwo.DepartmentId = options.DepartmentId; objTwo.CompanyId = options.CompanyId; objTwo.IsActive = true; objTwo.AddPer = options.AddPer ?? false; objTwo.ViewPer = options.ViewPer ?? false; objTwo.EditPer = options.EditPer ?? false; objTwo.ExportPer = options.ExportPer ?? false; objTwo.DelPer = options.DelPer ?? false; objTwo.UserCreateId = token.UserID; objTwo.CreatDate = DateTime.Now; objTwo.ParentId = menuOne.Id; _context.Sys_Cog_Permission.Add(objTwo); Sys_Cog_Permission objThree = new Sys_Cog_Permission(); objThree.MenuId = options.MenuId; objThree.GroupRoleId = options.GroupRoleId; objThree.DepartmentId = options.DepartmentId; objThree.CompanyId = options.CompanyId; objThree.IsActive = true; objThree.AddPer = options.AddPer ?? false; objThree.ViewPer = options.ViewPer ?? false; objThree.EditPer = options.EditPer ?? false; objThree.ExportPer = options.ExportPer ?? false; objThree.DelPer = options.DelPer ?? false; objThree.UserCreateId = token.UserID; objThree.CreatDate = DateTime.Now; objThree.ParentId = menuTwo.Id; _context.Sys_Cog_Permission.Add(objThree); } } else { var menuComTwoParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuThree.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); Sys_Cog_Permission objThree = new Sys_Cog_Permission(); objThree.MenuId = options.MenuId; objThree.GroupRoleId = options.GroupRoleId; objThree.CompanyId = options.CompanyId; objThree.DepartmentId = options.DepartmentId; objThree.IsActive = true; objThree.AddPer = options.AddPer ?? false; objThree.ViewPer = options.ViewPer ?? false; objThree.EditPer = options.EditPer ?? false; objThree.ExportPer = options.ExportPer ?? false; objThree.DelPer = options.DelPer ?? false; objThree.UserCreateId = token.UserID; objThree.CreatDate = DateTime.Now; objThree.ParentId = menuTwo.Id; _context.Sys_Cog_Permission.Add(objThree); #region ViewPer three nhap vao = true if (_context.Sys_Cog_Permission.Count(x => x.ViewPer == true && x.ParentId == menuThree.ParentId && x.GroupRoleId == options.GroupRoleId && x.CompanyId == options.CompanyId && x.MenuId != options.MenuId) == 0) { var menuTwoParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuThree.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); menuTwoParent.ViewPer = true; if (_context.Sys_Cog_Permission.Count(x => x.ViewPer == true && x.ParentId == menuTwoParent.ParentId && x.GroupRoleId == options.GroupRoleId && x.CompanyId == options.CompanyId && x.MenuId != menuTwoParent.MenuId) == 0) { var menuoneParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuTwoParent.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); menuoneParent.ViewPer = true; } } #endregion } } else { var menuCome = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == options.MenuId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); #region Viewper nhap vao = false if (options.ViewPer == false && menuCome.ViewPer == true) { if (_context.Sys_Cog_Permission.Count(x => x.ViewPer == true && x.ParentId == menuCome.ParentId && x.GroupRoleId == options.GroupRoleId && x.CompanyId == options.CompanyId && x.MenuId != options.MenuId) == 0) { var menuTwoParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuCome.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); menuTwoParent.ViewPer = false; if (_context.Sys_Cog_Permission.Count(x => x.ViewPer == true && x.ParentId == menuTwoParent.ParentId && x.GroupRoleId == options.GroupRoleId && x.CompanyId == options.CompanyId && x.MenuId != menuTwoParent.MenuId) == 0) { var menuoneParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuTwoParent.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); menuoneParent.ViewPer = false; } } } #endregion #region ViewPer three nhap vao = true if (options.ViewPer == true && menuCome.ViewPer == false) { if (_context.Sys_Cog_Permission.Count(x => x.ViewPer == true && x.ParentId == menuCome.ParentId && x.GroupRoleId == options.GroupRoleId && x.CompanyId == options.CompanyId && x.MenuId != options.MenuId) == 0) { var menuTwoParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuCome.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); menuTwoParent.ViewPer = true; if (_context.Sys_Cog_Permission.Count(x => x.ViewPer == true && x.ParentId == menuTwoParent.ParentId && x.GroupRoleId == options.GroupRoleId && x.CompanyId == options.CompanyId && x.MenuId != menuTwoParent.MenuId) == 0) { var menuoneParent = await _context.Sys_Cog_Permission.FirstOrDefaultAsync(x => x.MenuId == menuTwoParent.ParentId && x.CompanyId == options.CompanyId && x.GroupRoleId == options.GroupRoleId); menuoneParent.ViewPer = true; } } } #endregion menuCome.AddPer = options.AddPer ?? false; menuCome.ViewPer = options.ViewPer ?? false; menuCome.EditPer = options.EditPer ?? false; menuCome.ExportPer = options.ExportPer ?? false; menuCome.DelPer = options.DelPer ?? false; } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <CV_QT_MyWork> > > r1SpaceTimeOnDay() { try { TimeSpan ts17 = new TimeSpan(17, 00, 0); RequestToken token = CommonData.GetDataFromToken(User); var datesDefault = TransforDate.FromDateToDouble(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 01)); var dateeDefault = TransforDate.FromDateToDouble(DateTime.Now); var reports = (from a in _context.CV_QT_StartPauseHistory where a.UserCreateId == token.UserID && a.Done != true && a.CreateDate.Month == DateTime.Now.Month orderby a.Id select new { a.Id, a.CreateDate, a.CycleWork, a.MyWorkId, a.UserCreateId }).ToList(); if (reports.Count() < 2) { return(new ObjectResult(new { error = 0 })); } List <CV_QT_SpaceTimeOnDay> listSpace = new List <CV_QT_SpaceTimeOnDay>(); for (int i = 0; i < reports.Count() - 1; i++) { if (reports[i].CreateDate.Hour >= 17 && reports[i].CreateDate.Minute > 3) { continue; } if (reports[i].CycleWork == 2) { CV_QT_SpaceTimeOnDay obj = new CV_QT_SpaceTimeOnDay() { SpaceStart = TransforDate.FromDateToDouble(reports[i].CreateDate), SpaceEnd = TransforDate.FromDateToDouble(reports[i + 1].CreateDate), Time = SpaceTimeOnDay.CalSpaceTimeOnDay(reports[i].CreateDate, reports[i + 1].CreateDate), MyWorkId = reports[i].MyWorkId, UserId = reports[i].UserCreateId }; if (obj.Time >= 30) { listSpace.Add(obj); } } } var objup = _context.CV_QT_StartPauseHistory.Where(x => x.UserCreateId == token.UserID && x.Done != true); foreach (var item in objup) { item.Done = true; } _context.CV_QT_StartPauseHistory.UpdateRange(objup); await _context.AddRangeAsync(listSpace); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception e) { return(new ObjectResult(new { error = 1 })); } }
public async Task <ActionResult <IEnumerable <VB_QT_VanBanMoiSoHoa> > > r2AddQTPheDuyetTrinhKy(LuanChuyenVbDuyetTrinhKy luanChuyenVbXNHT) { try { List <NguoiNhanThongBao> nhanThongBaos = new List <NguoiNhanThongBao>(); var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var user = await _context.Sys_Dm_User.FindAsync(userId); var qtLuanChuyenVb = await _context.VB_QT_LuanChuyenVanBan.FindAsync(luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.Id); qtLuanChuyenVb.NgayXuLy = DateTime.Now; qtLuanChuyenVb.NgayDoc = DateTime.Now; qtLuanChuyenVb.DaDoc = true; var nguoiNhans = _context.VB_QT_LuanChuyenVanBan.Where(x => x.VbMoiSoHoaId == qtLuanChuyenVb.VbMoiSoHoaId).Select(a => new { a.TenNguoiGui, a.NguoiGuiId, a.MaLenh }).Distinct().ToList(); if (luanChuyenVbXNHT.UserXNHT.isNguoiGui == true) { foreach (var item in nguoiNhans.Where(x => x.MaLenh == "VB_CHOTRINHKY" && x.NguoiGuiId != nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId)) { var userNN = await _context.Sys_Dm_User.FindAsync(item.NguoiGuiId); VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan( qtLuanChuyenVb.VbMoiSoHoaId, item.NguoiGuiId, item.TenNguoiGui, userId, user.FullName, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.TieuDe, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung, false, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.HanXuLy, null, 5, "VB_NHANTHONGBAO", null, false, qtLuanChuyenVb.Id, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuGuiId, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuNhanId, userNN.PositionName, user.PositionName, userNN.DepartmentName, user.DepartmentName); _context.VB_QT_LuanChuyenVanBan.Add(lcvb); // thêm vào thông báo Sys_QT_ThongBao obj = new Sys_QT_ThongBao(); obj.MaLenh = "VB_NHANTHONGBAO"; obj.QuyTrinhId = 1; obj.TenNguoiGui = user.FullName; obj.NguoiNhanId = item.NguoiGuiId; obj.NoiDung = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung; obj.NgayGui = DateTime.Now; obj.DaDoc = false; obj.NgayDoc = null; obj.TrangThaiXuLy = 5; obj.RouterLink = "/vanban/quytrinhvanban/vanbandapheduyet"; NguoiNhanThongBao nguoiNhan = new NguoiNhanThongBao(); nguoiNhan.NguoiNhanId = item.NguoiGuiId; nhanThongBaos.Add(nguoiNhan); _context.Sys_QT_ThongBao.Add(obj); } } var userNNN = await _context.Sys_Dm_User.FindAsync(nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId); VB_QT_LuanChuyenVanBan lcvb1 = LuanChuyenVanBan.r2AddLuanChuyenVanBan( qtLuanChuyenVb.VbMoiSoHoaId, nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId, nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").TenNguoiGui, userId, user.FullName, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.TieuDe, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung, false, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.HanXuLy, null, 3, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MaLenh, null, false, qtLuanChuyenVb.Id, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuGuiId, luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MenuNhanId, userNNN.PositionName, user.PositionName, userNNN.DepartmentName, user.DepartmentName); _context.VB_QT_LuanChuyenVanBan.Add(lcvb1); NguoiNhanThongBao nguoiNhan1 = new NguoiNhanThongBao(); nguoiNhan1.NguoiNhanId = nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId; nhanThongBaos.Add(nguoiNhan1); // thêm vào thông báo Sys_QT_ThongBao obj1 = new Sys_QT_ThongBao(); obj1.MaLenh = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.MaLenh; obj1.QuyTrinhId = 1; obj1.TenNguoiGui = user.FullName; obj1.NguoiNhanId = nguoiNhans.FirstOrDefault(x => x.MaLenh == "VB_MOISOHOA").NguoiGuiId; obj1.NoiDung = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.NoiDung; obj1.NgayGui = DateTime.Now; obj1.DaDoc = false; obj1.NgayDoc = null; obj1.TrangThaiXuLy = luanChuyenVbXNHT.VB_QT_LuanChuyenVanBan.TrangThaiXuLy; obj1.RouterLink = "/vanban/quytrinhvanban/vanbandapheduyet"; _context.Sys_QT_ThongBao.Add(obj1); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, nguoiNhanTbs = nhanThongBaos })); } catch (Exception) { return(new ObjectResult(new { error = 1 })); } }
public async Task <IActionResult> r2addObjUnitCode() { try { var model = JsonConvert.DeserializeObject <VB_QT_VanBanMoiSoHoa>(Request.Form["model"]); VB_QT_VanBanMoiSoHoa objvb = new VB_QT_VanBanMoiSoHoa(); var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value); var user = await _context.Sys_Dm_User.FindAsync(userId); var userNguoiKy = await _context.Sys_Dm_User.FirstOrDefaultAsync(x => x.Id == model.NguoiKyId); if (model != null) { objvb.Id = Helper.GenKey(); objvb.CompanyId = user.CompanyId ?? 0; objvb.DepartmentId = user.DepartmentId ?? 0; objvb.TenNguoiKy = userNguoiKy.FullName; objvb.LinhVucId = model.LinhVucId; objvb.LoaiVanBanId = model.LoaiVanBanId; objvb.SoKyHieu = model.SoKyHieu; objvb.NoiBanHanh = model.NoiBanHanh; objvb.NgayBanHanh = model.NgayBanHanh; objvb.TuKhoa = model.TuKhoa; objvb.SoTrang = model.SoTrang; objvb.SoTrang = model.SoTrang; objvb.TenNguoiTao = user.FullName; objvb.CreateDate = DateTime.Now; objvb.UserCreateId = userId; objvb.TrichYeu = model.TrichYeu; _context.VB_QT_VanBanMoiSoHoa.Add(objvb); } VB_QT_LuanChuyenVanBan lcvb = LuanChuyenVanBan.r2AddLuanChuyenVanBan(objvb.Id, userId, user.FullName, userId, user.FullName, "", "", false, null, null, 1, "VB_MOISOHOA", DateTime.Now, false, null, "VB0101", "VB0101", user.PositionName, user.PositionName, user.DepartmentName, user.DepartmentName); _context.VB_QT_LuanChuyenVanBan.Add(lcvb); if (Request.Form.Files.Count != 0) { foreach (var item in Request.Form.Files) { VB_QT_FileVBMoiSoHoa obj = new VB_QT_FileVBMoiSoHoa(); var file = item; var folderName = Path.Combine("Resources", "VanBan"); var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName); if (!Directory.Exists(pathToSave)) { Directory.CreateDirectory(pathToSave); } if (model != null) { if (file.Length > 0) { var fileName = long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss")).ToString() + ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"'); var fullPath = Path.Combine(pathToSave, fileName); var dbPath = Path.Combine(folderName, fileName); obj.Path = dbPath; using (var stream = new FileStream(fullPath, FileMode.Create)) { file.CopyTo(stream); } } } obj.Name = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"'); obj.VbMoiSoHoaId = objvb.Id; obj.Size = file.Length; obj.Type = 1; _context.VB_QT_FileVBMoiSoHoa.Add(obj); } } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0, ms = "" }));; } catch (Exception ex) { var result = new OkObjectResult(new { error = 1, ms = "Lỗi khi thêm mới UnitCode, vui lòng kiểm tra lại!" }); return(result); } }
public async Task <ActionResult <IEnumerable <Sys_Cog_MenuCom> > > r2AddDataModel(MenuCongtyOp options) { try { RequestToken token = CommonData.GetDataFromToken(User); var menuThree = await _context.Sys_Dm_Menu.FindAsync(options.Id); var menuComThree = _context.Sys_Cog_MenuCom.Count(x => x.MenuId == menuThree.Id && x.CompanyId == options.CompanyId); if (menuComThree == 0) { var menuTwo = await _context.Sys_Dm_Menu.FindAsync(menuThree.ParentId); var menuComTwo = _context.Sys_Cog_MenuCom.Count(x => x.MenuId == menuThree.ParentId && x.CompanyId == options.CompanyId); if (menuComTwo == 0) { var menuOne = await _context.Sys_Dm_Menu.FindAsync(menuTwo.ParentId); var menuComOne = _context.Sys_Cog_MenuCom.Count(x => x.MenuId == menuTwo.ParentId && x.CompanyId == options.CompanyId); if (menuComOne == 0) { Sys_Cog_MenuCom objOne = new Sys_Cog_MenuCom(); objOne.MenuId = menuOne.Id; objOne.CompanyId = options.CompanyId; objOne.IsActive = true; objOne.ParentId = null; objOne.UserUpdateId = token.UserID; objOne.DateUpdate = DateTime.Now; _context.Sys_Cog_MenuCom.Add(objOne); Sys_Cog_MenuCom objTwo = new Sys_Cog_MenuCom(); objTwo.MenuId = menuTwo.Id; objTwo.CompanyId = options.CompanyId; objTwo.IsActive = true; objTwo.ParentId = menuOne.Id; objTwo.UserUpdateId = token.UserID; objTwo.DateUpdate = DateTime.Now; _context.Sys_Cog_MenuCom.Add(objTwo); Sys_Cog_MenuCom objThree = new Sys_Cog_MenuCom(); objThree.MenuId = options.Id; objThree.CompanyId = options.CompanyId; objThree.IsActive = true; objThree.ParentId = menuTwo.Id; objThree.UserUpdateId = token.UserID; objThree.DateUpdate = DateTime.Now; _context.Sys_Cog_MenuCom.Add(objThree); } else { Sys_Cog_MenuCom objTwo = new Sys_Cog_MenuCom(); objTwo.MenuId = menuTwo.Id; objTwo.CompanyId = options.CompanyId; objTwo.IsActive = true; objTwo.ParentId = menuOne.Id; objTwo.UserUpdateId = token.UserID; objTwo.DateUpdate = DateTime.Now; _context.Sys_Cog_MenuCom.Add(objTwo); Sys_Cog_MenuCom objThree = new Sys_Cog_MenuCom(); objThree.MenuId = options.Id; objThree.CompanyId = options.CompanyId; objThree.ParentId = menuTwo.Id; objThree.IsActive = true; objThree.UserUpdateId = token.UserID; objThree.DateUpdate = DateTime.Now; _context.Sys_Cog_MenuCom.Add(objThree); } } else { var menuComTwoParent = await _context.Sys_Cog_MenuCom.FirstOrDefaultAsync(x => x.MenuId == menuThree.ParentId && x.CompanyId == options.CompanyId); Sys_Cog_MenuCom objThree = new Sys_Cog_MenuCom(); objThree.MenuId = options.Id; objThree.CompanyId = options.CompanyId; objThree.IsActive = true; objThree.ParentId = menuTwo.Id; objThree.UserUpdateId = token.UserID; objThree.DateUpdate = DateTime.Now; _context.Sys_Cog_MenuCom.Add(objThree); menuComTwoParent.IsActive = true; } } else { var menuCome = await _context.Sys_Cog_MenuCom.FirstOrDefaultAsync(x => x.MenuId == options.Id && x.CompanyId == options.CompanyId); var menuComTwoParent = await _context.Sys_Cog_MenuCom.FirstOrDefaultAsync(x => x.MenuId == menuThree.ParentId && x.CompanyId == options.CompanyId); if (options.IsActive == false) { var rmmenuDeps = _context.Sys_Cog_MenuDep.Where(x => x.MenuId == options.Id && x.CompanyId == options.CompanyId).ToList(); // xóa menu phòng if (_context.Sys_Cog_MenuCom.Count(x => x.ParentId == menuThree.ParentId && x.CompanyId == options.CompanyId && x.IsActive == true && x.MenuId != options.Id) == 0) { menuComTwoParent.IsActive = false; } foreach (var item in rmmenuDeps) { item.IsActive = false; var menuDepParent = await _context.Sys_Cog_MenuDep.FirstOrDefaultAsync(x => x.MenuId == item.ParentId && x.CompanyId == item.CompanyId && x.DepartmentId == item.DepartmentId); if (_context.Sys_Cog_MenuDep.Count(x => x.ParentId == item.ParentId && x.CompanyId == item.CompanyId && x.IsActive == true && x.MenuId != item.MenuId) == 0) { menuDepParent.IsActive = false; } var rmmenuNests = _context.Sys_Cog_MenuNest.Where(x => x.MenuId == options.Id && x.CompanyId == options.CompanyId && x.ParentDepartmentId == item.DepartmentId).ToList(); // xóa menu phòng foreach (var ntem in rmmenuNests) { ntem.IsActive = false; } } menuCome.IsActive = false; menuCome.DateUpdate = DateTime.Now; menuCome.UserUpdateId = token.UserID; } else { if (_context.Sys_Cog_MenuCom.Count(x => x.ParentId == menuThree.ParentId && x.CompanyId == options.CompanyId && x.IsActive == true) == 0) { menuComTwoParent.IsActive = true; } menuCome.IsActive = true; menuCome.DateUpdate = DateTime.Now; menuCome.UserUpdateId = token.UserID; } } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception ez) { return(new ObjectResult(new { error = 1 })); } }