/// <summary>
        /// Data to populate Owner Grid
        /// </summary>
        /// <param name="saleId">The Sale Id</param>
        /// <param name="ownerId">The Owner Id</param>
        /// <param name="parcelId">The Parcel Id</param>
        /// <param name="userId">The User Id</param>
        /// <returns>Owner Details DataSet</returns>
        public static F29551ParcelSaleTrackingData F29551_GetOwnerDetails(int?saleId, int?ownerId, int?parcelId, int userId)
        {
            F29551ParcelSaleTrackingData parcelSaleTracking = new F29551ParcelSaleTrackingData();
            Hashtable ht = new Hashtable();
            DataSet   ds = new DataSet();

            ht.Add("@SaleID", saleId);
            ht.Add("@OwnerID", ownerId);
            ht.Add("@ParcelID", parcelId);
            ht.Add("@UserID", userId);
            Utility.LoadDataSet(parcelSaleTracking.OwnerDetails, "f29551_pcget_SaleOwners", ht);
            return(parcelSaleTracking);
        }
        /// <summary>
        /// Parcel and Owner details
        /// </summary>
        /// <param name="parcelId">The Parcel Id</param>
        /// <param name="parcelCollection">Parcel Collections</param>
        /// <param name="saleId">The Sale Id</param>
        /// <param name="userId">The User Id</param>
        /// <returns>Parcel and Owner details</returns>
        ///
        public static F29551ParcelSaleTrackingData F29551_GetParcelOwnerDetails(int?parcelId, string parcelCollection, int?saleId, int userId)
        {
            F29551ParcelSaleTrackingData parcelSaleTracking = new F29551ParcelSaleTrackingData();
            Hashtable ht = new Hashtable();
            DataSet   ds = new DataSet();

            ht.Add("@ParcelID", parcelId);
            ht.Add("@ParcelIDs", parcelCollection);
            ht.Add("@SaleID", saleId);
            ht.Add("@UserID", userId);
            string[] tableNames = new string[]
            {
                parcelSaleTracking.ParcelDetails.TableName,
                parcelSaleTracking.OwnerDetails.TableName,
                parcelSaleTracking.ReturnMessage.TableName
            };
            Utility.LoadDataSet(parcelSaleTracking, "f29551_pcget_SaleParcelsAndOwners", ht, tableNames);
            return(parcelSaleTracking);
        }
        /// <summary>
        /// DataSet to Populate Grid and other controls
        /// </summary>
        /// <param name="eventId">The Event Id</param>
        /// <param name="userId">The User ID</param>
        /// <returns>DataSet to populate Controls</returns>
        public static F29551ParcelSaleTrackingData F29551_GetParcelSaleTrackingDetails(int eventId, int userId)
        {
            F29551ParcelSaleTrackingData parcelSaleTracking = new F29551ParcelSaleTrackingData();
            Hashtable ht = new Hashtable();
            DataSet   ds = new DataSet();

            ht.Add("@EventID", eventId);
            ht.Add("@UserID", userId);
            string[] tableNames = new string[]
            {
                parcelSaleTracking.SaleDetails.TableName,
                parcelSaleTracking.ParcelDetails.TableName,
                parcelSaleTracking.OwnerDetails.TableName,
                parcelSaleTracking.ReturnMessage.TableName,
                parcelSaleTracking.ValidRecord.TableName
            };

            Utility.LoadDataSet(parcelSaleTracking, "f29551_pcget_ParcelSaleTracking", ht, tableNames);
            return(parcelSaleTracking);
        }
        /// <summary>
        /// DataSet to populate combo values
        /// </summary>
        /// <param name="userId">The User Id</param>
        /// <returns>DataSet to populate combos</returns>
        public static F29551ParcelSaleTrackingData F29551_GetParcelSaleComboDetails(int userId)
        {
            F29551ParcelSaleTrackingData parcelSaleTracking = new F29551ParcelSaleTrackingData();
            Hashtable ht = new Hashtable();
            DataSet   ds = new DataSet();

            ht.Add("@UserID", userId);
            string[] tableNames = new string[]
            {
                parcelSaleTracking.DeedType.TableName,
                parcelSaleTracking.StateList.TableName,
                parcelSaleTracking.Advisory.TableName,
                parcelSaleTracking.Assignment.TableName,
                parcelSaleTracking.Status.TableName,
                parcelSaleTracking.Apprasiser.TableName,
                parcelSaleTracking.LocalQualification.TableName
            };

            Utility.LoadDataSet(parcelSaleTracking, "f29551_pclst_ParcelSaleTracking", ht, tableNames);
            return(parcelSaleTracking);
        }