private PeriodMonth getPeriodMonth(PeriodDetail evaluatedPeriod, PeriodDetail previousPeriod, PeriodDetail nextPeriod, PeriodDetail lastPeriodOfYear) { var firstPeriodOfMonth = false; var lastPeriodOfMonth = false; if ((evaluatedPeriod.Number == FIRST_NUMBER_PERIOD) || (evaluatedPeriod.Month != previousPeriod.Month)) { firstPeriodOfMonth = true; } if ((evaluatedPeriod.Number == lastPeriodOfYear.Number) || (evaluatedPeriod.Month != nextPeriod.Month)) { lastPeriodOfMonth = true; } if (firstPeriodOfMonth && lastPeriodOfMonth) { return(PeriodMonth.Both); } else if (firstPeriodOfMonth) { return(PeriodMonth.Initial); } else if (lastPeriodOfMonth) { return(PeriodMonth.Final); } else { return(PeriodMonth.None); } }
public ResponseMessage UpdatePeriodDetail(PeriodDetailEntity periodUpdateDetail) { ResponseMessage response = new ResponseMessage(); using (var trans = db.Database.BeginTransaction()) { try { PeriodDetail periodDetail = db.PeriodDetails.Find(periodUpdateDetail.PeriodDetailId); periodDetail.Type = periodUpdateDetail.Type; periodDetail.Amount = periodUpdateDetail.Amount; periodDetail.AmountDate = periodUpdateDetail.AmountDate; periodDetail.Note = periodUpdateDetail.Note; periodDetail.AdvanceAmount = periodUpdateDetail.AdvanceAmount; periodDetail.AdvanceDate = periodUpdateDetail.AdvanceDate; periodDetail.Payment = periodUpdateDetail.Payment; periodDetail.PaymentDate = periodUpdateDetail.PaymentDate; 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 async Task <Object> Add(PeriodRecored recored) { if (ModelState.IsValid) { PeriodDetail model = new PeriodDetail { ID = recored.ID, Course = authDb.Courses.Where(a => a.ID == recored.Course).FirstOrDefault(), Teacher = authDb.Teachers.Where(a => a.ID == recored.Teacher).FirstOrDefault(), Classes = authDb.Classes.Where(a => a.Name == recored.Classes && a.Section == recored.Section).FirstOrDefault(), Period = recored.Period, }; if (model.ID != 0) { await Task.Run(() => authDb.Entry(model).State = EntityState.Modified); } else { await Task.Run(() => authDb.AddAsync(model)); } await authDb.SaveChangesAsync(); return(Ok()); } return(BadRequest("data is not valid")); }
private PeriodFiscalYear getPeriodFiscalYear(PeriodDetail evaluatedPeriod, PeriodDetail lastPeriodOfYear) { if (evaluatedPeriod.Number == FIRST_NUMBER_PERIOD) { return(PeriodFiscalYear.Initial); } else if (evaluatedPeriod.Number == lastPeriodOfYear.Number) { return(PeriodFiscalYear.Final); } else { return(PeriodFiscalYear.None); } }
private void SetPeriodsFlags(List <PeriodDetail> periods) { PeriodDetail previousPeriod = null; PeriodDetail nextPeriod = null; int posElement = 0; foreach (var period in periods) { nextPeriod = (posElement + 1 < periods.Count) ? periods[posElement + 1] : null; var periodFiscalYear = getPeriodFiscalYear(period, periods.LastOrDefault()); var periodMonth = getPeriodMonth(period, previousPeriod, nextPeriod, periods.LastOrDefault()); var periodBimonth = getPeriodBimonthlyIMSS(period.Month, periodMonth); period.PeriodFiscalYear = periodFiscalYear; period.PeriodMonth = periodMonth; period.PeriodBimonthlyIMSS = periodBimonth; previousPeriod = period; posElement++; } }
public ResponseMessage DeletePeriodDetail(PeriodDetailEntity periodDetailDelete) { ResponseMessage response = new ResponseMessage(); using (var trans = db.Database.BeginTransaction()) { try { PeriodDetail periodDetail = db.PeriodDetails.Find(periodDetailDelete.PeriodDetailId); db.PeriodDetails.Remove(periodDetail); 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); }
private PeriodMonth getPeriodMonth(PeriodDetail evaluatedPeriod, PeriodDetail previousPeriod, PeriodDetail nextPeriod, PeriodDetail lastPeriodOfYear) { if (evaluatedPeriod.Number == FIRST_NUMBER_PERIOD) { return(PeriodMonth.Initial); } else if (evaluatedPeriod.Number == lastPeriodOfYear.Number) { return(PeriodMonth.Final); } else if (evaluatedPeriod.Month < nextPeriod.Month) { return(PeriodMonth.Final); } else if (evaluatedPeriod.Month > previousPeriod.Month) { return(PeriodMonth.Initial); } else { return(PeriodMonth.None); } }
public ResponseMessage AddPeriodDetail(PeriodDetailEntity periodDetailAdd) { ResponseMessage response = new ResponseMessage(); using (var trans = db.Database.BeginTransaction()) { try { PeriodDetail p = new PeriodDetail() { PeriodDetailId = Guid.NewGuid().ToString(), Type = periodDetailAdd.Type, Amount = periodDetailAdd.Amount, AmountDate = periodDetailAdd.AmountDate, AdvanceAmount = periodDetailAdd.AdvanceAmount, AdvanceDate = periodDetailAdd.AdvanceDate, Payment = periodDetailAdd.Payment, PaymentDate = periodDetailAdd.PaymentDate, Note = periodDetailAdd.Note, ProjectId = periodDetailAdd.ProjectId }; db.PeriodDetails.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); } }