public void InitClientData(Client clsClient)
{
DateTime StartPeriod;
DateTime EndPeriod;
string[] DateStuff = ServiceDate.Split('/');
ClientStuff.NoCommodity = clsClient.clsHH.NoCommodities;
ClientStuff.SupplementalOnly = clsClient.clsHH.SupplOnly;
ClientStuff.HaveCSFP = (clsClient.clsHH.NbrCSFP > 0);
ClientStuff.FamilySize = clsClient.clsHH.TotalFamily;
ClientStuff.Homeless = clsClient.clsHH.Homeless;
ClientStuff.Transient = (clsClient.clsHH.ClientType == CCFBPrefs.TransientId);
TrxLog trxLogWork = new TrxLog(CCFBGlobal.connectionString);
//Nbr Service This Month
StartPeriod = Convert.ToDateTime(DateStuff[0].ToString() + "/01/" + DateStuff[2].ToString());
EndPeriod = StartPeriod.AddMonths(1).AddDays(-1);
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
ClientStuff.NbrServicesThisMonth = trxLogWork.RowCount;
//Nbr Services This Fiscal Year
StartPeriod = CCFBGlobal.CalcFiscalStartDate(Convert.ToDateTime(ServiceDate));
EndPeriod = CCFBGlobal.CalcFiscalEndDate(Convert.ToDateTime(ServiceDate));
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
ClientStuff.NbrServicesThisFiscalYr = trxLogWork.RowCount;
//Nbr Services This Calendar Year
if (CCFBPrefs.FiscalYearStartMonth != 1)
{
StartPeriod = Convert.ToDateTime("01/01/" + DateStuff[2].ToString());
EndPeriod = StartPeriod.AddYears(1).AddDays(-1);
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
}
ClientStuff.NbrServicesThisCalYr = trxLogWork.RowCount;
ClearSelected();
}
public void InitClientData(Client clsClient)
{
DateTime StartPeriod;
DateTime EndPeriod;
DateTime servicedate;
string[] DateStuff = ServiceDate.Split('/');
servicedate = Convert.ToDateTime(ServiceDate);
ClientStuff.NoCommodity = clsClient.clsHH.NoCommodities;
ClientStuff.SupplementalOnly = clsClient.clsHH.SupplOnly;
ClientStuff.HaveCSFP = (clsClient.clsHH.NbrCSFP > 0);
ClientStuff.FamilySize = clsClient.clsHH.TotalFamily;
ClientStuff.Homeless = clsClient.clsHH.Homeless;
ClientStuff.Transient = (clsClient.clsHH.ClientType == CCFBPrefs.TransientId);
ClientStuff.NbrServicesThisCalYr = 0;
ClientStuff.NbrServicesThisFiscalYr = 0;
ClientStuff.NbrServicesThisMonth = 0;
ClientStuff.NbrServicesThisWeek = 0;
ClientStuff.NbrSupplThisMonth = 0;
ClientStuff.NbrTEFAPThisMonth = 0;
ClientStuff.NbrFullSvcThisMonth = 0;
ClientStuff.LastFullService = clsClient.clsHH.LatestService;
ClientStuff.LastTEFAPService = clsClient.clsHH.LastCommodityService;
ClientStuff.LastSupplService = clsClient.clsHH.LastSupplService;
TrxLog trxLogWork = new TrxLog(CCFBGlobal.connectionString, true, true, false, false);
//Nbr Service This Month
StartPeriod = Convert.ToDateTime(DateStuff[0].ToString() + "/01/" + DateStuff[2].ToString());
EndPeriod = servicedate.AddDays(-1);
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
ClientStuff.NbrServicesThisMonth = trxLogWork.RowCount;
for (int i = 0; i < trxLogWork.RowCount; i++)
{
trxLogWork.setDataRow(i);
if (trxLogWork.RcvdCommodity == true)
{
ClientStuff.NbrTEFAPThisMonth++;
}
if (trxLogWork.RcvdSupplemental == true)
{
ClientStuff.NbrSupplThisMonth++;
}
if (trxLogWork.FullService == true)
{
ClientStuff.NbrFullSvcThisMonth++;
}
}
//Nbr Services This Fiscal Year
StartPeriod = CCFBGlobal.CalcFiscalStartDate(Convert.ToDateTime(ServiceDate));
EndPeriod = servicedate;
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
ClientStuff.NbrServicesThisFiscalYr = trxLogWork.RowCount;
//Nbr Services This Calendar Year
if (CCFBPrefs.FiscalYearStartMonth != 1)
{
StartPeriod = Convert.ToDateTime("01/01/" + DateStuff[2].ToString());
EndPeriod = servicedate;
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
}
ClientStuff.NbrServicesThisCalYr = trxLogWork.RowCount;
int dayofweek = Convert.ToInt32(servicedate.DayOfWeek);
StartPeriod = servicedate.AddDays(-dayofweek);
EndPeriod = servicedate.AddDays(-1);
trxLogWork.openUsingDateRange(clsClient.clsHH.ID, StartPeriod, EndPeriod);
ClientStuff.NbrServicesThisWeek = trxLogWork.RowCount;
ClearSelected();
}
