I have the following collection in mongodb, I want to get the cveUsuario, activoand the historial, but the history only the days that are in the date range selected by the user.

{
  "_id": ObjectId("5847167aa7f950253039ef7e"),
  "cveUsuario": "000210",
  "activo": true,
  "historial": {
    "13 Jan 2017": {
      "VFVNTF03": [
        "09:38:33",
        "09:38:57",
        "09:39:38",
        "09:40:37"
      ],
      "CHPAGF099": [
        "16:38:41",
        "16:41:16"
      ]
    },
    "14 Jan 2017": {
      "CHRCAF003": [
        "09:33:21",
        "09:33:43"
      ],
      "CHPAGF099": [
        "10:36:22",
        "12:13:14"
      ]
    }
  },...
  {...}
}

I have the following query but when I use it in JAVA it does not bring me results, since if the user enters more than 4 days it becomes larger.

db.getCollection('sesiones').find({
    historial:{$exists:true},
    $or:[
        {"historial.24 Nov 2018":{$exists:true}},
        {"historial.23 Nov 2018":{$exists:true}},
        {"historial.22 Nov 2018":{$exists:true}}
    ]
},{
    cveUsuario:1,
    activo:1,
    "historial.24 Nov 2018":1,
    "historial.23 Nov 2018":1,
    "historial.22 Nov 2018":1
})

Is there any way to simplify the query I have, I'm new to mongodb queries.

Related How to group a record that is repeated, showing all the different records that are associated with it?

I'm doing a query to get all the clientesand total de cuentas asociadasbut I don't want to show the ones that I already have associated.

I have the following tables:

----dbClientes-----    --------syUsers--------    -----syUsers_WebAccess----
|  id  |  Nombre  |    |  id  |  Nombre      |    | id | idUser | idClient |
-------------------    -----------------------    --------------------------
|  1   |  Juan    |    |  1   | Contabilidad |    | 1  |    1   |    1     |
|  2   |  Victor  |    |  2   | JuankGlezz   |    | 2  |    1   |    3     |
|  3   |  Arturo  |    -----------------------    | 3  |    2   |    1     |
-------------------                               --------------------------

Doing the following query brings me all the clienteswith the total de cuentas asociadas.

SELECT DISTINCT C.Nombre, C.id, IFNULL(NC.NumCuentas,0) AS NumCuentas
FROM dbclientes C
LEFT JOIN (
    SELECT idClient, count(id) AS NumCuentas FROM syUsers_WebAccess
  ) NC ON NC.idCliente = C.id

It gives me as a result:

Nombre   idCliente  NumCuentas
Juan        1          2
Victor      2          1
Arturo      3          0

Now I want to apply Get all clientesExcept those clientesassociated with it JuankGlezz, that is, I expect this as a result:

Nombre   idCliente  NumCuentas
Victor      2          1
Arturo      3          0

In case the selected user Contabilidadwas the following would be displayed:

Nombre   idCliente  NumCuentas
Victor      2          1

How would the query be to obtain those results? , try this, but it only works if there is only one associated account.

SELECT * FROM (
    SELECT DISTINCT C.Nombre, C.id, IFNULL(NC.NumCuentas,0) AS NumCuentas
    FROM dbclientes C
    LEFT JOIN (
        SELECT idCliente, count(id) AS NumCuentas FROM syUsers_WebAccess
      ) NC ON NC.idCliente = C.id
) TB
WHERE id != (SELECT idCliente FROM syUsers_WebAccess WHERE idUser = 48)

Note: I can't just put the idClient, because from the application I get only theidUser

I have the need to make a POST request from the controller before loading the view, I want to do this due to a certain condition that is required of me.

The condition is:

If I have more than one product in the contract, show a "Menu" with the contracted products, otherwise, if I only have 1, show the view of that product and not the "Menu".

The Menu controller code is:

