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); } }