public List <LARCA2.Data.DatabaseModels.LARCA20_RcClasification> TodosNivel3()
{
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA2.Data.DatabaseModels.LARCA20_RcClasification> ObjFiltro = from q in ObjEnt.LARCA20_RcClasification
where q.level_name.Equals("3")
select q;
List <LARCA2.Data.DatabaseModels.LARCA20_RcClasification> ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public List <LARCA2.Data.DatabaseModels.LARCA20_Level4> TodosFiltroBU(string Tx1)
{
Tx1 = (Tx1 == null ? "" : Tx1);
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA2.Data.DatabaseModels.LARCA20_Level4> ObjFiltro = from q in ObjEnt.LARCA20_Level4
where q.RefIdBU.ToString().Equals(Tx1)
select q;
List <LARCA2.Data.DatabaseModels.LARCA20_Level4> ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public List <LARCA20_User_Owner> TodosFiltro(long Tx1)
{
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA20_User_Owner> ObjFiltro = from q in ObjEnt.LARCA20_User_Owner
where q.Id == Tx1
select q;
List <LARCA20_User_Owner> ListaReturn = new List <LARCA20_User_Owner>();
ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public List <LARCA20_Users> TodosFiltro(string Tx1, string Tx2)
{
Tx1 = (Tx1 == null ? "" : Tx1);
Tx2 = (Tx2 == null ? "" : Tx2);
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA20_Users> ObjFiltro = from q in ObjEnt.LARCA20_Users
where q.name.Contains(Tx1) && q.last_name.Contains(Tx2)
select q;
List <LARCA20_Users> ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public List <LARCA2.Data.DatabaseModels.LARCA20_RcClasification> TodosNivel3_Filtro(string Tx1)
{
Tx1 = (Tx1 == null ? "" : Tx1);
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA2.Data.DatabaseModels.LARCA20_RcClasification> ObjFiltro = from q in ObjEnt.LARCA20_RcClasification
where q.Description.Contains(Tx1)
select q;
List <LARCA2.Data.DatabaseModels.LARCA20_RcClasification> ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public List <LARCA2.Data.DatabaseModels.LARCA20_MasterData> TraerSoloData(string Tx1)
{
Tx1 = (Tx1 == null ? "" : Tx1);
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA2.Data.DatabaseModels.LARCA20_MasterData> ObjFiltro = from q in ObjEnt.LARCA20_MasterData
where q.Data == Tx1 && q.deleted == false
select q;
List <LARCA2.Data.DatabaseModels.LARCA20_MasterData> ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public List <LARCA20_UsersRoles> TodosFiltro(string Tx1, string Tx2)
{
Tx1 = (Tx1 == null ? "0" : Tx1);
Tx2 = (Tx2 == null ? "" : Tx2);
int ValPaso = Convert.ToInt32(Tx1);
using (Larca2Entities ObjEnt = new Larca2Entities())
{
IQueryable <LARCA20_UsersRoles> ObjFiltro = from q in ObjEnt.LARCA20_UsersRoles
where q.RefIdUser == ValPaso
select q;
List <LARCA20_UsersRoles> ListaReturn = ObjFiltro.ToList();
return(ListaReturn);
}
}
public BaseDAL()
{
Context = new Larca2Entities();
}
