public StudentAttendanceAddViewModel GetAllStudentAttendanceList(StudentAttendanceAddViewModel studentAttendanceAddViewModel)
{
//StudentAttendanceAddViewModel studentAttendanceViewModel = new StudentAttendanceAddViewModel();
try
{
var studentAttendanceData = this.context?.StudentAttendance.Include(c => c.StudentCoursesectionSchedule).Where(x => x.TenantId == studentAttendanceAddViewModel.TenantId && x.SchoolId == studentAttendanceAddViewModel.SchoolId && x.CourseSectionId == studentAttendanceAddViewModel.CourseSectionId && x.AttendanceDate == studentAttendanceAddViewModel.AttendanceDate && x.PeriodId == studentAttendanceAddViewModel.PeriodId).ToList();
if (studentAttendanceData.Count > 0)
{
studentAttendanceAddViewModel.studentAttendance = studentAttendanceData;
//studentAttendanceAddViewModel._tenantName = studentAttendanceListViewModel._tenantName;
//studentAttendanceAddViewModel._token = studentAttendanceListViewModel._token;
studentAttendanceAddViewModel._failure = false;
}
else
{
studentAttendanceAddViewModel._failure = true;
studentAttendanceAddViewModel._message = NORECORDFOUND;
}
}
catch (Exception es)
{
studentAttendanceAddViewModel._message = es.Message;
studentAttendanceAddViewModel._failure = true;
}
return(studentAttendanceAddViewModel);
}
public ActionResult <StudentAttendanceAddViewModel> GetAllStudentAttendanceList(StudentAttendanceAddViewModel studentAttendanceAddViewModel)
{
StudentAttendanceAddViewModel studentAttendanceView = new StudentAttendanceAddViewModel();
try
{
studentAttendanceView = _studentAttendanceService.GetAllStudentAttendanceList(studentAttendanceAddViewModel);
}
catch (Exception ex)
{
studentAttendanceView._message = ex.Message;
studentAttendanceView._failure = true;
}
return(studentAttendanceView);
}
public StudentAttendanceAddViewModel GetAllStudentAttendanceList(StudentAttendanceAddViewModel studentAttendanceAddViewModel)
{
StudentAttendanceAddViewModel studentAttendanceView = new StudentAttendanceAddViewModel();
if (TokenManager.CheckToken(studentAttendanceAddViewModel._tenantName + studentAttendanceAddViewModel._userName, studentAttendanceAddViewModel._token))
{
studentAttendanceView = this.studentAttendanceRepository.GetAllStudentAttendanceList(studentAttendanceAddViewModel);
}
else
{
studentAttendanceView._failure = true;
studentAttendanceView._message = TOKENINVALID;
}
return(studentAttendanceView);
}
/// <summary>
/// Student Attendance Add/Update
/// </summary>
/// <param name="studentAttendanceAddViewModel"></param>
/// <returns></returns>
public StudentAttendanceAddViewModel SaveStudentAttendance(StudentAttendanceAddViewModel studentAttendanceAddViewModel)
{
StudentAttendanceAddViewModel studentAttendanceAdd = new StudentAttendanceAddViewModel();
if (TokenManager.CheckToken(studentAttendanceAddViewModel._tenantName + studentAttendanceAddViewModel._userName, studentAttendanceAddViewModel._token))
{
studentAttendanceAdd = this.studentAttendanceRepository.AddUpdateStudentAttendance(studentAttendanceAddViewModel);
}
else
{
studentAttendanceAdd._failure = true;
studentAttendanceAdd._message = TOKENINVALID;
}
return(studentAttendanceAdd);
}
public ActionResult <StudentAttendanceAddViewModel> AddUpdateStudentAttendance(StudentAttendanceAddViewModel studentAttendanceAddViewModel)
{
StudentAttendanceAddViewModel studentAttendanceAdd = new StudentAttendanceAddViewModel();
try
{
studentAttendanceAdd = _studentAttendanceService.SaveStudentAttendance(studentAttendanceAddViewModel);
}
catch (Exception ex)
{
studentAttendanceAdd._message = ex.Message;
studentAttendanceAdd._failure = true;
}
return(studentAttendanceAdd);
}
/// <summary>
/// Student Attendance Add/Update
/// </summary>
/// <param name="studentAttendanceAddViewModel"></param>
/// <returns></returns>
public StudentAttendanceAddViewModel AddUpdateStudentAttendance(StudentAttendanceAddViewModel studentAttendanceAddViewModel)
{
using (var transaction = this.context.Database.BeginTransaction())
{
try
{
List <StudentAttendance> studentAttendance = new List <StudentAttendance>();
if (studentAttendanceAddViewModel.studentAttendance.Count > 0)
{
var attendanceDataExist = this.context?.StudentAttendance.Where(x => x.TenantId == studentAttendanceAddViewModel.TenantId && x.SchoolId == studentAttendanceAddViewModel.SchoolId && x.CourseSectionId == studentAttendanceAddViewModel.CourseSectionId && x.AttendanceDate == studentAttendanceAddViewModel.AttendanceDate && x.PeriodId == studentAttendanceAddViewModel.PeriodId).ToList();
if (attendanceDataExist.Count > 0)
{
this.context?.StudentAttendance.RemoveRange(attendanceDataExist);
foreach (var studentAttendancedata in studentAttendanceAddViewModel.studentAttendance.ToList())
{
var studentAttendanceUpdate = new StudentAttendance()
{
TenantId = studentAttendanceAddViewModel.TenantId,
SchoolId = studentAttendanceAddViewModel.SchoolId,
StudentId = studentAttendancedata.StudentId,
StaffId = studentAttendanceAddViewModel.StaffId,
CourseId = studentAttendanceAddViewModel.CourseId,
CourseSectionId = studentAttendanceAddViewModel.CourseSectionId,
AttendanceCategoryId = studentAttendancedata.AttendanceCategoryId,
AttendanceCode = studentAttendancedata.AttendanceCode,
AttendanceDate = studentAttendanceAddViewModel.AttendanceDate,
Comments = studentAttendancedata.Comments,
UpdatedBy = studentAttendanceAddViewModel.UpdatedBy,
UpdatedOn = DateTime.UtcNow,
BlockId = studentAttendancedata.BlockId,
PeriodId = studentAttendanceAddViewModel.PeriodId,
};
studentAttendance.Add(studentAttendanceUpdate);
}
studentAttendanceAddViewModel._message = "Student Attendance updated succsesfully.";
}
else
{
foreach (var studentAttendancedata in studentAttendanceAddViewModel.studentAttendance.ToList())
{
var studentAttendanceAdd = new StudentAttendance()
{
TenantId = studentAttendanceAddViewModel.TenantId,
SchoolId = studentAttendanceAddViewModel.SchoolId,
StudentId = studentAttendancedata.StudentId,
StaffId = studentAttendanceAddViewModel.StaffId,
CourseId = studentAttendanceAddViewModel.CourseId,
CourseSectionId = studentAttendanceAddViewModel.CourseSectionId,
AttendanceCategoryId = studentAttendancedata.AttendanceCategoryId,
AttendanceCode = studentAttendancedata.AttendanceCode,
AttendanceDate = studentAttendanceAddViewModel.AttendanceDate,
Comments = studentAttendancedata.Comments,
CreatedBy = studentAttendanceAddViewModel.UpdatedBy,
CreatedOn = DateTime.UtcNow,
BlockId = studentAttendancedata.BlockId,
PeriodId = studentAttendanceAddViewModel.PeriodId,
};
studentAttendance.Add(studentAttendanceAdd);
}
studentAttendanceAddViewModel._message = "Student Attendance added succsesfully.";
}
this.context?.StudentAttendance.AddRange(studentAttendance);
this.context?.SaveChanges();
transaction.Commit();
studentAttendanceAddViewModel._failure = false;
}
}
catch (Exception es)
{
transaction.Rollback();
studentAttendanceAddViewModel._failure = true;
studentAttendanceAddViewModel._message = es.Message;
}
}
return(studentAttendanceAddViewModel);
}
