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); }
}
}
