protected void dataSourceViewResourceReport_Inserted(object sender, ObjectContainerDataSourceStatusEventArgs e)
        {
            ViewResourceReportViewData RptData = (ViewResourceReportViewData)e.Instance;

            RptData.SubmitterID = AccountInfo.UserId.ToString();
            _NewReportId        = Logic.AddReport(RptData);
        }
Esempio n. 2
0
 /// <summary>
 /// Adds a new Resource Report record
 /// </summary>
 /// <param name="RptData">ResourceReport</param>
 /// <returns>ResourceReportId</returns>
 public static int AddResourceReport(ViewResourceReportViewData RptData)
 {
     try
     {
         int ResourceReportId = 0;
         SaveResourceReport(RptData, out ResourceReportId);
         return(ResourceReportId);
     }
     catch (System.Exception exFail)
     {
         //TODO: Log error and report error
         return(-1);
     }
 }
Esempio n. 3
0
        /// <summary>
        /// Adds a new resource report
        /// </summary>
        /// <param name="RptData"></param>
        /// <returns>ResourceReportId</returns>
        /// <exception cref="ArgumentNullException"></exception>
        public int AddReport(ViewResourceReportViewData RptData)
        {
            // Ensure the fields that are required contain values
            if (RptData.SubmitterID == "-1")
            {
                throw(new ArgumentNullException("SubmitterId"));
            }

            if ((string.IsNullOrEmpty(RptData.StateFIPSCode)))
            {
                throw (new ArgumentNullException("StateFIPSCode"));
            }
            return(ReportsDAL.AddResourceReport(RptData));
        }
