protected void fv_ItemInserting(object sender, FormViewInsertEventArgs e)
{
int?i = null;
int iCode = 0;
DropDownList ddlYear = fv.FindControl("ddlYear") as DropDownList;
DropDownList ddlSource = fv.FindControl("ddlSource") as DropDownList;
TextBox tbAmt = fv.FindControl("tbAmt") as TextBox;
StringBuilder sb = new StringBuilder();
using (WACDataClassesDataContext wac = new WACDataClassesDataContext())
{
try
{
short?shYear = null;
if (!string.IsNullOrEmpty(ddlYear.SelectedValue))
{
shYear = Convert.ToInt16(ddlYear.SelectedValue);
}
else
{
sb.Append("Year is required. ");
}
string sSource = null;
if (!string.IsNullOrEmpty(ddlSource.SelectedValue))
{
sSource = ddlSource.SelectedValue;
}
else
{
sb.Append("Source is required. ");
}
decimal?dAmt = null;
if (!string.IsNullOrEmpty(tbAmt.Text))
{
try { dAmt = Convert.ToDecimal(tbAmt.Text); }
catch { sb.Append("Amount must be a number (Decimal). "); }
}
else
{
sb.Append("Amount is required. ");
}
if (string.IsNullOrEmpty(sb.ToString()))
{
iCode = wac.agWorkloadFunding_add(shYear, sSource, dAmt, Session["userName"].ToString(), ref i);
if (iCode == 0)
{
fv.ChangeMode(FormViewMode.ReadOnly);
BindWorkloadFunding(Convert.ToInt32(i));
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
else
{
sb.Insert(0, "The Insert Failed: ");
WACAlert.Show(sb.ToString(), 0);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
