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