public structCamperGrantInfo GetCamperGrantInfo(string FJCID) { structCamperGrantInfo CamperGrantInfo = new structCamperGrantInfo(); DataSet dsCamperGrant; DataRow drCamperGrant; CamperApplication oCA = new CamperApplication(); dsCamperGrant = oCA.getCamperGrantInfo(FJCID); if (dsCamperGrant.Tables[0].Rows.Count > 0) { drCamperGrant = dsCamperGrant.Tables[0].Rows[0]; if (!Convert.IsDBNull(drCamperGrant["FJCID"])) { CamperGrantInfo.FJCID = Convert.ToInt64(drCamperGrant["FJCID"]); } if (!Convert.IsDBNull(drCamperGrant["FederationID"])) { CamperGrantInfo.FederationID = Convert.ToInt32(drCamperGrant["FederationID"]); } if (!Convert.IsDBNull(drCamperGrant["CampID"])) { CamperGrantInfo.CampID = Convert.ToInt32(drCamperGrant["CampID"]); } if (!Convert.IsDBNull(drCamperGrant["TimeInCamp"])) { CamperGrantInfo.TimeInCamp = Convert.ToInt32(drCamperGrant["TimeInCamp"]); } if (!Convert.IsDBNull(drCamperGrant["CampYearID"])) { CamperGrantInfo.CampYearID = Convert.ToInt32(drCamperGrant["CampYearID"]); } if (!Convert.IsDBNull(drCamperGrant["DaysInCamp"])) { CamperGrantInfo.DaysInCamp = Convert.ToInt32(drCamperGrant["DaysInCamp"]); } if (!Convert.IsDBNull(drCamperGrant["OverProjection"])) { CamperGrantInfo.OverProjection = Convert.ToBoolean(drCamperGrant["OverProjection"]); } if (!Convert.IsDBNull(drCamperGrant["GrantAmount"])) { CamperGrantInfo.GrantAmount = Convert.ToDecimal(drCamperGrant["GrantAmount"]); } if (!Convert.IsDBNull(drCamperGrant["StandardGrant"])) { CamperGrantInfo.StandardGrant = Convert.ToDecimal(drCamperGrant["StandardGrant"]); } if (!Convert.IsDBNull(drCamperGrant["FJCMatch"])) { CamperGrantInfo.FJCMatch = Convert.ToDecimal(drCamperGrant["FJCMatch"]); } } return(CamperGrantInfo); }