public ResponseMessage UpdatePeriod(PeriodEntity periodUpdate) { ResponseMessage response = new ResponseMessage(); using (var trans = db.Database.BeginTransaction()) { try { Period period = db.Periods.Find(periodUpdate.PeriodId); period.Amount = periodUpdate.Amount; period.AmountReutrn = periodUpdate.AmountReutrn; db.SaveChanges(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); Console.Error.WriteLine(ex.Message); response.MessageText = ResponseMessage.MSG_CANNOT_CONNECT_TO_THE_DATABASE; response.Data = null; return(response); } } return(response); }
public ResponseMessage UpdateTransferPeriod(PeriodEntity periodTransfer) { ResponseMessage response = new ResponseMessage(); using (var trans = db.Database.BeginTransaction()) { try { Period period = db.Periods.Single(p => p.Year == (periodTransfer.Year + 1) && p.ProjectId.Equals(periodTransfer.ProjectId)); period.AmountForward = periodTransfer.AmountForward; period.BalanceForward = periodTransfer.BalanceForward; db.SaveChanges(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); Console.Error.WriteLine(ex.Message); response.MessageText = "Năm " + (periodTransfer.Year + 1) + " chưa được thêm vào phân kỳ!!"; response.Data = null; return(response); } } return(response); }
private ServiceResult AddPeriod(PeriodDto periodDto) { SchoolDayEntity day = Context.SchoolDays .Include(d => d.Periods) .SingleOrDefault(d => d.Id == periodDto.SchoolDayId); if (day == null) { return(new ServiceResult(Result.NotFound)); } var periodEntity = new PeriodEntity(); periodEntity.Number = periodDto.Number; periodEntity.Cabinet = periodDto.Cabinet; periodEntity.Subgroup = periodDto.Subgroup; periodEntity.IsLecture = periodDto.IsLecture; periodEntity.Option = periodDto.Option; periodEntity.OptionDate = periodDto.OptionDate; periodEntity.OptionCabinet = periodDto.OptionCabinet; periodEntity.IsApproved = true; day.Periods.Add(periodEntity); Context.SaveChanges(); return(new ServiceResult(Result.OK, periodEntity.Id)); }
public void Arrange() { _request = new GetPeriodsQueryRequest(); _periodEntity1 = new PeriodEntity { Period = 12, AcademicYear = 1671, ReferenceDataValidationDate = new DateTime(2017, 8, 31), CompletionDate = new DateTime(2017, 9, 5, 19, 27, 34) }; _periodEntity2 = new PeriodEntity { //Id = "1718-R01", Period = 1, AcademicYear = 1718, ReferenceDataValidationDate = new DateTime(2017, 10, 2), CompletionDate = new DateTime(2017, 10, 4, 23, 34, 10) }; _periodRepository = new Mock <IPeriodRepository>(); _periodRepository.Setup(r => r.GetPeriods()) .Returns(Task.FromResult(new[] { _periodEntity1, _periodEntity2 })); _mapper = new AutoMapperMapper(AutoMapperConfigurationFactory.CreateMappingConfig()); _handler = new Application.Period.GetPeriodsQuery.GetPeriodsQueryHandler(_periodRepository.Object, _mapper); }
private void AssertPeriodForEntity(Data.CollectionPeriod period, PeriodEntity entity) { Assert.AreEqual(period.Id, $"{entity.AcademicYear}-R{entity.Period:D2}"); Assert.AreEqual(period.CalendarMonth, PeriodExtensions.GetMonthFromPaymentEntity(entity.Period)); Assert.AreEqual(period.CalendarYear, PeriodExtensions.GetYearFromPaymentEntity(entity.AcademicYear, entity.Period)); Assert.AreEqual(period.AccountDataValidAt, entity.ReferenceDataValidationDate); Assert.AreEqual(period.CommitmentDataValidAt, entity.ReferenceDataValidationDate); Assert.AreEqual(period.CompletionDateTime, entity.CompletionDate); }
private void AssertPeriodForEntity(Data.Period period, PeriodEntity entity) { Assert.AreEqual(entity.Id, period.Id); Assert.AreEqual(entity.CalendarMonth, period.CalendarMonth); Assert.AreEqual(entity.CalendarYear, period.CalendarYear); Assert.AreEqual(entity.AccountDataValidAt, period.AccountDataValidAt); Assert.AreEqual(entity.CommitmentDataValidAt, period.CommitmentDataValidAt); Assert.AreEqual(entity.CompletionDateTime, period.CompletionDateTime); }
public ResponseMessage SearchPeriodById(PeriodEntity periodSearch) { PeriodEntity result = new PeriodEntity(); var period = db.Periods.Find(periodSearch.PeriodId); ResponseMessage response = new ResponseMessage(); response.Data = period; return(response); }
private void UpdatePeriod(PeriodEntity period, PeriodEntity newPeriod) { period.Hash = newPeriod.Hash; period.IsApproved = false; period.Cabinet = newPeriod.Cabinet; period.Subgroup = newPeriod.Subgroup; period.IsLecture = newPeriod.IsLecture; period.Option = newPeriod.Option; period.OptionDate = newPeriod.OptionDate; period.OptionCabinet = newPeriod.OptionCabinet; }
public GetHouseSelectPeriodResultEntity Post(GetHouseSelectPeriodRequestModel req) { GetHouseSelectPeriodResultEntity ret = new GetHouseSelectPeriodResultEntity() { Code = 0, ErrMsg = string.Empty, Periods = new List <PeriodEntity>() }; try { var projectGroups = _projectGroupBLL.GetModels(i => i.ProjectID == req.ProjectId).ToList(); foreach (var i in projectGroups) { var shakingNumberResult = _shakingNumberResultBLL.GetModels(s => s.ProjectGroupID == i.ID).OrderBy(s => s.ShakingNumberSequance).ToList(); if (shakingNumberResult.Count == 0) { Logger.LogWarning(string.Format("项目分组{0}下没有找到摇号结果。跳过此分组。", i.ID), "GetHouseSelectPeriodController", "Post"); continue; } var shakingNumberIds = shakingNumberResult.Select(si => si.ID); var beginNumber = shakingNumberResult.Min(bn => bn.ShakingNumberSequance); var endNumber = shakingNumberResult.Max(en => en.ShakingNumberSequance); var periodsTimes = _houseSelectPeriodBLL.GetModels(hsp => shakingNumberIds.Contains(hsp.ShakingNumberResultID)).ToList(); var startDateTime = periodsTimes.Min(bt => bt.StartTime); var endDateTime = periodsTimes.Max(mt => mt.EndTime); var date = startDateTime.Date; var startTime = startDateTime.TimeOfDay; var endTime = endDateTime.TimeOfDay; PeriodEntity periodInfo = new PeriodEntity() { Date = date.ToString("yyyy-MM-dd"), BeginTime = startTime, EndTime = endTime, GroupId = i.ProjectGroupName, Number = string.Format("{0}-{1}", beginNumber, endNumber) }; ret.Periods.Add(periodInfo); } } catch (Exception ex) { Logger.LogException("获取项目时间段发生异常!", "GetHouseSelectPeriodController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; ret.Periods = null; } return(ret); }
private List <PeriodEntity> MapPeriods(List <PeriodModel> periods) { var entities = new List <PeriodEntity>(); foreach (PeriodModel period in periods) { PeriodEntity entity = MapOnePeriod(period); entities.Add(entity); } return(entities); }
public HttpResponseMessage SearchPeriodDetail(PeriodEntity searchPeriodDetail) { NV5000_FundsForBusiness FundsForBusiness = new NV5000_FundsForBusiness(); ResponseMessage response = FundsForBusiness.SearchPeriodDetail(searchPeriodDetail); if (response.IsSuccess) { return(Request.CreateResponse(HttpStatusCode.OK, response.Data)); } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, response.MessageText)); } }
public HttpResponseMessage UpdateTransferPeriod(PeriodEntity period) { NV5000_FundsForBusiness FundsForBusiness = new NV5000_FundsForBusiness(); ResponseMessage response = FundsForBusiness.UpdateTransferPeriod(period); if (response.IsSuccess) { return(Request.CreateResponse(HttpStatusCode.OK, response.Data)); } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, response.MessageText)); } }
public ResponseMessage SearchPeriod(PeriodEntity periodSearch) { //count project each year var listMoneyGet = (from p in db.PeriodDetails.AsNoTracking() select new { p.Amount, p.AmountDate, p.AdvanceAmount, p.AdvanceDate, p.Payment, p.PaymentDate, p.ProjectId } ); var list = (from p in db.Periods.AsNoTracking() where p.ProjectId.Equals(periodSearch.ProjectId) orderby p.Year select new { PeriodId = p.PeriodId, Year = p.Year, Amount = p.Amount, AmountReutrn = p.AmountReutrn, AmountForward = p.AmountForward, BalanceForward = p.BalanceForward, ProjectId = p.ProjectId, Note = p.Note, //Kinh phí đã cấp MoneyGet = (from r in listMoneyGet where (r.AdvanceDate.Value.Year == p.Year || r.AmountDate.Value.Year == p.Year) && r.ProjectId.Equals(p.ProjectId) select(r.Amount == null ? 0 : r.Amount) + (r.AdvanceAmount == null ? 0 : r.AdvanceAmount)).Sum(), //Kinh phí đã thanh toán MoneyPaid = (from r in listMoneyGet where (r.PaymentDate.Value.Year == p.Year || r.AmountDate.Value.Year == p.Year) && r.ProjectId.Equals(p.ProjectId) select(r.Amount == null ? 0 : r.Amount) + (r.Payment == null ? 0 : r.Payment)).Sum(), //Dư ứng MoneyAdd = (from r in listMoneyGet where (r.AdvanceDate.Value.Year == p.Year || r.PaymentDate.Value.Year == p.Year) && r.ProjectId.Equals(p.ProjectId) select(r.AdvanceAmount == null ? 0 : r.AdvanceAmount) - (r.Payment == null ? 0 : r.Payment)).Sum() }).ToList(); ResponseMessage respond = new ResponseMessage(); respond.Data = list; return(respond); }
public void Arrange() { _request = new GetPeriodsQueryRequest(); _periodEntity1 = new PeriodEntity { Id = "1617-R12", CalendarMonth = 8, CalendarYear = 2017, AccountDataValidAt = new DateTime(2017, 8, 31), CommitmentDataValidAt = new DateTime(2017, 9, 1), CompletionDateTime = new DateTime(2017, 9, 5, 19, 27, 34) }; _periodEntity2 = new PeriodEntity { Id = "1718-R01", CalendarMonth = 9, CalendarYear = 2017, AccountDataValidAt = new DateTime(2017, 10, 2), CommitmentDataValidAt = new DateTime(2017, 9, 30), CompletionDateTime = new DateTime(2017, 10, 4, 23, 34, 10) }; _periodRepository = new Mock <IPeriodRepository>(); _periodRepository.Setup(r => r.GetPeriods()) .Returns(Task.FromResult(new[] { _periodEntity1, _periodEntity2 })); _mapper = new Mock <IMapper>(); _mapper.Setup(m => m.Map <Data.Period[]>(It.IsAny <PeriodEntity[]>())) .Returns((PeriodEntity[] source) => { return(source.Select(e => new Data.Period { Id = e.Id, CalendarMonth = e.CalendarMonth, CalendarYear = e.CalendarYear, AccountDataValidAt = e.AccountDataValidAt, CommitmentDataValidAt = e.CommitmentDataValidAt, CompletionDateTime = e.CompletionDateTime }).ToArray()); }); _handler = new Application.Period.GetPeriodsQuery.GetPeriodsQueryHandler(_periodRepository.Object, _mapper.Object); }
private PeriodEntity MapOnePeriod(PeriodModel period) { string periodJson = TimetableSerializer.SerializeToJson(period); string periodHash = HashCoder.GetSha256Hash(periodJson); var entity = new PeriodEntity { Number = period.Number, Cabinet = period.Cabinet, Subgroup = period.Subgroup, IsLecture = period.IsLecture, Option = period.Modification.Option, OptionDate = period.Modification.Date, OptionCabinet = period.Modification.Cabinet, Hash = periodHash }; return(entity); }
public ResponseMessage AddPeriod(PeriodEntity periodAdd) { ResponseMessage response = new ResponseMessage(); var count = db.Periods.AsNoTracking().Where(p => p.Year == periodAdd.Year && p.ProjectId.Equals(periodAdd.ProjectId)).Count(); if (count == 0) { using (var trans = db.Database.BeginTransaction()) { try { Period p = new Period() { PeriodId = Guid.NewGuid().ToString(), ProjectId = periodAdd.ProjectId, Year = periodAdd.Year, Amount = periodAdd.Amount, AmountReutrn = periodAdd.AmountReutrn }; db.Periods.Add(p); db.SaveChanges(); trans.Commit(); } catch (Exception ex) { Console.Error.WriteLine(ex.Message); response.MessageText = ResponseMessage.MSG_CANNOT_CONNECT_TO_THE_DATABASE; response.Data = null; return(response); } return(response); } } else { response.MessageText = "Năm phân kỳ đã tồn tại, vui lòng sử dụng chức năng cập nhật"; response.Data = null; return(response); } }
private void UpdatePeriods(List <PeriodEntity> periods, IReadOnlyCollection <PeriodEntity> newPeriods) { periods.RemoveAll(p => newPeriods.All(n => n.Number != p.Number)); foreach (PeriodEntity newPeriod in newPeriods) { PeriodEntity periodEntity = periods.FirstOrDefault(p => p.Number == newPeriod.Number); if (periodEntity == null) { periods.Add(newPeriod); continue; } if (HashCoder.IsSameHashes(periodEntity.Hash, newPeriod.Hash)) { continue; } UpdatePeriod(periodEntity, newPeriod); } }
public ServiceResult DeletePeriod(int id) { PeriodEntity period = Context.Periods .Include(p => p.SchoolDay) .ThenInclude(d => d.Subject) .FirstOrDefault(p => p.Id == id); if (period == null) { return(new ServiceResult(Result.NotFound)); } int subjectId = period.SchoolDay.Subject.Id; int dayId = period.SchoolDay.Id; Context.Periods.Remove(period); Context.SaveChanges(); SchoolDayService.UpdateApprovedStatus(dayId); return(new ServiceResult(Result.OK, subjectId)); }
public ServiceResult ApprovePeriod(int periodId) { PeriodEntity period = Context.Periods .Include(p => p.SchoolDay) .ThenInclude(d => d.Subject) .SingleOrDefault(p => p.Id == periodId); if (period == null) { return(new ServiceResult(Result.NotFound)); } int subjectId = period.SchoolDay.Subject.Id; int dayId = period.SchoolDay.Id; period.IsApproved = true; Context.SaveChanges(); SchoolDayService.UpdateApprovedStatus(dayId); return(new ServiceResult(Result.OK, subjectId)); }
private ServiceResult UpdatePeriod(PeriodDto periodDto, int periodId) { PeriodEntity periodEntity = Context.Periods .SingleOrDefault(d => d.Id == periodId); if (periodEntity == null) { return(new ServiceResult(Result.NotFound)); } periodEntity.Number = periodDto.Number; periodEntity.Cabinet = periodDto.Cabinet; periodEntity.Subgroup = periodDto.Subgroup; periodEntity.IsLecture = periodDto.IsLecture; periodEntity.Option = periodDto.Option; periodEntity.OptionDate = periodDto.OptionDate; periodEntity.OptionCabinet = periodDto.OptionCabinet; periodEntity.IsApproved = true; Context.SaveChanges(); return(new ServiceResult(Result.OK, periodId)); }
public ResponseMessage SearchPeriodDetail(PeriodEntity periodDetailSearch) { var list = (from p in db.PeriodDetails.AsNoTracking() where p.ProjectId.Equals(periodDetailSearch.ProjectId) && (p.AmountDate.Value.Year == periodDetailSearch.Year || p.AdvanceDate.Value.Year == periodDetailSearch.Year) orderby(p.AmountDate == null?p.AdvanceDate:p.AmountDate) select new { PeriodDetailId = p.PeriodDetailId, Type = p.Type, Amount = p.Amount, AmountDate = p.AmountDate, AdvanceAmount = p.AdvanceAmount, AdvanceDate = p.AdvanceDate, Payment = p.Payment, PaymentDate = p.PaymentDate, Note = p.Note, ProjectId = p.ProjectId }).ToList(); ResponseMessage respond = new ResponseMessage(); respond.Data = list; return(respond); }
public void Save(PeriodEntity alunoEntity) { PeriodRepository.Save(alunoEntity); }