public async Task <IActionResult> PutAttendanceSheet(int id, AttendanceSheet attendanceSheet) { if (id != attendanceSheet.Id) { return(BadRequest()); } _context.Entry(attendanceSheet).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AttendanceSheetExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// 详情 /// </summary> /// <returns></returns> public AttendanceSheet GetListyi(int id) { string sql = "select * from AttendanceSheet where AttendanceID=" + id; db.PrepareSql(sql); DataTable dt = new DataTable(); dt = db.ExecQuery(); if (dt.Rows.Count == 0) { return(null); } AttendanceSheet entity = new AttendanceSheet(); foreach (DataRow item in dt.Rows) { entity.AttendanceID = int.Parse(item["AttendanceID"].ToString()); entity.AttendanceStartTime = DateTime.Parse(item["AttendanceStartTime"].ToString()); entity.AttendanceType = int.Parse(item["AttendanceType"].ToString()); entity.UserID = int.Parse(item["UserID"].ToString()); entity.ClockTime = DateTime.Parse(item["ClockTime"].ToString()); entity.ClockOutTime = DateTime.Parse(item["ClockOutTime"].ToString()); entity.Workinghours = int.Parse(item["Workinghours"].ToString()); entity.remake = item["remake"].ToString(); entity.Late = int.Parse(item["Late"].ToString()); entity.Absenteeism = int.Parse(item["Absenteeism"].ToString()); } return(entity); }
public bool AddRemake(DateTime time, string name, string remakes) { AttendanceSheet attendanceSheet = sheetDAL.LoadEntities(u => u.AttendanceStartTime == time && u.UserName == name).FirstOrDefault(); attendanceSheet.remake = remakes; return(sheetDAL.ModifyEntity(attendanceSheet)); }
public HomeViewModel(Account account, AttendanceSheet attendance) { isError = false; AccountId = account.Id; Name = $"Welcome {account.Name}"; Date = attendance.Date; LoginTime = attendance.Login; LogoutTime = attendance.Logout; _attendanceService = new AttendanceService(); }
public bool AddSign(int userid) { AttendanceSheet newAttendance = new AttendanceSheet(); newAttendance.AttendanceStartTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); newAttendance.AttendanceType = 1;//默认 newAttendance.UserID = userid; UserInfo us = userInfoDAL.LoadEntities(u => u.UserID == userid).FirstOrDefault(); newAttendance.UserName = us.UserName; newAttendance.DepartmentID = us.DepartmentID; newAttendance.ClockTime = DateTime.Now.ToLocalTime(); return(sheetDAL.AddEntity(newAttendance)); }
/// <summary> /// 添加 /// </summary> /// <returns></returns> public int Add(AttendanceSheet entity) { string sql = "insert into AttendanceSheet(AttendanceStartTime,AttendanceType,UserID,ClockTime,ClockOutTime,Workinghours,remake,Late,Absenteeism) values(@AttendanceStartTime,@AttendanceType,@UserID,@ClockTime,@ClockOutTime,@Workinghours,@remake,@Late,@Absenteeism)"; db.PrepareSql(sql); db.SetParameter("AttendanceStartTime", entity.AttendanceStartTime); db.SetParameter("AttendanceType", entity.AttendanceType); db.SetParameter("UserID", entity.UserID); db.SetParameter("ClockTime", entity.ClockTime); db.SetParameter("ClockOutTime", entity.ClockOutTime); db.SetParameter("Workinghours", entity.Workinghours); db.SetParameter("remake", entity.remake); db.SetParameter("Late", entity.Late); db.SetParameter("Absenteeism", entity.Absenteeism); return(db.ExecNonQuery()); }
/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(AttendanceSheet entity) { string sql = "update AttendanceSheet set AttendanceStartTime=@AttendanceStartTime,AttendanceType=@AttendanceType,UserID=@UserID,ClockTime=@ClockTime,ClockOutTime=@ClockOutTime,Workinghours=@Workinghours,remake=@remake,Late=@Late,Absenteeism=@Absenteeism where AttendanceID=@AttendanceID"; db.PrepareSql(sql); db.SetParameter("AttendanceStartTime", entity.AttendanceStartTime); db.SetParameter("AttendanceType", entity.AttendanceType); db.SetParameter("UserID", entity.UserID); db.SetParameter("ClockTime", entity.ClockTime); db.SetParameter("ClockOutTime", entity.ClockOutTime); db.SetParameter("Workinghours", entity.Workinghours); db.SetParameter("remake", entity.remake); db.SetParameter("Late", entity.Late); db.SetParameter("Absenteeism", entity.Absenteeism); db.SetParameter("AttendanceID", entity.AttendanceID); return(db.ExecNonQuery()); }
public bool DelAttendance(string[] time, string[] name) { int n = 0; for (int i = 0; i < time.Length; i++) { var ti = Convert.ToDateTime(time[i]); var na = name[i]; AttendanceSheet us = sheetDAL.LoadEntities(u => u.AttendanceStartTime == ti && u.UserName == na).FirstOrDefault(); bool del = sheetDAL.DeleteEntity(us); if (del == false) { n++; } } if (n > 0) { return(false); } return(true); }
public async Task SetAttendanceLogout(SetAttendanceLogoutDto model) { var accountAttendance = await _attendanceRepository.GetAccountAttendance(model.AccountId, model.LogoutDate); if (accountAttendance == null) { var attendance = new AttendanceSheet { Id = Guid.NewGuid().ToString(), AccountId = model.AccountId, Date = model.LogoutDate, Logout = TimeSpan.Parse(model.LogoutTime) }; await _attendanceRepository.Add(attendance); } else { accountAttendance.Logout = TimeSpan.Parse(model.LogoutTime); await _attendanceRepository.Update(accountAttendance); } }
public async ValueTask <AttendanceSheet> CreateAttendanceSheet(AttendanceSheet newAttendanceSheet) { _uow.AttendanceSheetRepository.Create(newAttendanceSheet); // Create attendances for enrolled students. var enrolledStudents = _uow.StudentRepository.RetrieveEnrolledStudents(newAttendanceSheet.LessonId); newAttendanceSheet.Attendances = new List <Attendance>(); foreach (var student in await enrolledStudents) { newAttendanceSheet.Attendances.Add( new Attendance { AttendanceSheetId = newAttendanceSheet.Id, LessonId = newAttendanceSheet.LessonId, StudentId = student.Id, Comment = "", AttendanceType = AttendanceType.Absent } ); } return(newAttendanceSheet); }
public void PostAttendanceSheetList(Guid userId, int lecturerId, int tutorId, string classId, int month, int year) { // tạo hết 1 loạt các chi tiết điểm danh theo các buổi học var classSessions = (from cl in _context.LanguageClasses join ts in _context.TeachingSchedules on cl.Id equals ts.LanguageClassId join s in _context.ClassSessions on ts.Id equals s.TeachingScheduleId where cl.Id == classId && s.Date.Month == month && s.Date.Year == year select s).OrderBy(x => x.Date).ToList(); //lấy ra các học viên trong lớp đó. var learners = (from l in _context.Learners join st in _context.StudyProcesses on l.Id equals st.LearnerId where st.LanguageClassId == classId && l.Status == Status.Active && st.Status == Status.Active select l).ToList(); var _class = _context.LanguageClasses.Where(x => x.Id == classId).SingleOrDefault(); List <AttendanceSheet> attendanceSheets = new List <AttendanceSheet>(); foreach (var cs in classSessions) { AttendanceSheet attendanceSheet = new AttendanceSheet(); attendanceSheet.WageOfLecturer = Convert.ToDecimal(_class.WageOfLecturer); attendanceSheet.WageOfTutor = Convert.ToDecimal(_class.WageOfTutor); attendanceSheet.DateCreated = DateTime.Now; attendanceSheet.Status = Status.Active; attendanceSheet.AppUserId = userId; attendanceSheet.LecturerId = lecturerId; attendanceSheet.TutorId = tutorId; attendanceSheet.LanguageClassId = classId; attendanceSheet.Date = cs.Date; attendanceSheets.Add(attendanceSheet); } _context.AttendanceSheets.AddRange(attendanceSheets); _context.SaveChanges(); List <AttendanceSheetDetail> attendanceSheetDetails = new List <AttendanceSheetDetail>(); foreach (var attendance in attendanceSheets) { foreach (var learner in learners) { AttendanceSheetDetail attendanceSheetDetail = new AttendanceSheetDetail(); attendanceSheetDetail.Status = Status.InActive; attendanceSheetDetail.LanguageClassId = classId; attendanceSheetDetail.DateCreated = attendance.Date; attendanceSheetDetail.AttendanceSheetId = attendance.Id; attendanceSheetDetail.LearnerId = learner.Id; attendanceSheetDetails.Add(attendanceSheetDetail); } } _context.AttendanceSheetDetails.AddRange(attendanceSheetDetails); _context.SaveChanges(); }
/// <summary> /// 分页 /// </summary> /// <returns></returns> public List <AttendanceSheet> GetPage(AttendanceSheet entity, int PageIndex, int PageSiez, out int count) { throw new NotImplementedException(); }