Esempio n. 4
0
        private static bool SaveResourceReport(ViewResourceReportViewData RptData, out int outResourceReportId)
        {
            bool result = false;

            Database db = DatabaseFactory.CreateDatabase("DB_SHIP-NPR");

            outResourceReportId = -1;
            using (DbCommand dbCmd = db.GetStoredProcCommand(StoredProcNames.Reports.SaveResourceReport.Description()))
            {
                dbCmd.Connection = db.CreateConnection();
                dbCmd.Connection.Open();
                db.AddInParameter(dbCmd, "@SubmitterID", DbType.Int32, int.Parse(RptData.SubmitterID));
                db.AddInParameter(dbCmd, "@ReviewerID", DbType.Int32, int.Parse(RptData.ReviewerID));
                db.AddInParameter(dbCmd, "@RepYrFrom", DbType.Date, Convert.ToDateTime(RptData.RepYrFrom));
                db.AddInParameter(dbCmd, "@RepYrTo", DbType.Date, Convert.ToDateTime(RptData.RepYrTo));
                db.AddInParameter(dbCmd, "@StateFIPSCode", DbType.String, RptData.StateFIPSCode);
                db.AddInParameter(dbCmd, "@StateGranteeName", DbType.String, RptData.StateGranteeName);
                db.AddInParameter(dbCmd, "@PersonCompletingReportName", DbType.String, RptData.PersonCompletingReportName);
                db.AddInParameter(dbCmd, "@PersonCompletingReportTitle", DbType.String, RptData.PersonCompletingReportTitle);
                db.AddInParameter(dbCmd, "@PersonCompletingReportTel", DbType.String, RptData.PersonCompletingReportTel);
                db.AddInParameter(dbCmd, "@NoOfStateVolunteerCounselors", DbType.Int32, int.Parse(RptData.NoOfStateVolunteerCounselors));

                db.AddInParameter(dbCmd, "@NoOfOtherVolunteerCounselors", DbType.Int32, int.Parse(RptData.NoOfOtherVolunteerCounselors));
                db.AddInParameter(dbCmd, "@NoOfStateShipPaidCounselors", DbType.Int32, int.Parse(RptData.@NoOfStateShipPaidCounselors));
                db.AddInParameter(dbCmd, "@NoOfOtherShipPaidCounselors", DbType.Int32, int.Parse(RptData.NoOfOtherShipPaidCounselors));
                db.AddInParameter(dbCmd, "@NoOfStateInKindPaidCounselors", DbType.Int32, int.Parse(RptData.@NoOfStateInKindPaidCounselors));
                db.AddInParameter(dbCmd, "@NoOfOtherInKindPaidCounselors", DbType.Int32, int.Parse(RptData.NoOfOtherInKindPaidCounselors));
                db.AddInParameter(dbCmd, "@NoOfStateVolunteerCounselorsHrs", DbType.Int32, int.Parse(RptData.NoOfStateVolunteerCounselorsHrs));
                db.AddInParameter(dbCmd, "@NoOfOtherVolunteerCounselorsHrs", DbType.Int32, int.Parse(RptData.NoOfOtherVolunteerCounselorsHrs));
                db.AddInParameter(dbCmd, "@NoOfStateShipPaidCounselorsHrs", DbType.Int32, int.Parse(RptData.NoOfStateShipPaidCounselorsHrs));
                db.AddInParameter(dbCmd, "@NoOfOtherShipPaidCounselorsHrs", DbType.Int32, int.Parse(RptData.NoOfOtherShipPaidCounselorsHrs));
                db.AddInParameter(dbCmd, "@NoOfStateInKindPaidCounselorsHrs", DbType.Int32, int.Parse(RptData.NoOfStateInKindPaidCounselorsHrs));
                db.AddInParameter(dbCmd, "@NoOfOtherInKindPaidCounselorsHrs", DbType.Int32, int.Parse(RptData.NoOfOtherInKindPaidCounselorsHrs));

                db.AddInParameter(dbCmd, "@NoOfUnpaidVolunteerCoordinators", DbType.Int32, int.Parse(RptData.NoOfUnpaidVolunteerCoordinators));
                db.AddInParameter(dbCmd, "@NoOfSHIPPaidCoordinators", DbType.Int32, int.Parse(RptData.NoOfSHIPPaidCoordinators));
                db.AddInParameter(dbCmd, "@NoOfInKindPaidCoordinators", DbType.Int32, int.Parse(RptData.NoOfInKindPaidCoordinators));
                db.AddInParameter(dbCmd, "@NoOfUnpaidVolunteerCoordinatorsHrs", DbType.Int32, int.Parse(RptData.NoOfUnpaidVolunteerCoordinatorsHrs));
                db.AddInParameter(dbCmd, "@NoOfSHIPPaidCoordinatorsHrs", DbType.Int32, int.Parse(RptData.@NoOfSHIPPaidCoordinatorsHrs));
                db.AddInParameter(dbCmd, "@NoOfInKindPaidCoordinatorsHrs", DbType.Int32, int.Parse(RptData.NoOfInKindPaidCoordinatorsHrs));
                db.AddInParameter(dbCmd, "@NoOfStateShipPaidOtherStaff", DbType.Int32, int.Parse(RptData.NoOfStateShipPaidOtherStaff));
                db.AddInParameter(dbCmd, "@NoOfOtherShipPaidOtherStaff", DbType.Int32, int.Parse(RptData.NoOfOtherShipPaidOtherStaff));
                db.AddInParameter(dbCmd, "@NoOfStateInKindPaidOtherStaff", DbType.Int32, int.Parse(RptData.NoOfStateInKindPaidOtherStaff));

                db.AddInParameter(dbCmd, "@NoOfOtherInKindPaidOtherStaff", DbType.Int32, int.Parse(RptData.NoOfOtherInKindPaidOtherStaff));
                db.AddInParameter(dbCmd, "@NoOfStateVolunteerOtherStaffHrs", DbType.Int32, int.Parse(RptData.NoOfStateVolunteerOtherStaffHrs));
                db.AddInParameter(dbCmd, "@NoOfOtherVolunteerOtherStaffHrs", DbType.Int32, int.Parse(RptData.NoOfOtherVolunteerOtherStaffHrs));
                db.AddInParameter(dbCmd, "@NoOfStateShipPaidOtherStaffHrs", DbType.Int32, int.Parse(RptData.NoOfStateShipPaidOtherStaffHrs));
                db.AddInParameter(dbCmd, "@NoOfOtherShipPaidOtherStaffHrs", DbType.Int32, int.Parse(RptData.NoOfOtherShipPaidOtherStaffHrs));
                db.AddInParameter(dbCmd, "@NoOfStateInKindPaidOtherStaffHrs", DbType.Int32, int.Parse(RptData.NoOfStateInKindPaidOtherStaffHrs));
                db.AddInParameter(dbCmd, "@NoOfOtherInKindPaidOtherStaffHrs", DbType.Int32, int.Parse(RptData.NoOfOtherInKindPaidOtherStaffHrs));
                db.AddInParameter(dbCmd, "@NoOfInitialTrainings", DbType.Int32, int.Parse(RptData.NoOfInitialTrainings));
                db.AddInParameter(dbCmd, "@NoOfInitialTrainingsAttend", DbType.Int32, int.Parse(RptData.NoOfInitialTrainingsAttend));
                db.AddInParameter(dbCmd, "@NoOfInitTrainingsTotalHrs", DbType.Int32, int.Parse(RptData.NoOfInitTrainingsTotalHrs));
                db.AddInParameter(dbCmd, "@NoOfUpdateTrainings", DbType.Int32, int.Parse(RptData.NoOfUpdateTrainings));

                db.AddInParameter(dbCmd, "@NoOfUpdateTrainingsAttend", DbType.Int32, int.Parse(RptData.NoOfUpdateTrainingsAttend));
                db.AddInParameter(dbCmd, "@NoOfUpdateTrainingsTotalHrs", DbType.Int32, int.Parse(RptData.NoOfUpdateTrainingsTotalHrs));
                db.AddInParameter(dbCmd, "@NoOfYrsServiceLessThan1", DbType.Int32, int.Parse(RptData.NoOfYrsServiceLessThan1));
                db.AddInParameter(dbCmd, "@NoOfYrsService1To3", DbType.Int32, int.Parse(RptData.NoOfYrsService1To3));
                db.AddInParameter(dbCmd, "@NoOfYrsService3To5", DbType.Int32, int.Parse(RptData.NoOfYrsService3To5));
                db.AddInParameter(dbCmd, "@NoOfYrsServiceOver5", DbType.Int32, int.Parse(RptData.NoOfYrsServiceOver5));
                db.AddInParameter(dbCmd, "@NoOfYrsServiceNotCol", DbType.Int32, int.Parse(RptData.NoOfYrsServiceNotCol));
                db.AddInParameter(dbCmd, "@NoOfDisabled", DbType.Int32, int.Parse(RptData.NoOfDisabled));
                db.AddInParameter(dbCmd, "@NoOfNotDisabled", DbType.Int32, int.Parse(RptData.NoOfNotDisabled));
                db.AddInParameter(dbCmd, "@NoOfDisabledNotCollected", DbType.Int32, int.Parse(RptData.NoOfDisabledNotCollected));
                db.AddInParameter(dbCmd, "@NoOfEthnicityHispanic", DbType.Int32, int.Parse(RptData.NoOfEthnicityHispanic));
                db.AddInParameter(dbCmd, "@NoOfEthnicityWhite", DbType.Int32, int.Parse(RptData.NoOfEthnicityWhite));

                db.AddInParameter(dbCmd, "@NoOfEthnicityAfricanAmerican", DbType.Int32, int.Parse(RptData.NoOfEthnicityAfricanAmerican));
                db.AddInParameter(dbCmd, "@NoOfEthnicityAmericanIndian", DbType.Int32, int.Parse(RptData.NoOfEthnicityAmericanIndian));
                db.AddInParameter(dbCmd, "@NoOfEthnicityAsianIndian", DbType.Int32, int.Parse(RptData.NoOfEthnicityAsianIndian));
                db.AddInParameter(dbCmd, "@NoOfEthnicityChinese", DbType.Int32, int.Parse(RptData.NoOfEthnicityChinese));
                db.AddInParameter(dbCmd, "@NoOfEthnicityFilipino", DbType.Int32, int.Parse(RptData.NoOfEthnicityFilipino));
                db.AddInParameter(dbCmd, "@NoOfEthnicityJapanese", DbType.Int32, int.Parse(RptData.NoOfEthnicityJapanese));
                db.AddInParameter(dbCmd, "@NoOfEthnicityKorean", DbType.Int32, int.Parse(RptData.NoOfEthnicityKorean));
                db.AddInParameter(dbCmd, "@NoOfEthnicityVietnamese", DbType.Int32, int.Parse(RptData.NoOfEthnicityVietnamese));
                db.AddInParameter(dbCmd, "@NoOfEthnicityNativeHawaiian", DbType.Int32, int.Parse(RptData.NoOfEthnicityNativeHawaiian));
                db.AddInParameter(dbCmd, "@NoOfEthnicityGuamanian", DbType.Int32, int.Parse(RptData.NoOfEthnicityGuamanian));
                db.AddInParameter(dbCmd, "@NoOfEthnicitySamoan", DbType.Int32, int.Parse(RptData.NoOfEthnicitySamoan));

                db.AddInParameter(dbCmd, "@NoOfEthnicityOtherAsian", DbType.Int32, int.Parse(RptData.NoOfEthnicityOtherAsian));
                db.AddInParameter(dbCmd, "@NoOfEthnicityOthherPacificIslander", DbType.Int32, int.Parse(RptData.NoOfEthnicityOthherPacificIslander));
                db.AddInParameter(dbCmd, "@NoOfEthnicitySomeOtherRace", DbType.Int32, int.Parse(RptData.NoOfEthnicitySomeOtherRace));
                db.AddInParameter(dbCmd, "@NoOfEthnicityMoreThanOneRaceEthnicity", DbType.Int32, int.Parse(RptData.NoOfEthnicityMoreThanOneRaceEthnicity));
                db.AddInParameter(dbCmd, "@NoOfEthnicityNotCollected", DbType.Int32, int.Parse(RptData.NoOfEthnicityNotCollected));
                db.AddInParameter(dbCmd, "@NoOfAgeLessThan65", DbType.Int32, int.Parse(RptData.NoOfAgeLessThan65));
                db.AddInParameter(dbCmd, "@NoOfAgeOver65", DbType.Int32, int.Parse(RptData.NoOfAgeOver65));
                db.AddInParameter(dbCmd, "@NoOfAgeNotCollected", DbType.Int32, int.Parse(RptData.NoOfAgeNotCollected));
                db.AddInParameter(dbCmd, "@NoOfGenderFemale", DbType.Int32, int.Parse(RptData.NoOfGenderFemale));
                db.AddInParameter(dbCmd, "@NoOfGenderMale", DbType.Int32, int.Parse(RptData.NoOfGenderMale));
                db.AddInParameter(dbCmd, "@NoOfGenderNotCollected", DbType.Int32, int.Parse(RptData.NoOfGenderNotCollected));

                db.AddInParameter(dbCmd, "@NoOfSpeaksAnotherLanguageOtherThanEnglish", DbType.Int32, int.Parse(RptData.NoOfSpeaksAnotherLanguageOtherThanEnglish));
                db.AddInParameter(dbCmd, "@NoOfEnglishSpeakerOnly", DbType.Int32, int.Parse(RptData.NoOfEnglishSpeakerOnly));
                db.AddInParameter(dbCmd, "@NoOfSpeaksAnotherLanguageNotCollected", DbType.Int32, int.Parse(RptData.NoOfSpeaksAnotherLanguageNotCollected));
                db.AddInParameter(dbCmd, "@LastUpdatedBy", DbType.Int32, RptData.LastUpdatedBy.Value);

                db.AddInParameter(dbCmd, "@ResourceReportId", DbType.Int32, int.Parse(RptData.ResourceReportId));
                db.AddInParameter(dbCmd, "@NoOfStateVolunteerOtherStaff", DbType.Int32, int.Parse(RptData.NoOfStateVolunteerOtherStaff));
                db.AddInParameter(dbCmd, "@NoOfOtherVolunteerOtherStaff", DbType.Int32, int.Parse(RptData.NoOfOtherVolunteerOtherStaff));
                db.AddInParameter(dbCmd, "@Title", DbType.String, RptData.Title);
                db.AddOutParameter(dbCmd, "@NewReportId", DbType.Int32, 4);
                dbCmd.ExecuteNonQuery();

                if (dbCmd.Parameters["@ResourceReportId"].Value != null)
                {
                    outResourceReportId = int.Parse(db.GetParameterValue(dbCmd, "@NewReportId").ToString());
                    result = true;
                }
            }
            return(result);
        }
