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