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