private void BindBuildingUnitNumbers(int BuildingNo)
{
try
{
DataTable dt = ProjectLeadOccupantsData.GetBuildingUnitNumbers(BuildingNo);
if (dt.Rows.Count > 0)
{
ddlUnitNumber.Items.Clear();
ddlUnitNumber.DataSource = dt;
ddlUnitNumber.DataValueField = "LeadUnitID";
ddlUnitNumber.DataTextField = "Unit";
ddlUnitNumber.DataBind();
ddlUnitNumber.Items.Insert(0, new ListItem("Select", "NA"));
}
else
{
ddlUnitNumber.Items.Clear();
ddlUnitNumber.Items.Insert(0, new ListItem("No Units Found", "NA"));
}
}
catch (Exception ex)
{
LogError(Pagename, "BindBuildingNumbers", "", ex.Message);
}
}
private void BindOccupantsGrid()
{
try
{
DataTable dt = ProjectLeadOccupantsData.GetProjectLeadOccupantList(DataUtils.GetInt(hfProjectId.Value), cbActiveOnly.Checked);
if (dt.Rows.Count > 0)
{
dvOccupantGrid.Visible = true;
gvOccupant.DataSource = dt;
gvOccupant.DataBind();
Session["dtOccupantsList"] = dt;
}
else
{
dvOccupantGrid.Visible = false;
gvOccupant.DataSource = null;
gvOccupant.DataBind();
}
}
catch (Exception ex)
{
LogError(Pagename, "BindOccupantsGrid", "", ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ddlBldgNumber.SelectedIndex == 0)
{
LogMessage("Select Building #");
ddlBldgNumber.Focus();
return;
}
if (ddlUnitNumber.SelectedIndex == 0)
{
LogMessage("Select Unit #");
ddlUnitNumber.Focus();
return;
}
if (btnSubmit.Text == "Submit")
{
OccupantsResult objOccupantsResult = ProjectLeadOccupantsData.AddProjectLeadOccupants((DataUtils.GetInt(hfProjectId.Value)),
DataUtils.GetInt(ddlBldgNumber.SelectedValue.ToString()), DataUtils.GetInt(ddlUnitNumber.SelectedValue.ToString()),
txtOccupantName.Text, DataUtils.GetInt(ddlAge.SelectedValue.ToString()), DataUtils.GetInt(ddlEthnicity.SelectedValue.ToString()),
DataUtils.GetInt(ddlRace.SelectedValue.ToString()));
ClearOccupantForm();
BindGrids();
if (objOccupantsResult.IsDuplicate && !objOccupantsResult.IsActive)
{
LogMessage("Occupant Info already exist for tihs Bldg# and Unit# as in-active");
}
else if (objOccupantsResult.IsDuplicate)
{
LogMessage("Occupant Info already exist for tihs Bldg# and Unit#");
}
else
{
LogMessage("Occupant Info Added Successfully");
}
}
else
{
ProjectLeadOccupantsData.UpdateProjectLeadOccupants(DataUtils.GetInt(hfLeadOccupantID.Value), txtOccupantName.Text, DataUtils.GetInt(ddlAge.SelectedValue.ToString()), DataUtils.GetInt(ddlEthnicity.SelectedValue.ToString()),
DataUtils.GetInt(ddlRace.SelectedValue.ToString()), chkOccupantActive.Checked);
//ProjectLeadBuildingsData.UpdateProjectLeadBldg((DataUtils.GetInt(hfLeadBldgID.Value)), DataUtils.GetInt(txtBldgnumber.Text), DataUtils.GetInt(ddlAddress.SelectedValue.ToString()),
// DataUtils.GetInt(txtAge.Text), DataUtils.GetInt(ddlType.SelectedValue.ToString()), DataUtils.GetInt(txtLHCUnits.Text), cbFloodHazardArea.Checked, cbFloodInsurance.Checked,
// DataUtils.GetInt(ddlverifiedBy.SelectedValue.ToString()), txtInsuredby.Text, DataUtils.GetInt(ddlHistoricStatus.SelectedValue.ToString()),
// DataUtils.GetInt(ddlAppendixA.SelectedValue.ToString()), chkBldgActive.Checked);
gvOccupant.EditIndex = -1;
BindGrids();
hfLeadOccupantID.Value = "";
ClearOccupantForm();
btnSubmit.Text = "Submit";
LogMessage("Occupant Info Updated Successfully");
}
}
private void BindBuildingNumbers()
{
try
{
ddlBldgNumber.Items.Clear();
ddlBldgNumber.DataSource = ProjectLeadOccupantsData.GetBuildingNumbers(DataUtils.GetInt(hfProjectId.Value));
ddlBldgNumber.DataValueField = "LeadBldgID";
ddlBldgNumber.DataTextField = "Building";
ddlBldgNumber.DataBind();
ddlBldgNumber.Items.Insert(0, new ListItem("Select", "NA"));
//Unit Number Drop Down
ddlUnitNumber.Items.Clear();
ddlUnitNumber.Items.Insert(0, new ListItem("Select", "NA"));
}
catch (Exception ex)
{
LogError(Pagename, "BindBuildingNumbers", "", ex.Message);
}
}
protected void gvOccupant_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
CommonHelper.GridViewSetFocus(e.Row);
btnSubmit.Text = "Update";
//Checking whether the Row is Data Row
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[6].Controls[0].Visible = false;
Label lblLeadOccupantID = e.Row.FindControl("lblLeadOccupantID") as Label;
DataRow dr = ProjectLeadOccupantsData.GetProjectLeadOccupantById(DataUtils.GetInt(lblLeadOccupantID.Text));
hfLeadOccupantID.Value = lblLeadOccupantID.Text;
PopulateDropDown(ddlBldgNumber, dr["LeadBldgID"].ToString());
BindBuildingUnitNumbers(DataUtils.GetInt(dr["LeadBldgID"].ToString()));
PopulateDropDown(ddlUnitNumber, dr["LeadUnitID"].ToString());
PopulateDropDown(ddlAge, dr["LKAge"].ToString());
PopulateDropDown(ddlEthnicity, dr["LKEthnicity"].ToString());
PopulateDropDown(ddlRace, dr["LKRace"].ToString());
txtOccupantName.Text = dr["Name"].ToString();
chkOccupantActive.Checked = DataUtils.GetBool(dr["RowIsActive"].ToString());
ddlBldgNumber.Enabled = false;
ddlUnitNumber.Enabled = false;
chkOccupantActive.Enabled = true;
}
}
}
catch (Exception ex)
{
LogError(Pagename, "gvOccupant_RowDataBound", "", ex.Message);
}
}
