public ObservableCollection<UnidadMedidaModel> GetUnidadMedida(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<UnidadMedidaModel> unidades = new ObservableCollection<UnidadMedidaModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
( from res in entity.CAT_UNIDAD_MEDIDA
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res ).ToList().ForEach(row =>
{
unidades.Add(new UnidadMedidaModel()
{
IdUnidadMedida = row.IdUnidadMedida,
UnidadMedidaName=row.UnidadMedidaName,
UnidadMedidaShort=row.UnidadMedidaShort,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate
});
});
}
catch (Exception)
{
}
}
return unidades;
}
public ObservableCollection<AppSettingsModel> GetSettings(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<AppSettingsModel> result = new ObservableCollection<AppSettingsModel>();
try
{
using(var entity=new db_SeguimientoProtocolo_r2Entities())
{
(from item in entity.APP_SETTINGS
where item.LastModifiedDate >= LastModifiedDate || item.ServerLastModifiedDate >= ServerLastModifiedDate
select item).ToList().ForEach(row => {
result.Add(new AppSettingsModel() {
IdSettings = row.IdSettings,
SettingName=row.SettingName,
Value=row.Value,
LastModifiedDate=row.LastModifiedDate,
ServerLastModifiedDate=row.ServerLastModifiedDate
});
});
}
}
catch (Exception)
{
}
return result;
}
public ObservableCollection<EstructuraDependenciaModel> GetRelEstructuraDependencia(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<EstructuraDependenciaModel> result = new ObservableCollection<EstructuraDependenciaModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.REL_ESTRUCTURA_DEPENDENCIA
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
result.Add(new EstructuraDependenciaModel()
{
IdEstructuraDependencia = row.IdEstructuraDependencia,
IdDependencia = row.IdDependencia,
IdEstructura = row.IdEstructura,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate
});
});
}
}
catch (Exception)
{
}
return result;
}
public string GetJsonEstPuntoMed(long? Last_Modified_Date)
{
string res = null;
ObservableCollection<Model.EstPuntoMedModel> EstPuntoMed = new ObservableCollection<EstPuntoMedModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
(from o in entity.REL_EST_PUNTOMED
where o.LastModifiedDate > Last_Modified_Date
select o).ToList().ForEach(p =>
{
EstPuntoMed.Add(new Model.EstPuntoMedModel()
{
IdEstPuntoMed=p.IdEstPuntoMed,
IdEstructura=p.IdEstructura,
IdPuntoMedicion=p.IdEstPuntoMed,
IsActive = p.IsActive,
IsModified = p.IsModified,
LastModifiedDate = p.LastModifiedDate
});
});
if (EstPuntoMed.Count > 0)
res = SerializerJson.SerializeParametros(EstPuntoMed);
}
catch (Exception)
{
return res;
}
return res;
}
}
public bool UndadMedida_Update(string KeySesion, long IdUnidadMedida, string UnidadMedidaName, string UnidadMedidaShort)
{
bool res = true;
ObservableCollection<WAPP_USUARIO_SESION> Key = new ObservableCollection<WAPP_USUARIO_SESION>();
try
{
using (var entity_ = new db_SeguimientoProtocolo_r2Entities())
{
(from s in entity_.WAPP_USUARIO_SESION
where s.IdSesion == KeySesion
select s).ToList().ForEach(row =>
{
Key.Add(new WAPP_USUARIO_SESION()
{
IdUsuario = row.IdUsuario,
IdSesion = row.IdSesion
});
});
if (Key[0].IdSesion == KeySesion.ToString())
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
entity.SP_UnidadMedidaUpdate(IdUnidadMedida, UnidadMedidaName, UnidadMedidaShort);
}
}
}
}
catch (Exception ex)
{
var errr = ex.Message;
}
return res;
}
public ObservableCollection<AppUsuarioRolModel> GetAppUsuarioRol(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<AppUsuarioRolModel> appUsuarioRol = new ObservableCollection<AppUsuarioRolModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.APP_USUARIO_ROL
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
appUsuarioRol.Add(new AppUsuarioRolModel()
{
IdUsuario = row.IdUsuario,
IdRol = row.IdRol,
IsActive = row.IsActive,
LastModifiedDate = row.LastModifiedDate,
IsModified = row.IsModified,
ServerLastModifiedDate = row.ServerLastModifiedDate
});
});
}
}
catch (Exception)
{
}
return appUsuarioRol;
}
public ObservableCollection<WAPP_RECOVERY_PASS> Get_WAPP_RECOVERY_PASS(string Key)
{
ObservableCollection<WAPP_RECOVERY_PASS> res = new ObservableCollection<WAPP_RECOVERY_PASS>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from item in entity.WAPP_RECOVERY_PASS
where item.IdSesion == Key
select item).ToList().ForEach(row =>
{
res.Add(new WAPP_RECOVERY_PASS()
{
IdSesion = row.IdSesion,
IdUsuario = row.IdUsuario
});
});
}
}
catch (Exception ex)
{
var err = ex.Message;
}
return res;
}
public ObservableCollection<OperacionEstructuraModel> GetCatOperacionEstructura(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<OperacionEstructuraModel> result = new ObservableCollection<OperacionEstructuraModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.CAT_OPERACION_ESTRUCTURA
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
result.Add(new OperacionEstructuraModel()
{
IdOperacionEstructura = row.IdOperacionEstructura,
IdCondicion = row.IdCondicion,
IdEstructura = row.IdEstructura,
OperacionEstrucuturaName = row.OperacionEstrucuturaName,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate,
});
});
}
}
catch (Exception)
{
}
return result;
}
public ObservableCollection<ProtocoloModel> GetProtocolo(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<ProtocoloModel> result = new ObservableCollection<ProtocoloModel>();
try
{
using(var entity= new db_SeguimientoProtocolo_r2Entities())
{
(from items in entity.CAT_PROTOCOLO
where items.LastModifiedDate >= LastModifiedDate || items.ServerLastModifiedDate >= ServerLastModifiedDate
select items).ToList().ForEach(row =>
{
result.Add(new ProtocoloModel()
{
IdProtocolo = row.IdProtocolo,
IdPuntoMedicion = (long)row.IdPuntoMedicion,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate
});
});
}
}
catch (Exception)
{
}
return result;
}
public ObservableCollection<AccionActualModel> GetAccionActual(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<AccionActualModel> result = new ObservableCollection<AccionActualModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from item in entity.CAT_ACCION_ACTUAL
where item.LastModifiedDate >= LastModifiedDate || item.ServerLastModifiedDate >= ServerLastModifiedDate
select item).ToList().ForEach(row =>
{
result.Add(new AccionActualModel()
{
IdAccionActual=row.IdAccionActual,
AccionAcualName=row.AccionAcualName,
IsModified=row.IsModified,
IsActive=row.IsActive,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate
});
});
}
}
catch (Exception)
{
}
return result;
}
public ObservableCollection<EstPuntoMedModel> GetRelEstPuntoMed(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<EstPuntoMedModel> result = new ObservableCollection<EstPuntoMedModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.REL_EST_PUNTOMED
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
result.Add(new EstPuntoMedModel()
{
IdEstPuntoMed = row.IdEstPuntoMed,
IdEstructura = row.IdEstructura,
IdPuntoMedicion = row.IdPuntoMedicion,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate,
});
});
}
}
catch (Exception)
{
}
return result;
}
public string GetJsonTipoPuntoMedicion(long? Last_Modified_Date)
{
string res = null;
ObservableCollection<Model.TipoPuntoMedicionModel> TipoPuntoMedicion = new ObservableCollection<Model.TipoPuntoMedicionModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
(from o in entity.CAT_TIPO_PUNTO_MEDICION
where o.LastModifiedDate > Last_Modified_Date
select o).ToList().ForEach(p =>
{
TipoPuntoMedicion.Add(new Model.TipoPuntoMedicionModel()
{
IdTipoPuntoMedicion=p.IdTipoPuntoMedicion,
TipoPuntoMedicionName=p.TipoPuntoMedicionName,
IsActive = p.IsActive,
IsModified = p.IsModified,
LastModifiedDate = p.LastModifiedDate
});
});
if (TipoPuntoMedicion.Count > 0)
res = SerializerJson.SerializeParametros(TipoPuntoMedicion);
}
catch (Exception)
{
return res;
}
return res;
}
}
public AjaxDictionary<string, object> GetNivelLluvia()
{
AjaxDictionary<string, object> res = new AjaxDictionary<string, object>();
try
{
using (var entity=new db_SeguimientoProtocolo_r2Entities())
{
(from s in entity.CAT_NIVEL_LLUVIA
where s.IsActive == true
select s).ToList().ForEach(i =>
{
AjaxDictionary<string, object> tmp = new AjaxDictionary<string, object>();
tmp.Add("idNivel", i.IdNivelLluvia);
tmp.Add("rangoMax", i.RangMax);
tmp.Add("rangoMin", i.RangoMin);
tmp.Add("intensidadName", i.IntensidadName);
tmp.Add("imagen", i.Imagen);
res.Add("N" + i.RangoMin + "_" + i.RangMax, tmp);
});
}
}
catch (Exception ex)
{
}
return res;
}
public ObservableCollection<CatPuntosMedicionShortNameModel> GetItems(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<CatPuntosMedicionShortNameModel> items = new ObservableCollection<CatPuntosMedicionShortNameModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.CAT_PUNTOS_MEDICION_SHORTNAME
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
items.Add(new CatPuntosMedicionShortNameModel()
{
IdShortName = row.IdShortName,
IdPuntoMedicion = (long)row.IdPuntoMedicion,
ShortName = row.ShortName,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate,
});
});
}
}
catch (Exception)
{
}
return items;
}
public string GetJsonDependencia(long? Last_Modified_Date)
{
string res = null;
ObservableCollection<Model.DependenciaModel> dependencia = new ObservableCollection<Model.DependenciaModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
(from o in entity.CAT_DEPENDENCIA
where o.LastModifiedDate > Last_Modified_Date
select o).ToList().ForEach(p =>
{
dependencia.Add(new Model.DependenciaModel()
{
IdDependencia = p.IdDependencia,
DependenciaName = p.DependenciaName,
IsActive = p.IsActive,
IsModified = p.IsModified,
LastModifiedDate = p.LastModifiedDate
});
});
if (dependencia.Count > 0)
res = SerializerJson.SerializeParametros(dependencia);
}
catch (Exception)
{
return res;
}
return res;
}
}
public string GetJsonCondPro(long? Last_Modified_Date)
{
string res = null;
ObservableCollection<Model.CondProModel> CondPro = new ObservableCollection<Model.CondProModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
(from o in entity.CAT_CONDPRO
where o.LastModifiedDate > Last_Modified_Date
select o).ToList().ForEach(p =>
{
CondPro.Add(new Model.CondProModel()
{
IdCondicion = p.IdCondicion,
CondicionName = p.CondicionName,
PathCodicion = p.PathCodicion,
IsActive = p.IsActive,
IsModified = p.IsModified,
LastModifiedDate = p.LastModifiedDate
});
});
if (CondPro.Count > 0)
res = SerializerJson.SerializeParametros(CondPro);
}
catch (Exception)
{
return res;
}
return res;
}
}
public ObservableCollection<ModifiedDataModel> getModifiedDate()
{
ObservableCollection<ModifiedDataModel> modifiedDate = new ObservableCollection<ModifiedDataModel>();
using(var entity=new db_SeguimientoProtocolo_r2Entities())
{
try
{
( from res in entity.MODIFIEDDATAs
select res ).ToList().ForEach(row => {
modifiedDate.Add(new ModifiedDataModel()
{
IdModifiedData=row.IdModifiedData,
IdSyncTable=row.IdSyncTable,
IsModified=row.IsModified,
ServerModifiedDate=row.ServerModifiedDate
});
});
}
catch (Exception)
{
}
}
return modifiedDate;
}
public IEnumerable<Model.GdDatosEstructurasModel> GetData()
{
ObservableCollection<Model.GdDatosEstructurasModel> oc=new ObservableCollection<Model.GdDatosEstructurasModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from o in entity.SpGdGetDatosEstructuras2()
select o).ToList().ForEach(r =>
{
oc.Add(
new Model.GdDatosEstructurasModel()
{
NombreColumna = r.NombreColumna
,
NumeroColumna = (int)r.NumeroColumna
,
NumeroFila = (int)r.RowNum
,
Valor = r.Valor
}
);
});
}
return oc;
}
public string GetJsonUnidadMedida(long? Last_Modified_Date)
{
string res = null;
ObservableCollection<Model.UnidadMedidaModel> UnidadMedida = new ObservableCollection<Model.UnidadMedidaModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
(from o in entity.CAT_UNIDAD_MEDIDA
where o.LastModifiedDate > Last_Modified_Date
select o).ToList().ForEach(p =>
{
UnidadMedida.Add(new Model.UnidadMedidaModel()
{
IdUnidadMedida=p.IdUnidadMedida,
UnidadMedidaName=p.UnidadMedidaName,
UnidadMedidaShort=p.UnidadMedidaShort,
IsActive = p.IsActive,
IsModified = p.IsModified,
LastModifiedDate = p.LastModifiedDate
});
});
if (UnidadMedida.Count > 0)
res = SerializerJson.SerializeParametros(UnidadMedida);
}
catch (Exception)
{
return res;
}
return res;
}
}
public ObservableCollection<AgrupadorIsiyetasModel> GetCatAgrupadorIsoyetas(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<AgrupadorIsiyetasModel> result = new ObservableCollection<AgrupadorIsiyetasModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.CAT_AGRUPADOR_ISOYETA
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
result.Add(new AgrupadorIsiyetasModel()
{
IdAgrupadorIsoyeta = row.IdAgrupadorIsoyeta,
AgrupadorIsoyetaName = row.AgrupadorIsoyetaName,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate,
});
});
}
}
catch (Exception)
{
}
return result;
}
public ObservableCollection<LinksModel> GetCatLinks(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<LinksModel> result = new ObservableCollection<LinksModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.CAT_LINKS
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
result.Add(new LinksModel()
{
IdLink = row.IdLink,
LinkUrl = row.LinkUrl,
LinkName = row.LinkName,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate = row.ServerLastModifiedDate
});
});
}
}
catch (Exception)
{
}
return result;
}
public List<CiRegistroUploadConfirmationModel> CommitBulkUpsertUploaded(long session)
{
List<CiRegistroUploadConfirmationModel> confirmation = new List<CiRegistroUploadConfirmationModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
List<spCommitBulkUpsertCiRegistroUploaded_Result> res = entity.spCommitBulkUpsertCiRegistroUploaded(session).ToList();
if (res != null && res.Count > 0)
{
res.ForEach(o =>
{
confirmation.Add(new CiRegistroUploadConfirmationModel()
{
IdRegistro=Int64.Parse( o.FechaNumerica.ToString()+o.IdPuntoMedicion.ToString() ),
IdPuntoMedicion = o.IdPuntoMedicion,
FechaNumerica = (long)o.FechaNumerica,
LMD = o.LastModifiedDate,
SLMD = (long)o.ServerLastModifiedDate
});
});
}
}
}
catch (Exception)
{
throw;
}
return confirmation;
}
public ObservableCollection<PuntoMedicionMaxMinModel> GetCatPuntoMedicionMaxMin(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<PuntoMedicionMaxMinModel> result = new ObservableCollection<PuntoMedicionMaxMinModel>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from res in entity.CAT_PUNTO_MEDICION_MAX_MIN
where res.LastModifiedDate >= LastModifiedDate || res.ServerLastModifiedDate >= ServerLastModifiedDate
select res).ToList().ForEach(row =>
{
result.Add(new PuntoMedicionMaxMinModel()
{
IdPuntoMedicionMaxMin = row.IdPuntoMedicionMaxMin,
IdPuntoMedicion = row.IdPuntoMedicion,
Max = row.Max,
Min = row.Min,
ServerLastModifiedDate = row.ServerLastModifiedDate,
LastModifiedDate = row.LastModifiedDate
});
});
}
}
catch (Exception)
{
}
return result;
}
public bool OperationEstruct_Update(string KeySesion, string IdOperacionEstructura, long IdCondicion, long IdEstructura, string OperacionEstrucuturaName)
{
bool res = true;
ObservableCollection<WAPP_USUARIO_SESION> Key = new ObservableCollection<WAPP_USUARIO_SESION>();
try
{
using (var entity_ = new db_SeguimientoProtocolo_r2Entities())
{
(from s in entity_.WAPP_USUARIO_SESION
where s.IdSesion == KeySesion
select s).ToList().ForEach(row =>
{
Key.Add(new WAPP_USUARIO_SESION()
{
IdUsuario = row.IdUsuario,
IdSesion = row.IdSesion
});
});
if (Key[0].IdSesion == KeySesion.ToString())
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
entity.SP_OperEstructurasUpdate(IdOperacionEstructura, IdCondicion, IdEstructura, OperacionEstrucuturaName);
}
}
}
}
catch (Exception ex)
{
var errr = ex.Message;
}
return res;
}
public Model.UploadLogModel InsertUploadLogServer(Model.UploadLogModel uploadLog)
{
Model.UploadLogModel res;
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
CAT_UPLOAD_LOG ull = new CAT_UPLOAD_LOG()
{
IdUploadLog = new UNID().getNewUNID(),
IdUsuario = uploadLog.IdUsuario,
IpDir = uploadLog.IpDir,
Msg = uploadLog.Msg,
PcName = uploadLog.PcName
};
entity.CAT_UPLOAD_LOG.AddObject(ull);
entity.SaveChanges();
res = new Model.UploadLogModel()
{
IdUploadLog = ull.IdUploadLog,
IdUsuario = ull.IdUsuario,
IpDir = ull.IpDir,
Msg = ull.Msg,
PcName = ull.PcName
};
return res;
}
}
// Servidor
public string GetJsonSistema(long? Last_Modified_Date)
{
string res = null;
ObservableCollection<Model.SistemaModel> Sistemas = new ObservableCollection<Model.SistemaModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
(from o in entity.CAT_SISTEMA
where o.LastModifiedDate > Last_Modified_Date
select o).ToList().ForEach(p =>
{
Sistemas.Add(new Model.SistemaModel()
{
IdSistema = p.IdSistema,
SistemaName = p.SistemaName,
IsActive = p.IsActive,
IsModified = p.IsModified,
LastModifiedDate = p.LastModifiedDate
});
});
if (Sistemas.Count > 0)
res = SerializerJson.SerializeParametros(Sistemas);
}
catch (Exception)
{
return res;
}
return res;
}
}
public ObservableCollection<CondProModel> GetCondicion(long LastModifiedDate, long ServerLastModifiedDate)
{
ObservableCollection<CondProModel> condiciones = new ObservableCollection<CondProModel>();
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
try
{
( from res in entity.CAT_CONDPRO
where res.LastModifiedDate>=LastModifiedDate || res.ServerLastModifiedDate>=ServerLastModifiedDate
select res ).ToList().ForEach(row => {
condiciones.Add(new CondProModel()
{
IdCondicion = row.IdCondicion,
CondicionName = row.CondicionName,
PathCodicion = row.PathCodicion,
IsActive = row.IsActive,
IsModified = row.IsModified,
LastModifiedDate = row.LastModifiedDate,
ServerLastModifiedDate=row.ServerLastModifiedDate
});
});
}
catch (Exception)
{
}
}
return condiciones;
}
public ObservableCollection<CAT_OPERACION_ESTRUCTURA_V2_Model> Get_CatOperacionSobreEstructuras()
{
ObservableCollection<CAT_OPERACION_ESTRUCTURA_V2_Model> res = new ObservableCollection<CAT_OPERACION_ESTRUCTURA_V2_Model>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
(from item in entity.CAT_OPERACION_ESTRUCTURA_V2
select item).ToList().ForEach(row =>
{
res.Add(new CAT_OPERACION_ESTRUCTURA_V2_Model()
{
IdCondicion = row.IdCondicion,
IdEstructura = row.IdEstructura,
OperacionEstrucuturaName = row.OperacionEstrucuturaName
});
});
}
}
catch (Exception ex)
{
var err = ex.Message;
}
return res;
}
public bool Dependencia_Insert(string KeySesion, string DependenciaName)
{
bool res = true;
ObservableCollection<WAPP_USUARIO_SESION> Key = new ObservableCollection<WAPP_USUARIO_SESION>();
try
{
using (var entity_ = new db_SeguimientoProtocolo_r2Entities())
{
(from s in entity_.WAPP_USUARIO_SESION
where s.IdSesion == KeySesion
select s).ToList().ForEach(row =>
{
Key.Add(new WAPP_USUARIO_SESION()
{
IdUsuario = row.IdUsuario,
IdSesion = row.IdSesion
});
});
if (Key[0].IdSesion == KeySesion.ToString())
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
entity.SP_DependenciaInsert(DependenciaName);
}
}
}
}
catch (Exception ex)
{
var errr = ex.Message;
}
return res;
}
public AjaxDictionary<string, object> Get_CatUrl()
{
AjaxDictionary<string, object> result = new AjaxDictionary<string, object>();
try
{
using (var entity = new db_SeguimientoProtocolo_r2Entities())
{
//entity.wappSpAttemptLogUser("", "", true).ToList();
List<spGetHashablePuntoMedicion_Result> res = entity.spGetHashablePuntoMedicion().ToList();
int i = 0;
(from s in entity.CAT_LINKS
where s.IsActive == true
select s).ToList().ForEach(row =>
{
AjaxDictionary<string, object> item = new AjaxDictionary<string, object>();
item.Add("idUrl", row.IdLink);
item.Add("Url", row.LinkUrl);
item.Add("IsActive", row.IsActive);
item.Add("DescriptionUrl", row.LinkName);
result.Add("Result" + i.ToString(),item);
i++;
});
}
}
catch (Exception ex)
{
var err = ex.Message;
}
return result;
}
