Hectorepg's questions

I am trying to insert a record with 3 digits, example: if it is the first one that comes out 001 and the consecutive one is 002, when reaching 10! let 010 come out.

in my code what I achieve is that I insert it without the two zeros

declare @Resultado int
SELECT @Resultado = SUBSTRING(MAX(Agente), CHARINDEX('V', MAX(Agente)) + 1, 4) + 1
FROM Agente
WHERE Agente LIKE '%204%'
AND Tipo = 'Agente'

print @Resultado

    insert into Agente
        (Agente, Nombre, Estatus, Conciliar, Nomina, Logico1, Logico2, Equipo)
    values
        ('204V'  + Convert(varchar, @Resultado), 'Lalo Garcia', 'ALTA', 1, 1, 0, 0, 0)
end

I hope you can support me.

I have a system in which I want to register an "Agent"

What I am looking for is to fill in the part SucursalEmpresawith the information that is in its own table in a SelectList, but I cannot call two models in a single view.

This is my Agent model:

public class AgenteM
{
    public string Agente { get; set; }
    [Required(ErrorMessage = "El campo Nombre es obligatorio")]
    public string Nombre { get; set; }
    public string Familia { get; set; }
    public string Tipo { get; set; }
    public string Estatus { get; set; }
    public int SucursalEmpresa { get; set; }
}

And this is my Branch model:

public class SucursalM
{
    public int Sucursal { get; set; }
    public string Nombre { get; set; }
}

This is my controller:

    [HttpPost]
    public IActionResult Guardar(AgenteM oAgente)
    {
        //Recibe el objeto para guardarlo en BD

        if (!ModelState.IsValid)
            return View();

        var respuesta = _AgenteD.Guardar(oAgente);

        if (respuesta == true)
            return RedirectToAction("Listar");
        else
        return View();
    }

where do I call my functionGuardar

    public bool Guardar(AgenteM oAgente)
    {
        ListarSucursal();
        bool rpta;
        try
        {
            var cn = new Conexion();

            using (var conexion = new SqlConnection(cn.GetCadenaSql()))
            {
                conexion.Open();
                SqlCommand cmd = new SqlCommand("sp_WebCrearAgente", conexion);
                cmd.Parameters.AddWithValue("Agente", oAgente.Agente);
                cmd.Parameters.AddWithValue("Nombre", oAgente.Nombre);
                cmd.Parameters.AddWithValue("SucursalEmpresa", oAgente.SucursalEmpresa);
                cmd.Parameters.AddWithValue("Tipo", oAgente.Tipo);
                cmd.Parameters.AddWithValue("Estatus", oAgente.Estatus);
                cmd.Parameters.AddWithValue("Familia", oAgente.Familia);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.ExecuteNonQuery();
            }
            rpta = true;
        }
        catch(Exception ex)
        {
            string error = ex.Message;
            rpta = false;
        }

        return rpta;
    }

here I have a function to bring all the information of the branches:

    public List<SucursalM> ListarSucursal()
    {
        var oLista = new List<SucursalM>();
        var cn = new Conexion();

        using (var conexion = new SqlConnection(cn.GetCadenaSql()))
        {
            conexion.Open();
            SqlCommand cmd = new SqlCommand("sp_WebObtenerSucursales", conexion);
            cmd.CommandType = CommandType.StoredProcedure;

            using (var dr = cmd.ExecuteReader())
            {
                while (dr.Read())
                {
                    oLista.Add(new SucursalM()
                    {
                        Sucursal = (int)dr["Sucursal"],
                        Nombre = dr["Nombre"].ToString()
                    });
                }
            }
        }
        return oLista;
    }

And this is my view, where I want to fill a selectList with the information from the table.

        <div class="row">
            <div class="col-sm-6">
                <label class="form-label">Agente</label>
                <input asp-for="Agente" type="text" class="form-control" name="Agente">
            </div>
            <div class="col-sm-6">
                <label class="form-label">Nombre</label>
                <input asp-for="Nombre" type="text" class="form-control" name="Nombre">
                <span asp-validation-for="Nombre" class="text-danger"></span>
            </div>
            <div class="col-sm-6">
                <label class="form-label">Sucursal Empresa</label>
                @*@Html.DropDownListFor(model => model.AgenteM.SucursalM.Sucursal, new SelectList(Model.AgenteM.SucursalM.Sucursales, "Sucursal", "Nombre"), "Selecciona una Sucursal", new { @class = "form-control", @id = "txtSucursal", @placeholder = "Sucursal" })*@
                <input asp-for="SucursalEmpresa" type="text" class="form-control" name="SucursalEmpresa">
            </div>
            <div class="col-sm-6">
                <label class="form-label">Tipo</label>
                <input asp-for="Tipo" type="text" class="form-control" name="Tipo">
            </div>

        </div>

What is wrong with me or what am I doing wrong? I hope you can help me.

I am trying to iterate in a range of dates, I get everything correct if I enter from a month below to the current one:

Example from 08-1-2022 to 09-14-2022, for that use the following code:

    DateTime Fecini = new DateTime(2022, 8, 1);
    DateTime FecFinal = new DateTime(2022, 9, 14);
    System.TimeSpan dif = FecFinal - Fecini;
    DateTime FecSec;//fecha seleccionad en el bucle
    for (int n = 0; n <=dif.Days; n++)
    {
        FecSec = Fecini.AddDays(n);
        Console.WriteLine(FecSec);
    }

It prints correctly, but what I want is for it to be from today to last month (09-14-2022 to 08-01-2022), I use the following code but the problem is that it does not stop on the 1st of the month August, continues and continues to print more dates.

I hope you can support me with it or support me where my mistake is to correct it.

        DateTime Fecini = new DateTime(2022, 9, 14);
        DateTime FecFinal = new DateTime(2022, 8, 1);
        System.TimeSpan dif = Fecini - FecFinal;
        DateTime FecSec;
        for (int n = 0; n <= dif.Days; n--)
        {
            FecSec = Fecini.AddDays(n);
            Console.WriteLine(FecSec);
        }