public List <ProductType> getOneProductType(string RestaurantId)
{
List <ProductType> list = null;
try
{
IParameterMapper ipmapper = new getProductTypeParameterMapper();
DataAccessor <ProductType> tableAccessor;
string strSql = @" select
pt.TypeId,
pt.TypeName,
pt.IsServiceType,
pt.OrderNo,
pt.ParentType,
pt.PrintId,
pt.RestaurantId
from ProductType pt
where pt.IsServiceType=0 and pt.RestaurantId=@RestaurantId
and pt.ParentType='00000000-0000-0000-0000-000000000000'
and not exists(select 1 from producttypeisbook pb where pt.TypeId=pb.ProductTypeid and pb.isbook=0 )
order by pt.OrderNo ";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <ProductType> .
MapAllProperties().Build());
list = tableAccessor.Execute(new string[] { RestaurantId }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
}
public List<ProductType> getProductType(string RestaurantId)
{
List<ProductType> list = null;
try
{
IParameterMapper ipmapper = new getProductTypeParameterMapper();
DataAccessor<ProductType> tableAccessor;
string strSql = @" select
pt.TypeId,
pt.TypeName,
pt.IsServiceType,
pt.OrderNo,
pt.ParentType,
pt.PrintId,
pt.RestaurantId
from ProductType pt
where pt.IsServiceType=0 and pt.RestaurantId=@RestaurantId
and pt.ParentType!='00000000-0000-0000-0000-000000000000'
and exists(select 1 from Product p where pt.TypeId=p.ProductType and p.Status=1)
and not exists(select 1 from producttypeisbook pb where pt.TypeId=pb.ProductTypeid and pb.isbook=0 )
order by pt.OrderNo ";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ProductType>.
MapAllProperties().Build());
list = tableAccessor.Execute(new string[] { RestaurantId }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
