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