Example #1
0
        /// <summary>
        ///
        /// Created By: Trent Cullinan 04/14/16
        /// </summary>
        /// <param name="needContribution"></param>
        /// <returns></returns>
        public int SendContribution(NeedContribution needContribution)
        {
            int rowsAffected = 0;

            var conn = DBConnection.GetDBConnection();

            var cmd = new SqlCommand("Needs.spInsertContributions", conn);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@NeedID",
                                        needContribution.Need.GardenNeedId);
            cmd.Parameters.AddWithValue("@Description",
                                        needContribution.Description);
            cmd.Parameters.AddWithValue("@UserID",
                                        this.userId);

            try
            {
                conn.Open();

                rowsAffected = cmd.ExecuteNonQuery();
            }
            catch (SqlException)
            {
                throw;
            }
            finally
            {
                conn.Close();
            }

            return(rowsAffected);
        }
Example #2
0
        public ActionResult SendContribution(SendContributionViewModel model)
        {
            ActionResult view = View(model);

            if (ModelState.IsValid)
            {
                int userID = RetrieveUserId();

                NeedContribution contribution = new NeedContribution()
                {
                    Need = new GardenNeed()
                    {
                        GardenNeedId
                            = model.NeedID
                    },
                    Description
                           = model.Description,
                    SentBy = new User()
                    {
                        UserID
                            = userID
                    }
                };

                if (new UserNeedsManager(userID).SendContribution(contribution))
                {
                    view = RedirectToAction("ViewContributions", "Donation");
                }
            }

            return(view);
        }
Example #3
0
        /// <summary>
        ///
        /// Created By: Trent Cullinan 04/14/16
        /// </summary>
        /// <param name="needContribution"></param>
        /// <returns></returns>
        public bool SendContribution(NeedContribution needContribution)
        {
            bool flag = false;

            try
            {
                flag = 1 == Accessor.SendContribution(needContribution);
            }
            catch (Exception) { }

            return(flag);
        }