public IQueryable <KeyValue> GetTypeDoc()
{
List <KeyValue> CsReturn = new List <KeyValue>();
try
{
using (MyRoomDigEntities dbContext = new MyRoomDigEntities())
{
var lsTemp = (from TD in db.tipdocs
select TD).ToList();
foreach (var item in lsTemp)
{
CsReturn.Add(new KeyValue
{
id = item.id,
name = item.name,
nameAux = item.sigla
});
}
}
}
catch (Exception ex)
{
}
return(CsReturn.AsQueryable());
}
public IQueryable <EvidenciasModel> GetClients(string identification, int idTypeDoc)
{
List <EvidenciasModel> CsReturn = new List <EvidenciasModel>();
try
{
using (MyRoomDigEntities dbContext = new MyRoomDigEntities())
{
var lsTemp = (from C in db.clientes
where C.id == identification && C.tipodoc == idTypeDoc
select new
{
IdTercero = C.idtercero ?? 0,
IdentifClient = C.id,
NameClient = C.name,
FirstName = C.primname,
SecondName = C.segname,
FirstLastName = C.primapel,
SeconLastName = C.segapel
}).ToList();
foreach (var item in lsTemp)
{
CsReturn.Add(new EvidenciasModel
{
idTercero = item.IdTercero,
identifClient = item.IdentifClient,
nameClient = item.NameClient,
firstName = item.FirstName,
secondName = item.SecondName,
firstLastName = item.FirstLastName,
secondLastName = item.SeconLastName
});
}
}
}
catch (Exception ex)
{
}
return(CsReturn.AsQueryable());
}
