/// <summary>
/// F1044 list District Type.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition GetDistributionDetails()
{
F16040ImprovementDistrictDefinition getDistributionDetails = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(getDistributionDetails.GetDistributionDetails, "f10040_pclst_DistributionType", ht);
return(getDistributionDetails);
}
/// <summary>
/// F16040 list Interest Method.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition GetDistrictDetails(int districtIdType)
{
F16040ImprovementDistrictDefinition getDistrictDetailsdata = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(getDistrictDetailsdata.DistrictTypeTable, "f1044_pclst_DistrictType", ht);
return(getDistrictDetailsdata);
}
/// <summary>
/// F16040 list Interest Method.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition ListInterestDelqDetails()
{
F16040ImprovementDistrictDefinition getDelqInterestCalcMethod = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(getDelqInterestCalcMethod.DelqInterestCalcTable, "f10040_pclst_DelqInterestCalc", ht);
return(getDelqInterestCalcMethod);
}
/// <summary>
/// F16040 list Interest Method.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition ListInterestMethod()
{
F16040ImprovementDistrictDefinition getInterestMethod = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(getInterestMethod.InterestMethodTable, "f10040_pclst_InterestMethod", ht);
return(getInterestMethod);
}
/// <summary>
/// F1044 list District Type.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition ImprovementDistrictTypelist(string districtType)
{
F16040ImprovementDistrictDefinition getImprovementDistrictTypelist = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
ht.Add("@IDType", districtType);
Utility.LoadDataSet(getImprovementDistrictTypelist.DistrictTypeTable, "f1044_pclst_DistrictType", ht);
return(getImprovementDistrictTypelist);
}
/// <summary>
/// F1044 list District Type.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition GetDistrictDefinitionDetails(int districtId)
{
F16040ImprovementDistrictDefinition getDistrictDefinitionDetails = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
string[] tableName = new string[] { getDistrictDefinitionDetails.GetDistrictDetails.TableName, getDistrictDefinitionDetails.GetSummaryDetails.TableName, getDistrictDefinitionDetails.GetDistributionDetails.TableName };
ht.Add("@DistrictID", districtId);
Utility.LoadDataSet(getDistrictDefinitionDetails, "f10040_pclst_DistrictDefinitionDetails", ht, tableName);
return(getDistrictDefinitionDetails);
}
/// <summary>
/// Execute Rollover ImprovementDistrict.
/// </summary>
/// <returns>listtemplateData</returns>
public static F16040ImprovementDistrictDefinition RollOver_ImprovementDistrict(int districtId, int userId)
{
F16040ImprovementDistrictDefinition getDistributionDetails = new F16040ImprovementDistrictDefinition();
Hashtable ht = new Hashtable();
ht.Add("@SADistrictID", districtId);
ht.Add("@UserID", userId);
Utility.LoadDataSet(getDistributionDetails, "f9080_pcexe_RollOver_TR_ImprovementDistrict", ht);
return(getDistributionDetails);
}
/// <summary>
/// search event.
/// </summary>
private void SearchFunction()
{
try
{
this.Cursor = Cursors.WaitCursor;
if (this.SearchButton.Enabled)
{
int recordCount = 0;
//Removed the .Replace("'","''") for Database Execution retrieves nothing
string description = this.DescriptionTextBox.Text.Trim();
string idType = this.DistrictTextBox.Text.Trim();
//if (!string.IsNullOrEmpty(description) && string.IsNullOrEmpty(idType))
//{
this.getImprovementDistrictDefinition = this.f1404Controller.WorkItem.ImprovementDistrictTypelist(description);
if (this.getImprovementDistrictDefinition.DistrictTypeTable.Rows.Count > 0)
{
recordCount = this.getImprovementDistrictDefinition.DistrictTypeTable.Rows.Count;
this.SpecialDistrictSelectionGridView.Enabled = true;
this.SpecialDistrictSelectionGridView.DataSource = this.getImprovementDistrictDefinition.DistrictTypeTable;
this.SpecialDistrictSelectionGridView.Focus();
this.SpecialDistrictSelectionGridView.Rows[0].Selected = true;
this.SpecialDistrictSelectAcceptButton.Enabled = true;
this.emptyRecord = false;
}
else
{
this.SpecialDistrictSelectionGridView.DataSource = this.getImprovementDistrictDefinition.DistrictTypeTable;
this.SpecialDistrictSelectionGridView.Rows[0].Selected = false;
this.SpecialDistrictSelectionGridView.Enabled = false;
this.emptyRecord = true;
this.SpecialDistrictSelectAcceptButton.Enabled = false;
}
this.SearchResultLabel.Visible = true;
this.SearchResultLabel.Text = recordCount + " record(s) match.";
this.DisableVScrollBar();
//}
//else
//{
// this.SearchResultLabel.Text = recordCount + " record(s) match.";
//}
}
}
catch (Exception ex)
{
ExceptionManager.ManageException(ex, ExceptionManager.ActionType.CloseCurrentForm, this.ParentForm);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// Populate Improvement District Type.
/// </summary>
private void PopulateImprovementDistrictType()
{
string districtType = string.Empty;
this.getDistrictTypeDetails.Clear();
this.SpecialDistrictSelectionGridView.NumRowsVisible = 5;
this.getImprovementDistrictDefinition = this.f1404Controller.WorkItem.ImprovementDistrictTypelist(districtType);
this.getDistrictTypeDetails = this.getImprovementDistrictDefinition.DistrictTypeTable;
int rowcount = this.getDistrictTypeDetails.Rows.Count;
if (rowcount > 3)
{
this.SpecialDistrictSelectionVscrollBar.Visible = false;
}
else
{
this.SpecialDistrictSelectionVscrollBar.Visible = true;
}
this.SpecialDistrictSelectionGridView.DataSource = getDistrictTypeDetails;
}