Esempio n. 5
0
        public ViewResourceReportViewData GetViewResourceReport(int ResourceReportId)
        {
            ViewResourceReportViewData vwData = new ViewResourceReportViewData();

            if (ResourceReportId == 0)
            {
                vwData.ReviewerID  = "0";
                vwData.SubmitterID = "0";
                vwData.NoOfStateVolunteerCounselors       = "0";
                vwData.NoOfOtherVolunteerCounselors       = "0";
                vwData.NoOfStateShipPaidCounselors        = "0";
                vwData.NoOfOtherShipPaidCounselors        = "0";
                vwData.NoOfStateInKindPaidCounselors      = "0";
                vwData.NoOfOtherInKindPaidCounselors      = "0";
                vwData.NoOfStateVolunteerCounselorsHrs    = "0";
                vwData.NoOfOtherVolunteerCounselorsHrs    = "0";
                vwData.NoOfStateShipPaidCounselorsHrs     = "0";
                vwData.NoOfOtherShipPaidCounselorsHrs     = "0";
                vwData.NoOfStateInKindPaidCounselorsHrs   = "0";
                vwData.NoOfOtherInKindPaidCounselorsHrs   = "0";
                vwData.NoOfUnpaidVolunteerCoordinators    = "0";
                vwData.NoOfSHIPPaidCoordinators           = "0";
                vwData.NoOfInKindPaidCoordinators         = "0";
                vwData.NoOfUnpaidVolunteerCoordinatorsHrs = "0";
                vwData.NoOfSHIPPaidCoordinatorsHrs        = "0";
                vwData.NoOfInKindPaidCoordinatorsHrs      = "0";
                vwData.NoOfStateOtherStaff             = "0";
                vwData.NoOfOtherOtherStaff             = "0";
                vwData.NoOfStateShipPaidOtherStaff     = "0";
                vwData.NoOfOtherShipPaidOtherStaff     = "0";
                vwData.NoOfStateInKindPaidOtherStaff   = "0";
                vwData.NoOfOtherInKindPaidOtherStaff   = "0";
                vwData.NoOfStateVolunteerOtherStaffHrs = "0";
                vwData.NoOfStateVolunteerOtherStaff    = "0";
                vwData.NoOfStateVolunteerOtherStaff    = "0";
                vwData.NoOfOtherVolunteerOtherStaffHrs = "0";
                vwData.NoOfOtherVolunteerOtherStaff    = "0";
                vwData.NoOfStateShipPaidOtherStaffHrs  = "0";
                //vwData.NoOfSHIPPaidOtherStaffHrs = "0";
                vwData.NoOfOtherShipPaidOtherStaffHrs   = "0";
                vwData.NoOfStateInKindPaidOtherStaffHrs = "0";
                vwData.NoOfOtherInKindPaidOtherStaffHrs = "0";
                vwData.NoOfInitialTrainings             = "0";
                vwData.NoOfInitialTrainingsAttend       = "0";
                vwData.NoOfInitTrainingsTotalHrs        = "0";
                vwData.NoOfUpdateTrainings         = "0";
                vwData.NoOfUpdateTrainingsAttend   = "0";
                vwData.NoOfUpdateTrainingsTotalHrs = "0";
                vwData.NoOfYrsServiceLessThan1     = "0";
                vwData.NoOfYrsService1To3          = "0";
                vwData.NoOfYrsService3To5          = "0";
                vwData.NoOfYrsServiceOver5         = "0";
                vwData.NoOfYrsServiceNotCol        = "0";
                vwData.NoOfDisabled                              = "0";
                vwData.NoOfNotDisabled                           = "0";
                vwData.NoOfEthnicityHispanic                     = "0";
                vwData.NoOfEthnicityWhite                        = "0";
                vwData.NoOfEthnicityAfricanAmerican              = "0";
                vwData.NoOfEthnicityAmericanIndian               = "0";
                vwData.NoOfEthnicityAsianIndian                  = "0";
                vwData.NoOfEthnicityChinese                      = "0";
                vwData.NoOfEthnicityFilipino                     = "0";
                vwData.NoOfEthnicityJapanese                     = "0";
                vwData.NoOfEthnicityKorean                       = "0";
                vwData.NoOfEthnicityVietnamese                   = "0";
                vwData.NoOfEthnicityNativeHawaiian               = "0";
                vwData.NoOfEthnicityGuamanian                    = "0";
                vwData.NoOfEthnicitySamoan                       = "0";
                vwData.NoOfEthnicityOtherAsian                   = "0";
                vwData.NoOfEthnicityOthherPacificIslander        = "0";
                vwData.NoOfEthnicitySomeOtherRace                = "0";
                vwData.NoOfEthnicityMoreThanOneRaceEthnicity     = "0";
                vwData.NoOfEthnicityNotCollected                 = "0";
                vwData.NoOfAgeLessThan65                         = "0";
                vwData.NoOfAgeOver65                             = "0";
                vwData.NoOfAgeNotCollected                       = "0";
                vwData.NoOfGenderFemale                          = "0";
                vwData.NoOfGenderMale                            = "0";
                vwData.NoOfGenderNotCollected                    = "0";
                vwData.NoOfSpeaksAnotherLanguageOtherThanEnglish = "0";
                vwData.NoOfEnglishSpeakerOnly                    = "0";
                vwData.NoOfSpeaksAnotherLanguageNotCollected     = "0";
                vwData.ResourceReportId                          = "0";
            }
            else
            {
                //Initialize Object and return it.
                ResourceReportBLL ReportLogic = new ResourceReportBLL();
                DataTable         ReportData  = ReportLogic.GetResourceReportByReportId(ResourceReportId);
                DataRow           rw          = ReportData.Rows[0];
                vwData.RepYrFrom     = rw["RepYrFrom"].ToString();
                vwData.RepYrTo       = rw["RepYrTo"].ToString();
                vwData.ReviewerID    = rw["ReviewerID"].ToString();
                vwData.SubmitterID   = rw["SubmitterID"].ToString();
                vwData.StateFIPSCode = rw["StateFIPSCode"].ToString();
                vwData.NoOfStateVolunteerCounselors       = rw["NoOfStateVolunteerCounselors"].ToString();;
                vwData.NoOfOtherVolunteerCounselors       = rw["NoOfOtherVolunteerCounselors"].ToString();;
                vwData.NoOfStateShipPaidCounselors        = rw["NoOfStateShipPaidCounselors"].ToString();;
                vwData.NoOfOtherShipPaidCounselors        = rw["NoOfOtherShipPaidCounselors"].ToString();;
                vwData.NoOfStateInKindPaidCounselors      = rw["NoOfStateInKindPaidCounselors"].ToString();;
                vwData.NoOfOtherInKindPaidCounselors      = rw["NoOfOtherInKindPaidCounselors"].ToString();;
                vwData.NoOfStateVolunteerCounselorsHrs    = rw["NoOfStateVolunteerCounselorsHrs"].ToString();;
                vwData.NoOfOtherVolunteerCounselorsHrs    = rw["NoOfOtherVolunteerCounselorsHrs"].ToString();;
                vwData.NoOfStateShipPaidCounselorsHrs     = rw["NoOfStateShipPaidCounselorsHrs"].ToString();;
                vwData.NoOfOtherShipPaidCounselorsHrs     = rw["NoOfOtherShipPaidCounselorsHrs"].ToString();;
                vwData.NoOfStateInKindPaidCounselorsHrs   = rw["NoOfStateInKindPaidCounselorsHrs"].ToString();;
                vwData.NoOfOtherInKindPaidCounselorsHrs   = rw["NoOfOtherInKindPaidCounselorsHrs"].ToString();;
                vwData.NoOfUnpaidVolunteerCoordinators    = rw["NoOfUnpaidVolunteerCoordinators"].ToString();;
                vwData.NoOfSHIPPaidCoordinators           = rw["NoOfSHIPPaidCoordinators"].ToString();;
                vwData.NoOfInKindPaidCoordinators         = rw["NoOfInKindPaidCoordinators"].ToString();;
                vwData.NoOfUnpaidVolunteerCoordinatorsHrs = rw["NoOfUnpaidVolunteerCoordinatorsHrs"].ToString();;
                vwData.NoOfSHIPPaidCoordinatorsHrs        = rw["NoOfSHIPPaidCoordinatorsHrs"].ToString();;
                vwData.NoOfInKindPaidCoordinatorsHrs      = rw["NoOfInKindPaidCoordinatorsHrs"].ToString();;
                vwData.NoOfStateShipPaidOtherStaff        = rw["NoOfStateShipPaidOtherStaff"].ToString();;
                vwData.NoOfOtherShipPaidOtherStaff        = rw["NoOfOtherShipPaidOtherStaff"].ToString();;
                vwData.NoOfStateInKindPaidOtherStaff      = rw["NoOfStateInKindPaidOtherStaff"].ToString();;
                vwData.NoOfOtherInKindPaidOtherStaff      = rw["NoOfOtherInKindPaidOtherStaff"].ToString();;

                vwData.NoOfStateVolunteerOtherStaffHrs = rw["NoOfStateVolunteerOtherStaffHrs"].ToString();;
                vwData.NoOfStateVolunteerOtherStaff    = rw["NoOfStateVolunteerOtherStaff"].ToString();;

                vwData.NoOfStateVolunteerOtherStaff     = rw["NoOfStateVolunteerOtherStaff"].ToString();;
                vwData.NoOfOtherVolunteerOtherStaffHrs  = rw["NoOfOtherVolunteerOtherStaffHrs"].ToString();;
                vwData.NoOfOtherVolunteerOtherStaff     = rw["NoOfOtherVolunteerOtherStaff"].ToString();;
                vwData.NoOfStateShipPaidOtherStaffHrs   = rw["NoOfStateShipPaidOtherStaffHrs"].ToString();;
                vwData.NoOfOtherShipPaidOtherStaffHrs   = rw["NoOfOtherShipPaidOtherStaffHrs"].ToString();;
                vwData.NoOfStateInKindPaidOtherStaffHrs = rw["NoOfStateInKindPaidOtherStaffHrs"].ToString();;
                vwData.NoOfOtherInKindPaidOtherStaffHrs = rw["NoOfOtherInKindPaidOtherStaffHrs"].ToString();;
                vwData.NoOfInitialTrainings             = rw["NoOfInitialTrainings"].ToString();;
                vwData.NoOfInitialTrainingsAttend       = rw["NoOfInitialTrainingsAttend"].ToString();;
                vwData.NoOfInitTrainingsTotalHrs        = rw["NoOfInitTrainingsTotalHrs"].ToString();;
                vwData.NoOfUpdateTrainings         = rw["NoOfUpdateTrainings"].ToString();;
                vwData.NoOfUpdateTrainingsAttend   = rw["NoOfUpdateTrainingsAttend"].ToString();;
                vwData.NoOfUpdateTrainingsTotalHrs = rw["NoOfUpdateTrainingsTotalHrs"].ToString();;
                vwData.NoOfYrsServiceLessThan1     = rw["NoOfYrsServiceLessThan1"].ToString();;
                vwData.NoOfYrsService1To3          = rw["NoOfYrsService1To3"].ToString();;
                vwData.NoOfYrsService3To5          = rw["NoOfYrsService3To5"].ToString();;
                vwData.NoOfYrsServiceOver5         = rw["NoOfYrsServiceOver5"].ToString();;
                vwData.NoOfYrsServiceNotCol        = rw["NoOfYrsServiceNotCol"].ToString();;
                vwData.NoOfDisabled                              = rw["NoOfDisabled"].ToString();;
                vwData.NoOfNotDisabled                           = rw["NoOfNotDisabled"].ToString();
                vwData.NoOfDisabledNotCollected                  = rw["NoOfDisabledNotCollected"].ToString();
                vwData.NoOfEthnicityHispanic                     = rw["NoOfEthnicityHispanic"].ToString();;
                vwData.NoOfEthnicityWhite                        = rw["NoOfEthnicityWhite"].ToString();;
                vwData.NoOfEthnicityAfricanAmerican              = rw["NoOfEthnicityAfricanAmerican"].ToString();;
                vwData.NoOfEthnicityAmericanIndian               = rw["NoOfEthnicityAmericanIndian"].ToString();;
                vwData.NoOfEthnicityAsianIndian                  = rw["NoOfEthnicityAsianIndian"].ToString();;
                vwData.NoOfEthnicityChinese                      = rw["NoOfEthnicityChinese"].ToString();;
                vwData.NoOfEthnicityFilipino                     = rw["NoOfEthnicityFilipino"].ToString();;
                vwData.NoOfEthnicityJapanese                     = rw["NoOfEthnicityJapanese"].ToString();;
                vwData.NoOfEthnicityKorean                       = rw["NoOfEthnicityKorean"].ToString();;
                vwData.NoOfEthnicityVietnamese                   = rw["NoOfEthnicityVietnamese"].ToString();;
                vwData.NoOfEthnicityNativeHawaiian               = rw["NoOfEthnicityNativeHawaiian"].ToString();;
                vwData.NoOfEthnicityGuamanian                    = rw["NoOfEthnicityGuamanian"].ToString();;
                vwData.NoOfEthnicitySamoan                       = rw["NoOfEthnicitySamoan"].ToString();;
                vwData.NoOfEthnicityOtherAsian                   = rw["NoOfEthnicityOtherAsian"].ToString();;
                vwData.NoOfEthnicityOthherPacificIslander        = rw["NoOfEthnicityOthherPacificIslander"].ToString();;
                vwData.NoOfEthnicitySomeOtherRace                = rw["NoOfEthnicitySomeOtherRace"].ToString();;
                vwData.NoOfEthnicityMoreThanOneRaceEthnicity     = rw["NoOfEthnicityMoreThanOneRaceEthnicity"].ToString();;
                vwData.NoOfEthnicityNotCollected                 = rw["NoOfEthnicityNotCollected"].ToString();;
                vwData.NoOfAgeLessThan65                         = rw["NoOfAgeLessThan65"].ToString();;
                vwData.NoOfAgeOver65                             = rw["NoOfAgeOver65"].ToString();;
                vwData.NoOfAgeNotCollected                       = rw["NoOfAgeNotCollected"].ToString();;
                vwData.NoOfGenderFemale                          = rw["NoOfGenderFemale"].ToString();;
                vwData.NoOfGenderMale                            = rw["NoOfGenderMale"].ToString();;
                vwData.NoOfGenderNotCollected                    = rw["NoOfGenderNotCollected"].ToString();;
                vwData.NoOfSpeaksAnotherLanguageOtherThanEnglish = rw["NoOfSpeaksAnotherLanguageOtherThanEnglish"].ToString();;
                vwData.NoOfEnglishSpeakerOnly                    = rw["NoOfEnglishSpeakerOnly"].ToString();;
                vwData.NoOfSpeaksAnotherLanguageNotCollected     = rw["NoOfSpeaksAnotherLanguageNotCollected"].ToString();;
                vwData.ResourceReportId                          = rw["ResourceReportId"].ToString();;
                vwData.Title            = rw["Title"].ToString();
                vwData.StateGranteeName = rw["StateGranteeName"].ToString();
            }
            return(vwData);
        }