/// <summary>
/// Delete AttendanceCodeCategories
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel DeleteAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
try
{
var attendanceCodeCategoriesDelete = this.context?.AttendanceCodeCategories.FirstOrDefault(x => x.TenantId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.TenantId && x.SchoolId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.SchoolId && x.AttendanceCategoryId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AttendanceCategoryId);
var AttendanceCodeExist = this.context?.AttendanceCode.FirstOrDefault(x => x.TenantId == attendanceCodeCategoriesDelete.TenantId && x.SchoolId == attendanceCodeCategoriesDelete.SchoolId && x.AttendanceCategoryId == attendanceCodeCategoriesDelete.AttendanceCategoryId);
if (AttendanceCodeExist != null)
{
attendanceCodeCategoriesAddViewModel.attendanceCodeCategories = null;
attendanceCodeCategoriesAddViewModel._message = "AttendanceCodeCategory cannot be deleted because it has its association";
attendanceCodeCategoriesAddViewModel._failure = true;
}
else
{
this.context?.AttendanceCodeCategories.Remove(attendanceCodeCategoriesDelete);
this.context?.SaveChanges();
attendanceCodeCategoriesAddViewModel._failure = false;
attendanceCodeCategoriesAddViewModel._message = "Attendance Code Category Deleted Successfully";
}
}
catch (Exception es)
{
attendanceCodeCategoriesAddViewModel._failure = true;
attendanceCodeCategoriesAddViewModel._message = es.Message;
}
return(attendanceCodeCategoriesAddViewModel);
}
/// <summary>
/// Get AttendanceCodeCategories By Id
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel ViewAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesViewModel = new AttendanceCodeCategoriesAddViewModel();
try
{
var attendanceCodeCategoriesView = this.context?.AttendanceCodeCategories.FirstOrDefault(x => x.TenantId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.TenantId && x.SchoolId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.SchoolId && x.AttendanceCategoryId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AttendanceCategoryId);
if (attendanceCodeCategoriesView != null)
{
attendanceCodeCategoriesViewModel.attendanceCodeCategories = attendanceCodeCategoriesView;
attendanceCodeCategoriesViewModel._failure = false;
}
else
{
attendanceCodeCategoriesViewModel._failure = true;
attendanceCodeCategoriesViewModel._message = NORECORDFOUND;
}
}
catch (Exception es)
{
attendanceCodeCategoriesViewModel._failure = true;
attendanceCodeCategoriesViewModel._message = es.Message;
}
return(attendanceCodeCategoriesViewModel);
}
/// <summary>
/// Add AttendanceCodeCategories
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel AddAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
int?AttendanceCodeCategoryId = Utility.GetMaxPK(this.context, new Func <AttendanceCodeCategories, int>(x => x.AttendanceCategoryId));
attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AttendanceCategoryId = (int)AttendanceCodeCategoryId;
attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.LastUpdated = DateTime.UtcNow;
this.context?.AttendanceCodeCategories.Add(attendanceCodeCategoriesAddViewModel.attendanceCodeCategories);
this.context?.SaveChanges();
attendanceCodeCategoriesAddViewModel._failure = false;
return(attendanceCodeCategoriesAddViewModel);
}
public ActionResult <AttendanceCodeCategoriesAddViewModel> DeleteAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
AttendanceCodeCategoriesAddViewModel attendanceCodeCategorieslDelete = new AttendanceCodeCategoriesAddViewModel();
try
{
attendanceCodeCategorieslDelete = _attendanceCodeRegisterService.DeleteAttendanceCodeCategories(attendanceCodeCategoriesAddViewModel);
}
catch (Exception es)
{
attendanceCodeCategorieslDelete._failure = true;
attendanceCodeCategorieslDelete._message = es.Message;
}
return(attendanceCodeCategorieslDelete);
}
/// <summary>
/// Update AttendanceCodeCategories
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel UpdateAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesUpdateModel = new AttendanceCodeCategoriesAddViewModel();
try
{
var attendanceCodeCategoriesUpdate = this.context?.AttendanceCodeCategories.FirstOrDefault(x => x.TenantId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.TenantId && x.SchoolId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.SchoolId && x.AttendanceCategoryId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AttendanceCategoryId);
attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.LastUpdated = DateTime.Now;
this.context.Entry(attendanceCodeCategoriesUpdate).CurrentValues.SetValues(attendanceCodeCategoriesAddViewModel.attendanceCodeCategories);
this.context?.SaveChanges();
attendanceCodeCategoriesAddViewModel._failure = false;
attendanceCodeCategoriesAddViewModel._message = "Attendance Code Category Updated Successfully";
}
catch (Exception es)
{
attendanceCodeCategoriesAddViewModel._failure = true;
attendanceCodeCategoriesAddViewModel._message = es.Message;
}
return(attendanceCodeCategoriesAddViewModel);
}
/// <summary>
/// Add AttendanceCodeCategories
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel AddAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
//int? AttendanceCodeCategoryId = Utility.GetMaxPK(this.context, new Func<AttendanceCodeCategories, int>(x => x.AttendanceCategoryId));
int?AttendanceCodeCategoryId = 1;
var AttendanceCodeCategoriesData = this.context?.AttendanceCodeCategories.Where(x => x.TenantId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.TenantId && x.SchoolId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.SchoolId).OrderByDescending(x => x.AttendanceCategoryId).FirstOrDefault();
if (AttendanceCodeCategoriesData != null)
{
AttendanceCodeCategoryId = AttendanceCodeCategoriesData.AttendanceCategoryId + 1;
}
attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AttendanceCategoryId = (int)AttendanceCodeCategoryId;
attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.LastUpdated = DateTime.UtcNow;
this.context?.AttendanceCodeCategories.Add(attendanceCodeCategoriesAddViewModel.attendanceCodeCategories);
this.context?.SaveChanges();
attendanceCodeCategoriesAddViewModel._failure = false;
attendanceCodeCategoriesAddViewModel._message = "Attendance Code Category Added Successfully";
return(attendanceCodeCategoriesAddViewModel);
}
/// <summary>
/// Update AttendanceCodeCategories
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel UpdateAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesUpdateModel = new AttendanceCodeCategoriesAddViewModel();
try
{
var attendanceCodeCategoriesUpdate = this.context?.AttendanceCodeCategories.FirstOrDefault(x => x.TenantId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.TenantId && x.SchoolId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.SchoolId && x.AttendanceCategoryId == attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AttendanceCategoryId);
attendanceCodeCategoriesUpdate.AcademicYear = attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.AcademicYear;
attendanceCodeCategoriesUpdate.Title = attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.Title;
attendanceCodeCategoriesUpdate.LastUpdated = DateTime.UtcNow;
attendanceCodeCategoriesUpdate.UpdatedBy = attendanceCodeCategoriesAddViewModel.attendanceCodeCategories.UpdatedBy;
this.context?.SaveChanges();
attendanceCodeCategoriesAddViewModel._failure = false;
attendanceCodeCategoriesAddViewModel._message = "Entity Updated";
}
catch (Exception es)
{
attendanceCodeCategoriesAddViewModel._failure = true;
attendanceCodeCategoriesAddViewModel._message = es.Message;
}
return(attendanceCodeCategoriesAddViewModel);
}
/// <summary>
/// Get AttendanceCodeCategories By Id
/// </summary>
/// <param name="attendanceCodeCategoriesAddViewModel"></param>
/// <returns></returns>
public AttendanceCodeCategoriesAddViewModel ViewAttendanceCodeCategories(AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesAddViewModel)
{
AttendanceCodeCategoriesAddViewModel attendanceCodeCategoriesViewModel = new AttendanceCodeCategoriesAddViewModel();
try
{
if (TokenManager.CheckToken(attendanceCodeCategoriesAddViewModel._tenantName + attendanceCodeCategoriesAddViewModel._userName, attendanceCodeCategoriesAddViewModel._token))
{
attendanceCodeCategoriesViewModel = this.attendanceCodeRepository.ViewAttendanceCodeCategories(attendanceCodeCategoriesAddViewModel);
}
else
{
attendanceCodeCategoriesViewModel._failure = true;
attendanceCodeCategoriesViewModel._message = TOKENINVALID;
}
}
catch (Exception es)
{
attendanceCodeCategoriesViewModel._failure = true;
attendanceCodeCategoriesViewModel._message = es.Message;
}
return(attendanceCodeCategoriesViewModel);
}