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