/*
         * public DataTable SelectAllAdmin()
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
         *      dt = objCls_farmerproducts_db.SelectAllAdmin();
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         *
         * public DataTable farmerproducts_WSSelectAll()
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
         *      dt = objCls_farmerproducts_db.farmerproducts_WSSelectAll();
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         * public DataTable farmerproducts_WSSelectById(Int64 cid)
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
         *      dt = objCls_farmerproducts_db.farmerproducts_WSSelectById(cid);
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         *
         * public bool farmerproducts_IsActive(Int64 farmerproductsId, Boolean IsActive)
         * {
         *  try
         *  {
         *      Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
         *      if (objCls_farmerproducts_db.farmerproducts_IsActive(farmerproductsId, IsActive))
         *      {
         *          return true;
         *      }
         *      return false;
         *  }
         *  catch (Exception ex)
         *  {
         *      throw new Exception(ex.Message);
         *  }
         * }
         *
         */

        public DataTable SelectAll()
        {
            DataTable dt = new DataTable();

            try
            {
                Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
                dt = objCls_farmerproducts_db.SelectAll();
                return(dt);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(dt);
            }
        }
        public farmerproducts SelectById(Int64 cid)
        {
            farmerproducts objfarmerproducts = new farmerproducts();

            try
            {
                Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
                objfarmerproducts = objCls_farmerproducts_db.SelectById(cid);
                return(objfarmerproducts);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(objfarmerproducts);
            }
        }
        public Int64 Update(farmerproducts objfarmerproducts)
        {
            Int64 result = 0;

            try
            {
                Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
                result = Convert.ToInt64(objCls_farmerproducts_db.Update(objfarmerproducts));
                return(result);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(result);
            }
        }
        public bool Delete(Int64 cid)
        {
            bool result = false;

            try
            {
                Cls_farmerproducts_db objCls_farmerproducts_db = new Cls_farmerproducts_db();
                if (objCls_farmerproducts_db.Delete(cid))
                {
                    result = true;
                }
                else
                {
                    result = false;
                }
            }
            catch (Exception ex)
            {
                result = false;
                ErrHandler.writeError(ex.Message, ex.StackTrace);
            }
            return(result);
        }