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 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 string GetConnectionId(string userId) { string connectionId = Context.ConnectionId; var contact = _context.Sys_Dm_Connection.FirstOrDefault(x => x.UserId == Convert.ToInt32(userId)); if (contact != null) { contact.ConnectionId = connectionId; contact.CreatedDate = TransforDate.FromDateToDouble(DateTime.Now); } else { Sys_Dm_Connection obj = new Sys_Dm_Connection() { UserId = Convert.ToInt32(userId), ConnectionId = connectionId, CreatedDate = TransforDate.FromDateToDouble(DateTime.Now) }; _context.Sys_Dm_Connection.Add(obj); } _context.SaveChanges(); return(connectionId); }