public ActionResult MenuApps(){
  if (WSKernel.Suscriptions_WebDevices_Get(productosDatos, out productosRespuesta)) {
    model.Productos = productosRespuesta.ListSuscriptions_WebDevices;
    //si solo se cuenta con un solo producto, hacer redireccion directa al unico producto
    if (model.Productos != null && model.Productos.Length == 1){
      switch (model.Productos[0].AdmixProduct){
        case "Producto1":
          return Redirect("http://localhost/Producto1");
        case "Producto2":
          return Redirect("http://localhost/Producto2");
      }
    }
  }else{//sin productos}
}

But the do return Redirect("http://localhost/Producto2");makes a request HTTPbecause GETI want to send information and I want the user not to see it just because I need him to always log in correctly.

On the other hand, where I want to redirect is another project that is already finished and this one is configured to receive information by POST.

How can I make the POST request and redirect to the page from the controller?

I have a menu which redirects to different urlone of them is a different project but within the same domain.

Main project (myDomain.com.mx/MenuApps/Index)

Menu

//mas código como este
<div class="col-xs-6 col-sm-3 col-md-2">
  <div class="contact-box">
    <!-- /Nuevo se sustituye por /BuzonFiscal -->
    <a href="#">
      <div class="col-sm-12">
        <div class="text-center">
          <img alt="image" class="m-t-xs img-responsive" src="~/img/admix_logo_colibri.png">
          <div class="m-t-xs font-bold">Buzon Fiscal</div>
        </div>
      </div>
      <div class="clearfix"></div>
    </a>
  </div>
</div>
//mas código como este

in scriptit I have this where I make my requestajax

$.ajax({
  data:  "Dato_en_MD5",
  url:   '/BuzonFiscal',
  type:  'post',
  success:  function (response) {
    console.log(response)
  }
});

As far as I understand this ajaxwill not do the redirection to the url, what I need is to redirect and send the hidden data.

Fiscal Mailbox (miDominio.com.mx/BuzonFiscal)

this is the fiscal mailbox controller :

namespace Emisiones.Controllers
{
    public class HomeController : Controller
    {
        [HttpPost]
        public ActionResult Empresas(string dato_en_MD5)
        {
            //.. lo que tenga que hacer 
            return View();
        }
    }
}

So how can I redirect to miDominio.com.mx/BuzonFiscalsending two data by post?

I have a problem with TempDatarefreshing the view.

This controllerassigns a stringto TempData:

public ActionResult Sucursales(string rfcCompany)
{
    model.CuentaUser = CuentaUser;
    TempData["RFCCompany"] = rfcCompany;//solo para evitar mandar el rfc por la url nuevamente
    return View(model);
}

Being in the view Sucursales.cshtmlI redirect to DetalleSucursal.cshtml, which the controller has this:

public ActionResult DetalleSucursal(int id, int idEmpresa, string CuentaUser){
    ComprobantesModel model = new ComprobantesModel();
    model.idEmpresa = idEmpresa;
    model.idSucursal = id;
    model.CuentaUser = CuentaUser;
    ViewBag.RFCCompany = TempData["RFCCompany"] as string;//para mostrar el RFC en algun lugar de la vista
    return View(model);
}

I have no problem with the first load of the view, the problem comes when I refresh the view DetalleSucursal.cshtmlit TempData["RFCCompany"]is loaded in the controller as nullif it had not been loaded from the controller Sucursales. How can I avoid the TempData["RFCCompany"]not to return nullon page refresh DetalleSucursal.cshtml?

I have a query in which I get a list of companies

SELECT S.FileB64 AS ImgB64, E.* FROM dbempresas E
    LEFT JOIN systorage S ON S.id = E.Logo_100 
    ORDER BY E.Nombre;

RESULTADO:
id |     RFC      |           Nombre
---+--------------+----------------------------------
14 | AAA010101AAA | ACCEM SERVICIOS EMPRESARIALES SC
15 | BBB010101BBB | CORPORACION ACME
16 | CCC010101CCC | INDUSTRIAS KORD

So far so good, but I want to add how many branches there are per company , giving me a result like this:

id |     RFC      |           Nombre                    |  Sucursales
---+--------------+-------------------------------------+--------------
14 | AAA010101AAA | ACCEM SERVICIOS EMPRESARIALES SC    |    2
15 | BBB010101BBB | CORPORACION ACME                    |    1
16 | CCC010101CCC | INDUSTRIAS KORD                     |    1

To try to achieve the above I have done this:

SELECT S.FileB64 AS ImgB64, ES.id, E.* FROM dbempresas E
    LEFT JOIN systorage S ON S.id = E.Logo_100 
    LEFT JOIN dbempresas_sucursales ES ON ES.IdEmpresa = E.id
    ORDER BY E.Nombre;

RESULTADO:
id |     RFC      |           Nombre                    |  ES.id
---+--------------+-------------------------------------+--------------
14 | AAA010101AAA | ACCEM SERVICIOS EMPRESARIALES SC    |    13
14 | AAA010101AAA | ACCEM SERVICIOS EMPRESARIALES SC    |    16
15 | BBB010101BBB | CORPORACION ACME                    |    17
16 | CCC010101CCC | INDUSTRIAS KORD                     |    18

I know that COUNT()I can count the records but I have no idea how to do it in the same query. How can I prevent idthe company from repeating itself and give me the result I want?

These are the tables in which I do the queries:

+------------------------------+   +-------------------------------+
|          dbEmpresas          |   |     dbEmpresas_Sucursales     |
+-------------+----------------+   +-------------+-----------------+
|  id         |  bigint(20)    |   |  id         |  bigint(20)     |
|  RFC        |  varchar(15)   |   |  IdEmpresa  |  bigint(20)     |
|  Nombre     |  varchar(100)  |   |  Nombre     |  varchar(100)   |
|  Logo_100   |  bigint(20)    |   +-------------+-----------------+
+-------------+----------------+

+-----------------------------+
|          syStorage          | 
+-----------+-----------------+
|  id       |  bigint(20)     |
|  FileB64  |  text           |
+-----------+-----------------+

I have a problem when I want to convert one object to another, these models being the same but different namespace.

Explaining myself better, I have two projects in a solution each with its model in which I have that repeated model ( AdminModel) I am passing that variable from Sessionand converting it

This is the initial model of the object.

namespace Admin.ModeloAdmin{

    public class AdminModel
    {
        public string devKey { get; set; }
        public string mobileKey { get; set; }
        public string cuenta { get; set; }
        public int idCliente { get; set; }
        public int idCuenta { get; set; }
        public int idEmpresa { get; set; }
        public int regreso { get; set; }
    }
}

I want to convert it to this other model

namespace User.ModeloAdmin{

    public class AdminModel
    {
        public string devKey { get; set; }
        public string mobileKey { get; set; }
        public string cuenta { get; set; }
        public int idCliente { get; set; }
        public int idCuenta { get; set; }
        public int idEmpresa { get; set; }
        public int regreso { get; set; }
    }
}

But when I want to convert it, I get an error in the following line:

AdminModel sesionManage = (AdminModel) Session["sessionManage"];

How can I pass data from one model to another?

this is the error message:

Server error in application '/'.

Cannot convert an object of type 'AdmixDownloads.Models.AdminModel' to type 'DownloadSU.Models.AdminModel'.

Description: Unhandled exception executing the current web request. Review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Cannot cast an object of type 'AdmixDownloads.Models.AdminModel' to type 'DownloadSU.Models.AdminModel'.

Source code error:

Line 31: else

Line 32: {

Line 33: sessionManage = (AdminModel)HttpContext.Session["sessionManage"];

Line 34: }

Line 35:

Source file: C:\Users\juan.gonzalez\Documents\JuanGonzalez\PruebasMVC\AdmixPortal\AdmixDescargas\AdmixDescargas\Areas\DescargaSU\Controllers\InicioController.cs Line: 33

Stack trace:

[InvalidCastException: Cannot cast an object of type 'AdmixDescargas.Models.AdminModel' to type 'DescargaSU.Models.AdminModel'.] DownloadSU.Controllers.InicioController.Index(String Sesion) in C:\Users\juan.gonzalez\ Documents\JuanGonzalez\PruebasMVC\AdmixPortal\AdmixDescargas\AdmixDescargas\Areas\DescargaSU\Controllers\InicioController.cs:33 lambda_method(Closure , ControllerBase , Object[] ) +103 System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[ ] parameters) +14 System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +157 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor,IDictionary`2 parameters) +27 System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +22 System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +29 System.Web. Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +32 System.Web.Mvc.Async.AsyncInvocationWithFilters.b__3d() +50 System.Web.Mvc .Async.<>c__DisplayClass46.b__3f() +225 System.Web.Mvc.Async.<>c__DisplayClass33.b__32(IAsyncResult asyncResult) +10 System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +34 System.Web.Mvc.Async.<>c__DisplayClass2b.b__1c() +26 System.Web.Mvc.Async.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult) +100 System.Web.Mvc .Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +27 System. Web.Mvc.Controller.b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13 System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29 System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +36 System.Web.Mvc.Controller.b__15(IAsyncResult asyncResult, Controller controller) +12 System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +22 System.Web.Mvc. Async.WrappedAsyncResultBase`1.End() +49 System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +26 System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) + 10 System.Web.Mvc.MvcHandler.b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +21 System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29 System.Web.Mvc.Async.WrappedAsyncResultBase`1. End() +49 System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +28 System.Web.Mvc.+9765121

I have a solution in Visual Studio 2015 with multiple MVC projects, based on areas, working correctly and redirecting from Test1, which is the main project, but I need to use subdomains to obtain information depending on it. My project is like the following image:

Now to capture the subdomains I did a test with a project without areas with the following code that worked correctly for me:

SubdomainRoute

namespace Prueba1.App_Start
{
    public class SubdomainRoute : RouteBase
    {
        public override RouteData GetRouteData(HttpContextBase httpContext)
        {
            if (httpContext.Request == null || httpContext.Request.Url == null)
            {
                return null;
            }

            var host = httpContext.Request.Url.Host;
            var index = host.IndexOf(".");
            string[] segments = httpContext.Request.Url.PathAndQuery.TrimStart('/').Split('/');

            if (index < 0)
            {
                return null;
            }

            var subdomain = host.Substring(0, index);
            string[] blacklist = { "www", "admix", "mail" };

            if (blacklist.Contains(subdomain))
            {
                return null;
            }

            string controller = "Home";
            string action = "Index";

            var routeData = new RouteData(this, new MvcRouteHandler());

            routeData.Values.Add("controller", controller); //Goes to the relevant Controller  class
            routeData.Values.Add("action", action); //Goes to the relevant action method on the specified Controller
            routeData.Values.Add("id", ""); //pass subdomain as argument to action method

            return routeData;
        }

        public override VirtualPathData GetVirtualPath(RequestContext requestContext, RouteValueDictionary values)
        {
            return null;
        }
    }
}

RouteConfig

namespace Prueba1
{
    public class RouteConfig
    {
        public static void RegisterRoutes(RouteCollection routes)
        {
            routes.IgnoreRoute("{resource}.axd/{*pathInfo}");

            routes.Add(new SubdomainRoute());

            routes.MapRoute(
                name: "Default",
                url: "{controller}/{action}/{id}",
                defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
            );
        }
    }
}

But when trying it with my new project structure based on areas it gives me this error:

Error de servidor en la aplicación '/'.

Multiple types were found that match the controller named 'Home'. This can happen if the route that services this request does not specify namespaces to search for a controller that matches the request. If this is the case, register this route by calling an overload of the 'MapRoute' method that takes a 'namespaces' parameter.

The request for 'Home' has found the following matching controllers:
Proyecto2.Controllers.HomeController
Proyecto1.Controllers.HomeController
Prueba1.Controllers.HomeController

Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código. 

Detalles de la excepción: System.InvalidOperationException: Multiple types were found that match the controller named 'Home'. This can happen if the route that services this request does not specify namespaces to search for a controller that matches the request. If this is the case, register this route by calling an overload of the 'MapRoute' method that takes a 'namespaces' parameter.

The request for 'Home' has found the following matching controllers:
Proyecto2.Controllers.HomeController
Proyecto1.Controllers.HomeController
Prueba1.Controllers.HomeController

Error de código fuente: 

Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.

Seguimiento de la pila: 


[InvalidOperationException: Multiple types were found that match the controller named 'Home'. This can happen if the route that services this request does not specify namespaces to search for a controller that matches the request. If this is the case, register this route by calling an overload of the 'MapRoute' method that takes a 'namespaces' parameter.

The request for 'Home' has found the following matching controllers:
Proyecto2.Controllers.HomeController
Proyecto1.Controllers.HomeController
Prueba1.Controllers.HomeController]
   System.Web.Mvc.DefaultControllerFactory.GetControllerTypeWithinNamespaces(RouteBase route, String controllerName, HashSet`1 namespaces) +256
   System.Web.Mvc.DefaultControllerFactory.GetControllerType(RequestContext requestContext, String controllerName) +651
   System.Web.Mvc.DefaultControllerFactory.System.Web.Mvc.IControllerFactory.GetControllerSessionBehavior(RequestContext requestContext, String controllerName) +57
   System.Web.Mvc.MvcRouteHandler.GetSessionStateBehavior(RequestContext requestContext) +208
   System.Web.Mvc.MvcRouteHandler.GetHttpHandler(RequestContext requestContext) +45
   System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +12040727
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +92

