public ProductsDml(string name, IProductsRepo prodRep, IHelpers helper) : base(helper)
{
_nameFilter = string.IsNullOrEmpty(name) ? string.Empty : $"where lower(name) like '%{name.ToLower()}%'";
_prodRepo = prodRep;
_dbHelper = prodRep.GetDbHelper();
}
public ProductDml(string id, IProductsRepo prodRep, IHelpers helper) : base(helper)
{
_id = id;
_prodRepo = prodRep;
_dbHelper = prodRep.GetDbHelper();
}
public ProductsOpDml(string id, IProductsRepo prodRep, IHelpers helper) : base(helper)
{
_prodIdFilter = string.IsNullOrEmpty(id) ? string.Empty : $"where productid = '{id}'";
_prodRepo = prodRep;
_dbHelper = prodRep.GetDbHelper();
}