public static CV_QT_WorkFlow objWorkFlow(humanDbContext dbContext, string MyWorkId, int UserSendId, int UserDeliverId, int TypeFlow, string MaLenh, string ParentId, string Note, string Require, int Repossibility) { var userSend = dbContext.Sys_Dm_User.Find(UserSendId); var userDeli = dbContext.Sys_Dm_User.Find(UserDeliverId); CV_QT_WorkFlow obj = new CV_QT_WorkFlow(); obj.DeliverName = userDeli.FullName; obj.Id = Helper.GenKey(); obj.MyWorkId = MyWorkId; obj.UserSendId = UserSendId; obj.SendName = userSend.FullName; obj.UserDeliverId = UserDeliverId; obj.SendDate = DateTime.Now; obj.TypeFlow = TypeFlow; obj.CreateDate = DateTime.Now; obj.MaLenh = MaLenh; obj.ParentId = ParentId; obj.Note = Note; obj.Require = Require; obj.PositionDeli = userDeli.PositionName; obj.PositionSend = userSend.PositionName; obj.DepartSend = userSend.DepartmentName; obj.DepartDeli = userDeli.DepartmentName; obj.Readed = false; obj.ReadDate = null; obj.Handled = false; obj.HandleDate = null; obj.Repossibility = Repossibility; return(obj); }
public static List <MoHinhToChuc> IsComCurrentOnly(humanDbContext _context, int CompanyId) { var _listDepartMents = _context.Sys_Dm_Department.Where(x => x.ParentId == null).Select(a => new { a.Id, a.Name, a.CompanyId, Loai = 1, children = _context.Sys_Dm_Department.Where(x => x.ParentId == a.Id).Select(v => new { v.Id, v.Name, Loai = 2 }).ToList() }); var tables = ((List <MoHinhToChuc>) from a in _context.Sys_Dm_Company where a.Id == CompanyId select new { a.Id, a.Name, Loai = 0, children = _listDepartMents.Where(x => x.CompanyId == CompanyId).Select(c => new { c.Id, c.Name, c.Loai, c.children }).ToList() }).ToList(); return(tables); }
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 static List <Sys_Dm_GroupRoleLogin> getListGroupRole(humanDbContext context, int UserId) { List <Sys_Dm_GroupRoleLogin> userRole = (List <Sys_Dm_GroupRoleLogin>)(from a in context.Sys_Cog_UsersGroup join b in context.Sys_Dm_GroupRole on a.GroupRoleId equals b.Id where a.UserId == UserId orderby b.RankRole select new { a.GroupRoleId, }); return(userRole); }
public static bool SaveLogEx(humanDbContext dbContext, string urlApi, string errorLog, string Description) { Sys_TK_SaveLog sys_TK_SaveLog = new Sys_TK_SaveLog() { UrlApi = urlApi, ErrorLog = errorLog, Description = Description }; dbContext.Sys_TK_SaveLog.Add(sys_TK_SaveLog); dbContext.SaveChanges(); return(true); }
public static bool checkDefaultWorksFlow(humanDbContext dbContext, string WorkName, int DepartmentId) { var task = dbContext.CV_DM_DefaultTask.FirstOrDefault(x => x.Name == WorkName); if (task == null) { CV_DM_DefaultTask obj = new CV_DM_DefaultTask(); obj.Name = WorkName; obj.Id = Helper.GenKey(); obj.GroupTaskId = 10; obj.Frequency = 0; } return(false); }
public static bool PauseMyWork(humanDbContext _context, CV_QT_MyWork myWork, CV_QT_WorkNote workNote) { if (myWork.CycleWork == 1) { if (myWork.StartDate.Value.Hour < 17 || (myWork.StartDate.Value.Hour == 17 && myWork.StartDate.Value.Minute < 5)) { myWork.WorkTime = myWork.WorkTime + (SpaceTimeOnDay.CalSpaceTimeOnDay(myWork.StartDate.Value, DateTime.Now) / 60); } myWork.CycleWork = 2; CV_QT_StartPauseHistory his = new CV_QT_StartPauseHistory(); // lưu vào bảng lịch sử his.MyWorkId = myWork.Id; his.CreateDate = DateTime.Now; his.CycleWork = 2; his.UserCreateId = myWork.UserTaskId; _context.CV_QT_StartPauseHistory.Add(his); if (workNote != null) { workNote.DateEnd = his.CreateDate; workNote.WorkTime = (his.CreateDate - workNote.DateStart.Value).TotalHours; } } else if (myWork.CycleWork == 3) { if (myWork.EndPause.Value.Hour < 17 || (myWork.EndPause.Value.Hour == 17 && myWork.EndPause.Value.Minute < 5)) { myWork.WorkTime = myWork.WorkTime + (SpaceTimeOnDay.CalSpaceTimeOnDay(myWork.EndPause.Value, DateTime.Now) / 60); } myWork.CycleWork = 2; CV_QT_StartPauseHistory his = new CV_QT_StartPauseHistory(); // lưu vào bảng lịch sử his.MyWorkId = myWork.Id; his.CreateDate = DateTime.Now; his.CycleWork = 2; his.UserCreateId = myWork.UserTaskId; _context.CV_QT_StartPauseHistory.Add(his); _context.CV_QT_StartPauseHistory.Add(his); if (workNote != null) { workNote.DateEnd = his.CreateDate; workNote.WorkTime = (his.CreateDate - workNote.DateStart.Value).TotalHours; } } else { return(false); } _context.SaveChanges(); return(true); }
public static async Task <int> getDepartmentID(humanDbContext _context, int departmentId) // lấy phòng ban từ tổ Id { int DepId = 0; var room = await _context.Sys_Dm_Department.FindAsync(departmentId); if (room.ParentId == null) { DepId = room.Id; } else { DepId = room.ParentId ?? 0; } return(DepId); }
public static List <MoHinhToChuc> IsNestCurrentOnly(humanDbContext _context, int CompanyId, int DepartmentId) { var _listDepartMents = ((List <MoHinhToChuc>)_context.Sys_Dm_Department.Where(x => x.CompanyId == CompanyId && x.Id == DepartmentId).Select(a => new { a.Id, a.Name, a.CompanyId, Loai = 2, children = _context.Sys_Dm_Department.Where(x => x.ParentId == a.Id).Select(v => new { v.Id, v.Name, Loai = 2 }).ToList() })).ToList(); return(_listDepartMents); }
public static int DuocHienThiNguoiNhan(humanDbContext _context, int GroupRoleId, int BuocLenhGroupId) { var buoclenhGroup = _context.VB_QT_BuocLenhGroupRole.Find(BuocLenhGroupId); if (buoclenhGroup.IsAll) { // Hiện tất cả return(0); } if (buoclenhGroup.IsAllComCha) { // chỉ hiện công ty mẹ return(1); } if (buoclenhGroup.IsAllComCon) { // chỉ hiện công ty hiện tại của user return(2); } if (buoclenhGroup.IsDepartment) { // chỉ hiện phòng return(3); } if (buoclenhGroup.IsNest) { // chỉ hiện tổ return(4); } if (buoclenhGroup.IsNguoiGui) { // chỉ hiện tổ return(5); } if (buoclenhGroup.IsNguoiLap) { // chỉ hiện tổ return(6); } if (buoclenhGroup.IsManagement) { // chỉ hiện trưởng phòng return(7); } return(0); }
public static int getGroupRoleDefault(humanDbContext context, int UserId) { var userRole = from a in context.Sys_Cog_UsersGroup join b in context.Sys_Dm_GroupRole on a.GroupRoleId equals b.Id where a.UserId == UserId orderby b.RankRole select new { a.GroupRoleId, }; if (userRole.Count() == 0) { return(0); // chưa có role } else { return(userRole.FirstOrDefault().GroupRoleId); } }
public static int CheckPer(humanDbContext context, int UserId, int GroupRoleId) { var user = context.Sys_Cog_UsersGroup.FirstOrDefault(x => x.UserId == UserId); if (user == null) { return(6); // chưa tồn tài nhóm quyền } var groupRole = context.Sys_Dm_GroupRole.Find(GroupRoleId); if (groupRole.IsAdministrator == true) { return(0); // admin tổng } else if (groupRole.IsAdminCom == true) { return(1);// admin công ty } else if (groupRole.IsAdminDep == true) { return(2);// admin phòng } else if (groupRole.IsAdminNest == true) { return(3);// admin Tổ } else if (groupRole.CompanyId != 0 && groupRole.IsAdminCom == null && groupRole.IsAdminDep == null && groupRole.IsAdminNest == null) { return(4);// role thường } else if (groupRole.CompanyId != 0 && groupRole.IsAdminCom == false && groupRole.IsAdminDep == false && groupRole.IsAdminNest == false) { return(4);// role thường } return(6); }
public CommonController(humanDbContext context) { _context = context; }
public static async Task <List <UserAndStatusDeliver> > getUserFromTypeUserDeli(humanDbContext dbContext, int Type, string MyworkId) { List <UserAndStatusDeliver> list = new List <UserAndStatusDeliver>(); var cV_QT_MyWork = await dbContext.CV_QT_MyWork.FindAsync(MyworkId); if (Type == 1) // người chủ trì { if (cV_QT_MyWork != null) { UserAndStatusDeliver userAndStatus = new UserAndStatusDeliver() { UserId = cV_QT_MyWork.UserTaskId, Type = Type }; list.Add(userAndStatus); return(list); } } else if (Type == 2) // người phối hợp { var cV_QT_MySupportWork = dbContext.CV_QT_MySupportWork.Where(x => x.MyWorkId == MyworkId); if (cV_QT_MySupportWork.Count() > 0) { foreach (var item in cV_QT_MySupportWork) { UserAndStatusDeliver userAndStatus = new UserAndStatusDeliver() { UserId = item.UserId, Type = Type }; list.Add(userAndStatus); } return(list); } } else if (Type == 3) // người làm trước { if (cV_QT_MyWork != null) { if (cV_QT_MyWork.Predecessor != null) { var cV_TQ = dbContext.CV_QT_MyWork.FirstOrDefault(x => x.Code == cV_QT_MyWork.Predecessor); UserAndStatusDeliver userAndStatus = new UserAndStatusDeliver() { UserId = cV_TQ.UserTaskId, Type = Type }; list.Add(userAndStatus); return(list); } else { return(new List <UserAndStatusDeliver>()); } } } return(new List <UserAndStatusDeliver>()); }
public VanBanChoPheDuyetController(humanDbContext context) { _context = context; }
public CompanyController(humanDbContext context) { _context = context; }
public SoHoaVanBanController(humanDbContext context) { _context = context; }
public SignalAppOffice(humanDbContext context) { _context = context; }
public MyWorkErrorController(humanDbContext context) { _context = context; }
public VanBanThuHoiController(humanDbContext context) { _context = context; }
public async static Task <List <MoHinhToChuc> > IsAllCom(humanDbContext _context) { var _listUniOn = await _context.Sys_Dm_Department.Where(x => x.ParentId == null && x.CompanyId == 1).Select(a => new { a.Id, a.Name, ParentId = a.CompanyId, Loai = 1 }).Union( _context.Sys_Dm_Company.Where(x => x.ParentId == 1).Select(c => new { c.Id, c.Name, ParentId = 1, Loai = 0 })).ToListAsync(); var _listDepartMents = _context.Sys_Dm_Department.Where(x => x.ParentId == null).Select(a => new { a.Id, a.Name, a.CompanyId, Loai = 1, children = _context.Sys_Dm_Department.Where(x => x.ParentId == a.Id).Select(v => new { v.Id, v.Name, Loai = 2 }).ToList() }); var s = _listUniOn.Select(x => new { x.Id, x.Name, x.ParentId, x.Loai, children = x.Loai == 0 ? _listDepartMents.Where(b => b.CompanyId == x.Id).Select(k => new { k.Id, k.Name, k.Loai, k.children }).ToList() : _listDepartMents.Where(b => b.CompanyId == 0).Select(k => new { k.Id, k.Name, k.Loai, k.children }).ToList() }); var tables = ((List <MoHinhToChuc>) from a in _context.Sys_Dm_Company where a.ParentId == null select new { a.Id, a.Name, Loai = 0, children = s.ToList() }).ToList(); return(tables); }
public PheDuyetMyWorkController(humanDbContext context) { _context = context; }
public UserController(humanDbContext context) { _context = context; }
public VanBanBiTraLaiController(humanDbContext context) { _context = context; }
public Notifiler(humanDbContext context, IHubNotifi hubnoti) { _context = context; _hubnoti = hubnoti; HubService.Instance.Initialized(); }
public PermissionGroupController(humanDbContext context) { _context = context; }
public MailerController(humanDbContext context, IMailer mailer) { _context = context; _mailer = mailer; }
public MyWorkReportController(humanDbContext context, IHostingEnvironment hostingEnvironment) { _context = context; _hostingEnvironment = hostingEnvironment; }
public QuyTrinhVanBanController(humanDbContext context) { _context = context; }
public GroupRoleController(humanDbContext context) { _context = context; }