protected void fvAg_WFP3_BMP_ItemInserting(object sender, EventArgs e) { int? i = null; int iCode = 0; 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 tbUnitsCompleted = fv.FindControl("tbUnitsCompleted") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { int?iBMP = null; if (!string.IsNullOrEmpty(ddlBMP.SelectedValue)) { iBMP = Convert.ToInt32(ddlBMP.SelectedValue); } else { sb.Append("BMP is required. "); } decimal?dUnitsDesigned = 0; if (!string.IsNullOrEmpty(tbUnitsDesigned.Text)) { try { dUnitsDesigned = Convert.ToDecimal(tbUnitsDesigned.Text); } catch { sb.Append("Units Designed must be a number (Decimal). "); } } decimal?dDesignCost = 0; if (!string.IsNullOrEmpty(tbDesignCost.Text)) { try { dDesignCost = Convert.ToDecimal(tbDesignCost.Text); } catch { sb.Append("Design Cost must be a number (Decimal). "); } } decimal?dUnitsCompleted = 0; if (!string.IsNullOrEmpty(tbUnitsCompleted.Text)) { try { dUnitsCompleted = Convert.ToDecimal(tbUnitsCompleted.Text); } catch { sb.Append("Units Completed must be a number (Decimal). "); } } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.form_wfp3_bmp_add(FK_Wfp3, iBMP, dUnitsDesigned, dUnitsCompleted, dDesignCost, Session["userName"].ToString(), ref i); if (iCode != 0) { WACAlert.Show("Error Returned from Database. " + sb.ToString(), iCode); } else { PK_Wfp3Bmp = Convert.ToInt32(i); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }