private void Login(object sender, EventArgs e) { BaseControl.OpenForm(new LoginForm(), true); if (BaseControl.UserId > 0) { VisibleMenuItem(true); LoginButtons(false); tsDate.Text = DateTime.Now.ToString("dddd, yyyy-MMM-d"); tsUser.Text = BaseControl.UserLogin; tsCorporate.Text = BaseControl.CorporateName; var runningText = new RunningTextDataManager().GetRunningText(WhereTerm.Default(1, "announcement_type", EnumSqlOperator.Equals)); var text = ConfigurationManager.AppSettings["DefaultAnnouncement"]; if (DynamicQueryable.Any(runningText)) { var rFranchise = runningText.FirstOrDefault(r => r.CorporateId == BaseControl.CorporateId); if (rFranchise != null) { text = rFranchise.Name; } var rDate = runningText.FirstOrDefault(r => r.FromDate >= DateTime.Now && r.ToDate <= DateTime.Now && r.FromHour >= DateTime.Now.Hour && r.FromMinute >= DateTime.Now.Minute && r.ToHour <= DateTime.Now.Minute && r.ToMinute <= DateTime.Now.Minute); if (rDate != null) { text = rDate.Name; } } tsAnnouncement.MarqueeText = text; tsAnnouncement.Interval = 300; Authorization.FilterToolstripMenu(ms.Items); } }
private void SeedData(IApplicationBuilder app) { using (var serviceScope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope()) { var configurationContext = serviceScope.ServiceProvider.GetRequiredService <ConfigurationDbContext>(); if (!DynamicQueryable.Any(configurationContext.ApiResources)) { // In the simple case an API has exactly one scope. But there are cases where you might want to sub-divide the functionality of an API, and give different clients access to different parts. configurationContext.ApiResources.Add(new ApiResource() { Enabled = true, Scopes = new List <ApiScope>() { new ApiScope() { Name = "nop_api", DisplayName = "nop_api" } }, Name = "nop_api" }); configurationContext.SaveChanges(); TryRunUpgradeScript(configurationContext); } } }
private static Proyectos GetUltimoProyecto() { NegocioDataContext aDataContext = new NegocioDataContext(); ConfiguracionGeneral configuracion = DynamicQueryable.FirstOrDefault(aDataContext.ConfiguracionGeneral); var proyectosdelAnno = aDataContext.Proyectos.Where(c => c.Anno == configuracion.AnnoDeTrabajo); if (DynamicQueryable.Any(proyectosdelAnno)) { Proyectos ultimoProyecto = DynamicQueryable.FirstOrDefault(proyectosdelAnno.OrderByDescending(c => c.Consecutivo)); return(ultimoProyecto); } return(null); }
private void Cueentas_gridView_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { var cuenta = (CuentasBancariasDeCliente)e.Row; //obtengo una cuenta que tenga la misma moneda si existe tambien devuelvo falso de lo contrario true var cuentaDiferenteConIgualMoneda = AGlobalDataContext.CuentasBancariasDeCliente.Where(c => c.ControlClienteId == AControlClientesId && c.TipoMonedaId == cuenta.TipoMonedaId && c.CuentaBancariaID != cuenta.CuentaBancariaID); e.Valid = !DynamicQueryable.Any(cuentaDiferenteConIgualMoneda); if (e.Valid) { return; } e.ErrorText = "No pueden haber dos cuentas para la misma moneda, Desea Corregir el valor ?"; Cuentas_gridView.SetColumnError(colTipoMonedaId, "No pueden haber dos cuentas para la misma moneda"); //Si se esta actualizando una cuenta y coincide que ya habia otra cuenta configurada con la misma moneda no lo permito }
public virtual void testQueryWithReadPermissionOnOneTaskProcess() { // given createGrantAuthorization(Resources.ProcessDefinition, ONE_TASK_PROCESS_KEY, userId, Permissions.Read); // when IQueryable <IProcessDefinitionStatistics> query = managementService.CreateProcessDefinitionStatisticsQuery(); // then //verifyQueryResults(query, 1); IProcessDefinitionStatistics statistics = query.First(); Assert.AreEqual(ONE_TASK_PROCESS_KEY, statistics.Key); Assert.AreEqual(0, statistics.Instances); Assert.AreEqual(0, statistics.FailedJobs); Assert.True(!DynamicQueryable.Any(statistics.IncidentStatistics)); }
public async Task <IList <int> > GetSelectColumnOnlyAsync(IEnumerable <Filter> filters, string selectProperty) { using (_context) { IQueryable <T> query = _dbset; var conditionAttributes = typeof(T).GetCustomAttributes(typeof(ConditionAttribute), false).Cast <ConditionAttribute>().ToList(); foreach (var attribute in conditionAttributes) { var func = LambdaConstructor <T>(attribute.ColumnName, attribute.Condition, FilterType.Equal); query = query.Where(func); } if (filters != null) { foreach (var filter in filters) { if (filter.Values != null && filter.Values.Any()) { query = query.Where(filter.FilterProperty, filter.Values, filter.FilterType); } else if (filter.Value != null) { query = query.Where(LambdaConstructor <T>(filter.FilterProperty, filter.Value, filter.FilterType)); } } } var any = DynamicQueryable.Any(query); if (any) { return(await query.AsNoTracking().Select(selectProperty).ToListAsync()); } return(new List <int>()); } }
public static Int32 GetProximoConsecutivo() { try { using (NegocioDataContext dc = new NegocioDataContext()) { Int32 annoDeTrabajo = ConfiguracionGeneral.EsCierre? ConfiguracionGeneral.Anno - 1:ConfiguracionGeneral.Anno; var nominas = dc.Nomina.Where(c => c.Anno == annoDeTrabajo); if (DynamicQueryable.Any(nominas)) { var ultConsecutivo = DynamicQueryable.FirstOrDefault(nominas.OrderByDescending(c => c.Consecutivo)).Consecutivo; return(ultConsecutivo + 1); } return(1); } } catch (Exception) { return(0); throw; } }