/// <summary>
/// Delete BlockPeriod
/// </summary>
/// <param name="blockPeriodAddViewModel"></param>
/// <returns></returns>
public BlockPeriodAddViewModel DeleteBlockPeriod(BlockPeriodAddViewModel blockPeriodAddViewModel)
{
try
{
var blockPeriodDelete = this.context?.BlockPeriod.FirstOrDefault(x => x.TenantId == blockPeriodAddViewModel.blockPeriod.TenantId && x.SchoolId == blockPeriodAddViewModel.blockPeriod.SchoolId && x.PeriodId == blockPeriodAddViewModel.blockPeriod.PeriodId);
if (blockPeriodDelete != null)
{
this.context?.BlockPeriod.Remove(blockPeriodDelete);
this.context?.SaveChanges();
blockPeriodAddViewModel._failure = false;
blockPeriodAddViewModel._message = "Period Deleted Successfully";
}
else
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = NORECORDFOUND;
}
}
catch (Exception es)
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = es.Message;
}
return(blockPeriodAddViewModel);
}
public ActionResult <BlockPeriodAddViewModel> UpdateBlockPeriod(BlockPeriodAddViewModel blockPeriodAddViewModel)
{
BlockPeriodAddViewModel blockPeriodUpdate = new BlockPeriodAddViewModel();
try
{
blockPeriodUpdate = _periodService.UpdateBlockPeriod(blockPeriodAddViewModel);
}
catch (Exception es)
{
blockPeriodUpdate._failure = false;
blockPeriodUpdate._message = es.Message;
}
return(blockPeriodUpdate);
}
/// <summary>
/// Add Block Period
/// </summary>
/// <param name="blockPeriodAddViewModel"></param>
/// <returns></returns>
public BlockPeriodAddViewModel AddBlockPeriod(BlockPeriodAddViewModel blockPeriodAddViewModel)
{
try
{
var periodTitle = this.context?.BlockPeriod.FirstOrDefault(x => x.TenantId == blockPeriodAddViewModel.blockPeriod.TenantId && x.SchoolId == blockPeriodAddViewModel.blockPeriod.SchoolId && x.PeriodTitle.ToLower() == blockPeriodAddViewModel.blockPeriod.PeriodTitle.ToLower() && x.BlockId == blockPeriodAddViewModel.blockPeriod.BlockId);
if (periodTitle == null)
{
int?PeriodId = 1;
int?SortOrder = 1;
var blockPeriodData = this.context?.BlockPeriod.Where(x => x.TenantId == blockPeriodAddViewModel.blockPeriod.TenantId && x.SchoolId == blockPeriodAddViewModel.blockPeriod.SchoolId).OrderByDescending(x => x.PeriodId).FirstOrDefault();
if (blockPeriodData != null)
{
PeriodId = blockPeriodData.PeriodId + 1;
}
var sortOrderData = this.context?.BlockPeriod.Where(x => x.TenantId == blockPeriodAddViewModel.blockPeriod.TenantId && x.SchoolId == blockPeriodAddViewModel.blockPeriod.SchoolId && x.BlockId == blockPeriodAddViewModel.blockPeriod.BlockId).OrderByDescending(x => x.PeriodSortOrder).FirstOrDefault();
if (sortOrderData != null)
{
SortOrder = sortOrderData.PeriodSortOrder + 1;
}
blockPeriodAddViewModel.blockPeriod.PeriodId = (int)PeriodId;
blockPeriodAddViewModel.blockPeriod.PeriodSortOrder = (int)SortOrder;
blockPeriodAddViewModel.blockPeriod.CreatedOn = DateTime.UtcNow;
this.context?.BlockPeriod.Add(blockPeriodAddViewModel.blockPeriod);
this.context?.SaveChanges();
blockPeriodAddViewModel._failure = false;
blockPeriodAddViewModel._message = "Period Added Successfully";
}
else
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = "Period Title Already Exists";
}
}
catch (Exception es)
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = es.Message;
}
return(blockPeriodAddViewModel);
}
/// <summary>
/// Update BlockPeriod
/// </summary>
/// <param name="blockPeriodAddViewModel"></param>
/// <returns></returns>
public BlockPeriodAddViewModel UpdateBlockPeriod(BlockPeriodAddViewModel blockPeriodAddViewModel)
{
try
{
var blockPeriodUpdate = this.context?.BlockPeriod.FirstOrDefault(x => x.TenantId == blockPeriodAddViewModel.blockPeriod.TenantId && x.SchoolId == blockPeriodAddViewModel.blockPeriod.SchoolId && x.PeriodId == blockPeriodAddViewModel.blockPeriod.PeriodId);
if (blockPeriodUpdate != null)
{
var periodTitle = this.context?.BlockPeriod.FirstOrDefault(x => x.TenantId == blockPeriodAddViewModel.blockPeriod.TenantId && x.SchoolId == blockPeriodAddViewModel.blockPeriod.SchoolId && x.BlockId == blockPeriodAddViewModel.blockPeriod.BlockId && x.PeriodId != blockPeriodAddViewModel.blockPeriod.PeriodId && x.PeriodTitle.ToLower() == blockPeriodAddViewModel.blockPeriod.PeriodTitle.ToLower());
if (periodTitle == null)
{
blockPeriodAddViewModel.blockPeriod.CreatedBy = blockPeriodUpdate.CreatedBy;
blockPeriodAddViewModel.blockPeriod.CreatedOn = blockPeriodUpdate.CreatedOn;
blockPeriodAddViewModel.blockPeriod.PeriodSortOrder = blockPeriodUpdate.PeriodSortOrder;
blockPeriodAddViewModel.blockPeriod.UpdatedOn = DateTime.Now;
this.context.Entry(blockPeriodUpdate).CurrentValues.SetValues(blockPeriodAddViewModel.blockPeriod);
this.context?.SaveChanges();
blockPeriodAddViewModel._failure = false;
blockPeriodAddViewModel._message = "Period Updated Successfully";
}
else
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = "Period Title Already Exists";
}
}
else
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = NORECORDFOUND;
}
}
catch (Exception es)
{
blockPeriodAddViewModel._failure = true;
blockPeriodAddViewModel._message = es.Message;
}
return(blockPeriodAddViewModel);
}
/// <summary>
/// Delete BlockPeriod
/// </summary>
/// <param name="blockPeriodAddViewModel"></param>
/// <returns></returns>
public BlockPeriodAddViewModel DeleteBlockPeriod(BlockPeriodAddViewModel blockPeriodAddViewModel)
{
BlockPeriodAddViewModel blockPeriodDelete = new BlockPeriodAddViewModel();
try
{
if (TokenManager.CheckToken(blockPeriodAddViewModel._tenantName + blockPeriodAddViewModel._userName, blockPeriodAddViewModel._token))
{
blockPeriodDelete = this.periodRepository.DeleteBlockPeriod(blockPeriodAddViewModel);
}
else
{
blockPeriodDelete._failure = true;
blockPeriodDelete._message = TOKENINVALID;
}
}
catch (Exception es)
{
blockPeriodDelete._failure = true;
blockPeriodDelete._message = es.Message;
}
return(blockPeriodDelete);
}
