Exemplo n.º 1
0
        /// <summary>
        /// Obtiene las CxC cargadas a los PR
        /// </summary>
        /// <param name="authorized">Indica si se desean las CxC autorizadas</param>
        /// <param name="salesRoom">Clave de la sala de ventas</param>
        /// <param name="user">Clave de usuario</param>
        /// <param name="dateFrom">Fecha desde</param>
        /// <param name="dateTo">Fecha hasta</param>
        /// <param name="leadSource">Clave del Lead Source</param>
        /// <param name="personnel">Clave del PR</param>
        /// <returns>CxC cargadas a los PR</returns>
        /// <history>
        /// [michan] 01/Junio/2016 Created
        /// </history>
        public async static Task <List <CxCData> > GetCxC(bool authorized, string salesRoom, string user, DateTime?dateFrom, DateTime?dateTo, string leadSource = null, string personnel = null)
        {
            List <CxCData> cxcData = new List <CxCData>();
            await Task.Run(() => {
                using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString()))
                {
                    dbContext.Database.CommandTimeout = Settings.Default.USP_OR_GetCxC_Timeout;
                    cxcData = dbContext.USP_OR_GetCxC(authorized, salesRoom, user, dateFrom.Value, dateTo.Value, leadSource, personnel).ToList();
                }
            });

            return(cxcData);
        }