public List <MemProduct> getMemProducts(string CompanyId)
{
List <MemProduct> list = null;
try
{
IParameterMapper ipmapper = new getMemProductsParameterMapper();
DataAccessor <MemProduct> tableAccessor;
string strSql = @"select p.ProductName ,p.Price,p.MemberPrice ,p.id ,cl.CodeTypeListName
from ProductMenu p ,S_CodeList cl where p.Price>p.MemberPrice and p.Status='1'
and cl.CodeTypeListValue=p.Unit and cl.CodeType='ProductUnit' and p.CompanyId =@CompanyId order by p.Price";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <MemProduct> .
MapAllProperties().Build());
list = tableAccessor.Execute(new string[] { CompanyId }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
}
public List <ProductMenu> getImageProductMenu(string id)
{
List <ProductMenu> list = null;
try
{
IParameterMapper ipmapper = new getMemProductsParameterMapper();
DataAccessor <ProductMenu> tableAccessor;
string strSql = @"select b.ThumbImage
from ProductMenu b where 1=1 and b.Status=1 and b.Id=@CompanyId";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <ProductMenu> .MapAllProperties()
.Map(t => t.ThumbImage).ToColumn("ThumbImage")
.Build());
list = tableAccessor.Execute(new string[] { id }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
}
public List<ProductMenu> getImageProductMenu(string id)
{
List<ProductMenu> list = null;
try
{
IParameterMapper ipmapper = new getMemProductsParameterMapper();
DataAccessor<ProductMenu> tableAccessor;
string strSql = @"select b.ThumbImage
from ProductMenu b where 1=1 and b.Status=1 and b.Id=@CompanyId";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<ProductMenu>.MapAllProperties()
.Map(t => t.ThumbImage).ToColumn("ThumbImage")
.Build());
list = tableAccessor.Execute(new string[] { id }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
public List<MemProduct> getMemProducts(string CompanyId)
{
List<MemProduct> list = null;
try
{
IParameterMapper ipmapper = new getMemProductsParameterMapper();
DataAccessor<MemProduct> tableAccessor;
string strSql = @"select p.ProductName ,p.Price,p.MemberPrice ,p.id ,cl.CodeTypeListName
from ProductMenu p ,S_CodeList cl where p.Price>p.MemberPrice and p.Status='1'
and cl.CodeTypeListValue=p.Unit and cl.CodeType='ProductUnit' and p.CompanyId =@CompanyId order by p.Price";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<MemProduct>.
MapAllProperties().Build());
list = tableAccessor.Execute(new string[] { CompanyId }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
