private void InitTarifario(Tarifario entity, double?importe = null, string oi = null)
{
var tarifas = FCMediosClient.Get <IList <TarifaFcMedios> >(GetTarifasAction)
.Where(e => e.cod_vehiculo == entity.Vehiculo.Codigo).ToList();
var actualMedios = PdmContext.Medios.ToList();
var actualPlazas = PdmContext.Plazas.ToList();
var actualVehiculos = PdmContext.Vehiculos.ToList();
#region Tarifas
var toAdd = new List <Entities.Tarifa>();
tarifas.ForEach(t =>
{
var medio = actualMedios.Single(e => e.Codigo == t.cod_medio);
var plaza = actualPlazas.Single(e => e.Codigo == t.cod_plaza);
var vehiculo = actualVehiculos.Single(e => e.Codigo == t.cod_vehiculo);
toAdd.Add(new Entities.Tarifa
{
CodigoPrograma = t.cod_programa,
Descripcion = t.espacio,
HoraDesde = t.hora_inicio,
HoraHasta = t.hora_fin,
Importe = importe ?? t.bruto,
OrdenDeCompra = oi,
ImporteOld = t.bruto,
Lunes = t.Lunes,
Martes = t.Martes,
Miercoles = t.Miercoles,
Jueves = t.Jueves,
Viernes = t.Viernes,
Sabado = t.Sabado,
Domingo = t.Domingo,
Medio = medio,
Plaza = plaza,
Tarifario = entity,
Vehiculo = vehiculo,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true,
Estado = t.bruto > 0 ? EstadoTarifa.PendienteAprobacion : EstadoTarifa.SinTarifaAsociada
});
});
entity.Estado = toAdd.All(tt => tt.Estado == EstadoTarifa.PendienteAprobacion)
? EstadoTarifario.PendienteAprobacion
: EstadoTarifario.Editable;
PdmContext.Configuration.AutoDetectChangesEnabled = false;
toAdd.ForEach(e => PdmContext.Tarifas.Add(e));
PdmContext.SaveChanges();
PdmContext.Configuration.AutoDetectChangesEnabled = true;
PdmContext = new PDMContext();
#endregion
}
public BaseAdmin()
{
PdmContext = new PDMContext();
FCMediosClient = new JsonServiceClient(FcMediosTarifarioUrl);
//FCMediosclient.Credentials = NetWorkCredential;
//FCMediosclient.Proxy = WebProxy;
try
{
if (HttpContext.Current != null && HttpContext.Current.Request.IsAuthenticated)
{
UsuarioLogged = HttpContext.Current.User.Identity.Name;
}
}
catch (Exception)
{
}
}
public PressureTestController(PDMContext context)
{
_db = context;
}
public PhotoRepository()
{
context = new PDMContext();
}
public ProductModelRepository()
{
context = new PDMContext();
}
public WellProdDayCompactController(ILogger <WellProdDayCompactController> logger, PDMContext context)
{
_logger = logger;
_db = context;
}
public WellBoreMasterController(PDMContext context)
{
_db = context;
}
public TracerProdController(PDMContext context)
{
_db = context;
}
public StreamMasterController(PDMContext context)
{
_db = context;
}
public IonCombController(PDMContext context, ILoggerFactory loggerFactory)
{
_db = context;
_logger = loggerFactory.CreateLogger("IonCombController");
}
public StreamAllocBalanceDayController(PDMContext context, ILoggerFactory loggerFactory)
{
_db = context;
_logger = loggerFactory.CreateLogger("StreamAllocBalanceDayController");
}
public ImsTagMappingController(PDMContext context)
{
_db = context;
}
public StreamPcAllocDayController(PDMContext context)
{
_db = context;
}
public FlowlineMasterController(PDMContext context)
{
_db = context;
}
public ProductCategoryRepository()
{
context = new PDMContext();
}
public void SyncTablasBasicas()
{
var serviceSync = PdmContext.ServiceSyncs.FirstOrDefault();
if (serviceSync != null && !serviceSync.MustSync)
{
return;
}
if (serviceSync == null)
{
serviceSync = new ServiceSync
{
CreateDate = DateTime.Now,
Enabled = true,
CreatedBy = UsuarioLogged
};
PdmContext.ServiceSyncs.Add(serviceSync);
}
serviceSync.LastBaseTablesSync = DateTime.Now;
var tarifas = FCMediosClient.Get <IList <TarifaFcMedios> >(GetTarifasAction);
#region Base
var actualMedios = PdmContext.Medios.ToList();
var actualPlazas = PdmContext.Plazas.ToList();
var actualVehiculos = PdmContext.Vehiculos.ToList();
var serviceMedios = tarifas.Select(e => new { Codigo = e.cod_medio, Descripcion = e.des_medio }).Distinct().ToList();
var servicePlazas = tarifas.Select(e => new { Codigo = e.cod_plaza, Descripcion = e.des_plaza }).Distinct().ToList();
var serviceVehiculos = tarifas.Select(e => new { Codigo = e.cod_vehiculo, Descripcion = e.des_vehiculo }).Distinct().ToList();
#region Medios
serviceMedios.ForEach(t =>
{
var medio = actualMedios.FirstOrDefault(e => e.Codigo == t.Codigo);
if (medio == null)
{
medio = new Entities.Medio
{
Codigo = t.Codigo,
Descripcion = t.Descripcion,
Nombre = t.Descripcion,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true
};
PdmContext.Medios.Add(medio);
}
else
{
medio.Descripcion = t.Descripcion;
medio.UpdateDate = DateTime.Now;
medio.UpdatedBy = App.ImportUser;
}
});
#endregion
#region Plazas
servicePlazas.ForEach(t =>
{
var plaza = actualPlazas.FirstOrDefault(e => e.Codigo == t.Codigo);
if (plaza == null)
{
plaza = new Entities.Plaza
{
Codigo = t.Codigo,
Descripcion = t.Descripcion,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true
};
PdmContext.Plazas.Add(plaza);
}
else
{
plaza.Descripcion = t.Descripcion;
plaza.UpdateDate = DateTime.Now;
plaza.UpdatedBy = App.ImportUser;
}
});
#endregion
#region Vehiculos
serviceVehiculos.ForEach(t =>
{
var vehiculo = actualVehiculos.FirstOrDefault(e => e.Codigo == t.Codigo);
if (vehiculo == null)
{
vehiculo = new Entities.Vehiculo
{
Codigo = t.Codigo,
Descripcion = t.Descripcion,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true,
Nombre = t.Descripcion
};
PdmContext.Vehiculos.Add(vehiculo);
}
else
{
vehiculo.Nombre = t.Descripcion;
vehiculo.Descripcion = t.Descripcion;
vehiculo.UpdateDate = DateTime.Now;
vehiculo.UpdatedBy = App.ImportUser;
}
});
#endregion
#endregion
PdmContext.Configuration.AutoDetectChangesEnabled = false;
PdmContext.SaveChanges();
PdmContext.Configuration.AutoDetectChangesEnabled = true;
PdmContext = new PDMContext();
}
public FacilityOpCommentsController(PDMContext context, IUserProvider userProvider, ILoggerFactory loggerFactory)
{
_db = context;
_userProvider = userProvider;
_logger = loggerFactory.CreateLogger("FacilityOpCommentsController");
}
public StreamMeasDayController(PDMContext context, IUserProvider userProvider, ILoggerFactory loggerFactory)
{
_db = context;
_userProvider = userProvider;
_logger = loggerFactory.CreateLogger("StreamMeasDayController");
}
public TracerInjController(PDMContext context)
{
_db = context;
}
public WellEventController(PDMContext context, IUserProvider userProvider, ILoggerFactory loggerFactory)
{
_db = context;
_userProvider = userProvider;
_logger = loggerFactory.CreateLogger("WellEventController");
}
public FieldMasterController(ILogger <FieldMasterController> logger, PDMContext context)
{
_logger = logger;
_db = context;
}
public void SyncTablasBasicas(IList <PautaFcMedios> pautas)
{
#region Base
var actualMedios = PdmContext.Medios.ToList();
var actualPlazas = PdmContext.Plazas.ToList();
var actualVehiculos = PdmContext.Vehiculos.ToList();
var serviceMedios = pautas.Select(e => new { Codigo = e.cod_medio, Descripcion = e.des_medio }).Distinct().ToList();
var servicePlazas = pautas.Select(e => new { Codigo = e.cod_plaza, Descripcion = e.des_plaza }).Distinct().ToList();
var serviceVehiculos = pautas.Select(e => new { Codigo = e.cod_vehiculo, Descripcion = e.des_vehiculo }).Distinct().ToList();
#region Medios
serviceMedios.ForEach(t =>
{
var medio = actualMedios.FirstOrDefault(e => e.Codigo == t.Codigo);
if (medio == null)
{
medio = new Entities.Medio
{
Codigo = t.Codigo,
Descripcion = t.Descripcion,
Nombre = t.Descripcion,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true
};
PdmContext.Medios.Add(medio);
}
else
{
medio.Descripcion = t.Descripcion;
medio.UpdateDate = DateTime.Now;
medio.UpdatedBy = App.ImportUser;
}
});
#endregion
#region Plazas
servicePlazas.ForEach(t =>
{
var plaza = actualPlazas.FirstOrDefault(e => e.Codigo == t.Codigo);
if (plaza == null)
{
plaza = new Entities.Plaza
{
Codigo = t.Codigo,
Descripcion = t.Descripcion,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true
};
PdmContext.Plazas.Add(plaza);
}
else
{
plaza.Descripcion = t.Descripcion;
plaza.UpdateDate = DateTime.Now;
plaza.UpdatedBy = App.ImportUser;
}
});
#endregion
#region Vehiculos
serviceVehiculos.ForEach(t =>
{
var vehiculo = actualVehiculos.FirstOrDefault(e => e.Codigo == t.Codigo);
if (vehiculo == null)
{
vehiculo = new Entities.Vehiculo
{
Codigo = t.Codigo,
Descripcion = t.Descripcion,
CreateDate = DateTime.Now,
CreatedBy = App.ImportUser,
Enabled = true,
Nombre = t.Descripcion
};
PdmContext.Vehiculos.Add(vehiculo);
}
else
{
vehiculo.Nombre = t.Descripcion;
vehiculo.Descripcion = t.Descripcion;
vehiculo.UpdateDate = DateTime.Now;
vehiculo.UpdatedBy = App.ImportUser;
}
});
#endregion
#endregion
PdmContext.Configuration.AutoDetectChangesEnabled = false;
PdmContext.SaveChanges();
PdmContext.Configuration.AutoDetectChangesEnabled = true;
PdmContext = new PDMContext();
}
public StreamAccMonthController(PDMContext context)
{
_db = context;
}
public WellPerformanceCurveController(PDMContext context)
{
_db = context;
}
public IonController(PDMContext context)
{
_db = context;
}
public DefermentDayController(PDMContext context, IUserProvider userProvider, ILoggerFactory loggerFactory)
{
_db = context;
_userProvider = userProvider;
_logger = loggerFactory.CreateLogger("DefermentDayController");
}
public FacilityMasterController(PDMContext context)
{
_db = context;
}
