public ActionResult DeleteConfirmed(decimal id)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "DELETE_POLL(:id, :result)", new OracleParameter("id", id), resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind("Id", "TerritoryName")] Terrtitory terrtitory)
{
if (ModelState.IsValid)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "UPDATE_TERRITORY(:id, :name, :result)", new OracleParameter("id", terrtitory.Id), new OracleParameter("name", terrtitory.TerritoryName), resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
return(View(terrtitory));
}
public ActionResult Edit([Bind("Id", "PollDate", "IdRespondent")] Poll poll)
{
if (ModelState.IsValid)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "UPDATE_POLL(:id, :id_respondent, :poll_date, :result)",
new OracleParameter("id", poll.Id),
new OracleParameter("id_respondent", poll.IdRespondent),
new OracleParameter("poll_date", OracleDbType.Date, poll.PollDate, System.Data.ParameterDirection.Input),
resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
ViewBag.IdRespondent = new SelectList(db.Respondents, "Id", "Surname", poll.IdRespondent);
return(View(poll));
}
public ActionResult Edit([Bind("Id", "Text", "IdPolitician")] Orders orders)
{
if (ModelState.IsValid)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "UPDATE_ORDERS(:id, :text, :id_politician, :result)",
new OracleParameter("id", orders.Id),
new OracleParameter("text", orders.Text),
new OracleParameter("id_politician", orders.IdPolitician),
resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
ViewBag.IdPolitician = new SelectList(db.Politicians, "Id", "Surname", orders.IdPolitician);
return(View(orders));
}
public ActionResult Edit([Bind("Id", "Name", "Surname", "Patro", "BirthDate")] Respondents respondents)
{
if (ModelState.IsValid)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "UPDATE_RESPONDENTS(:id, :name, :surname, :patro, :birthdate, :result)",
new OracleParameter("id", respondents.Id),
new OracleParameter("name", respondents.Name),
new OracleParameter("surname", respondents.Surname),
new OracleParameter("patro", respondents.Patro),
new OracleParameter("birthdate", OracleDbType.Date, respondents.BirthDate, System.Data.ParameterDirection.Input),
resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
return(View(respondents));
}
public ActionResult Edit([Bind("IdPoll", "IdPolitician", "Rating")] PoliticianSets politician_sets)
{
if (ModelState.IsValid)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "UPDATE_POLITICIAN_SETS(:id_poll, :id_politician, :rating, :result)",
new OracleParameter("id_poll", politician_sets.IdPoll),
new OracleParameter("id_politician", politician_sets.IdPolitician),
new OracleParameter("rating", politician_sets.Rating),
resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
ViewBag.IdPolitician = new SelectList(db.Politicians, "Id", "Surname", politician_sets.IdPolitician);
ViewBag.IdPoll = new SelectList(db.Poll, "Id", "Id", politician_sets.IdPoll);
return(View(politician_sets));
}
public ActionResult Edit([Bind("Id", "Name", "Surname", "Patro", "IdTerritory")] Politicians politicians)
{
if (ModelState.IsValid)
{
var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output);
SqlUtility.ExecuteStoredProcedure(db, "UPDATE_POLITICIANS(:id, :name, :surname, :patro, :id_territory, :result)",
new OracleParameter("id", politicians.Id),
new OracleParameter("name", politicians.Name),
new OracleParameter("surname", politicians.Surname),
new OracleParameter("patro", politicians.Patro),
new OracleParameter("id_territory", politicians.IdTerritory),
resParam);
var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value;
if (result < 0)
{
return(BadRequest());
}
return(RedirectToAction("Index"));
}
ViewBag.IdTerritory = new SelectList(db.Terrtitory, "Id", "TerritoryName", politicians.IdTerritory);
return(View(politicians));
}
protected ICollection <T> ExecuteStoredProcedure(SqlCommand command)
{
command.Connection = _connection;
return(SqlUtility.ExecuteStoredProcedure <T>(command));
}
