/// <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);
}
