private void fillMonthlyFinalizationDateAndFinalized(FinalizedMonthItem item) { item.DateFinalized = null; item.IsFinalized = false; if (item.ID.HasValue) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SELECT DateCreated FROM dbo.CaseMonthlyPeriodProviderFinalizations " + "WHERE CaseMonthlyPeriodID = @PeriodID AND ProviderID = @ProviderID AND IsComplete = 1;"; cmd.Parameters.AddWithValue("@PeriodID", item.ID.Value); cmd.Parameters.AddWithValue("@ProviderID", Global.Default.GetUserProvider().ID.Value); DataRow r = cmd.GetRowOrNull(); if (r == null) { return; } else { item.DateFinalized = r.ToDateTime("DateCreated"); item.IsFinalized = true; return; } } } }
internal FinalizeMonthPopupVM GetFinalizeMonthPopupVM(int caseID) { var model = new FinalizeMonthPopupVM(); var items = new List <FinalizedMonthItem>(); var data = caseService.GetCaseMonthlyPeriods(caseID, DateTime.Now.AddMonths(-6), DateTime.Now); foreach (var dataItem in data) { var item = new FinalizedMonthItem(); item.ID = dataItem.ID; item.FirstDayOfTargetMonth = dataItem.FirstDayOfMonth; fillMonthlyFinalizationDateAndFinalized(item); items.Add(item); } model.Items = items.OrderByDescending(x => x.FirstDayOfTargetMonth).ToList(); return(model); }