public void DeleteFundingSource(FundingSource model, int projectVersionId)
 {
     using (SqlCommand command = new SqlCommand("[dbo].[DeleteProjectFundingSource]") { CommandType = CommandType.StoredProcedure })
     {
         command.Parameters.AddWithValue("@ProjectVersionID", projectVersionId);
         command.Parameters.AddWithValue("@FundingResourceId", model.Id);
         this.ExecuteNonQuery(command);
     }
 }
 public JsonResult DeleteFundingSource(int fundingResourceId, int projectVersionId)
 {
     var fundingSource = new FundingSource() { Id = fundingResourceId };
     try
     {
         _surveyRepository.DeleteFundingSource(fundingSource, projectVersionId);
     }
     catch (Exception ex)
     {
         return Json(new { error = "Changes could not be stored. An error has been logged." });
     }
     return Json(new { message = "Funding Source successfully removed." });
 }
        public IList<FundingSource> GetProjectFundingSources(int projectVersionId)
        {
            var fundingSources = new List<FundingSource>();

            // Get Agencies which are eligible to sponsor projects
            SqlCommand cmd = new SqlCommand("[Survey].[GetProjectFundingSources]");
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ProjectVersionID", projectVersionId);

            using (IDataReader rdr = this.ExecuteReader(cmd))
            {
                while (rdr.Read())
                {
                    var temp = new FundingSource()
                    {
                        Id = rdr["FundingResourceID"].ToString().SmartParseDefault<int>(default(int))
                        ,
                        Name = rdr["FundingType"].ToString()
                    };
                    if (temp.Id != default(int)) fundingSources.Add(temp);
                }
            }

            return fundingSources;
        }