ByGroxD's questions

Hello fellow StackOverFlow,

I come across the following question:

How can I add all of them inputwith name VN_TOTAL[] when the input with name VN_GRABIVA[] of the same row of the table is empty or equal to zero.

Said total I need to save in the inputwith ID siniva .

In the same way, I need to add all of them inputwith name VN_TOTAL[] when the input with name VN_GRABIVA[] of the same row of the table has a value greater than zero.

I need this sum in the input with ID coniva .

In the following image I show the result that I am looking for as an example:

https://i.ibb.co/CsbfqZ1/zrmrf.jpg

$(document).ready(function() {
    var tr = 2;
    $('#addrowdte').on("click", function() {
        $(".details-dte").append('<tr id="'+tr+'"> <td><button onclick="remove_tr('+tr+')" class="btn btn-default btn-sm"><i class="fas fa-trash"></i></button> </td> <td> <input onkeyup="subtotal('+tr+');" type="text" class="input-sm separ-miles cantidad'+tr+'" name="VN_CANTIDA[]" value=""> </td> <td> <div class="input-group"> <input style="min-width: 100px;" type="text" class="form-control input-sm" required="required" id="ADD_CODIGO'+tr+'" name="VN_CODPRO[]" value=""> <a data-toggle="modal" data-target="#modal-search-product" onclick="getrowid('+tr+');" class="input-group-addon input-sm"><i class="fas fa-search"></i></a> </div> </td> <td> <input id="ADD_DETALLE'+tr+'" type="text" class="input-sm" name="VN_DETALLE[]" value=""> </td> <td> <input id="ADD_VALUNI'+tr+'" type="text" class="input-sm separ-miles precio'+tr+'" name="VN_VALUNI[]" value=""> </td> <td> <input type="text" class="input-sm separ-miles subtotal'+tr+'" name="VN_PARCIAL[]" value=""> </td> <td> <input onkeyup="get_total('+tr+');" type="text" class="input-sm separ-miles descuento'+tr+'" name="VN_TASADES[]" placeholder="00,00"> </td> <td> <input id="ADD_VALIVA'+tr+'" type="text" class="input-sm separ-miles iva'+tr+'" name="VN_GRABIVA[]" value=""> </td> <td> <input type="text" class="input-sm separ-miles total'+tr+'" name="VN_TOTAL[]" value=""> </td> </tr>');
        tr++;
    });
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.10.2/css/all.min.css" rel="stylesheet"/>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css" rel="stylesheet"/>
<table class="table table-condensed table-bordered table-hover table-striped">
    <thead class="bg-info text-white">
        <tr>
            <td class="text-center"><a id="addrowdte" class="btn btn-warning btn-xs"><i class="fas fa-plus"></i></a>
            </td>
            <th>CANTIDAD</th>
            <th>CODIGO</th>
            <th>NOMBRE</th>
            <th>PRECIO</th>
            <th>SUB TOTAL</th>
            <th>DCTO %</th>
            <th>IVA %</th>
            <th>TOTAL</th>
        </tr>
    </thead>
    <tbody class="details-dte">
        <tr id="1">
            <td>
                <button onclick="remove_tr(1)" class="btn btn-default btn-sm"><i class="fas fa-trash"></i>
                </button>
            </td>
            <td>
                <input onkeyup="subtotal(1);" type="text" class="input-sm separ-miles cantidad1" name="VN_CANTIDA[]" value="">
            </td>
            <td>
                <div class="input-group">
                    <input style="min-width: 100px;" type="text" class="form-control input-sm" required="required" id="ADD_CODIGO1" name="VN_CODPRO[]" value="">
                    <a data-toggle="modal" data-target="#modal-search-product" onclick="getrowid(1);" class="input-group-addon input-sm"><i class="fas fa-search"></i></a>
                </div>
            </td>
            <td>
                <input id="ADD_DETALLE1" type="text" class="input-sm" name="VN_DETALLE[]" value="">
            </td>
            <td>
                <input id="ADD_VALUNI1" type="text" class="input-sm separ-miles precio1" name="VN_VALUNI[]" value="">
            </td>
            <td>
                <input type="text" class="input-sm separ-miles subtotal1" name="VN_PARCIAL[]" value="">
            </td>
            <td>
                <input onkeyup="get_total(1);" type="text" class="input-sm separ-miles descuento1" name="VN_TASADES[]" placeholder="00,00">
            </td>
            <td>
                <input id="ADD_VALIVA1" type="text" class="input-sm separ-miles iva1" name="VN_GRABIVA[]" value="">
            </td>
            <td>
                <input type="text" class="input-sm separ-miles total1" name="VN_TOTAL[]" value="">
            </td>
        </tr>
    </tbody>
</table>
<script>
    function remove_tr(id) {
        event.preventDefault();
        if (id != 1) {
            $('#' + id).remove();
        }
    }

    function subtotal(idrow) {
        var rowid = idrow;
        var cantidad, precio, total, iva;
        if ($('.cantidad' + rowid).val().length > 0) {
            cantidad = parseFloat($('.cantidad' + rowid).val());
        } else {
            cantidad = 0;
        }
        if ($('.precio' + rowid).val().length > 0) {
            precio = parseFloat($('.precio' + rowid).val());
        } else {
            precio = 0;
        }
        total = (precio * cantidad);
        $('.subtotal' + rowid).val(total);

        if ($('.iva' + rowid).val().length > 0) {
            iva = parseFloat($('.iva' + rowid).val());
            iva = (total * iva / 100);
            total = (total + iva);
        }

        $('.total' + rowid).val(total);
    };

    function get_total(idrow) {
        var rowid = idrow;
        var subtotal, descuento, total, iva;
        subtotal = parseFloat($('.subtotal' + rowid).val());
        if ($('.descuento' + rowid).val().length <= 0) {
            descuento = 0;
        } else {
            descuento = parseFloat($('.descuento' + rowid).val());
        }
        total = (subtotal * descuento / 100);
        total = (subtotal - total);
        if ($('.iva' + rowid).val().length > 0) {
            iva = parseFloat($('.iva' + rowid).val());
            iva = (total * iva / 100);
            total = (total + iva);
        }
        $('.total' + rowid).val(total);

    }
</script><br>
<span>Total sin iva:</span>
<input type="text" id="siniva" value="">
<br><br>
<span>Total con iva:</span>
<input type="text" id="coniva" value="">

Any questions or news I will be very aware.

Companions of StackOverFlow, I have the following doubt, I am trying to make a simple test or evaluation system in php and I created my database in the following way:

+----------------+
| Tables_in_game |
+----------------+
| answers        |
| questions      |
+----------------+

Questions table

+----------+------------+------+-----+---------+----------------+
| Field    | Type       | Null | Key | Default | Extra          |
+----------+------------+------+-----+---------+----------------+
| id       | int(11)    | NO   | PRI | NULL    | auto_increment |
| question | text       | NO   |     | NULL    |                |
| type     | varchar(5) | NO   |     | NULL    |                |
+----------+------------+------+-----+---------+----------------+

Answer table (Answers)

+-------------+------------+------+-----+---------+----------------+
| Field       | Type       | Null | Key | Default | Extra          |
+-------------+------------+------+-----+---------+----------------+
| id          | int(11)    | NO   | PRI | NULL    | auto_increment |
| id_question | int(11)    | NO   |     | NULL    |                |
| answer      | text       | NO   |     | NULL    |                |
| is_right    | tinyint(1) | NO   |     | NULL    |                |
+-------------+------------+------+-----+---------+----------------+

My PHP PDO query is as follows:

$db = new PDO('mysql:host=localhost;dbname=game', 'root', '');
    $stmt = $db->prepare('SELECT * FROM questions LEFT JOIN answers ON (questions.id = answers.id_question) WHERE questions.type = :type');
    $type = "quiz3";
    $stmt->bindParam(':type', $type);
    $stmt->execute();

The problem is that when going through it, it prints the question several times according to the answers that the question has:

<div class="container">
        <?php foreach ($stmt as $val): ?>
        <p>
            <?= $val['question']; ?>
        </p>
        <ul>
            <li>
                <?= $val['answer']; ?>
            </li>
        </ul>
        <?php endforeach ?>
    </div>

What I need is to be able to print the question only once and to be able to print all the possible answers.

As an example I show how it should look:

This is question #1............

1. Answer 1
2. Answer #2
3. Answer #3
4. Answer #4

I have a problem sending the value of the inputin status checkedto my controller, unfortunately it only sends me the values ​​of the page I am on at that moment and not that of all the pages where I have selected a checkbox, which I mean by paginas is because I am using pagination from datatables.

My code is the following:

<div class="container">
        <h2>Ventas</h2>
        <form action="venta.php" method="POST">
            <table id="inventario" class="table table-hover table-bordered table-condensed">
                <thead>
                    <tr>
                        <th><i class="fa fa-check"></i>&nbsp;Selección articulo</th>
                        <th><i class="fa fa-list-ol"></i>&nbsp;Cantidad</th>
                        <th><i class="fa fa-building"></i>&nbsp;Marca</th>
                        <th><i class="fa fa-list"></i>&nbsp;Categoria</th>
                        <th><i class="fa fa-usd"></i>&nbsp;Precio</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($articulos as $articulo): ?>
                    <tr>
                        <td><label class="checkbox-inline"><input name="articulos[]" type="checkbox" value="<?php echo $articulo['id']; ?>"><?php echo $articulo['nombre']; ?></label></td>
                        <td><?php echo $articulo['cantidad']; ?></td>
                        <td><?php echo $articulo['categoria']; ?></td>
                        <td><?php echo $articulo['marca']; ?></td>
                        <td><?php echo number_format($articulo['precio_u']); ?></td>
                    </tr>
                    <?php endforeach ?>
                </tbody>
            </table>
            <input type="submit" class="btn btn-warning" name="vender" value="Vender">
        </form>
    </div>
    <script type="text/javascript">
        $(document).ready(function() {
            $('#inventario').DataTable();
                var dataArr = [];
                 $('tr').filter(':has(:checkbox:checked)').each(function() {      
                      dataArr.push($(this).find('input').eq(0).val());
                        console.log(dataArr);
                 });
        } );
    </script>

As some of you could see, I tried to make a script to collect all the values ​​and be able to send them to my controller, however I can't do it, I'm not very good with JS.

I found that someone made this snippet for this problem, however I don't know how to complement it.

var rows = $(('#datatable')
   .rows({ 'search': 'applied' })
   .nodes()).filter(':has(:checkbox:checked)');//busca todos los registros del datatable

rows.each(function(index,elem){
   //cada row es un tr
     console.log($('datatable').row(elem).data());
});

If it is necessary to use ajax to send all the values ​​of the selected checkboxes, I have no problem.

I have a problem when trying to make a conditional with a string, what I try is first to ask the city and depending on what the user writes, I make the conditional that I have in the code, but it doesn't work for me, it takes me directly toelse

#include "stdio.h"

int main (){
    char ciudad[0];

    printf("Digite el nombre de una ciudad: ");
    scanf("%s",&ciudad);

if (ciudad == "medellin"){
    printf("En este momento en %s esta lloviendo",ciudad);
}else if (ciudad == "bucaramanga"){
    printf("En este momento en %s esta haiendo un dia caluroso",ciudad);
}else{
    printf("%s no esta en nuestra base de datos",ciudad);
}

    return 0;
}

How could I get the following style in my navbar in bootstrap 3, referencing the cloud style? The layout I want to get is the following:

I've tried with IMG as a border but I can't do it.

.navbar-principal .img-logo {
  width: 28px;
  height: 28px;
  display: inline-block;
}

.navbar-principal .navbar-brand,
.navbar-principal .navbar-brand li a:visited,
.navbar-principal .navbar-nav li a {
  color: #fff;
  font-weight: 500;
}

.navbar-cover .navbar-nav li a {
  color: #66757f;
  font-weight: 500;
}

.navbar-principal .navbar-nav .open a,
.navbar-principal .navbar-nav .open a:hover,
.navbar-principal .navbar-nav li a:hover, 
.navbar-principal .navbar-nav li a:focus, 
.navbar-principal .navbar-nav .active a, 
.navbar-principal .navbar-nav .active a:hover {
  color: #fff;
  background: rgba(0, 0, 0, .2);
}

.navbar-cover .navbar-nav li a:hover{
  background-color: #f9f9f9;
}

.navbar-principal .navbar-form .input-group input  {
  height: 30px;
}

.navbar-principal .input-group-addon {
  background-color: #FFFFFF;
  border: 1px solid #E3E3E3;
  border-left: 0px solid #E3E3E3;
}

.navbar-principal .navbar-brand:hover {
  color: #fff;
  font-weight: 500;
}

.navbar-principal .dropdown-menu .notification-row a{
  color: #2DBB7F;
}

.navbar-principal a i { 
  font-size: 20px;
}

.img-nav{
  width: 25px;
  height: 25px;
  margin-top: -3px;
  border-radius: 4px;
}

.form-control, .input-group-addon {
    -webkit-transition: all 300ms linear;
    -moz-transition: all 300ms linear;
    -o-transition: all 300ms linear;
    -ms-transition: all 300ms linear;
    transition: all 300ms linear;
}

.icons-nav{
  width: 25px;
  height: 25px;
  margin-top: -3px;
  -webkit-filter: invert(100%);
    filter: invert(100%);
}

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Baby Histories</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
    <link rel="stylesheet" href="http://demos.bootdey.com/clean-note/assets/css/timeline.css">
</head>
<body>
  <nav class="navbar navbar-default navbar-fixed-top navbar-principal">
      <div class="container">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="index.html">
            <b>Baby Histories</b>
          </a>
        </div>

        <div id="navbar" class="collapse navbar-collapse">
          <div class="col-md-5 col-sm-4">         
            <form class="navbar-form">
              <div class="form-group" style="display:inline;">
                <div class="input-group" style="display:table;">
                  <input class="form-control" name="search" placeholder="Search..." autocomplete="off" type="text">
                  <span class="input-group-addon" style="width:1%;">
                    <span class="fa fa-search"></span>
                  </span>
                </div>
              </div>
            </form>
          </div>        

          <ul class="nav navbar-nav navbar-right">
            <li><a href="#"><i class="fa fa-comments"></i></a></li>
            <li><a href="#" class="nav-controller"><i class="fa fa-bell"></i></a></li>
            <li>
              <a href="#">
                <img src="https://www.shareicon.net/data/512x512/2016/11/14/852449_globe_512x512.png" class="icons-nav">
                Inicio
              </a>
            </li>
            <li class="active">
              <a href="#">
                Wilson Pinzón 
                <img src="http://static.wixstatic.com/media/fa846e_0178f9176c8544d09624f3949519ec19.jpg_256" class="img-nav">
              </a>
            </li>
          </ul>
        </div>

      </div>
  </nav>
  
</body>
</html>

I need to know how I can export the following table that I have in a view of my project to an excel document.

The table I want to export to excel is as follows:

    <table class="exampletb table table-bordered table-hover display">
        <thead>
            <tr>
                <th>Colaborador</th>
                <th>Lider</th>
                <th>Eje</th>
            </tr>
        </thead>
        <tbody>
            @foreach (var item in ViewBag.colaboradores)
    {
        var namelider = item.lider;
        var codigo_col = item.codigo;
        var lider = (from p in ((List<SI_OldMutual.Models.Collaborators>)ViewBag.email_lider).Where(n => n.nombres == namelider)
                     select p.email).ToList();
        if (lider.Count == 0)
        {
            ViewBag.test = "No existe";
        }
        else
        {
            ViewBag.test = lider[0];
        }
        <tr>
            <td>@item.nombres</td>
            <td>@item.lider</td>
            <td>@item.eje_funcional</td>
            @foreach (var peso in ((List<SI_OldMutual.Models.Objectives>)ViewBag.pesos).Where(n => n.Lider == ViewBag.test))
            {
                <td>@peso.Peso_Objetivo</td>
            }
            @foreach (var calificacion in ((List<SI_OldMutual.Models.CalificarColaborador>)ViewBag.calificaciones).Where(n => n.codigo_colaborador == codigo_col))
        {
                <td>@calificacion.calificacion</td>
            }

        </tr>
            }
        </tbody>
    </table>

They tell me that I can do it from the controller but I have no idea how to do it, I'm new to Asp.Net Mvc5. My idea is to make it export that table with the same logic that I am using in view.

My controller is this:

public ActionResult Index()
        {
            ViewBag.colaboradores = (from p in db.Collaborators
                         where p.grupo_lider == "NO"
                         select p).ToList();

            ViewBag.pesos = (from p in db.Objectives
                         select p).ToList();

            ViewBag.calificaciones = (from p in db.CalificarColaboradors
                        select p).ToList();

            ViewBag.email_lider = (from p in db.Collaborators where p.grupo_lider == "SI"
                               select p).ToList();

            return View();
        }

It should be clarified that the table is painted in my view in the following way since the results of the weights and qualifications can vary depending on the person and are not always the same amount, I leave an image so that it is understood a little better:

This is why I need to be able to export this table just as it appears to me in the view or at least using the same logic.

In case of doubt, my namespaceisSI_OldMutual

Companions of Stack Overflow in Spanish, I have the following error when doing this conditional ViewBag.p.Where(n => n.Lider == nameliderin the loop foreach.

Here is part of my code:

<table class="table table-bordered">
    @foreach (var item in ViewBag.c)
    {
        var namelider = item.lider;
        <tr>
            <td>@item.nombres</td>
            <td>@item.lider</td>
            <td>@item.eje_funcional</td>
            @foreach(var peso in ViewBag.p.Where(n => n.Lider == namelider))
            {
                <td>@peso.Lider</td>
            }
        </tr>
    }
</table>

The error that appears to me is the following:

You cannot use a lambda expression as the argument of a dynamically dispatched operation without first converting it to an expression tree or delegate type.

I add controller queries:

ViewBag.c = (from p in db.Collaborators
             where p.grupo_lider == "NO"
             select p).ToList();

ViewBag.p = (from p in db.Objectives
             select p).ToList();

ViewBag.cal = (from p in db.CalificarColaboradors
               select p).ToList();

Hello fellow StackOverFlow, I am currently trying to do a multiplication of percentages %, but currently I have not been able to perform said operation,

Taking into account that it is a foreachthat loads me both inputs.weight and .qualification as many times as there is a record, I need to do the following operation:

Rating * Weight + Rating * Weight + rating * weight and so on depending on the number of records that the cycle throws at me foreach.

An example of data would be the following since I am working with percentages and decimals

Attached image for better understanding

My code is the following

    @foreach (var item in ViewBag.listobjetivos)
            {
                <tr>
                    <td>@item.Nombre_Objetivo</td>
                    <td><input class="peso" type="text" value="@item.Peso_Objetivo" />%</td>
                    <td>@item.Descripcion_Objetivo</td>
                    <td><input class="calificacion" type="text" value='@string.Format("{0:F1}", item.calificacion)' /></td>
                    <td>@item.observacion</td>
              </tr>
            }
<span class="resultado"></span>

I need to multiply the weight which is a percentage % by the grade and the same for the other records but I need a total result of the sum of all

Here I leave you an image in excel so that you can understand me a little better, in the image you can see the operation in excel.

Example Rating: 1.5 * Weight: 5%, Result: 0.075

I remain attentive to any questions or news.

Hello fellow StackOverFlow, I need to make a INSERTMultiple of records to my table through a dynamic form that I have created with JS.

My model is the following:

namespace MultiInsert.Models
{
    public class Ejemplo
    {
        [Key]
        public int id { get; set; }
        public string objetivos { get; set; }
        public string nombres { get; set; }
        public decimal puntaje { get; set; }
    }
}

My view is the following:

@model MultiInsert.Models.Ejemplo

@{
    ViewBag.Title = "MultiCreate";
}

<h2>MultiCreate</h2>


@using (Html.BeginForm()) 
{

    <div class="col-xs-12">
        <div class="col-md-12">
            <div id="field">
                <div id="field0">
                    <!-- Text input-->
                    <div class="form-group">
                        <label class="col-md-4 control-label" for="action_id">Objetivos</label>
                        <div class="col-md-5">
                            <input id="objetivos" name="objetivos" type="text" placeholder="" class="form-control input-md">

                        </div>
                    </div>
                    <br><br>
                    <!-- Text input-->
                    <div class="form-group">
                        <label class="col-md-4 control-label" for="action_id">Nombres</label>
                        <div class="col-md-5">
                            <input id="nombres" name="nombres" type="text" placeholder="" class="form-control input-md">

                        </div>
                    </div>
                    <br><br>
                    <!-- Text input-->
                    <div class="form-group">
                        <label class="col-md-4 control-label" for="action_name">Puntaje</label>
                        <div class="col-md-5">
                            <input id="puntaje" name="puntaje" type="text" placeholder="" class="form-control input-md">
                        </div>
                    </div>
                    <br><br>
                  </div>
            </div>
            <!-- Button -->
            <div class="form-group">
                <div class="col-md-4">
                    <button id="add-more" name="add-more" class="btn btn-primary">Add More</button>
                </div>
            </div>
            <br><br>
            <div class="form-group">
                <div class="col-md-offset-2 col-md-10">
                    <input type="submit" value="Create" class="btn btn-default" />
                </div>
            </div>
        </div>
    </div>



}

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

My Script with which I insert inputsdynamically:

<script>
    $(document).ready(function () {
        var next = 0;
        $("#add-more").click(function (e) {
            e.preventDefault();
            var addto = "#field" + next;
            var addRemove = "#field" + (next);
            next = next + 1;
            var newIn = ' <div id="field' + next + '" name="field' + next + '"><!-- Text input--><div class="form-group"><label class="col-md-4 control-label" for="action_id">Objetivos</label><div class="col-md-5"><input id="objetivos" name="objetivos" type="text" placeholder="" class="form-control input-md"></div></div><br><br><!-- Text input--><div class="form-group"><label class="col-md-4 control-label" for="action_id">Nombres</label><div class="col-md-5"><input id="nombres" name="nombres" type="text" placeholder="" class="form-control input-md"></div></div><br><br><!-- Text input--><div class="form-group"><label class="col-md-4 control-label" for="action_name">Puntaje</label><div class="col-md-5"><input id="puntaje" name="puntaje" type="text" placeholder="" class="form-control input-md"></div></div><br><br></div></div></div>';
            var newInput = $(newIn);
            var removeBtn = '<button id="remove' + (next - 1) + '" class="btn btn-danger remove-me" >Remove</button></div></div><div id="field">';
            var removeButton = $(removeBtn);
            $(addto).after(newInput);
            $(addRemove).after(removeButton);
            $("#field" + next).attr('data-source', $(addto).attr('data-source'));
            $("#count").val(next);

            $('.remove-me').click(function (e) {
                e.preventDefault();
                var fieldNum = this.id.charAt(this.id.length - 1);
                var fieldID = "#field" + fieldNum;
                $(this).remove();
                $(fieldID).remove();
            });
        });

    });
</script>

And finally part of my controller:

// View MultiCreate
        public ActionResult MultiCreate()
        {
            return View();
        }

        // View MultiCreate
        [HttpPost]
        public ActionResult MultiCreate([Bind(Include = "id,objetivos,nombres,puntaje")] Ejemplo ejemplo)
        {
            if (ModelState.IsValid)
            {
                db.Ejemploes.Add(ejemplo);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(ejemplo);
        }

I know that it is with a cycle Foreachthat I have to carry INSERTout, however I do not have the knowledge to carry out the process in MVC5.

I remain attentive to any news or doubt.

I am doing a project and at this moment I need to import data from an "Excel" CSV file Delimited by commas (,) certain information, I need that through a form they can upload the excel and that said excel is automatically imported into the table dbo.CollaboratorsI am using MVC5 and SQLServer 2014.

My view is the following:

@model SI_OldMutual.Models.Collaborators

@{
    ViewBag.Title = "UploadPlanta";
}

<h2>UploadPlanta</h2>

@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()
    <div class="form-group">
        <input class="form-control" type="file" name="planta" /><br />
        <input class="btn btn-default" type="submit" value="Cargar" />
    </div>
}

Part of my controller is the following:

private SI_OldMutualContext db = new SI_OldMutualContext();

//  UploadPlanta
public ActionResult UploadPlanta()
{
    return View();
}

//POST UploadPlanta
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult UploadPlanta([Bind(Include = "planta")] Collaborators collaborators)
{
    return View();
}

Part of my model:

[Key]
public int CollaboratorID { get; set; }
[Required]
[Display(Name = "Codigo")]
public string codigo { get; set; }
[Display(Name = "Cedula")]
public string cedula { get; set; }
[Display(Name = "Nombres")]
public string nombres { get; set; }
[Display(Name = "Fecha Ingreso")]
[DataType(DataType.Date)]
[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:yyyy-MM-dd}")]
public DateTime fecha_ingreso { get; set; }
[Display(Name = "Salario Basico")]
[DisplayFormat(DataFormatString = "{0:C0}", ApplyFormatInEditMode = false)]
public decimal salario_basico { get; set; }
[Display(Name = "Salario Cargo")]
[DisplayFormat(DataFormatString = "{0:C0}", ApplyFormatInEditMode = false)]
public decimal salario_cargo { get; set; }
[Display(Name = "Regimen")]
public string regimen { get; set; }
[Display(Name = "Tipo de Contrato")]
public string tipo_contrato { get; set; }
[Display(Name = "Ciudad")]
public string ciudad { get; set; }

Explanation: I need that through said form they can insert the CSV file delimited by commas and at the moment of automatically loading the information that is in said file, it is imported into the table Collaboratorscorresponding to the model.

I have been reviewing several examples in internet groups and StackOverFlow but I can't find a clear example regarding what I need, any input is quite useful.

It should be noted that I am using MVC5 in visual studio 2015.

Hello StackOverFlow colleagues, I have the following question, how can I load or give a value to an input when selecting an option in a select or dropdownlist.

my create controller is as follows:

// GET: Collaborators/Create
        public ActionResult Create()
        {
            var lideres = (from p in db.Collaborators
                                  where p.grupo_lider == "SI"
                                  select p).ToList();

            ViewBag.lideres = lideres.Select(p => new SelectListItem() { Value = p.nombres, Text = p.nombres }).ToList();

            ViewBag.CompanyID = new SelectList(db.Companies, "CompanyID", "compania");
            return View();
        }

Part of my view:

<div class="form-group">
            @Html.LabelFor(model => model.lider, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.DropDownListFor(model => model.lider, (List<SelectListItem>)ViewBag.lideres, "Selleccione un líder", new{ @class = "form-control" })
                @Html.ValidationMessageFor(model => model.lider, "", new { @class = "text-danger" })
</div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.cargo_lider, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.cargo_lider, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.cargo_lider, "", new { @class = "text-danger" })
            </div>
        </div>

Part of my model with the most relevant parts regarding my question:

[Display(Name = "Lider")]
public string lider { get; set; }
[Display(Name = "Cargo Lider")]
public string cargo_lider { get; set; }
[Display(Name = "Cargo")]
public string cargo { get; set; }

I explain exactly what I need, currently my dropdownList that has as a model model.lidershows the names of the users whose group_leader is equal to "SI"in the controller shows the query that I make, what I need now is to load the input @Html.EditorFor(model => model.cargo_lider, new { htmlAttributes = new { @class = "form-control" } })with the position according to the name or the user that is selected in the dropdownlist, taking into account that this data is in cargothe db.collaborators column, and I need to load it in the input with the modelo.cargo_lider.

I stay tuned for questions, answers and others.

Current Ajax Code:

$('#iddropdownlist').change(function () {
            var url = "/Collaborators/BuscarCargoLider?claveLider=" + $('#iddropdownlist option:selected').val();
            $.ajax({
                url: url,
                type: 'GET',
                dataType: 'json',
                contentType: 'application/json; charset=utf-8',
                async: true,
                success: function (result) {
                    var lider;
                    if (result != null && result.length > 0) {
                        lider= JSON.parse(result);
                    }
                    if (lider!= null ) {                    
                        $('#idinput').val(lider);//cargo debe ser la propiedad de la clase lider donde se almacena el cargo del lider 
                    }                
                },
                error: function (XMLHttpRequest, textStatus, errorThrown) {
                    alert("error al consultar datos del lider");
                }
            });        
        });

Controller:

[HttpGet]
        public JsonResult BuscarCargoLider(string claveLider)
        {
            try
            {
                var lider = (from p in db.Collaborators
                             where p.nombres == claveLider
                             select p.cargo).ToList();

                return Json(lider, JsonRequestBehavior.AllowGet);
            }
            catch (Exception)
            {
            }
            return Json("", JsonRequestBehavior.AllowGet);
        }

I want that in the register that comes by default when creating a project in MVC5, under repeat password, put a selection list ( ComboBox) where it shows me the list of roles that exist in the table AspNetRolesthat Visual Studio creates by default.

I've had problems getting the list of the AspNetRoles, since I don't know which context is using the Idendity, and I don't know exactly how to create the select.

I just need to know how to get the listing in the controller and how to pass it to the view, I Insertdon't need it.

My Controller:

// GET: /Account/Register
[AllowAnonymous]
public ActionResult Register()
{
    return View();
}

My sight:

@model StyleTest.Models.RegisterViewModel
@{
    ViewBag.Title = "Registrarse";
}

<h2>@ViewBag.Title.</h2>

@using (Html.BeginForm("Register", "Account", FormMethod.Post, new { @class = "form-horizontal", role = "form" }))
{
    @Html.AntiForgeryToken()
    <h4>Cree una cuenta nueva.</h4>
    <hr />
    @Html.ValidationSummary("", new { @class = "text-danger" })
    <div class="form-group">
        @Html.LabelFor(m => m.Email, new { @class = "col-md-2 control-label" })
        <div class="col-md-10">
            @Html.TextBoxFor(m => m.Email, new { @class = "form-control" })
        </div>
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Password, new { @class = "col-md-2 control-label" })
        <div class="col-md-10">
            @Html.PasswordFor(m => m.Password, new { @class = "form-control" })
        </div>
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.ConfirmPassword, new { @class = "col-md-2 control-label" })
        <div class="col-md-10">
            @Html.PasswordFor(m => m.ConfirmPassword, new { @class = "form-control" })
        </div>
    </div>
    <div class="form-group">
        <div class="col-md-offset-2 col-md-10">
            <input type="submit" class="btn btn-default" value="Registrarse" />
        </div>
    </div>
}

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

My connection in the web.config:

  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=.;Initial Catalog=StyleTest;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="StyleTestEntities" connectionString="metadata=res://*/Contexto.StyleTest.csdl|res://*/Contexto.StyleTest.ssdl|res://*/Contexto.StyleTest.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=StyleTest;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

I use MVC5 with Visual Studio 2015.

How can I format an integer?

I need to visualize it as a price.

r = 100000;
comision = 10000; 
totalp = r+comision;
document.getElementById("total").value = totalp;

Clearly the sum gives110000

Resultado que quiero obtener en el input

$110,000.00

I need to generate PDF with the following style. [![enter image description here][1]][1]

What I mean by (style) is the design as the logo in that location, the green border at the end of the sheet, and also the size of the sheet, in my case I need letter, I would like to know how I could do this, and if I can use iTextSharp or it is necessary to use another library, said previous image is a certification which I generated with PHP FPDF, but now I need to do the same but in ASP.NET MVC5.

Any help or advice would be very helpful.

I have a table with some users waiting for approval, I created a button called approve, pressing it sends you to for example

http://localhost:58074/Collaborators/Approved/1 <-- User ID

This is my view.

@{
    ViewBag.Title = "Approved";
}

<h2>Approved</h2>

@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()
    <div class="form-actions no-color">
        <input type="submit" value="Aprobar" class="btn btn-default" /> |
        @Html.ActionLink("Regresar", "Index", new { ViewBag.id })
    </div>
}

