protected void dataSourceViewResourceReport_Inserted(object sender, ObjectContainerDataSourceStatusEventArgs e)
{
ViewResourceReportViewData RptData = (ViewResourceReportViewData)e.Instance;
RptData.SubmitterID = AccountInfo.UserId.ToString();
_NewReportId = Logic.AddReport(RptData);
}
/// <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);
}
}
/// <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));
}
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);
}
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);
}