private void BindAg_WFP3_Encumbrance()
{
FormView fv = fvAg_WFP3_Encumbrance;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = from b in wDataContext.form_wfp3_encumbrances.Where(w => w.pk_form_wfp3_encumbrance == PK_Wfp3Encumbrance) select b;
fv.DataKeyNames = new string[] { "pk_form_wfp3_encumbrance" };
fv.DataSource = a;
fv.DataBind();
string sRegionWAC = WACGlobal_Methods.SpecialQuery_Agriculture_GetWACRegion_ByFarmBusinessPK(FK_FarmBusiness);
if (fv.CurrentMode == FormViewMode.Insert)
{
TextBox tbAmount = fv.FindControl("tbAmount") as TextBox;
try
{
var x = wDataContext.form_wfp3_get_encumbranceAmt_all(FK_Wfp3);
tbAmount.Text = x.Single().amt_encumbrance.ToString();
}
catch { }
WACGlobal_Methods.PopulateControl_DatabaseLists_Encumbrance_DDL(fv, "ddlEncumbrance", null);
}
if (fv.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_Encumbrance_DDL(fv, "ddlEncumbrance", a.Single().fk_encumbrance_code);
WACGlobal_Methods.PopulateControl_DatabaseLists_EncumbranceType_DDL(fv.FindControl("ddlType") as DropDownList, a.Single().fk_encumbranceType_code, true);
}
}
}