To give you a better idea of ​​the structure of my project, you can see the following link .

I know that the reference to the controllers of my main application is missing, but I don't know how to put them to avoid the error.

I want to display the names of people who don't have adepartamento

The data is:

+----+---------+----------------+    +----+--------------------+
| id | Nombre  | idDepartamento |    | id | NombreDepartamento |
+----+---------+----------------+    +----+--------------------+
| 44 | Daniel  |        1       |    | 1  |    Desarrollo      |
+----+---------+----------------+    +----+--------------------+
| 45 | Manuel  |        0       |    | 2  |   Contabilidad     |
+----+---------+----------------+    +----+--------------------+
| 47 |  Juan   |        0       |
+----+---------+----------------+
| 49 | Alfonso |        0       |
+----+---------+----------------+

I want to show them in a selecthtml using razor in asp.net -mvc-5

I have the following code:

<select class="form-control" name="UsuarioSelect" multiple>
  @{foreach (var departamento in Model.Departamentos)
  {
    <optgroup label="@departamento.Departamento"></optgroup>
    foreach (var empleado in Model.Empleados)
    {
      if (empleado.IdDepartamento == departamento.id)
      {
        <option value="@empleado.id">@empleado.Nombre</option>
      }
    }
  }}
</select>

But I have no idea how to show the users who don't have a department.

