// GET: Conductor

        public ActionResult Index()
        {
            ConductorRepository cr = new ConductorRepository();

            List <Conductor> conductor = cr.getConductoresAll();

            ViewBag.resultadoParaLaVista = conductor;

            return(View());
        }
        public ActionResult FormularioUpdate()
        {
            int id = Convert.ToInt32(Request["id"].ToString());

            ConductorRepository cr = new ConductorRepository();

            Conductor x = cr.getConductorById(id);

            ViewBag.conductor = x;

            return(View());
        }
        public void Insertar()
        {
            Conductor x = new Conductor();

            x.Nombre   = Request["Nombre"].ToString();
            x.Cedula   = Request["Cedula"].ToString();
            x.Telefono = Request["Telefono"].ToString();

            ConductorRepository cr = new ConductorRepository();

            int filasAfectadas = cr.insertConductor(x);

            Response.Redirect("/Conductor/Index");
        }
        public void Actualizar()
        {
            Conductor x = new Conductor();

            x.IdConductor = Convert.ToInt32(Request["IdConductor"].ToString());
            x.Nombre      = Request["Nombre"].ToString();
            x.Cedula      = Request["Cedula"].ToString();
            x.Telefono    = Request["Telefono"].ToString();

            ConductorRepository cr = new ConductorRepository();

            cr.updateConductor(x);


            Response.Redirect("/Conductor/Index");
        }
 public ConductorService()
 {
     conexion            = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=CoomulsoftApp;Integrated Security=True");
     ConductorRepository = new ConductorRepository(conexion);
 }