public ActionResult editarUsuario(string id)
        {
            UsuarioOriginal usuaO = ListUsuarioOriginal().Where(x => x.ID_USU == id).FirstOrDefault();

            ViewBag.distrito = new SelectList(ListDistrito(), "ID_DIST", "NOM_DIS");
            return(View(usuaO));
        }
        public ActionResult editarUsuario(UsuarioOriginal objU)
        {
            List <SqlParameter> parametros = new List <SqlParameter>()
            {
                new SqlParameter()
                {
                    ParameterName = "@IDUSU", SqlDbType = SqlDbType.Char, Value = objU.ID_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@NOMB", SqlDbType = SqlDbType.VarChar, Value = objU.NOMBRES
                },
                new SqlParameter()
                {
                    ParameterName = "@APE", SqlDbType = SqlDbType.VarChar, Value = objU.APELLIDOS
                },
                new SqlParameter()
                {
                    ParameterName = "@DIREC", SqlDbType = SqlDbType.VarChar, Value = objU.DIRECCION
                },
                new SqlParameter()
                {
                    ParameterName = "@DNI", SqlDbType = SqlDbType.VarChar, Value = objU.DNI
                },
                new SqlParameter()
                {
                    ParameterName = "@USU", SqlDbType = SqlDbType.VarChar, Value = objU.NOMB_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@PASS", SqlDbType = SqlDbType.VarChar, Value = objU.PASS_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@CORRE", SqlDbType = SqlDbType.VarChar, Value = objU.CORREO_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@FECHANA", SqlDbType = SqlDbType.Date, Value = objU.FECHA_NACI
                },
                new SqlParameter()
                {
                    ParameterName = "@TELE", SqlDbType = SqlDbType.VarChar, Value = objU.TELEFONO
                },
                new SqlParameter()
                {
                    ParameterName = "@SEXO", SqlDbType = SqlDbType.VarChar, Value = objU.SEXO_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@IDDIS", SqlDbType = SqlDbType.Char, Value = objU.ID_DIST
                }
            };

            ViewBag.mensaje  = CRUD("SP_MANTENIMIENTOUSUARIO", parametros);
            ViewBag.distrito = new SelectList(ListDistrito(), "ID_DIST", "NOM_DIS");
            return(RedirectToAction("listadoUsuario"));
        }
        public ActionResult registrarUsuario(UsuarioOriginal obju)
        {
            List <SqlParameter> parametros = new List <SqlParameter>()
            {
                new SqlParameter()
                {
                    ParameterName = "@IDUSU", SqlDbType = SqlDbType.Char, Value = obju.ID_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@NOMB", SqlDbType = SqlDbType.VarChar, Value = obju.NOMBRES
                },
                new SqlParameter()
                {
                    ParameterName = "@APE", SqlDbType = SqlDbType.VarChar, Value = obju.APELLIDOS
                },
                new SqlParameter()
                {
                    ParameterName = "@DIREC", SqlDbType = SqlDbType.VarChar, Value = obju.DIRECCION
                },
                new SqlParameter()
                {
                    ParameterName = "@DNI", SqlDbType = SqlDbType.VarChar, Value = obju.DNI
                },
                new SqlParameter()
                {
                    ParameterName = "@USU", SqlDbType = SqlDbType.VarChar, Value = obju.NOMB_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@PASS", SqlDbType = SqlDbType.VarChar, Value = obju.PASS_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@CORRE", SqlDbType = SqlDbType.VarChar, Value = obju.CORREO_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@FECHANA", SqlDbType = SqlDbType.Date, Value = obju.FECHA_NACI
                },
                new SqlParameter()
                {
                    ParameterName = "@TELE", SqlDbType = SqlDbType.VarChar, Value = obju.TELEFONO
                },
                new SqlParameter()
                {
                    ParameterName = "@SEXO", SqlDbType = SqlDbType.VarChar, Value = obju.SEXO_USU
                },
                new SqlParameter()
                {
                    ParameterName = "@IDDIS", SqlDbType = SqlDbType.Char, Value = obju.ID_DIST
                }
            };

            ViewBag.mensaje = CRUD("SP_MANTENIMIENTOUSUARIO", parametros);
            return(RedirectToAction("Index"));
        }