protected void fvAg_WFP3_BMP_ItemUpdating(object sender, EventArgs e) { StringBuilder sbErrorCollection = new StringBuilder(); FormView fv = fvAg_WFP3_BMP; DropDownList ddlBMP = fv.FindControl("ddlBMP") as DropDownList; TextBox tbUnitsDesigned = fv.FindControl("tbUnitsDesigned") as TextBox; TextBox tbDesignCost = fv.FindControl("tbDesignCost") as TextBox; //TextBox tbDimensions = fv.FindControl("tbDimensions") as TextBox; TextBox tbUnitsCompleted = fv.FindControl("tbUnitsCompleted") as TextBox; //TextBox tbDesignCostNote = fv.FindControl("tbDesignCostNote") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.vw_form_wfp3_BMPs.Where(w => w.pk_form_wfp3_bmp == Convert.ToInt32(fv.DataKey.Value)) select b).Single(); int pk_form_wfp3_bmp = a.pk_form_wfp3_bmp; int fk_bmp_ag = a.pk_bmp_ag; decimal?units_designed = a.units_designed; decimal?design_cost = a.design_cost; decimal?units_completed = a.units_completed; try { if (!string.IsNullOrEmpty(ddlBMP.SelectedValue)) { fk_bmp_ag = Convert.ToInt32(ddlBMP.SelectedValue); } if (!string.IsNullOrEmpty(tbUnitsDesigned.Text)) { try { units_designed = Convert.ToDecimal(tbUnitsDesigned.Text); } catch { sbErrorCollection.Append("Units Designed was not updated. Units Designed must be a number (Decimal). "); units_designed = a.units_designed; } } if (!string.IsNullOrEmpty(tbDesignCost.Text)) { try { design_cost = Convert.ToDecimal(tbDesignCost.Text); } catch { sbErrorCollection.Append("Design Cost was not updated. Design Cost must be a number (Decimal). "); design_cost = a.design_cost; } } if (!string.IsNullOrEmpty(tbUnitsCompleted.Text)) { try { units_completed = Convert.ToDecimal(tbUnitsCompleted.Text); } catch { sbErrorCollection.Append("Units Completed was not updated. Design Cost must be a number (Decimal). "); units_completed = a.units_completed; } } int iCode = wDataContext.form_wfp3_bmp_update(pk_form_wfp3_bmp, fk_bmp_ag, units_designed, units_completed, design_cost, Session["userName"].ToString()); if (iCode != 0) { WACAlert.Show("Error Returned from Database. ", iCode); } if (!string.IsNullOrEmpty(sbErrorCollection.ToString())) { WACAlert.Show(sbErrorCollection.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }