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;
}
}