public void Add(Stakeholdersend item)
{
using (IDbConnection dbConnection = new SqlConnection(ConnectionString))
{
string sQuery = "INSERT INTO plan_interested_user (id_plan, id_user) VALUES(@Plans, @Users)";
dbConnection.Open();
dbConnection.Execute(sQuery, item);
}
}
public void Update(Stakeholdersend item)
{
using (IDbConnection dbConnection = new SqlConnection(ConnectionString))
{
string sQuery = "UPDATE plan_interested_user SET id_plan = @Plans, id_user = @Users"
+ " WHERE id = @Id";
dbConnection.Open();
dbConnection.Query(sQuery, item);
}
}
public ActionResult Create([Bind("Plans,Users")] Stakeholdersend stake)
{
if (ModelState.IsValid)
{
stakeholderRepository.Add(stake);
return(RedirectToAction("Index"));
}
return(NoContent());
}
public ActionResult Edit([Bind("Id,Plans,Users")] Stakeholdersend stake)
{
var model = stakeholderRepository.FindByID(stake.Id);
if (model == null)
{
return(StatusCode(StatusCodes.Status404NotFound));
}
stakeholderRepository.Update(stake);
return(NoContent());
}
