public IHttpActionResult Cancel(AttendanceDTO gidDto) { var userID = User.Identity.GetUserId(); int gigID = gidDto.gidID; //1 var gigInfo = _context.Gigs.Single(g => g.ID == gigID && g.ArtistID == userID); /* 2 var attendees = _context.Attendances * .Where(a => a.GigID == gigID) * .Select(a => a.Attendee) * .ToList(); */ // Refactor cho 2 query 1 + 2 thanh nhu ben duoi . var gigInfo = _unitOfWork.Gig.GetGigOnly(gigID); if (gigInfo == null || gigInfo.IsCancelled) { return(NotFound()); } if (gigInfo.ArtistID != userID) { return(Unauthorized()); } gigInfo.Cancel(); _unitOfWork.Finish(); return(Ok()); }
public Object SaveAttendance(List <AttendanceHistoryDTO> history) { //Check this //List<AttendanceHistoryDTO> attHis = JsonConvert.DeserializeObject<List<AttendanceHistoryDTO>>(history); for (int i = 0; i < history.Count; i++) { AttendanceHistoryDTO ahd = history.ElementAt(i); AttendanceHistoryDAL.Save(ahd); AttendanceDTO atndnc = AttendanceDAO.GetAttendanceById(ahd.AttId); if (ahd.HisIsPresent) { atndnc.AttPresents++; } else { atndnc.AttAbsents++; } AttendanceDAO.Save(atndnc); } var IsSaved = true; return(IsSaved); }
public JsonResult EditAttendance(int id) { SedesolServiceClient proxy = new SedesolServiceClient(); AttendanceDTO data = proxy.GetAttendanceById(id); return(Json(data, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult PutAttendance(AttendanceDTO attendanceDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (attendanceDTO == null) { return(BadRequest("Missing values")); } //Attendance attendance = AttendanceRepo.Get(id); //if (date != null) // attendance.AttendanceDate = date; //if(studentIDList.Count > 0) // foreach (var studentID in collection) // { // if(attendance.Students.FirstOrDefault(c=> c.StudentID == studentID) != null) // attendance.Students.Add() // } //if(date != null) // attendance //attendance.ModuleID = moduleID; Attendance attendance = Mapper.Map <Attendance>(attendanceDTO); AttendanceRepo.Update(attendance); AttendanceRepo.Save(); return(StatusCode(HttpStatusCode.NoContent)); }
public JsonResult SetParamCapture(int idYear, int idMonth, int idSoupK, string soupK, string year, string month, string pFolio, string pCode) { SedesolServiceClient proxy = new SedesolServiceClient(); CaptureModel cModel = new CaptureModel(); CaptureDTO captDto = new CaptureDTO(); AttendanceDTO attDto = new AttendanceDTO(); UserDTO userDto = (UserDTO)Session["userData"]; string message = string.Empty; captDto.Id_Month = idMonth; captDto.Id_Year = idYear; captDto.Id_Soup_Kitchen = idSoupK; captDto.CreateDate = DateTime.Now; captDto.Description = year + " | " + month + " | " + soupK; captDto.IsActive = true; captDto.Id_Status = Convert.ToInt32(ConfigurationManager.AppSettings["stIniciada"].ToString()); captDto.Folio = pFolio; captDto.InspectionCode = pCode; captDto.Id_LevelApproval = userDto.UserType.Id; captDto.Id_User = userDto.Id; cModel.Capture = proxy.SaveCapture(captDto); //cModel.Capture = captDto; cModel.Attendance = attDto; Session.Add("CaptureModel", cModel); return(Json(new { message = cModel.Capture.Message })); }
public IHttpActionResult PostAttendance(AttendanceDTO attendanceDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } //if (date == null || studentIDList == null || moduleID <= 0) //{ // return BadRequest("One or more parameters are missing values"); //} //Attendance attendance = new Attendance { ModuleID = moduleID, AttendanceDate = date}; Attendance attendance = Mapper.Map <Attendance>(attendanceDTO); AttendanceRepo.Add(attendance); try { AttendanceRepo.Save(); return(Ok(attendance)); } catch { return(BadRequest("Failed to add attendance")); } }
public AttendanceDTO Save(AttendanceDTO dto) { AttendanceDAO b = new AttendanceDAO(); dto = b.Save(dto); return(dto); }
public async Task UpdateAsync(EditViewModel inputModel) { AttendanceDTOBuilderData builderData = new AttendanceDTOBuilderData(inputModel); AttendanceDTO updatedAttendance = dtoFactory.CreateDTO <AttendanceDTOBuilderData, AttendanceDTO>(builderData); attendanceService.UpdateBaseInfo(updatedAttendance); await attendanceService.SaveChangesAsync(); }
public async Task DeleteAsync(DeleteInputModel inputModel) { AttendanceDTOBuilderData bulderData = new AttendanceDTOBuilderData(inputModel); AttendanceDTO attendanceToRemove = dtoFactory.CreateDTO <AttendanceDTOBuilderData, AttendanceDTO>(bulderData); attendanceService.Delete(attendanceToRemove); await attendanceService.SaveChangesAsync(); }
public AttendanceDTO GetAttendanceById(int id) { AttendanceDTO dto = new AttendanceDTO(); AttendanceDAO d = new AttendanceDAO(); dto = d.GetAttendanceById(id); return(dto); }
public async Task <IActionResult> CreateAttendance(AttendanceDTO attDTO) { var att = _mapper.Map <Asistencia>(attDTO); await _attendanceService.InsertAttendance(att); attDTO = _mapper.Map <AttendanceDTO>(att); var apiResponse = new ApiResponse <AttendanceDTO>(attDTO); return(Ok(apiResponse)); }
private static AttendanceDTO FillAttendanceDTO(SqlDataReader reader) { AttendanceDTO dto = new AttendanceDTO(); dto.AttId = reader.GetInt32(0); dto.AttPresents = reader.GetInt32(1); dto.AttAbsents = reader.GetInt32(2); dto.StuId = reader.GetInt32(3); dto.CouId = reader.GetInt32(4); return(dto); }
public void Update(AttendanceDTO attendance) { List <AttendanceDTO> temp = _dbSet.Where(att => att.Id == attendance.Id).ToList(); var dpt = temp.FirstOrDefault(); //var entity = _dbSet.SingleOrDefault(a => a.Id == attendance.Id); if (dpt != null) { dpt.AttendanceStatus = attendance.AttendanceStatus; } }
public bool UpdateAttendance(AttendanceDTO attendance) { var attendanceToUpdate = attendanceRepository.Query(x => x.Id == attendance.Id).FirstOrDefault(); if (attendanceToUpdate != null) { attendanceRepository.InjectFrom(attendanceToUpdate); unitOfWork.Save(); return(true); } return(false); }
public async Task <DeleteViewModel> GetDeleteAttendanceViewModelAsync(int attendanceId) { AttendanceDTO attendance = await attendanceService.GetByIdAsync(attendanceId); if (attendance == null) { return(null); } DeleteViewData viewModelData = new DeleteViewData(attendance); DeleteViewModel viewModel = viewFactory.CreateView <DeleteViewData, DeleteViewModel>(viewModelData); return(viewModel); }
public async Task <IHttpActionResult> GetAttendance(int id) { AttendanceDTO dto = await AttendanceService.SearchSingleAttendanceByIdAsync(id); if (dto != null) { return(Ok(dto)); } else { return(NotFound()); } }
public async Task <IActionResult> Put(AttendanceDTO attDTO) { var att = _mapper.Map <Asistencia>(attDTO); await _attendanceService.UpdateAttendance(att); var cantaccepted = await _attendanceService.GetConfirmsByMeet(att.IdReunion); await _meetService.CalculateBeersForAcepted(att.IdReunion, cantaccepted); attDTO = _mapper.Map <AttendanceDTO>(att); var apiResponse = new ApiResponse <AttendanceDTO>(attDTO); return(Ok(apiResponse)); }
public async Task <int> AddAttendance(AttendanceDTO attendance) { if (attendance == null) { throw new ArgumentNullException($"Attendance cannot be null"); } var newEntity = mapper.Map <Attendance>(attendance); await _ctx.Attendance.AddAsync(newEntity); await _ctx.SaveChangesAsync(); return(newEntity.AttendanceId); }
public async Task <ActionResult> ModifyAttendance([FromBody] AttendanceModDTO attendance) { if (AttendanceExists(attendance.RecordID)) { // Call BLL method to run validation object BLLResponse = new AttendanceBLL(_context).ModifyAttendanceBLL(attendance: attendance, userClaims: User); if (BLLResponse.GetType().BaseType == typeof(Exception)) { // Create log entries for Debug log ((APIException)BLLResponse).Exceptions.ForEach(ex => Logger.Msg <AttendancesController>((Exception)ex, Serilog.Events.LogEventLevel.Debug)); // Return response from API return(BadRequest(new { errors = ((APIException)BLLResponse).Exceptions.Select(x => x.Message).ToArray() })); } else { try { // Cast the response to the correct type AttendanceModDTO modAttendanceRecord = (AttendanceModDTO)BLLResponse; // Modify the Attendance Record Attendance attendanceRecord = _context.AttendanceRecords.Where(x => x.RecordID == modAttendanceRecord.RecordID).First(); attendanceRecord.AttendanceStateID = attendance.AttendanceStateID; attendanceRecord.Comment = attendance.Comment; // Save changes await _context.SaveChangesAsync(); Logger.Msg <AttendancesController>($"[{User.FindFirstValue("email")}] [MODIFY] attendance RecordID '{attendanceRecord.RecordID}' updated", Serilog.Events.LogEventLevel.Information); AttendanceDTO response = new AttendanceDTO(attendanceRecord); return(Ok(response)); } catch (Exception ex) { // Local log entry. Database reconciliation issues are more serious so reported as Error Logger.Msg <AttendancesController>($"[MODIFY] Database sync error {ex.Message}", Serilog.Events.LogEventLevel.Error); // Return response to client return(StatusCode(500, new { errors = "Database update failed. Contact the administrator to resolve this issue." })); } } } else { return(NotFound()); } } // End of ModifyAttendance
public IHttpActionResult GetAttendance(int id) { Attendance Attendance = AttendanceRepo.Get(id); if (Attendance == null) { return(NotFound()); } AttendanceDTO AttendanceDTO = Mapper.Map <AttendanceDTO>(Attendance); return(Ok(AttendanceDTO)); }
public static AttendanceDTO GetAttendanceByStuIdAndCouId(int StuId, int CouId) { String sqlQuery = String.Format("Select * from Attendance where StuId={0} And CouId={1}", StuId, CouId); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(sqlQuery); AttendanceDTO dto = null; if (reader.Read()) { dto = FillAttendanceDTO(reader); } return(dto); } }
public IHttpActionResult GetAttendance(int id) { Attendance Attendance = (Attendance)attendanceRepo.Find(id); if (Attendance == null) { return(NotFound()); } Mapper.Initialize(c => c.CreateMap <Attendance, AttendanceDTO>()); AttendanceDTO AttendanceDTO = Mapper.Map <AttendanceDTO>(Attendance); return(Ok(AttendanceDTO)); }
public IHttpActionResult PostAttendance(AttendanceDTO AttendanceDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Mapper.Initialize(c => c.CreateMap <AttendanceDTO, Attendance>()); Attendance Attendance = Mapper.Map <Attendance>(AttendanceDTO); attendanceRepo.Add(Attendance); attendanceRepo.Save(); return(CreatedAtRoute("DefaultApi", new { id = Attendance.ID }, Attendance)); }
public static StudentDTO GetStudentByStuAndCouId(int Id, int CouId) { String sqlQuery = String.Format("Select * from Student where StuId={0}", Id); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(sqlQuery); StudentDTO dto = null; if (reader.Read()) { dto = FillStudentDTO(reader); AttendanceDTO attendance = AttendanceDAO.GetAttendanceByStuIdAndCouId(Id, CouId); dto.StuAttendance = attendance; } return(dto); } }
public async Task <IHttpActionResult> UpdateAttendance([FromBody] AttendanceDTO AttendanceModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var updatedAttendance = await AttendanceService.UpdateAttendanceAsync(AttendanceModel); if (updatedAttendance != null) { return(Ok(updatedAttendance)); } else { return(NotFound()); } }
public async Task <ActionResult> AddAttendance([FromBody] AttendanceDTO attendance) { // Call BLL method to run validation object BLLResponse = new AttendanceBLL(_context).AddAttendanceBLL(attendance: attendance, userClaims: User); if (BLLResponse.GetType().BaseType == typeof(Exception)) { // Create log entries for Debug log ((APIException)BLLResponse).Exceptions.ForEach(ex => Logger.Msg <AttendancesController>((Exception)ex, Serilog.Events.LogEventLevel.Debug)); // Return response from API return(BadRequest(new { errors = ((APIException)BLLResponse).Exceptions.Select(x => x.Message).ToArray() })); } else { try { Attendance newAttendanceRecord = new Attendance { StudentID = attendance.StudentID, StaffID = attendance.StaffID, AttendanceStateID = attendance.AttendanceStateID, Date = attendance.Date, Comment = attendance.Comment }; _context.AttendanceRecords.Add(newAttendanceRecord); // Save changes await _context.SaveChangesAsync(); Logger.Msg <AttendancesController>($"[{User.FindFirstValue("email")}] [ADD] attendance for StudentID '{newAttendanceRecord.StudentID}' recorded", Serilog.Events.LogEventLevel.Information); AttendanceDTO response = new AttendanceDTO(newAttendanceRecord); return(Ok(response)); } catch (Exception ex) { // Local log entry. Database reconciliation issues are more serious so reported as Error Logger.Msg <AttendancesController>($"[MODIFY] Database sync error {ex.Message}", Serilog.Events.LogEventLevel.Error); // Return response to client return(StatusCode(500, new { errors = "Database update failed. Contact the administrator to resolve this issue." })); } } } // End of AddAttendance
//Update Attendance (async) public async Task <AttendanceDTO> UpdateAttendanceAsync(AttendanceDTO modelDTO) { try { using (var unitOfWork = unitOfWorkFactory.Create()) { if (!string.IsNullOrEmpty(modelDTO._ImageFileUrl)) { var tempImageTypeModel = unitOfWork.ImageFileTypeRepository.GetSingleOrDefaultImageFileType(x => x.Type.Contains("AttendanceImage")); ImageFileTypeDTO imageFileTypeDTO = _Mapper_ToDTO.Map <ImageFileTypeModel, ImageFileTypeDTO>(tempImageTypeModel); modelDTO.ImageFileUrl = new ImageFileUrlDTO() { Url = modelDTO._ImageFileUrl, CreateDate = DateTime.Now, ImageFileTypeId = imageFileTypeDTO.ImageFileTypeId }; } else { modelDTO.ImageFileUrl = null; } AttendanceModel model = _Mapper_ToModel.Map <AttendanceDTO, AttendanceModel>(modelDTO); bool result = unitOfWork.AttendanceRepository.Update(model); AttendanceDTO modelRTN = null; if (result) { await unitOfWork.SaveChangesAsync(); modelRTN = _Mapper_ToDTO.Map <AttendanceModel, AttendanceDTO>(model); } return(modelRTN); } } catch (Exception ex) { LogException(ex); throw ex; } }
public IHttpActionResult Attend(AttendanceDTO dTO) { var userId = User.Identity.GetUserId(); if (_context.Attandances.Any(a => a.GigId == dTO.GigId && a.AttendeeId == userId)) { return(BadRequest("The attendance already exists")); } var attendance = new Attendance { AttendeeId = userId, GigId = dTO.GigId }; _context.Attandances.Add(attendance); _context.SaveChanges(); return(Ok()); }
public async Task <IHttpActionResult> AddAttendance([FromBody] AttendanceDTO AttendanceModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var newAttendanceId = await AttendanceService.AddAttendanceAsync(AttendanceModel); if (newAttendanceId != 0) { return(Ok(newAttendanceId)); } else { return(NotFound()); } }
public IHttpActionResult Attend(AttendanceDTO gidDto) { var exist = _unitOfWork.Attendance.FindAttendance(gidDto.gidID, User.Identity.GetUserId()); if (exist != null) { return(BadRequest("This attandance is existed")); } var attendance = new Attendance { GigID = gidDto.gidID, AttendeeID = User.Identity.GetUserId() }; _unitOfWork.Attendance.Add(attendance); _unitOfWork.Finish(); return(Ok()); }