public ActionResult AddNeed(CreateNeedViewModel model)
{
ActionResult viewResult = View(model);
if (ModelState.IsValid)
{
int userId = RetrieveUserId();
GardenNeedsManager needsManager = new GardenNeedsManager(userId, model.GardenId);
GardenNeed need = new GardenNeed()
{
Title
= model.Title,
Description
= model.Description,
};
if (needsManager.AddNeed(need))
{
viewResult = RedirectToAction("GardenDetail", new { id = model.GardenId });
}
else
{
viewResult = View("Error"); // CHANGE
}
}
return(viewResult);
}
/// <summary>
///
/// Created By: Trent Cullinan 04/14/16
/// </summary>
/// <param name="need"></param>
/// <returns></returns>
public bool EditNeed(GardenNeed need)
{
bool flag = false;
try
{
flag = 1 == Accessor.EditNeed(need);
}
catch (Exception) { }
return(flag);
}
/// <summary>
///
/// Created By: Trent Cullinan 04/28/16
/// </summary>
/// <param name="needID"></param>
/// <returns></returns>
public static GardenNeed RetrieveNeed(int needID)
{
GardenNeed need = null;
try
{
need = GardenNeedsAccessor.RetrieveGardenNeed(needID);
}
catch (Exception) { }
return(need);
}
public static GardenNeed RetrieveGardenNeed(int needID)
{
GardenNeed need = null;
var conn = DBConnection.GetDBConnection();
var cmd = new SqlCommand("Needs.spSelectNeed", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NeedID",
needID);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.Read())
{
need = new GardenNeed()
{
GardenNeedId
= needID,
Title
= reader.GetString(1),
Description
= reader.GetString(2),
DateCreated
= reader.GetDateTime(6),
CreatedBy = new User()
{
UserID
= reader.GetInt32(7)
}
};
}
}
catch (SqlException)
{
throw;
}
finally
{
conn.Close();
}
return(need);
}
public ActionResult SendContribution(int?id)
{
ActionResult view = View("Error");
if (id.HasValue)
{
SendContributionViewModel model = new SendContributionViewModel();
GardenNeed need = UserNeedsManager.RetrieveNeed(id.Value);
model.NeedTitle
= need.Title;
model.NeedID
= need.GardenNeedId;
view = View(model);
}
return(view);
}
/// <summary>
///
/// Created By: Trent Cullinan 04/14/16
/// </summary>
/// <param name="need"></param>
/// <returns></returns>
public int EditNeed(GardenNeed need, bool completed = false)
{
int rowsAffected = 0;
var conn = DBConnection.GetDBConnection();
var cmd = new SqlCommand("Needs.spUpdateNeed", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NeedID",
need.GardenNeedId);
cmd.Parameters.AddWithValue("@UserID",
this.userId);
cmd.Parameters.AddWithValue("@Title",
need.Title);
cmd.Parameters.AddWithValue("@Description",
need.Description);
cmd.Parameters.AddWithValue("@Completed",
completed);
try
{
conn.Open();
rowsAffected = cmd.ExecuteNonQuery();
}
catch (SqlException)
{
throw;
}
finally
{
conn.Close();
}
return(rowsAffected);
}
/// <summary>
///
/// Created By: Trent Cullinan 04/14/16
/// </summary>
/// <param name="need"></param>
/// <returns></returns>
public bool AddNeed(GardenNeed need)
{
bool flag = false;
need.CreatedBy = new User()
{
UserID = this.userId
};
need.Garden = new Garden()
{
GardenID = this.gardenId
};
need.DateCreated = DateTime.Now;
try
{
flag = 1 == Accessor.AddNeed(need);
}
catch (Exception) { }
return(flag);
}
