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