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