I'm a novice with MVC 4 My question is; How can I send all the information that the user captured in HTML to a function of my controller ?. That this function inserts my data sql server with Ajax.BeginForm there are not many examples since most use Razor
Code C # Controller
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Configuration;
using System.Data.SqlClient;
using RequerimientosABCusuarios.Models;
namespace RequerimientosABCusuarios.Controllers
{
public class RequerimientoController : Controller
{
public ActionResult Registros()
{
return View("Home");
}
[HttpPost]
public ActionResult Registro()
{
//PropiedadesUsu UsuRe = new PropiedadesUsu();
var constring = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
var Conn = new SqlConnection(constring);
try
{
Conn.Open();
string sqlconsult = "insert into Registros values('" + Request["solicitud"] + "', '" + Request["nombre"] + "','" + Request["apellido"] + "'," + Request["numero"] + ",'" + Request["fecha"] + "','" + Request["departamento"] + "','" + Request["puesto"] + "','" + Request["hotel"] + "'," +1+ ")";
var command = new SqlCommand(sqlconsult, Conn);
command.ExecuteNonQuery();
Conn.Close();
return RedirectToAction("Home", "Home");
}catch(Exception e)
{
}
}
}
}<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<RequerimientosABCusuarios.Models.PropiedadesUsu>" %>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
<meta name="viewport" content="width=device-width">
<title>REQUERIMIENTO DE ALTA-CAMBIOS-BAJA DE USUARIOS</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
<script src="../../Script/Validaciones.js"></script>
<link href="../../Content/Home.css" rel="stylesheet" />
<script src="../../Script/DatosSelect.js"></script>
</head>
<body>
<% using (Ajax.BeginForm( "Registro", "Requerimiento", new AjaxOptions { })) {%>
<div class="titulo">
<h1>Requerimiento De Alta-Cambio-Baja De Usuarios</h1>
<div class="Personal">
<div class="Datos">
<label for="solicitud">Solicitud</label>
<select name="solicitud">
<option>Alta</option>
<option>Cambio</option>
<option>Baja</option>
</select>
<label for="nombre">Nombre(s)</label>
<input type="text" id="nombre" name="nombre">
<label for="numero">Numero De Colaborador</label>
<input type="text" id="numero" name="numero">
<label for="departamento">Departamento</label>
<input type="text" id="departamento" name="departamento">
</div>
<div class="Datos2">
<label for="apellido">Apellidos(s)</label>
<input type="text" name="apellido">
<label for="fecha">Fecha De Solicitud</label>
<input type="date" name="fecha">
<label for="puesto">Puesto</label>
<input type="text" name="puesto">
</div>
<div class="hoteles"><span></span>
<label>Hotel - Empresa</label>
<br />
<label for="GC"><span>GC</span>
</label>
<input type="checkbox" name="hotel" id="GC">
<label for="GP"><span>GP</span>
</label>
<input type="checkbox" name="hotel" id="GP">
<label for="TRP"><span>TRP</span>
</label>
<input type="checkbox" name="hotel" id="TRP">
<label for="HZLC"><span>HZLC</span>
</label>
<input type="checkbox" name="hotel" id="HZLC">
<label for="HZVC"><span>HZCV</span>
</label>
<input type="checkbox" name="hotel" id="HZVC">
<label for="corporativo"><span>Corporativo</span>
</label>
<input type="checkbox" name="hotel" id="corporativo">
</div>
</div>
</div>
<div class="Subtitulo">
<h1>Accesos-Aplicaciones-Roles</h1>
<input type="button" onclick="pasar_parametro('NomSistemas','RecSistemas')" value=">" />
<input type="button" onclick="pasar_parametro('RecSistemas', 'NomSistemas')" value="<" />
</div>
<div class="button">
<input type="submit" class="BtnGuardar" id="BtnGuardar" name="BtnGuardar" />
</div>
<% } %>
</body>
</html>