public Int64 Insert(dispatchdetails objdispatchdetails)
        {
            Int64 result = 0;

            try
            {
                Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
                result = Convert.ToInt64(objCls_dispatchdetails_db.Insert(objdispatchdetails));
                return(result);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(result);
            }
        }
        /*
         * public DataTable SelectAllAdmin()
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      dt = objCls_dispatchdetails_db.SelectAllAdmin();
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         * public DataTable SelectAll()
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      dt = objCls_dispatchdetails_db.SelectAll();
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         * public DataTable dispatchdetails_WSSelectAll()
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      dt = objCls_dispatchdetails_db.dispatchdetails_WSSelectAll();
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         * public DataTable dispatchdetails_WSSelectById(Int64 cid)
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      dt = objCls_dispatchdetails_db.dispatchdetails_WSSelectById(cid);
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         * public bool Delete(Int64 cid)
         * {
         *  bool result = false;
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      if (objCls_dispatchdetails_db.Delete(cid))
         *      {
         *          result = true;
         *      }
         *      else
         *      {
         *          result = false;
         *      }
         *  }
         *  catch (Exception ex)
         *  {
         *      result = false;
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *  }
         *  return result;
         * }
         * public bool dispatchdetails_IsActive(Int64 dispatchdetailsId, Boolean IsActive)
         * {
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      if (objCls_dispatchdetails_db.dispatchdetails_IsActive(dispatchdetailsId, IsActive))
         *      {
         *          return true;
         *      }
         *      return false;
         *  }
         *  catch (Exception ex)
         *  {
         *      throw new Exception(ex.Message);
         *  }
         * }
         *
         *  public Int64 Update(dispatchdetails objdispatchdetails)
         * {
         *  Int64 result = 0;
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      result = Convert.ToInt64(objCls_dispatchdetails_db.Update(objdispatchdetails));
         *      return result;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return result;
         *  }
         * }
         *
         * public DataTable SelectByFarmerId(Int64 id)
         * {
         *  DataTable dt = new DataTable();
         *  try
         *  {
         *      Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
         *      dt = objCls_dispatchdetails_db.SelectByFarmerId(id);
         *      return dt;
         *  }
         *  catch (Exception ex)
         *  {
         *      ErrHandler.writeError(ex.Message, ex.StackTrace);
         *      return dt;
         *  }
         * }
         *
         *
         *
         */

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

            try
            {
                Cls_dispatchdetails_db objCls_dispatchdetails_db = new Cls_dispatchdetails_db();
                dt = objCls_dispatchdetails_db.SelectAllAdmin();
                return(dt);
            }
            catch (Exception ex)
            {
                ErrHandler.writeError(ex.Message, ex.StackTrace);
                return(dt);
            }
        }