This is my controller.

// GET: Collaborators/Approved/
        public ActionResult Approved(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Collaborators collaborators = db.Collaborators.Find(id);
            if (collaborators == null)
            {
                return HttpNotFound();
            }
            ViewBag.id = 1;
            return View(collaborators);
        }

I need that when clicking on (Approve) I change only the status value of my database for a specific value in my case the number 2.

It should be noted that the current status of a user NOT approved is 1 and I want that value 1 to change to 2 when approving it, for example.

This is the line on the modelpublic int status { get; set; }

I need to do this select:

<select class="form-control">
    <option>ESPOSO(A)</option>
    <option>HIJO(A)</option>
    <option>CONYUGUE</option>
    <option>ACUDIENTE</option>
</select>

But I don't know how to do it in Razor, I was looking at some posts and articles but it only shows how to dynamically load them with data from the database, and I only need that static data, but I don't give how.

My Controller:

// GET: Families/Create
public ActionResult Create()
{
    return View();
}

My View:

@model OldMutual.Models.Families

@{
    ViewBag.Title = "Create";
}

<h2>Create</h2>


@using (Html.BeginForm()) 
{
    @Html.AntiForgeryToken()

    <div class="form-horizontal">
        <h4>Families</h4>
        <hr />
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        <div class="form-group">
            @Html.LabelFor(model => model.documento_identidad, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.documento_identidad, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.documento_identidad, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.parentesco, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.parentesco, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.parentesco, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.names, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.names, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.names, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.fecha_nacimiento, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.fecha_nacimiento, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.fecha_nacimiento, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.sexo, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.sexo, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.sexo, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.celular, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.celular, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.celular, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.telefono, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.telefono, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.telefono, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.codigo_colaborador, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.codigo_colaborador, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.codigo_colaborador, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            <div class="col-md-offset-2 col-md-10">
                <input type="submit" value="Create" class="btn btn-default" />
            </div>
        </div>
    </div>
}

<div>
    @Html.ActionLink("Back to List", "Index")
</div>

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

It should be clarified that he selectis for him model.parentesco.

<div class="form-group">
    @Html.LabelFor(model => model.parentesco, htmlAttributes: new { @class = "control-label col-md-2" })
    <div class="col-md-10">
        @Html.EditorFor(model => model.parentesco, new { htmlAttributes = new { @class = "form-control" } })
        @Html.ValidationMessageFor(model => model.parentesco, "", new { @class = "text-danger" })
    </div>
</div>

I need to calculate the age of a person from their date of birth, but the calculation is doing me wrong, I give you an example.

Pepito was born on December 17, 1997, at this time Pepito is 19 years old, but the calculation shows me as if he were 20 years old.

My code is the following:

//FECHA NACIMIENTO EN LA BASE DE DATOS
[Display(Name = "Fecha Nacimiento")]
        [DataType(DataType.Date)]
        public DateTime fecha_nacimiento { get; set; }
//CALCULO DE LA EDAD
 [NotMapped]
 [Display(Name = "Edad")]
 public int edad { get { return DateTime.Now.Year - fecha_nacimiento.Year; } }

In my database the date is like this:

1997-12-17 00:00:00,000

I need that when I press the "Generate" button, I load a link in the "Certificate" div.

    <div class="container-fluid">
    <div class="side-body">
    <h1 class="titleh">Generar Certificado</h1>
    <div style="width: 40%;">
    <form action="#">
        <div class="form-group">
          <label for="dirigido">Dirigido a:</label>
          <input type="text" class="form-control" name="dirigido" id="dirigido" placeholder="Ingrese un valor">
        </div>
        <div class="form-group">
          <label for="cc">Cedula:</label>
          <input type="password" class="form-control" name="cc" id="cc" placeholder="Ingrese Cedula">
        </div>
        <input type="submit" value="Generar" name="Generar" class="btn btn-sm" style="color: white; background: #006050;">
    </form>
    </div>
    <br><br><br>
    <div class="container" style="width: 100%; height: 490px; background-color: #A7A7A7"></div>

    </div>
</div>

Hello, how could I load all the data of the person in a modal window when clicking on the button shown in the image called Register?

When I click on it, I need to load all the data, which is in a MySQL database.

I know that it is possible with AJAX but the truth is that I have no knowledge in such, if you can provide me with information to solve my problem it would be of great help.

Thank you very much.

I need to add the text type input with the checkbox type input, at this moment when clicking on the checkbox it is adding and showing the total, but I need it to also add the text type input called service price.

This is a screenshot of my form:

This is my code:

<?php foreach($servicelist as $listsv): ?>
<input name="service[]" type="checkbox" onClick="if (this.checked) sumar(<?php echo $listsv["price"]; ?>); else restar(<?php echo $listsv["price"]; ?>)" value='<?php echo $listsv["id"]; ?>'><?php echo utf8_encode($listsv['service']); ?><br>
<?php endforeach; ?>
<br>

this is my function

var total = 0;

function sumar(valor) {
    total += valor;
    document.formulario.total.value = '$' + total.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,");
}

function restar(valor) {
    total -= valor;
    document.formulario.total.value = '$' + total.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,");
}

function otro_servicio() {
    $("#lineas").append('<label>Nombre Servicio</label>');
    $("#lineas").append('<input name="othersv" type="text" class="form-control importe_linea" placeholder="Nombre del servicio extra"/><br/>');
    $("#lineas").append('<label>Precio Servicio</label>');
    $("#lineas").append('<input name="price" type="text" class="form-control importe_linea" placeholder="Precio del servicio"/><br/>');
}

To achieve this goal I can use javascript, jquery or angular.