public bool Delete(Int64 opid)
        {
            try
            {
                Cls_orderproducts_db objCls_orderproducts_db = new Cls_orderproducts_db();

                if (objCls_orderproducts_db.Delete(opid))
                {
                    return(true);
                }
                return(false);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public orderproducts SelectById(Int64 opid)
        {
            orderproducts objorderproducts = new orderproducts();

            try
            {
                Cls_orderproducts_db objCls_orderproducts_db = new Cls_orderproducts_db();

                objorderproducts = objCls_orderproducts_db.SelectById(opid);
                return(objorderproducts);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(objorderproducts);
            }
        }
        public Int64 Update(orderproducts objorderproducts)
        {
            Int64 result = 0;

            try
            {
                Cls_orderproducts_db objCls_orderproducts_db = new Cls_orderproducts_db();

                result = Convert.ToInt64(objCls_orderproducts_db.Update(objorderproducts));
                return(result);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(result);
            }
        }
        public DataTable SelectAll()
        {
            DataTable dt = new DataTable();

            try
            {
                Cls_orderproducts_db objCls_orderproducts_db = new Cls_orderproducts_db();

                dt = objCls_orderproducts_db.SelectAll();
                return(dt);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(dt);
            }
        }