What do I need to add in my code to make them show up?

What I want to achieve is something like this:

$('select').select2({
  width: '50%'
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
<select class="Select2" multiple>
  <optgroup label='Desarrollo'></optgroup>
  <option value='44'>Daniel</option>
  <optgroup label='Contabilidad'></optgroup>
  <optgroup label='Sin Departaento'></optgroup>
  <option value='45'>Juan</option>
  <option value='47'>Manuel</option>
  <option value='49'>Alfonso</option>
</select>

I need to create elements in a way that is not too confusing and easy to maintain to make a change.

Currently I do it with this code with .append()and .html():

$('.Selector').append(
  '<div class="dropdown">'+
    '<ul class="dropdown-menu" aria-labelledby="dropdownMenu1">'+
      '<li><a href="#">Elemento Menu 1</a></li>'
    '</ul>'+
  '</div>'
)

But it's too confusing and difficult to maintain, or make tag changes.

Is there any other way to make it easier?

I have the following error when making publisha web page on iismy local machine, if I do debugit it works fine but not when publishing from Visual Studio, if I copy the project folder it works without any problem but I cannot pass the files to the server since there is no username or password for ftp, they already provided me with a file to publish from theVisual Studio

This is the error when opening http://localhost/ControlCobranza

Server error in the application '/ControlCobranza'.

Cannot load file or assembly 'Microsoft.AI.Web' or one of its dependencies. The system cannot find the specified file.

Description: Unhandled exception executing the current web request. Review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Cannot load file or assembly 'Microsoft.AI.Web' or one of its dependencies. The system cannot find the specified file.

Source code error:

An unhandled exception was thrown during the execution of the current web request. Information about the origin and location of the exception can be identified using the following exception stack trace.

Trace on Assembly Load: The following information may be helpful in determining why the 'Microsoft.AI.Web' assembly did not load.

AVS: Assembly binding logging is disabled. To enable assembly binding error logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is a performance penalty associated with assembly binding error logging. To disable this feature, delete the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Stack trace:

[FileNotFoundException: Cannot load file or assembly 'Microsoft.AI.Web' or one of its dependencies. The system cannot find the specified file.]
System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type) +0
System.RuntimeTypeHandle.GetTypeByName(String name , Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName) +106 System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +62
System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) +50 System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) +61
System.Web.Configuration.ConfigUtil.GetType(String typeName , String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) +53

