/// <summary>
/// F15010_s the list excise WAC.
/// </summary>
/// <returns></returns>
public static F15010ExciseAffidavitData F15010_ListExciseWAC()
{
F15010ExciseAffidavitData exciseWAC = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(exciseWAC.ListExciseWAC, "f15010_pclst_ExciseWAC", ht);
return(exciseWAC);
}
/// <summary>
/// Gets the excise affidavit details.
/// </summary>
/// <returns>Return ExciseTaxAffidavitData Dataset</returns>
public static F15010ExciseAffidavitData F15010_GetExciseIndividualType()
{
F15010ExciseAffidavitData exciseIndividualType = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
string[] tableName = new string[] { exciseIndividualType.ExciseIndividualType.TableName, exciseIndividualType.ExciseDeedType.TableName, exciseIndividualType.ExciseSource.TableName, exciseIndividualType.ConfiguredRollYear.TableName };
Utility.LoadDataSet(exciseIndividualType, "f15010_pclst_ExciseIndividualType", ht, tableName);
return(exciseIndividualType);
}
/// <summary>
/// F1510_s the list open space field.
/// </summary>
/// <param name="parcelIds">The parcel ids.</param>
/// <returns></returns>
public static F15010ExciseAffidavitData F15010_ListOpenSpaceField(string parcelIds)
{
F15010ExciseAffidavitData openSpaceFieldData = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@ParcelList", parcelIds);
Utility.LoadDataSet(openSpaceFieldData.OpenSpaceData, "f15010_pcget_OpenSpaceData", ht);
return(openSpaceFieldData);
}
/// <summary>
/// F5010_s the list excise individual.
/// </summary>
/// <param name="ExciseIndividualElements">The excise individual elements.</param>
/// <returns></returns>
public static F15010ExciseAffidavitData F15010_ListExciseIndividual(string ExciseIndividualElements)
{
F15010ExciseAffidavitData exciseIndividualElements = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@ExciseIndividualElements", ExciseIndividualElements);
Utility.LoadDataSet(exciseIndividualElements.ListExciseIndividual, "f15010_pclst_ExciseIndividual", ht);
return(exciseIndividualElements);
}
/// <summary>
/// Gets the district selection.
/// </summary>
/// <param name="exciseRateId">The excise rate id.</param>
/// <returns>Returns Dataset foe District Selection</returns>
public static F15010ExciseAffidavitData F15010_GetDistrictSelection(int exciseRateId)
{
F15010ExciseAffidavitData districtSelection = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@ExciseRateID", exciseRateId);
Utility.LoadDataSet(districtSelection.ListAffidavitDistrictSelection, "f15013_pcget_ExciseTaxDistrict", ht);
return(districtSelection);
}
/// <summary>
/// Gets the owner details.
/// </summary>
/// <param name="ownerId">The owner id.</param>
/// <returns>Returns PartiesOwnerDetails Dataset</returns>
public static F15010ExciseAffidavitData F15010_GetOwnerDetails(int ownerId)
{
F15010ExciseAffidavitData ownerDetail = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@OwnerID", ownerId);
Utility.LoadDataSet(ownerDetail.ListPartiesOwnerDetail, "f9101_pcget_MasterName", ht);
return(ownerDetail);
}
/// <summary>
/// Get the owner Status.
/// </summary>
/// <param name="ownerId"></param>
/// <returns></returns>
public static F15010ExciseAffidavitData F15010_GetOwnerStatus(int ownerId)
{
F15010ExciseAffidavitData ownerStatus = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@Ownerid", ownerId);
string[] tableName = new string[] { ownerStatus.OwnerStatusLow.TableName, ownerStatus.OwnerStatusHigh.TableName };
Utility.LoadDataSet(ownerStatus, "f15010_GetOwnerStatus", ht, tableName);
return(ownerStatus);
}
/// <summary>
/// Gets the ExciseTaxAffidavit based on the statmentid.
/// </summary>
/// <param name="statementId">The statement id.</param>
/// <returns>The dataset containing the comments.</returns>
public static F15010ExciseAffidavitData F15010_GetExciseTaxAffidavitDetails(int statementId)
{
F15010ExciseAffidavitData exciseTaxAffiDavitData = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@StatementID", statementId);
////DataSet ds = new DataSet();
string[] tableName = new string[] { exciseTaxAffiDavitData.General.TableName, exciseTaxAffiDavitData.PartiesHeader.TableName, exciseTaxAffiDavitData.ParcelHeader.TableName, exciseTaxAffiDavitData.Affidavit.TableName, exciseTaxAffiDavitData.AmountDue.TableName, exciseTaxAffiDavitData.Suppliment.TableName, exciseTaxAffiDavitData.MobileHome.TableName, exciseTaxAffiDavitData.DorSubmitTable.TableName };
Utility.LoadDataSet(exciseTaxAffiDavitData, "f15010_pcget_ExciseTaxAffidavitStatmentDetails", ht, tableName);
return(exciseTaxAffiDavitData);
}
/// <summary>
/// F15010_s the get parcel detail.
/// </summary>
/// <param name="parcelId">The parcel id.</param>
/// <param name="parcelNumber">The parcel number.</param>
/// <returns>Returns Dataset foe parcel Selection</returns>
public static F15010ExciseAffidavitData F15010_GetParcelDetail(int?parcelId, string parcelNumber)
{
F15010ExciseAffidavitData districtSelection = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@ParcelID", parcelId);
ht.Add("@ParcelNumber", parcelNumber);
string[] tableName = new string[] { districtSelection.ListParcelDetailTable.TableName, districtSelection.PartiesOwnerDetail.TableName, districtSelection.ExciseUseCode.TableName };
Utility.LoadDataSet(districtSelection, "f15010_pcget_ParcelInfoForExcise", ht, tableName);
return(districtSelection);
}
/// <summary>
/// Gets the affidavit statement id.
/// </summary>
/// <param name="formId">The form id.</param>
/// <param name="orderField">The order field.</param>
/// <param name="orderBy">The order by.</param>
/// <returns>Returns dataset for list of statementID</returns>
public static F15010ExciseAffidavitData F15010_GetAffidavitStatementId(int formId, string orderField, string orderBy)
{
F15010ExciseAffidavitData affidavitStatementIdData = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@Form", formId);
ht.Add("@OrderField", orderField);
ht.Add("@Orderby", orderBy);
Utility.LoadDataSet(affidavitStatementIdData.ListAffidavitStatementId, "f15010_pcget_ExciseTaxAffidavitStatementIds", ht);
return(affidavitStatementIdData);
}
/// <summary>
/// Excises the tax affidavit calulate amount due.
/// </summary>
/// <param name="saleDate">The sale date.</param>
/// <param name="paymentDate">The payment date.</param>
/// <param name="exciseRateId">The excise rate ID.</param>
/// <param name="taxCode">The tax code.</param>
/// <param name="taxableSaleAmount">The taxable sale amount.</param>
/// <returns>AmountDue Calcualted Value </returns>
public static F15010ExciseAffidavitData F15010_GetExciseTaxAffidavitCalulateAmountDue(DateTime saleDate, DateTime paymentDate, int exciseRateId, int taxCode, double taxableSaleAmount)
{
F15010ExciseAffidavitData exciseTaxAffidavitAmountDueData = new F15010ExciseAffidavitData();
Hashtable ht = new Hashtable();
ht.Add("@SaleDate", saleDate);
ht.Add("@PaymentDate", paymentDate);
ht.Add("@ExciseRateID", exciseRateId);
ht.Add("@TaxCode", taxCode);
ht.Add("@TaxableSaleAmount", taxableSaleAmount);
Utility.LoadDataSet(exciseTaxAffidavitAmountDueData.CalAmountDue, "f15010_pcget_ExciseTaxAffidavitAmountDue", ht);
return(exciseTaxAffidavitAmountDueData);
}
private void ExciseRatePictureBox_Click(object sender, EventArgs e)
{
Form districtF1102 = new Form();
if (!string.IsNullOrEmpty(this.RollYearTextBox.Text.Trim()))
{
int temprollyear = int.Parse(this.RollYearTextBox.Text);
if (temprollyear > 0)
{
object[] optionalParameters = new object[] { temprollyear };
districtF1102 = this.form1505Control.WorkItem.Services.Get <TerraScan.Infrastructure.Interface.Services.IFormEngineService>().GetForm(1102, optionalParameters, this.form1505Control.WorkItem);
}
else
{
int temrollyear = GetYear();
object[] optionalParameters = new object[] { temrollyear };
districtF1102 = this.form1505Control.WorkItem.Services.Get <TerraScan.Infrastructure.Interface.Services.IFormEngineService>().GetForm(1102, optionalParameters, this.form1505Control.WorkItem);
}
}
else
{
int temrollyear = GetYear();
object[] optionalParameters = new object[] { temrollyear };
districtF1102 = this.form1505Control.WorkItem.Services.Get <TerraScan.Infrastructure.Interface.Services.IFormEngineService>().GetForm(1102, optionalParameters, this.form1505Control.WorkItem);
}
DialogResult districtDialog;
if (districtF1102 != null)
{
districtDialog = districtF1102.ShowDialog();
if (districtDialog == DialogResult.Yes)
{
try
{
exciseID = TerraScanCommon.GetValue(districtF1102, "ExciseRateDistrictSelectionId");
exciseRateId = Convert.ToInt32(exciseID);
this.districtSelectionDataSet = this.form1505Control.WorkItem.F15010_GetDistrictSelection(Convert.ToInt32(this.exciseRateId));
if (this.districtSelectionDataSet.ListAffidavitDistrictSelection.Rows.Count > 0)
{
F15010ExciseAffidavitData.ListAffidavitDistrictSelectionRow districtRow = (F15010ExciseAffidavitData.ListAffidavitDistrictSelectionRow) this.districtSelectionDataSet.ListAffidavitDistrictSelection.Rows[0];
if (!districtRow.IsDistrictNull())
{
this.Exciselabel.Text = districtRow.District;
}
else
{
this.Exciselabel.Text = string.Empty;
}
}
}
catch (Exception ex)
{
ExceptionManager.ManageException(SharedFunctions.GetResourceString("ErrorLoadingForm"), ex, ExceptionManager.ActionType.Display, this.ParentForm);
}
}
else if (districtDialog == DialogResult.Ignore)
{
try
{
FormInfo formInfo;
formInfo = TerraScanCommon.GetFormInfo(1101);
this.ShowForm(this, new DataEventArgs <FormInfo>(formInfo));
}
catch (Exception ex)
{
ExceptionManager.ManageException(SharedFunctions.GetResourceString("ErrorLoadingForm"), ex, ExceptionManager.ActionType.Display, this.ParentForm);
}
}
}
}
