private void BindForm()
        {
            DataRow dr = ProjectLeadDataData.GetProjectLeadDataById(DataUtils.GetInt(hfProjectId.Value));

            if (dr != null)
            {
                btnSubmit.Text = "Update";

                txtProjStartDate.Text     = dr["StartDate"].ToString() == "" ? "" : Convert.ToDateTime(dr["StartDate"].ToString()).ToShortDateString();
                txtAllUnitsClrDate.Text   = dr["UnitsClearDate"].ToString() == "" ? "" : Convert.ToDateTime(dr["UnitsClearDate"].ToString()).ToShortDateString();
                txtGrantAmt.Text          = Decimal.Parse(dr["Grantamt"].ToString()).ToString("#.00");
                txtHHIntAmt.Text          = Decimal.Parse(dr["HHIntervention"].ToString()).ToString("#.00");
                txtLoanAmt.Text           = Decimal.Parse(dr["Loanamt"].ToString()).ToString("#.00");
                txtRelocationAmt.Text     = Decimal.Parse(dr["Relocation"].ToString()).ToString("#.00");
                txtClearanceDeCommit.Text = Decimal.Parse(dr["ClearDecom"].ToString()).ToString("#.00");
                txtTotalAwardAmt.Text     = Decimal.Parse(dr["TotAward"].ToString()).ToString("#.00");
                PopulateDropDown(ddlPBContractor, dr["PBCont"].ToString());
                PopulateDropDown(ddlTestingConsultant, dr["Testconsult"].ToString());
            }
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            //if (ddlHousingType.SelectedIndex == 0)
            //{
            //    LogMessage("Select Housing Type");
            //    ddlHousingType.Focus();
            //    return;
            //}

            //if (string.IsNullOrWhiteSpace(txtTotalUnits.Text.ToString()) == true)
            //{
            //    LogMessage("Enter Total Units");
            //    txtTotalUnits.Focus();
            //    return;
            //}
            //if (DataUtils.GetDecimal(txtTotalUnits.Text) <= 0)
            //{
            //    LogMessage("Enter valid Total Units");
            //    txtTotalUnits.Focus();
            //    return;
            //}
            if (btnSubmit.Text.ToLower() == "update")
            {
                ProjectLeadDataData.UpdateProjectLeadData((DataUtils.GetInt(hfProjectId.Value)), DataUtils.GetDate(txtProjStartDate.Text), DataUtils.GetDate(txtAllUnitsClrDate.Text),
                                                          DataUtils.GetDecimal(txtGrantAmt.Text), DataUtils.GetDecimal(txtHHIntAmt.Text), DataUtils.GetDecimal(txtLoanAmt.Text), DataUtils.GetDecimal(txtRelocationAmt.Text),
                                                          DataUtils.GetDecimal(txtClearanceDeCommit.Text), DataUtils.GetInt(ddlTestingConsultant.SelectedValue.ToString()), DataUtils.GetInt(ddlPBContractor.SelectedValue.ToString()),
                                                          DataUtils.GetDecimal(txtTotalAwardAmt.Text), true);

                LogMessage("Project Lead Data updated successfully");
            }
            else
            {
                ProjectLeadDataData.AddProjectLeadData((DataUtils.GetInt(hfProjectId.Value)), DataUtils.GetDate(txtProjStartDate.Text), DataUtils.GetDate(txtAllUnitsClrDate.Text),
                                                       DataUtils.GetDecimal(txtGrantAmt.Text), DataUtils.GetDecimal(txtHHIntAmt.Text), DataUtils.GetDecimal(txtLoanAmt.Text), DataUtils.GetDecimal(txtRelocationAmt.Text),
                                                       DataUtils.GetDecimal(txtClearanceDeCommit.Text), DataUtils.GetInt(ddlTestingConsultant.SelectedValue.ToString()), DataUtils.GetInt(ddlPBContractor.SelectedValue.ToString()),
                                                       DataUtils.GetDecimal(txtTotalAwardAmt.Text));

                LogMessage("Project Lead Data added successfully");
            }
            BindForm();
        }