/// <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); }
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); }
/// <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); }