/// <summary>
/// Load the Reviewed By Combobox
/// </summary>
private void LoadComboBox()
{
F35100NeighborhoodHeaderData.f35100GetUserDetailsDataTableDataTable listUserDetails = new F35100NeighborhoodHeaderData.f35100GetUserDetailsDataTableDataTable();
DataRow customRow = listUserDetails.NewRow();
listUserDetails.Clear();
customRow[this.neighborhoodHeaderData.f35100GetUserDetailsDataTable.UserNameColumn.ColumnName] = string.Empty;
customRow[this.neighborhoodHeaderData.f35100GetUserDetailsDataTable.UserIDColumn.ColumnName] = "0";
listUserDetails.Rows.Add(customRow);
this.neighborhoodHeaderData = this.form35101Control.WorkItem.F35100_GetNeighborhoodHeaderUserDetails(TerraScanCommon.ApplicationId);
listUserDetails.Merge(this.neighborhoodHeaderData.f35100GetUserDetailsDataTable);
if (this.neighborhoodHeaderData.f35100GetUserDetailsDataTable.Rows.Count > 0)
{
this.ReviewedByComboBox.DataSource = listUserDetails;
this.ReviewedByComboBox.DisplayMember = this.neighborhoodHeaderData.f35100GetUserDetailsDataTable.UserNameColumn.ColumnName;
this.ReviewedByComboBox.ValueMember = this.neighborhoodHeaderData.f35100GetUserDetailsDataTable.UserIDColumn.ColumnName;
if (this.reviewedById > 0)
{
this.ReviewedByComboBox.SelectedValue = this.reviewedById;
}
else
{
this.ReviewedByComboBox.SelectedIndex = 0;
}
}
}
///// <summary>
///// F35100_GetNeighborhoodHeaderDetails
///// </summary>
///// <param name="neighborId">neighborId</param>
///// <returns>neighborhoodHeaderData</returns>
////public static F35100NeighborhoodHeaderData F35100_GetNeighborhoodHeaderDetails(int neighborId)
////{
//// F35100NeighborhoodHeaderData neighborhoodHeaderData = new F35100NeighborhoodHeaderData();
//// Hashtable ht = new Hashtable();
//// ht.Add("@NBHDID", neighborId);
//// Utility.FillDataSet(neighborhoodHeaderData.f35100GetNeighborhoodHeaderDataTable, "f35100_pcget_NeighborhoodHeader", ht);
//// return neighborhoodHeaderData;
////}
/// <summary>
/// F35100NeighborhoodHeaderData
/// </summary>
/// <param name="applicationId">applicationId</param>
/// <returns>Typed dataset</returns>
public static F35100NeighborhoodHeaderData F35100_GetNeighborhoodHeaderUserDetails(int applicationId)
{
F35100NeighborhoodHeaderData neighborhoodHeaderData = new F35100NeighborhoodHeaderData();
Hashtable ht = new Hashtable();
ht.Add("@ApplicationID", applicationId);
Utility.LoadDataSet(neighborhoodHeaderData.f35100GetUserDetailsDataTable, "f35100_pclst_UserDetails", ht);
return(neighborhoodHeaderData);
}
/// <summary>
/// GetNeighborhoodHeaderDetails
/// </summary>
/// <param name="neighborId">neighborId</param>
/// <returns>neighborhoodHeaderData</returns>
public static F35100NeighborhoodHeaderData GetNeighborhoodHeaderDetails(int neighborId)
{
F35100NeighborhoodHeaderData neighborhoodHeaderData = new F35100NeighborhoodHeaderData();
// NeighborhoodHeaderData.f35100NeighborhoodHeaderDataTablef
Hashtable ht = new Hashtable();
ht.Add("@NBHDID", neighborId);
Utility.LoadDataSet(neighborhoodHeaderData.f35100NeighborhoodHeaderDataTable, "f35100_pcget_NeighborhoodHeader", ht);
return(neighborhoodHeaderData);
}
/// <summary>
/// GetParentNeighborhoodHeaderDetails
/// </summary>
/// <param name="rollYear">rollYear</param>
/// <param name="type">type</param>
/// <param name="parentneighborhood">parentneighborhood</param>
/// <returns>Typed dataset</returns>
public static F35100NeighborhoodHeaderData GetParentNeighborhoodHeaderDetails(int rollYear, int type, int parentneighborhood)
{
F35100NeighborhoodHeaderData neighborhoodHeaderData = new F35100NeighborhoodHeaderData();
neighborhoodHeaderData.EnforceConstraints = false;
DataSet ds = new DataSet();
Hashtable ht = new Hashtable();
ht.Add("@RollYear", rollYear);
ht.Add("@NBHDType", type);
ht.Add("@ParentNeighborhood", parentneighborhood);
string[] tableNames = new string[] { neighborhoodHeaderData.f35100pclstNeighborhoodDataTable.TableName, neighborhoodHeaderData.f35100GrpNeighborhood.TableName };
Utility.LoadDataSet(neighborhoodHeaderData, "f35100_pclst_Neighborhood", ht, tableNames);
//// Utility.FillDataSet(neighborhoodHeaderData, "f35100_pclst_Neighborhood", ht);
Utility.LoadDataSet(ds, "f35100_pclst_Neighborhood", ht);
return(neighborhoodHeaderData);
}
/// <summary>
/// Checks the duplicate district.
/// </summary>
/// <returns>duplicate record status</returns>
private bool CheckDuplicateneighborhood()
{
F35100NeighborhoodHeaderData duplicateNeighborhoodHeaderData = new F35100NeighborhoodHeaderData();
F35100NeighborhoodHeaderData.CheckDuplicateNeighborhoodTableRow dr = duplicateNeighborhoodHeaderData.CheckDuplicateNeighborhoodTable.NewCheckDuplicateNeighborhoodTableRow();
int errorId = -1;
int tempNBHDID = 0;
//int.TryParse(this.NBHDID.ToString().Trim(), out tempNBHDID);
//if (tempNBHDID > 0)
//{
// dr.NBHDID = this.NBHDID.ToString().Trim();
//}
//dr.NBHDID = tempNBHDID.ToString();
dr.Neighborhood = this.NewNeighborhoodTextBox.Text.Trim();
dr.RollYear = this.RollYear.ToString();
dr.Type = this.Type.ToString();
duplicateNeighborhoodHeaderData.CheckDuplicateNeighborhoodTable.Rows.Add(dr);
duplicateNeighborhoodHeaderData.CheckDuplicateNeighborhoodTable.AcceptChanges();
DataSet tempDataSet = new DataSet("Root");
tempDataSet.Tables.Add(duplicateNeighborhoodHeaderData.CheckDuplicateNeighborhoodTable.Copy());
tempDataSet.Tables[0].TableName = "Table";
//if (string.IsNullOrEmpty(this.NBHDID.ToString().Trim()))
{
errorId = this.form3511Controller.WorkItem.DuplicateNeighborhoodHeaderCheck(0, tempDataSet.GetXml());
}
//else
//{
// errorId = this.form3511Controller.WorkItem.DuplicateNeighborhoodHeaderCheck(tempNBHDID, tempDataSet.GetXml());
//}
if (errorId != -1)
{
return(true);
}
return(false);
}