[ConfigurationErrorsException: Cannot load file or assembly 'Microsoft.AI.Web' or one of its dependencies. The system cannot find the specified file.]
System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) +587
System.Web.Configuration.ConfigUtil.GetType( String typeName, String propertyName, ConfigurationElement configElement, Boolean checkAptcaBit) +33
System.Web.Configuration.Common.ModulesEntry.SecureGetType(String typeName, String propertyName, ConfigurationElement configElement) +57 System.Web.Configuration.Common.ModulesEntry..ctor(String name, String typeName, String propertyName, ConfigurationElement configElement) +54 System.Web.HttpApplication.BuildIntegratedModuleCollection(List`1 moduleList) +198
System.Web.HttpApplication.GetModuleCollection(IntPtr appContext) +1114 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +140
System .Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +402
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +343

[HttpException (0x80004005): Cannot load file or assembly 'Microsoft.AI.Web' or one of its dependencies. The system cannot find the specified file.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +539
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +125 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +731

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1586.0

I have a problem when I want to replace the last match one expresión regularby one textarea, I explain:

• If I write @in textareait, a menu opens where there are user names when selecting it, it auto-completes with the selected name.

• But if I write again @and select another user, replaceit is done in the first @.

• If I write @aand select a user, and I write again @aand select another user, it is correctly replaced in the last match.

How can I solve the second point?

var arrobaGato = "";
var $textarea = $('textarea');
var $btndropdown = $('.dropdown button');
/*Detectamos @, # o espacio*/
$textarea.on('keypress', function (evt) {
  if (evt.which == 64 || evt.which == 35) {
    arrobaGato = String.fromCharCode(evt.which);
    $btndropdown.dropdown('toggle');
  } else if (evt.which == 32) {
    arrobaGato = "";
    $('.dropdown.open').removeClass('open');
  }else if(arrobaGato != "" && !$('.dropdown').hasClass('open')){
    $btndropdown.dropdown('toggle');
  }
});
/*obtenemos el nombre seleccionado del menu*/
$('.dropdown li a').on('click', function(evt){
  evt.preventDefault();
  let txt = $textarea.val();
  let usr = $(this).text();
  let idusr = this.id;
  switch(arrobaGato){
    case "@":
      regex1 = /[\@][\w\.\-_]*/g
      matchs1 = txt.match(regex1);
      //console.log(matchs1)
      //console.log(matchs1[matchs1.length - 1])
      //console.log(matchs1.length)
      txt = txt.replace(matchs1[matchs1.length-1], "@" + usr + "~" + idusr + " ")
      break;
    case "#":
      regex2 = /[\#][\w\.\-_]*/g
      matchs2 = txt.match(regex2);
      txt = txt.replace(matchs2[matchs2.length-1], "#" + usr + "~" + idusr + " ")
      break;
  }
  match = [];
  arrobaGato = "";
  $textarea.val(txt);
});

textarea{
	border: 1px solid gray;
	height: 100px;
	min-width: 100%;
	max-width: 100%;
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">

<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
<!--<div contenteditable="true"></div>-->
<br/><br/><br/>
<textarea autofocus="true"></textarea>
<div class="dropdown">
<button id="dLabel" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" style="display: none;">
    Dropdown trigger
    <span class="caret"></span>
  </button>
  <ul class="dropdown-menu" aria-labelledby="dropdownMenu1">
    <li><a href="#" id='1'>User1</a></li>
    <li><a href="#" id='2'>User2</a></li>
    <li><a href="#" id='3'>User3</a></li>
    <li><a href="#" id='4'>User4</a></li>
  </ul>
</div>

I have a dropdownthat I want to position in the last character of the textarea, but I don't know how to achieve it, I have investigated how to capture the cursor position of the textareabut I have not found something useful and I have no idea how to do it

This is my code I have so far:

$(function(){
  $('textarea').on('keyup',function(evt){
    if(evt.which >= 96 && evt.which < 106){
      //console.log(String.fromCharCode(evt.which-48))
    }
    //console.log($('textarea').val());
    if($('div.dropdown').hasClass('open')){
      $('div.dropdown').removeClass('open');
    }else{
      $('div.dropdown').addClass('open');
    }
  })
});

textarea{
  border: 1px solid gray;
  height: 100px;
  min-width: 100%;
  max-width: 100%;
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>

<textarea></textarea>
<div class="dropdown open">
  <ul class="dropdown-menu" aria-labelledby="dropdownMenu1">
    <li><a href="#">Action</a></li>
    <li><a href="#">Another action</a></li>
    <li><a href="#">Something else here</a></li>
    <li role="separator" class="divider"></li>
    <li><a href="#">Separated link</a></li>
  </ul>
</div>

My expected result is this:

My concern is that I have a string in my database of the following form:

'<a href="#" id="Manuel">@Manuel</a>&nbsp;hola'

When I have it in my model it appears in the same way, and when I want to render the view it is shown as it is in the database, I do it in the following way:

<div>@Model.evento[0].Notas_Inicio</div>

How can I show it as if it belonged to DOMthe page?

I have a WebServiceto which I want to access its methods, I have searched but I have not found a solution on how to attack the service, I .svconly find services .asmx.

From c# I add the service reference and to use the method I do the following:

ServicioClient SClient = new ServicioClient();
Gestores_SesionResponse sesionRespuesta = null;
Gestores_SesionRequest datosSesion = new Gestores_SesionRequest(){
  Pwd = model.Password,
  UserName = model.UserName
};
SClient.dbGestores_Sesion(datosSesion, out sesionRespuesta);

But I want to attack the same service from jquery , I have tried as follows:

$.ajax({ 
  url: 'http://nombredominio.com.mx:1234/Service.svc/dbGestores_Sesion',
  data: '{"UserName":"usuario","Pwd":"123456"}',
  contentType: 'application/json; charset=utf-8',
  method: 'post',
  dataType: 'json',
  processdata: true,
  success: function (data) {
    console.log("exito");
    console.log(data);
  },
  error: function (result) {
    console.log("error");
    console.log(result);
  }
});

But when making the request it sends meerror 400

XMLHttpRequest cannot load http://domainname.com.mc:1234/service.svc/dbGestores_Session . Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin ' http://localhost:50478 ' is therefore not allowed access. The response had HTTP status code 400.

Where dbGestores_Sessionis the name of the method, and receives 2 username and password parameters, so how can I access my method WebService.svcfrom jquery ? And how can I get the data from the outone I use in c# with jquery ?

Note: If I access http://domainname.com.mc:1234/service.svc it shows me the service page but if I access this way http://domainname.com.mc:1234/service.svc/dbGestores_Session only show a blank page

I have a problem downloading a file with Internet Explorerany version. My problem is that I receive an array of bits from my controller which I receive in a JSONand download from javascript.

Note: I do not have a physical file on the server, this file is obtained from a storagethrough a WebService.

The code works fine in other browsers but not inInternet Explorer

$.ajax({
    type: 'POST',
    url: '/Portal/GetXML',
    data: $('#formDownload2' + id).serialize(),
    success: function (data) {
        if (data.error == "") {
            //aquí empieza la descarga del archivo
            var arr = data.Archivo;
            var byteArray = new Uint8Array(arr);
            var a = window.document.createElement('a');
            a.href = window.URL.createObjectURL(new Blob([byteArray], { type: 'application/octet-stream' }));
            a.download = data.Nombre;
            // Append anchor to body.
            document.body.appendChild(a)
            a.click();
            // Remove anchor from body
            document.body.removeChild(a)
        } else {
            $.jGrowl("" + data.error, {
                header: "Error",
                //sticky: true,
                theme: "red"
            });
        }
    }
});

All it does is download a file with a long name and no extension. On other computers with Internet Explorerdownload a file with extension:.JSON

Why is it that I download them that way? and how can I solve it?

I have a controller that sends me information to download a file, it currently sent the one jsonthat way

public JsonResult GetXML(DownloadModel model)
{
    JavaScriptSerializer serializer = new JavaScriptSerializer();
    Dictionary<string, byte[]> d = new Dictionary<string, byte[]>();
    if (getXML.GetXMLComprobante(datosXML, out respuestaXML))
    {
        byte[] archivoPDF = Convert.FromBase64String(respuestaXML.XMLB64);
        d.Add("pdf", archivoPDF);
        return Json(serializer.Serialize(d));
    }
}

and my problem comes when i want to add the file name

d.Add("nombre", "documento-de-prueba.pfd");

and in this case I would have to declare another dictionary to send it and I don't like this way of having to add more dictionaries to send multiple data anymore.

Is there any other way to send the Json?

I need to make a request ajaxto my controller after I have typed the search words in my inputde datatables.

The point I'm getting at is that it doesn't do the prompts for each character typed until a little time has passed since the last key was pressed.

This is my code how the table is declared

var table = $('#tableComprobantes').dataTable({
    "order": [[5, "desc"]],
    "sDom": "<'row'<'col-xs-6'l><'col-xs-6'f>r>t<'row'<'col-xs-6'i><'col-xs-6'p>>",
    "sPaginationType": "sangoma",
    "oLanguage": {
    "sLengthMenu": "_MENU_ comprobantes por página",
    "sInfo": "Mostrando _START_ a _END_ de _TOTAL_ comprobantes",
    "sInfoEmpty": "Sin comprobantes a mostrar",
    "sInfoFiltered": "(Filtrado de _MAX_ comprobantes totales)",
    "sSearch": "Filtro:",
        "sZeroRecords": "Sin comprobantes encontrados"
    },
    "bProcessing": true,
    "bServerSide": true,
    "sAjaxSource": "/Portal/listComprobantes",
    "fnRowCallback": function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {
        $('td:eq(7)', nRow).attr('align', 'center');
        $('td:eq(8)', nRow).attr('align', 'center');
        return nRow;
    },
    "aoColumns": [
        { "bSortable": false },
        { "bSortable": true },
        { "bSortable": true },
        { "bSortable": true },
        { "bSortable": true },
        { "bSortable": true },
        { "bSortable": true },
        { "bSortable": false },
        { "bSortable": false },
        { "bSortable": true }
    ]
});

I am trying to download a file from a url with ajax and asp.net mvc 5 this is my controller:

[HttpPost]
public ActionResult DownloadDocument(DownloadModel model){
   urlFile = "http://www.storage.net/data/pdf-xml/" + model.nombre.ToLower() + model.Extencion;
   //Create a stream for the file
   Stream stream = null;
   //This controls how many bytes to read at a time and send to the client
   int bytesToRead = 10000;
   // Buffer to read bytes in chunk size specified above
   byte[] buffers = new Byte[bytesToRead];
   // The number of bytes read
   try{
     //Create a WebRequest to get the file
     HttpWebRequest fileReq = (HttpWebRequest)HttpWebRequest.Create(urlFile);
     //Create a response for this request
     HttpWebResponse fileResp = (HttpWebResponse)fileReq.GetResponse();
     if (fileResp.ContentLength > 0)//aquí reviso si el archivo contiene datos (existe o no)
     {
       if (fileReq.ContentLength > 0)
         fileResp.ContentLength = fileReq.ContentLength;
       //Get the Stream returned from the response
       stream = fileResp.GetResponseStream();
       // prepare the response to the client. resp is the client Response
       //var resp = HttpContext.Current.Response;
       //Indicate the type of data being sent
       Response.ContentType = "application/octet-stream";
       //Name the file 
       Response.AddHeader("Content-Disposition", "attachment; filename=\"" + model.nombre + model.Extencion + "\"");
       Response.AddHeader("Content-Length", fileResp.ContentLength.ToString());
       int length;
       do{
         // Verify that the client is connected.
         if (Response.IsClientConnected){
           // Read data into the buffer.
           length = stream.Read(buffers, 0, bytesToRead);
           // and write it out to the response's output stream
           Response.OutputStream.Write(buffers, 0, length);
           // Flush the data
           Response.Flush();
           //Clear the buffer
           buffers = new Byte[bytesToRead];
         }else{
           // cancel the download if client has disconnected
           length = -1;
         }
       } while (length > 0); //Repeat until no data is read
     }
   }catch (Exception e){
     d2.Add("Error", e.Message);
   }finally{
     if (stream != null){
       //Close the input stream
       stream.Close();
     }else if (d2.Count < 1){
       d2.Add("Error", "El Archivo no existe");
     }
   }
   //mostramso el mensaje de que no existe el archivo
   return Json(serializer.Serialize(d2));
 }  

If the form is directed to the controller, it performs the download, but if a file did not exist, it would send me a message which I show in my view but it is shown in a separate view.
And I want the download to be done through jquery ajax since this is the way I can show the message, but the download does not appear in the browser
This is my form:

<form method="post" class="form-horizontal" role="form" name="formDownload" id="formDownload140464">
  <input type="hidden" value="AAA010101AAA" id="rfcCompany" name="rfcCompany">
  <input type="hidden" value="40464" id="id" name="id">
  <input type="hidden" value=".pdf" id="Extencion" name="Extencion">
  <input id="Nombre" name="Nombre">
  <button type="button" class="btn btn-primary btn-sm previewPopover" title="Descargar" onclick="MostrarMensaje(40464)">
    <span class="elusive icon-download-alt"></span>
  </button>
</form> 

My ajax function is this, I use it to display the message.

function MostrarMensaje(id) {
    $('#formDownload1' + id).on("submit", function (e) {
        e.preventDefault();
        $.ajax({
            type: 'POST',
            url: '/Portal/DownloadDocument',
            data: $('#formDownload1' + id).serialize(),
            success: function (data) {
                var d = JSON.parse(data);
                $.jGrowl("" + d["Error"], {
                    header: "Error",
                    //sticky: true,
                    theme: "red"
                });
            }
        });
    });
} 

With this the message is displayed but the download does not perform.
I have seen that many pass the url in the data and download with window.location.href = d["Url"];, but my problem here with this code is that I will not know if the file exists or not and it will download an empty file.

I have a problem when closing a modal, this problem does not always occur, well the detail is that the backdropmodal stays, I attached an image.

The modal is closed but backdropit remains, the way I am closing it is as follows:

$('#Agregar').formValidation({
    opciones..
}).on('success.form.fv', function (e) {
    // Prevent form submission
    e.preventDefault();

    $.ajax({
        type: "POST",
        url: "/VistaPopUp/modalAgregar",
        data: $("#Agregar").serialize(),
        dataType: "json",
        success: function (data) {
            Exito(data);
            $('#ModalAgregar').modal('hide');
        },//mostramos el mensaje de error o exito dependiendo del caso
        error: Error1
    });
});

After submitting the form, it returns a Json with text that if the insertion was validated or otherwise the error, this text is attached to an alert message for which I use Toastr to show them and then close the modal.

As I mentioned above, sometimes it closes correctly and sometimes the backdrop.

I already tried changing the way to close the modal with $('#ModalAgregar').modal('hide');and it still produces the same thing after several tries.

This is how my modal is defined:

<div class="modal fade" id="myModal" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close fui-cross" data-dismiss="modal" aria-hidden="true"></button>
        <h4 class="modal-title text-primary">Agregar Cita</h4>
      </div>
      <form class="form-horizontal" id="Agregar" role="form" style="margin-bottom: 0px;">
        <input name="Tipo" type="hidden" id="Tipo" />
        <div class="modal-body">
          <div class="form-group">
            <div class="col-sm-12">
              <input id="titulo" name="Descripcion" type="text" class="form-control" placeholder="*Título:" style="border: none; width: 100%;" required />
            </div>
          </div>
          <hr style="margin: 5px; border-top: 2px solid #e1ebe9" />
          <div class="form-group">
            <div class="col-sm-12">
              <textarea name="Notas_Inicio" placeholder="Notas:" class="form-control" rows="2" style="border: none; resize: none;" onkeypress="return hashtag(event);"></textarea>
            </div>
          </div>
        </div>
        <div class="modal-footer">
          <label class="text-primary" style="float: left;">*Datos requeridos</label>
          <button type="submit" class="btn btn-primary btn-sm">Guardar</button>
        </div>
      </form>
    </div>
  </div>
</div>