/// <summary> /// Get AttendanceCode By Id /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel ViewAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { AttendanceCodeAddViewModel attendanceCodeViewModel = new AttendanceCodeAddViewModel(); try { var attendanceCodeView = this.context?.AttendanceCode.FirstOrDefault(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.AttendanceCode1 == attendanceCodeAddViewModel.attendanceCode.AttendanceCode1); if (attendanceCodeView != null) { attendanceCodeViewModel.attendanceCode = attendanceCodeView; attendanceCodeAddViewModel._failure = false; } else { attendanceCodeViewModel._failure = true; attendanceCodeViewModel._message = NORECORDFOUND; } } catch (Exception es) { attendanceCodeViewModel._failure = true; attendanceCodeViewModel._message = es.Message; } return(attendanceCodeViewModel); }
/// <summary> /// Update AttendanceCode /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel UpdateAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { AttendanceCodeAddViewModel attendanceCodeUpdateModel = new AttendanceCodeAddViewModel(); try { var attendanceCodeUpdate = this.context?.AttendanceCode.FirstOrDefault(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.AttendanceCode1 == attendanceCodeAddViewModel.attendanceCode.AttendanceCode1); attendanceCodeUpdate.AttendanceCategoryId = attendanceCodeAddViewModel.attendanceCode.AttendanceCategoryId; attendanceCodeUpdate.AcademicYear = attendanceCodeAddViewModel.attendanceCode.AcademicYear; attendanceCodeUpdate.Title = attendanceCodeAddViewModel.attendanceCode.Title; attendanceCodeUpdate.ShortName = attendanceCodeAddViewModel.attendanceCode.ShortName; attendanceCodeUpdate.Type = attendanceCodeAddViewModel.attendanceCode.Type; attendanceCodeUpdate.StateCode = attendanceCodeAddViewModel.attendanceCode.StateCode; attendanceCodeUpdate.DefaultCode = attendanceCodeAddViewModel.attendanceCode.DefaultCode; attendanceCodeUpdate.AllowEntryBy = attendanceCodeAddViewModel.attendanceCode.AllowEntryBy; attendanceCodeUpdate.SortOrder = attendanceCodeAddViewModel.attendanceCode.SortOrder; attendanceCodeUpdate.LastUpdated = DateTime.UtcNow; attendanceCodeUpdate.UpdatedBy = attendanceCodeAddViewModel.attendanceCode.UpdatedBy; this.context?.SaveChanges(); attendanceCodeAddViewModel._failure = false; attendanceCodeAddViewModel._message = "Entity Updated"; } catch (Exception es) { attendanceCodeAddViewModel._failure = true; attendanceCodeAddViewModel._message = es.Message; } return(attendanceCodeAddViewModel); }
/// <summary> /// Add AttendanceCode /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel AddAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { //int? AttendanceCodeId = Utility.GetMaxPK(this.context, new Func<AttendanceCode, int>(x => x.AttendanceCode1)); int?AttendanceCodeId = 1; int?SortOrder = 1; var AttendanceCodeData = this.context?.AttendanceCode.Where(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId).OrderByDescending(x => x.AttendanceCode1).FirstOrDefault(); if (AttendanceCodeData != null) { AttendanceCodeId = AttendanceCodeData.AttendanceCode1 + 1; } var attendanceCodeSortOrder = this.context?.AttendanceCode.Where(x => x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.AttendanceCategoryId == attendanceCodeAddViewModel.attendanceCode.AttendanceCategoryId).OrderByDescending(x => x.SortOrder).FirstOrDefault(); if (attendanceCodeSortOrder != null) { SortOrder = attendanceCodeSortOrder.SortOrder + 1; } attendanceCodeAddViewModel.attendanceCode.AttendanceCode1 = (int)AttendanceCodeId; attendanceCodeAddViewModel.attendanceCode.LastUpdated = DateTime.UtcNow; attendanceCodeAddViewModel.attendanceCode.SortOrder = (int)SortOrder; this.context?.AttendanceCode.Add(attendanceCodeAddViewModel.attendanceCode); this.context?.SaveChanges(); attendanceCodeAddViewModel._failure = false; attendanceCodeAddViewModel._message = "Attendance Code Added Successfully"; return(attendanceCodeAddViewModel); }
/// <summary> /// Add AttendanceCode /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel AddAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { int?AttendanceCodeId = Utility.GetMaxPK(this.context, new Func <AttendanceCode, int>(x => x.AttendanceCode1)); attendanceCodeAddViewModel.attendanceCode.AttendanceCode1 = (int)AttendanceCodeId; attendanceCodeAddViewModel.attendanceCode.LastUpdated = DateTime.UtcNow; this.context?.AttendanceCode.Add(attendanceCodeAddViewModel.attendanceCode); this.context?.SaveChanges(); attendanceCodeAddViewModel._failure = false; return(attendanceCodeAddViewModel); }
public ActionResult <AttendanceCodeAddViewModel> UpdateAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { AttendanceCodeAddViewModel attendanceCodeUpdate = new AttendanceCodeAddViewModel(); try { attendanceCodeUpdate = _attendanceCodeRegisterService.UpdateAttendanceCode(attendanceCodeAddViewModel); } catch (Exception es) { attendanceCodeUpdate._failure = true; attendanceCodeUpdate._message = es.Message; } return(attendanceCodeUpdate); }
/// <summary> /// Delete AttendanceCode /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel DeleteAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { try { var attendanceCodeDelete = this.context?.AttendanceCode.FirstOrDefault(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.AttendanceCode1 == attendanceCodeAddViewModel.attendanceCode.AttendanceCode1); this.context?.AttendanceCode.Remove(attendanceCodeDelete); this.context?.SaveChanges(); attendanceCodeAddViewModel._failure = false; attendanceCodeAddViewModel._message = "Deleted"; } catch (Exception es) { attendanceCodeAddViewModel._failure = true; attendanceCodeAddViewModel._message = es.Message; } return(attendanceCodeAddViewModel); }
/// <summary> /// Update AttendanceCode /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel UpdateAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { AttendanceCodeAddViewModel attendanceCodeUpdateModel = new AttendanceCodeAddViewModel(); try { var attendanceCodeUpdate = this.context?.AttendanceCode.FirstOrDefault(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.AttendanceCode1 == attendanceCodeAddViewModel.attendanceCode.AttendanceCode1); attendanceCodeAddViewModel.attendanceCode.LastUpdated = DateTime.Now; attendanceCodeAddViewModel.attendanceCode.AttendanceCategoryId = attendanceCodeUpdate.AttendanceCategoryId; this.context.Entry(attendanceCodeUpdate).CurrentValues.SetValues(attendanceCodeAddViewModel.attendanceCode); this.context?.SaveChanges(); attendanceCodeAddViewModel._failure = false; attendanceCodeAddViewModel._message = "Attendance Code Updated Successfully"; } catch (Exception es) { attendanceCodeAddViewModel._failure = true; attendanceCodeAddViewModel._message = es.Message; } return(attendanceCodeAddViewModel); }
/// <summary> /// Get AttendanceCode By Id /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel ViewAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { AttendanceCodeAddViewModel attendanceCodeViewModel = new AttendanceCodeAddViewModel(); try { if (TokenManager.CheckToken(attendanceCodeAddViewModel._tenantName + attendanceCodeAddViewModel._userName, attendanceCodeAddViewModel._token)) { attendanceCodeViewModel = this.attendanceCodeRepository.ViewAttendanceCode(attendanceCodeAddViewModel); } else { attendanceCodeViewModel._failure = true; attendanceCodeViewModel._message = TOKENINVALID; } } catch (Exception es) { attendanceCodeViewModel._failure = true; attendanceCodeViewModel._message = es.Message; } return(attendanceCodeViewModel); }
/// <summary> /// Delete AttendanceCode /// </summary> /// <param name="attendanceCodeAddViewModel"></param> /// <returns></returns> public AttendanceCodeAddViewModel DeleteAttendanceCode(AttendanceCodeAddViewModel attendanceCodeAddViewModel) { try { var attendanceCodeDelete = this.context?.AttendanceCode.FirstOrDefault(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.AttendanceCode1 == attendanceCodeAddViewModel.attendanceCode.AttendanceCode1); if (attendanceCodeDelete != null) { var studentAttendanceData = this.context?.StudentAttendance.FirstOrDefault(x => x.TenantId == attendanceCodeAddViewModel.attendanceCode.TenantId && x.SchoolId == attendanceCodeAddViewModel.attendanceCode.SchoolId && x.AttendanceCode == attendanceCodeAddViewModel.attendanceCode.AttendanceCode1); if (studentAttendanceData != null) { attendanceCodeAddViewModel._failure = true; attendanceCodeAddViewModel._message = "Cannot Delete Because It Has Association."; } else { this.context?.AttendanceCode.Remove(attendanceCodeDelete); this.context?.SaveChanges(); attendanceCodeAddViewModel._failure = false; attendanceCodeAddViewModel._message = "Attendance Code Deleted Successfully"; } } else { attendanceCodeAddViewModel._failure = true; attendanceCodeAddViewModel._message = NORECORDFOUND; } } catch (Exception es) { attendanceCodeAddViewModel._failure = true; attendanceCodeAddViewModel._message = es.Message; } return(attendanceCodeAddViewModel); }