public DataTable Product_WSSelectAllProductUsingCategoryId(Int64 CategoryId)
{
DataTable dt = new DataTable();
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
dt = objCls_product_db.Product_WSSelectAllProductUsingCategoryId(CategoryId);
return(dt);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(dt);
}
}
public DataTable SelectProductDetailsUsingProductId(Int64 pid)
{
DataTable dt = new DataTable();
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
dt = objCls_product_db.SelectProductDetailsUsingProductId(pid);
return(dt);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(dt);
}
}
public DataTable SelectAll()
{
DataTable dt = new DataTable();
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
dt = objCls_product_db.SelectAll();
return(dt);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(dt);
}
}
public bool Product_IsHotProduct(Int64 ProductId, Boolean IsActive)
{
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
if (objCls_product_db.Product_IsHotProduct(ProductId, IsActive))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool Delete(Int64 pid, Int64 cid)
{
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
if (objCls_product_db.Delete(pid, cid))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Int64 Update(product objproduct)
{
Int64 result = 0;
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
result = Convert.ToInt64(objCls_product_db.Update(objproduct));
return(result);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
}
public product SelectById(Int64 pid)
{
product objproduct = new product();
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
objproduct = objCls_product_db.SelectById(pid);
return(objproduct);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(objproduct);
}
}
public DataTable SearchProductUsingProductName(string Productname)
{
DataTable dt = new DataTable();
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
dt = objCls_product_db.SearchProductUsingProductName(Productname);
return(dt);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(dt);
}
}
public bool Product_UpdatePrice(Int64 ProductId, decimal CustomerPrice, decimal DealerPrice, decimal DiscountPrice, decimal GST, Int32 StockQuantites, bool IsStock, bool IsActive, decimal Wholesaleprice, decimal SuperWholesaleprice, int StockAlertQuantites, bool isHotproduct)
{
try
{
Cls_product_db objCls_product_db = new Cls_product_db();
if (objCls_product_db.Product_UpdatePrice(ProductId, CustomerPrice, DealerPrice, DiscountPrice, GST, StockQuantites, IsStock, IsActive, Wholesaleprice, SuperWholesaleprice, StockAlertQuantites, isHotproduct))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(false);
}
}
