public List <KodIsim> GetCariKodsBySubeKodu(string subeKodu, string cariKodIsim)
{
KodIsim kodIsim = null;
return(Session.QueryOver <Cari>().Where(x => (x.Sube.Id == subeKodu || x.SubelerdeOrtak == true) &&
(x.Id.IsLike(cariKodIsim, MatchMode.Anywhere) || x.CariIsim.IsLike(cariKodIsim, MatchMode.Anywhere)))
.SelectList(liste =>
liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod)
.SelectGroup(c => c.CariIsim).WithAlias(() => kodIsim.Isim)
).TransformUsing(Transformers.AliasToBean <KodIsim>())
.Take(GetMaxResult).List <KodIsim>() as List <KodIsim>);
}
public List <KodIsim> GetListParentSubCategoryKodAndName(string parentCategoryKod, string categoryName)
{
KodIsim kodIsim = null;
return(Session.QueryOver <StokCategory>().Where(x => x.ParentCategory.Id == parentCategoryKod &&
(x.Id.IsLike(categoryName, MatchMode.Anywhere) || x.CategoryName.IsLike(categoryName, MatchMode.Anywhere)))
.SelectList(liste =>
liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod)
.SelectGroup(c => c.CategoryName).WithAlias(() => kodIsim.Isim)
).TransformUsing(Transformers.AliasToBean <KodIsim>())
.Take(GetMaxResult).List <KodIsim>() as List <KodIsim>);
}
public List <KodIsim> GetListRootCategoriesKodAndName(string categoryName)
{
KodIsim kodIsim = null;
return(Session.QueryOver <CariCategory>().Where(x => x.ParentCategory == null &&
(x.Id.IsLike(categoryName, MatchMode.Anywhere) || x.CategoryName.IsLike(categoryName, MatchMode.Anywhere)))
.SelectList(liste =>
liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod)
.SelectGroup(c => c.CategoryName).WithAlias(() => kodIsim.Isim)
).TransformUsing(Transformers.AliasToBean <KodIsim>())
.Take(GetMaxResult).List <KodIsim>() as List <KodIsim>);
//IQuery query = Session.CreateQuery("select cc.Id from CariCategory cc where (cc.ParentCategory is null or cc.ParentCategory='') and cc.Id like :cname")
// .SetString("cname",categoryName + "%").SetMaxResults(GetMaxResult);
//return query.List<string>() as List<string>;
}
public List <KodIsim> GetCariKodsBySubeKodu(string subeKodu, string cariKodIsim, FTIRSIP ftirsip)
{
KodIsim kodIsim = null;
IQueryOver <Cari, Cari> over = Session.QueryOver <Cari>().Where(x => (x.Sube.Id == subeKodu || x.SubelerdeOrtak == true) &&
(x.Id.IsLike(cariKodIsim, MatchMode.Anywhere) || x.CariIsim.IsLike(cariKodIsim, MatchMode.Anywhere)));
if (FTIRSIP.AlisFat == ftirsip || FTIRSIP.AlisIrs == ftirsip)
{
over.And(x => (x.CariTip == "S" || x.CariTip == "AS"));
}
else if (FTIRSIP.SatisFat == ftirsip || FTIRSIP.SatisIrs == ftirsip)
{
over.And(x => (x.CariTip == "A" || x.CariTip == "AS"));
}
return(over.SelectList(liste =>
liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod)
.SelectGroup(c => c.CariIsim).WithAlias(() => kodIsim.Isim)
).TransformUsing(Transformers.AliasToBean <KodIsim>())
.Take(GetMaxResult).List <KodIsim>() as List <KodIsim>);
}
public List <KodIsim> StokKods(string stokKodIsim, Sube sube)
{
//ICriteria criteria = Session.CreateCriteria(typeof(Stok)).SetProjection(Projections.Property("Id"))
// .Add(Expression.Like("Id", stokKod, MatchMode.Start)).SetMaxResults(GetMaxResult);
//ICriteria subeCriteria = criteria.CreateCriteria("Sube");
//subeCriteria.Add(NHibernate.Criterion.Expression.Eq("Id", sube.Id));
//return criteria.List<string>() as List<string>;
//IQuery query = Session.CreateQuery("select st.Id from Stok st where st.Sube=:sube and st.Id like :st").SetString("st", stokKod + "%").SetEntity("sube", sube).SetMaxResults(10);
//return (List<string>)query.List<string>();
KodIsim kodIsim = null;
return(Session.QueryOver <Stok>().Where(x => (x.Sube == sube || x.SubelerdeOrtak == true) &&
(x.Id.IsLike(stokKodIsim, MatchMode.Anywhere) || x.StokAdi.IsLike(stokKodIsim, MatchMode.Anywhere)))
.SelectList(liste =>
liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod)
.SelectGroup(c => c.StokAdi).WithAlias(() => kodIsim.Isim)
).TransformUsing(Transformers.AliasToBean <KodIsim>())
.Take(GetMaxResult).List <KodIsim>() as List <KodIsim>);
}
