protected void fvOrganization_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { TextBox tbOrg = fvOrganization.FindControl("tbOrg") as TextBox; try { string sOrg = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbOrg.Text, 96).Trim(); iCode = wDataContext.organization_add(sOrg, Session["userName"].ToString(), ref i); if (iCode == 0) { fvOrganization.ChangeMode(FormViewMode.ReadOnly); BindOrganization(Convert.ToInt32(i)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); } } }
protected void fvSA_Note_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sb = new StringBuilder(); FormView fv = fvSA.FindControl("fvSA_Note") as FormView; TextBox tbNote = fv.FindControl("tbNote") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.supplementalAgreementNotes.Where(w => w.pk_supplementalAgreementNote == Convert.ToInt32(fv.DataKey.Value)).Select(s => s).Single(); try { a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fv.ChangeMode(FormViewMode.ReadOnly); Populate_SA_Note_FormView(fv, Convert.ToInt32(fv.DataKey.Value)); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Invoice_ItemInserting(object sender, FormViewInsertEventArgs e) { int? i = null; int iCode = 0; FormView fv = fvAg_WFP3_Invoice; CustomControls_AjaxCalendar invoiceDate = fv.FindControl("tbCalInvoiceDate") as CustomControls_AjaxCalendar; TextBox tbInvoiceNumber = fv.FindControl("tbInvoiceNumber") as TextBox; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { DateTime?dtDate = invoiceDate.CalDateNullable; string sInvoiceNumber = null; if (!string.IsNullOrEmpty(tbInvoiceNumber.Text)) { sInvoiceNumber = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbInvoiceNumber.Text, 48); } else { sb.Append("Invoice Number is required. "); } decimal?dAmount = null; if (!string.IsNullOrEmpty(tbAmount.Text)) { try { dAmount = Convert.ToDecimal(tbAmount.Text); } catch { sb.Append("Amount must be a number (Decimal). "); } } else { sb.Append("Amount is required. "); } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.form_wfp3_invoice_add(FK_Wfp3, dtDate, sInvoiceNumber, dAmount, Session["userName"].ToString(), ref i); if (iCode != 0) { WACAlert.Show("Error Returned from Database.", iCode); } else { PK_Wfp3Invoice = Convert.ToInt32(i); } } else { WACAlert.Show(sb.ToString(), iCode); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
private void Insert_Properties() { lblGlobal_Insert_Properties.ForeColor = System.Drawing.Color.ForestGreen; int?i = null; int iCode = 0; TextBox tbAddress1 = pnlGlobal_Insert_Properties.FindControl("tbAddress1") as TextBox; TextBox tbAddress2 = pnlGlobal_Insert_Properties.FindControl("tbAddress2") as TextBox; DropDownList ddlState = pnlGlobal_Insert_Properties.FindControl("ddlState") as DropDownList; DropDownList ddlZip = pnlGlobal_Insert_Properties.FindControl("ddlZip") as DropDownList; TextBox tbCity = pnlGlobal_Insert_Properties.FindControl("tbCity") as TextBox; TextBox tbZip4 = pnlGlobal_Insert_Properties.FindControl("tbZip4") as TextBox; DropDownList ddlCounty = pnlGlobal_Insert_Properties.FindControl("ddlCounty") as DropDownList; DropDownList ddlTownshipNY = pnlGlobal_Insert_Properties.FindControl("ddlTownshipNY") as DropDownList; DropDownList ddlBasin = pnlGlobal_Insert_Properties.FindControl("ddlBasin") as DropDownList; DropDownList ddlSubbasin = pnlGlobal_Insert_Properties.FindControl("ddlSubbasin") as DropDownList; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string addr1 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAddress1.Text, 100).Trim(); string addr2 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAddress2.Text, 48).Trim(); string city = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbCity.Text, 48).Trim(); string state = string.IsNullOrEmpty(ddlState.SelectedValue) ? null : ddlState.SelectedValue; string zipCode = string.IsNullOrEmpty(ddlZip.SelectedValue) ? null : ddlZip.SelectedValue; string zip4 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbZip4.Text, 4).Trim(); int? county = null; if (!string.IsNullOrEmpty(ddlCounty.SelectedValue)) { county = Convert.ToInt32(ddlCounty.SelectedValue); } int?township = null; if (!string.IsNullOrEmpty(ddlTownshipNY.SelectedValue)) { township = Convert.ToInt32(ddlTownshipNY.SelectedValue); } string basinCode = string.IsNullOrEmpty(ddlBasin.SelectedValue) ? null : ddlBasin.SelectedValue; string subBasinCode = string.IsNullOrEmpty(ddlSubbasin.SelectedValue) ? null : ddlSubbasin.SelectedValue; iCode = wDataContext.property_add_express(addr1, addr2, city, state, zipCode, zip4, county, township, basinCode, subBasinCode, Session["userName"].ToString(), ref i); if (iCode == 0) { lblGlobal_Insert_Properties.Text = "Successfully added Property: "; } else { throw new WAC_Exceptions.WACEX_GeneralDatabaseException(string.Empty, iCode); } } catch (Exception ex) { lblGlobal_Insert_Properties.ForeColor = System.Drawing.Color.Red; lblGlobal_Insert_Properties.Text = "Error Inserting Property: " + ex.Message; } } }
protected void fvProperty_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; TextBox tbAddress1 = fvProperty.FindControl("tbAddress1") as TextBox; TextBox tbAddress2 = fvProperty.FindControl("tbAddress2") as TextBox; DropDownList ddlState = fvProperty.FindControl("ddlState") as DropDownList; DropDownList ddlZip = fvProperty.FindControl("ddlZip") as DropDownList; TextBox tbCity = fvProperty.FindControl("tbCity") as TextBox; TextBox tbZip4 = fvProperty.FindControl("tbZip4") as TextBox; DropDownList ddlCountyNY = fvProperty.FindControl("ddlCounty") as DropDownList; DropDownList ddlTownshipNY = fvProperty.FindControl("ddlTownshipNY") as DropDownList; DropDownList ddlBasin = fvProperty.FindControl("ddlBasin") as DropDownList; DropDownList ddlSubbasin = fvProperty.FindControl("ddlSubbasin") as DropDownList; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string addr1 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAddress1.Text, 100).Trim(); string addr2 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAddress2.Text, 48).Trim(); string city = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbCity.Text, 48).Trim(); string state = string.IsNullOrEmpty(ddlState.SelectedValue) ? null : ddlState.SelectedValue; string zipCode = string.IsNullOrEmpty(ddlZip.SelectedValue) ? null : ddlZip.SelectedValue; string zip4 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbZip4.Text, 4).Trim(); int? county = null; if (!string.IsNullOrEmpty(ddlCountyNY.SelectedValue)) { county = Convert.ToInt32(ddlCountyNY.SelectedValue); } int?township = null; if (!string.IsNullOrEmpty(ddlTownshipNY.SelectedValue)) { township = Convert.ToInt32(ddlTownshipNY.SelectedValue); } string basinCode = string.IsNullOrEmpty(ddlBasin.SelectedValue) ? null : ddlBasin.SelectedValue; string subBasinCode = string.IsNullOrEmpty(ddlSubbasin.SelectedValue) ? null : ddlSubbasin.SelectedValue; iCode = wDataContext.property_add_express(addr1, addr2, city, state, zipCode, zip4, county, township, basinCode, subBasinCode, Session["userName"].ToString(), ref i); if (iCode == 0) { fvProperty.ChangeMode(FormViewMode.ReadOnly); BindProperty(Convert.ToInt32(i)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); } } }
protected void fvAg_WFP3_Modification_ItemInserting(object sender, FormViewInsertEventArgs e) { int? i = null; int iCode = 0; FormView fv = fvAg_WFP3_Modification; DropDownList ddlBMP = fv.FindControl("ddlBMP") as DropDownList; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; TextBox tbNote = fv.FindControl("tbNote") 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?dAmount = null; try { dAmount = Convert.ToDecimal(tbAmount.Text); } catch { sb.Append("Amount is required. Amount is a number (Decimal). "); } string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.form_wfp3_modification_add(FK_Wfp3, iBMP, dAmount, sNote, Session["userName"].ToString(), ref i); if (iCode != 0) { WACAlert.Show("Error Returned from Database. " + sb.ToString(), iCode); } else { PK_Wfp3Mod = Convert.ToInt32(i); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Invoice_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sb = new StringBuilder(); FormView fv = fvAg_WFP3_Invoice; CustomControls_AjaxCalendar invoiceDate = fv.FindControl("tbCalInvoiceDate") as CustomControls_AjaxCalendar; TextBox tbInvoiceNumber = fv.FindControl("tbInvoiceNumber") as TextBox; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.form_wfp3_invoices.Where(w => w.pk_form_wfp3_invoice == Convert.ToInt32(fv.DataKey.Value)).Select(s => s).Single(); try { a.date = (DateTime)invoiceDate.CalDateNullable; if (!string.IsNullOrEmpty(tbInvoiceNumber.Text)) { a.invoice_nbr = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbInvoiceNumber.Text, 48); } else { sb.Append("Invoice Number was not updated. Invoice Number is required. "); } if (!string.IsNullOrEmpty(tbAmount.Text)) { try { a.amt = Convert.ToDecimal(tbAmount.Text); } catch { sb.Append("Amount was not updated. Amount must be a number (Decimal). "); } } else { sb.Append("Amount was not updated. Amount is required. "); } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
private void Insert_Organizations() { lblGlobal_Insert_Organizations.ForeColor = System.Drawing.Color.ForestGreen; StringBuilder sb = new StringBuilder(); try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { string sOrganization = null; if (!string.IsNullOrEmpty(tbOrganizations_Organization.Text)) { sOrganization = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbOrganizations_Organization.Text, 96); } else { sb.Append("Organization is required. "); } if (string.IsNullOrEmpty(sb.ToString())) { int?i = null; int iCode = wac.organization_add(sOrganization, Session["userName"].ToString(), ref i); if (iCode == 0) { tbOrganizations_Organization.Text = ""; lblGlobal_Insert_Organizations.Text = "Successfully added Organization: " + sOrganization; } else { WACAlert.Show("Error Inserting Organization: ", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } } catch (Exception ex) { lblGlobal_Insert_Organizations.ForeColor = System.Drawing.Color.Red; lblGlobal_Insert_Organizations.Text = "Error Inserting Organization: " + ex.Message; } }
protected void fvOrganization_ItemUpdating(object sender, FormViewUpdateEventArgs e) { TextBox tbOrg = fvOrganization.FindControl("tbOrg") as TextBox; DropDownList ddlContact = fvOrganization.FindControl("UC_DropDownListByAlphabet_Organization").FindControl("ddl") as DropDownList; HiddenField hfPropertyPK = fvOrganization.FindControl("UC_Property_EditInsert_Organization").FindControl("hfPropertyPK") as HiddenField; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.organizations.Where(w => w.pk_organization == Convert.ToInt32(fvOrganization.DataKey.Value)) select b).Single(); a.org = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbOrg.Text, 96).Trim(); if (ddlContact.Items.Count > 0) { if (!string.IsNullOrEmpty(ddlContact.SelectedValue)) { a.fk_participant_contact = Convert.ToInt32(ddlContact.SelectedValue); } else { a.fk_participant_contact = null; } } if (!string.IsNullOrEmpty(hfPropertyPK.Value)) { a.fk_property = Convert.ToInt32(hfPropertyPK.Value); } else { a.fk_property = null; } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); try { wDataContext.SubmitChanges(); fvOrganization.ChangeMode(FormViewMode.ReadOnly); BindOrganization(Convert.ToInt32(fvOrganization.DataKey.Value)); } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Modification_ItemUpdating(object sender, FormViewUpdateEventArgs e) { FormView fv = fvAg_WFP3_Modification; DropDownList ddlBMP = fv.FindControl("ddlBMP") as DropDownList; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; TextBox tbNote = fv.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.form_wfp3_modifications.Where(w => w.pk_form_wfp3_modification == Convert.ToInt32(fv.DataKey.Value)).Select(s => s).Single(); try { if (!string.IsNullOrEmpty(ddlBMP.SelectedValue)) { a.fk_form_wfp3_bmp = Convert.ToInt32(ddlBMP.SelectedValue); } else { sb.Append("BMP was not updated. This is a required field. "); } try { a.amount = Convert.ToDecimal(tbAmount.Text); } catch { sb.Append("Amount was not updated. This is a required field of type number (Decimal). "); } a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvOrganization_Note_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; TextBox tbNote = fvOrganization_Note.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 4000).Trim(); if (string.IsNullOrEmpty(sNote)) { sb.Append("Note is required. "); } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.organizationNote_add(Convert.ToInt32(fvOrganization.DataKey.Value), sNote, Session["userName"].ToString(), ref i); if (iCode == 0) { fvOrganization_Note.ChangeMode(FormViewMode.ReadOnly); BindOrganization_Note(Convert.ToInt32(i)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); } } }
protected void fvOrganization_Note_ItemUpdating(object sender, FormViewUpdateEventArgs e) { TextBox tbNote = fvOrganization_Note.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { var a = (from b in wDataContext.organizationNotes.Where(w => w.pk_organizationNote == Convert.ToInt32(fvOrganization_Note.DataKey.Value)) select b).Single(); if (!string.IsNullOrEmpty(tbNote.Text)) { a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 4000).Trim(); } else { sb.Append("Note was not updated. Note is required. "); } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fvOrganization_Note.ChangeMode(FormViewMode.ReadOnly); BindOrganization_Note(Convert.ToInt32(fvOrganization_Note.DataKey.Value)); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvSA_Note_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; FormView fv = fvSA.FindControl("fvSA_Note") as FormView; TextBox tbNote = fv.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.supplementalAgreementNote_add(Convert.ToInt32(fvSA.DataKey.Value), sNote, Session["userName"].ToString(), ref i); if (iCode == 0) { fv.ChangeMode(FormViewMode.ReadOnly); Populate_SA_Note_FormView(fv, Convert.ToInt32(i)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected int fvAg_WFP3_ItemInserting(object sender, EventArgs e) { int?i = null; int iCode = -1; CustomControls_AjaxCalendar tbCalDesignDate = fvAg_WFP3.FindControl("tbCalDesignDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalProcurementPlanDate = fvAg_WFP3.FindControl("tbCalProcurementPlanDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalOutForBidDate = fvAg_WFP3.FindControl("tbCalOutForBidDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalBidDeadlineDate = fvAg_WFP3.FindControl("tbCalBidDeadlineDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalInstallToDate = fvAg_WFP3.FindControl("tbCalInstallToDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalInstallFromDate = fvAg_WFP3.FindControl("tbCalInstallFromDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalConstructionDate = fvAg_WFP3.FindControl("tbCalConstructionDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalPrintDate = fvAg_WFP3.FindControl("tbCalPrintDate") as CustomControls_AjaxCalendar; DropDownList ddlSpecialProvisions = fvAg_WFP3.FindControl("ddlSpecialProvisions") as DropDownList; TextBox tbDescription = fvAg_WFP3.FindControl("tbDescription") as TextBox; TextBox tbAttachedPages = fvAg_WFP3.FindControl("tbAttachedPages") as TextBox; TextBox tbAttachedSpecifications = fvAg_WFP3.FindControl("tbAttachedSpecifications") as TextBox; DropDownList ddlProcurementType = fvAg_WFP3.FindControl("ddlProcurementType") as DropDownList; TextBox tbNote = fvAg_WFP3.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string sProcurementType = null; if (!string.IsNullOrEmpty(ddlProcurementType.SelectedValue)) { sProcurementType = ddlProcurementType.SelectedValue; } if (string.IsNullOrEmpty(sProcurementType)) { sb.Append("Procurement Type is required. "); } if (!string.IsNullOrEmpty(sProcurementType)) { string sDescription = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbDescription.Text, 255); DateTime?dtDesignDate = tbCalDesignDate.CalDateNullable; DateTime?dtProcurementPlanDate = tbCalProcurementPlanDate.CalDateNullable; DateTime?dtOutForBid = tbCalOutForBidDate.CalDateNullable; DateTime?dtBidDeadlineDate = tbCalBidDeadlineDate.CalDateNullable; DateTime?dtUnderConstruction = tbCalConstructionDate.CalDateNullable; string sSpecialProvisions = "N"; if (!string.IsNullOrEmpty(ddlSpecialProvisions.SelectedValue)) { sSpecialProvisions = ddlSpecialProvisions.SelectedValue; } DateTime?dtInstallFrom = tbCalInstallFromDate.CalDateNullable; DateTime?dtInstallTo = tbCalInstallToDate.CalDateNullable; DateTime?dtPrintDate = tbCalPrintDate.CalDateNullable; string sAttachedPages = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAttachedPages.Text, 4); string sAttachedSpecifications = null; if (!string.IsNullOrEmpty(tbAttachedSpecifications.Text)) { sAttachedSpecifications = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAttachedSpecifications.Text, 255); } string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); iCode = wDataContext.form_wfp3_add_express(Convert.ToInt32(FK_FarmBusiness), sDescription, sProcurementType, dtDesignDate, dtPrintDate, dtProcurementPlanDate, dtBidDeadlineDate, dtOutForBid, dtUnderConstruction, sSpecialProvisions, dtInstallFrom, dtInstallTo, sAttachedPages, sAttachedSpecifications, sNote, Session["userName"].ToString(), ref i); if (iCode == 0) { fvAg_WFP3.ChangeMode(FormViewMode.ReadOnly); PK_FormWfp3 = Convert.ToInt32(i); BindAg_WFP3(); } else { WACAlert.Show("Error Returned from Database.", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } return(iCode); }
protected void fvProperty_ItemUpdating(object sender, FormViewUpdateEventArgs e) { TextBox tbAddress1 = fvProperty.FindControl("tbAddress1") as TextBox; TextBox tbAddress2 = fvProperty.FindControl("tbAddress2") as TextBox; DropDownList ddlState = fvProperty.FindControl("ddlState") as DropDownList; DropDownList ddlZip = fvProperty.FindControl("ddlZip") as DropDownList; TextBox tbCity = fvProperty.FindControl("tbCity") as TextBox; TextBox tbZip4 = fvProperty.FindControl("tbZip4") as TextBox; DropDownList ddlCountyNY = fvProperty.FindControl("ddlCounty") as DropDownList; DropDownList ddlTownshipNY = fvProperty.FindControl("ddlTownshipNY") as DropDownList; DropDownList ddlBasin = fvProperty.FindControl("ddlBasin") as DropDownList; DropDownList ddlSubbasin = fvProperty.FindControl("ddlSubbasin") as DropDownList; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { var a = wDataContext.properties.Where(w => w.pk_property == Convert.ToInt32(fvProperty.DataKey.Value)).Select(s => s).Single(); a.address = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAddress1.Text, 100).Trim(); a.address2 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAddress2.Text, 48).Trim(); a.city = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbCity.Text, 48).Trim(); if (!string.IsNullOrEmpty(ddlState.SelectedValue)) { a.state = ddlState.SelectedValue; } else { a.state = null; } if (!string.IsNullOrEmpty(ddlZip.SelectedValue)) { a.fk_zipcode = ddlZip.SelectedValue; } else { a.fk_zipcode = null; } a.zip4 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbZip4.Text, 4).Trim(); if (!string.IsNullOrEmpty(ddlCountyNY.SelectedValue)) { a.fk_list_countyNY = Convert.ToInt32(ddlCountyNY.SelectedValue); } else { a.fk_list_countyNY = null; } if (!string.IsNullOrEmpty(ddlTownshipNY.SelectedValue)) { a.fk_list_townshipNY = Convert.ToInt32(ddlTownshipNY.SelectedValue); } else { a.fk_list_townshipNY = null; } if (!string.IsNullOrEmpty(ddlBasin.SelectedValue)) { a.fk_basin_code = ddlBasin.SelectedValue; } else { a.fk_basin_code = null; } if (!string.IsNullOrEmpty(ddlSubbasin.SelectedValue)) { a.fk_subbasin_code = ddlSubbasin.SelectedValue; } else { a.fk_subbasin_code = null; } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fvProperty.ChangeMode(FormViewMode.ReadOnly); BindProperty(Convert.ToInt32(fvProperty.DataKey.Value)); } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvVenue_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; TextBox tbLocation = fvVenue.FindControl("tbLocation") as TextBox; DropDownList ddlPhone = fvVenue.FindControl("UC_Communication_EditInsert_Phone").FindControl("ddlNumber") as DropDownList; DropDownList ddlFax = fvVenue.FindControl("UC_Communication_EditInsert_Fax").FindControl("ddlNumber") as DropDownList; TextBox tbEmail = fvVenue.FindControl("tbEmail") as TextBox; TextBox tbNote = fvVenue.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string sLocation = null; if (!string.IsNullOrEmpty(tbLocation.Text)) { sLocation = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbLocation.Text, 48).Trim(); } else { sb.Append("Location is required. "); } int?iPhone = null; if (!string.IsNullOrEmpty(ddlPhone.SelectedValue)) { iPhone = Convert.ToInt32(ddlPhone.SelectedValue); } int?iFax = null; if (!string.IsNullOrEmpty(ddlFax.SelectedValue)) { iFax = Convert.ToInt32(ddlFax.SelectedValue); } string sEmail = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbEmail.Text, 48).Trim(); string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255).Trim(); if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.eventVenue_add(sLocation, iPhone, iFax, sEmail, sNote, Session["userName"].ToString(), ref i); if (iCode == 0) { fvVenue.ChangeMode(FormViewMode.ReadOnly); BindVenue(Convert.ToInt32(i)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); } } }
private void Insert_Participants() { lblGlobal_Insert_Participants.ForeColor = System.Drawing.Color.ForestGreen; StringBuilder sb = new StringBuilder(); try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { string sParticipant = null; string sParticipantSuffix = null; string sParticipantOrg = null; string sNameFirst = null; string sNameLast = null; string sFK_Suffix = null; int? iFK_Organization = null; string sParticipantType = null; string sWACRegion = null; if (rblParticipants.SelectedValue == "0" || rblParticipants.SelectedValue == "1") { if (!string.IsNullOrEmpty(tbParticipants_NameFirst.Text)) { sNameFirst = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbParticipants_NameFirst.Text, 48); } else { sb.Append("First Name is required. "); } if (!string.IsNullOrEmpty(tbParticipants_NameLast.Text)) { sNameLast = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbParticipants_NameLast.Text, 48); } else { sb.Append("Last Name is required. "); } if (!string.IsNullOrEmpty(ddlParticipants_Suffix.SelectedValue)) { sFK_Suffix = ddlParticipants_Suffix.SelectedValue; sParticipantSuffix = ddlParticipants_Suffix.SelectedItem.Text; } } if (rblParticipants.SelectedValue == "1" || rblParticipants.SelectedValue == "2") { DropDownList ddl = UC_DropDownListByAlphabet_Participants.FindControl("ddl") as DropDownList; if (!string.IsNullOrEmpty(ddl.SelectedValue)) { iFK_Organization = Convert.ToInt32(ddl.SelectedValue); sParticipantOrg = ddl.SelectedItem.Text; } else { sb.Append("Organization is required."); } } sParticipant = WACGlobal_Methods.SpecialText_Global_Participant_Name_Org(sNameLast, sNameFirst, null, sParticipantSuffix, sParticipantOrg); sParticipantType = ddlParticipantType.SelectedValue; if (!string.IsNullOrEmpty(ddlWACRegion.SelectedValue)) { sWACRegion = ddlWACRegion.SelectedValue; } if (string.IsNullOrEmpty(sb.ToString())) { int?i = null; int iCode = wac.participant_add_express(sNameFirst, sNameLast, sFK_Suffix, iFK_Organization, sParticipantType, sWACRegion, Session["userName"].ToString(), ref i); if (iCode == 0) { //if (!string.IsNullOrEmpty(StringParticipantType)) //{ // int? i2 = null; // int iCode2 = wac.participantType_add(i, StringParticipantType, Session["userName"].ToString(), ref i2); // if (iCode2 != 0) WACAlert.Show("Successfully added Participant, but Error Inserting Participant Type: ", iCode2); //} Handle_Participant_TypeChange("0", true); lblGlobal_Insert_Participants.Text = "Successfully added Participant: " + sParticipant; } else { WACAlert.Show("Error Inserting Participant: ", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } } catch (Exception ex) { lblGlobal_Insert_Participants.ForeColor = System.Drawing.Color.Red; lblGlobal_Insert_Participants.Text = "Error Inserting Participant: " + ex.Message; } }
protected void fvBMPPlanning_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sb = new StringBuilder(); TextBox tbBMPNumber = fvBMPPlanning.FindControl("tbBMPNumber") as TextBox; TextBox tbDescription = fvBMPPlanning.FindControl("tbDescription") as TextBox; TextBox tbSubIssueStatement = fvBMPPlanning.FindControl("tbSubIssueStatement") as TextBox; DropDownList ddlBMPSource = fvBMPPlanning.FindControl("ddlBMPSource") as DropDownList; TextBox tbLocation = fvBMPPlanning.FindControl("tbLocation") as TextBox; DropDownList ddlRevisionDescription = fvBMPPlanning.FindControl("ddlRevisionDescription") as DropDownList; DropDownList ddlPollutantCategory = fvBMPPlanning.FindControl("ddlPollutantCategory") as DropDownList; DropDownList ddlBMPPractice = fvBMPPlanning.FindControl("ddlBMPPractice") as DropDownList; TextBox tbUnitsPlanned = fvBMPPlanning.FindControl("tbUnitsPlanned") as TextBox; TextBox tbPriorPlanningEstimate = fvBMPPlanning.FindControl("tbPriorPlanningEstimate") as TextBox; TextBox tbPlanningEstimate = fvBMPPlanning.FindControl("tbPlanningEstimate") as TextBox; DropDownList ddlCREP = fvBMPPlanning.FindControl("ddlCREP") as DropDownList; DropDownList ddlNMCPType = fvBMPPlanning.FindControl("ddlNMCPType") as DropDownList; DropDownList ddlSAA = fvBMPPlanning.FindControl("ddlSAA") as DropDownList; DropDownList ddlSA = fvBMPPlanning.FindControl("ddlSA") as DropDownList; using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { try { int? iPH_PK_SA_TP = null; bool bPerformSABMPInsert = false; var a = wac.bmp_ags.Where(w => w.pk_bmp_ag == Convert.ToInt32(fvBMPPlanning.DataKey.Value)).Single(); string sBMP_NBR_Orig = a.bmp_nbr; string sBMP_NBR = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbBMPNumber.Text, 24); if (sBMP_NBR_Orig != sBMP_NBR) { int iBMP_NBR_Count = wac.bmp_ags.Where(w => w.fk_farmBusiness == a.fk_farmBusiness && w.bmp_nbr == sBMP_NBR).Count(); if (iBMP_NBR_Count > 0) { sb.Append("BMP Number was not updated. The BMP Number already exists within this farm."); } else { a.bmp_nbr = sBMP_NBR; } } if (!string.IsNullOrEmpty(tbDescription.Text)) { a.description = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbDescription.Text, 400); } else { sb.Append("Description was not updated. Description is required. "); } if (!string.IsNullOrEmpty(tbSubIssueStatement.Text)) { a.issueStatement_wfp2 = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbSubIssueStatement.Text, 1000); } else { a.issueStatement_wfp2 = null; } if (!string.IsNullOrEmpty(ddlBMPSource.SelectedValue)) { a.fk_BMPSource_code = ddlBMPSource.SelectedValue; } else { sb.Append("BMP Source was not updated. BMP Source is required. "); } if (!string.IsNullOrEmpty(tbLocation.Text)) { a.location = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbLocation.Text, 96); } //else sb.Append("Location was not updated. Location is required. "); if (!string.IsNullOrEmpty(ddlRevisionDescription.SelectedValue)) { a.fk_revisionDescription_code = ddlRevisionDescription.SelectedValue; } else { sb.Append("Revision Description was not updated. Revision Description is required. "); } if (!string.IsNullOrEmpty(ddlPollutantCategory.SelectedValue)) { a.fk_pollutant_category_code = ddlPollutantCategory.SelectedValue; } else { sb.Append("Pollutant Category was not updated. Pollutant Category is required. "); } if (!string.IsNullOrEmpty(ddlBMPPractice.SelectedValue)) { a.fk_bmpPractice_code = Convert.ToDecimal(ddlBMPPractice.SelectedValue); } else { sb.Append("BMP Practice was not updated. BMP Practice is required. "); } if (!string.IsNullOrEmpty(tbUnitsPlanned.Text)) { try { a.units_planned = Convert.ToDecimal(tbUnitsPlanned.Text); } catch { sb.Append("Units Planned was not updated. Units Planned must be a number (Decimal). "); } } //else sb.Append("Units Planned was not updated. Units Planned is required. "); if (!string.IsNullOrEmpty(tbPriorPlanningEstimate.Text)) { try { a.est_plan_prior = Convert.ToDecimal(tbPriorPlanningEstimate.Text); } catch { sb.Append("Prior Planning Estimate was not updated. Prior Planning Estimate must be a number (Decimal). "); } } else { sb.Append("Prior Planning Estimate was not updated. Prior Planning Estimate is required. "); } if (!string.IsNullOrEmpty(tbPlanningEstimate.Text)) { try { a.est_plan_rev = Convert.ToDecimal(tbPlanningEstimate.Text); } catch { sb.Append("Planning Estimate was not updated. Planning Estimate must be a number (Decimal). "); } } else { sb.Append("Planning Estimate was not updated. Planning Estimate is required. "); } if (!string.IsNullOrEmpty(ddlCREP.SelectedValue)) { a.CREP = ddlCREP.SelectedValue; } else { a.CREP = null; } //if (!string.IsNullOrEmpty(ddlNMCPType.SelectedValue)) a.fk_NMCPType_code = ddlNMCPType.SelectedValue; //else a.fk_NMCPType_code = null; if (!string.IsNullOrEmpty(ddlSAA.SelectedValue) && !string.IsNullOrEmpty(ddlSA.SelectedValue)) { iPH_PK_SA_TP = Convert.ToInt32(ddlSA.SelectedValue); if (a.fk_supplementalAgreementTaxParcel != iPH_PK_SA_TP) { bPerformSABMPInsert = true; } a.fk_SAAssignType_code = ddlSAA.SelectedValue; } else if ((!string.IsNullOrEmpty(ddlSAA.SelectedValue) && string.IsNullOrEmpty(ddlSA.SelectedValue)) || (string.IsNullOrEmpty(ddlSAA.SelectedValue) && !string.IsNullOrEmpty(ddlSA.SelectedValue))) { sb.Append("Supplemental Agreement was not updated. Both Supplemental Agreement Assignment and Supplemental Agreement must be defined when attaching a Supplemental Agreement. "); } else if (string.IsNullOrEmpty(ddlSAA.SelectedValue) && string.IsNullOrEmpty(ddlSA.SelectedValue)) { if (a.fk_supplementalAgreementTaxParcel != null) { bPerformSABMPInsert = true; } a.fk_SAAssignType_code = null; } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); //wac.SubmitChanges(); ISingleResult <bmp_ag_update_expressResult> code = wac.bmp_ag_update_express(a.pk_bmp_ag, a.fk_pollutant_category_code, a.bmp_nbr, a.description, a.fk_bmpPractice_code, a.units_planned, a.units_completed, a.est_plan_prior, a.est_plan_rev, a.CREP, a.fk_BMPSource_code, a.location, a.fk_revisionDescription_code, a.fk_SAAssignType_code, a.fk_supplementalAgreementTaxParcel, a.fk_BMPTypeCode, a.fk_BMPCode_code, a.fk_BMPCREPH20_code, a.lifespan_year, a.revisionDescription_addl, a.issueStatement_wfp2, a.modified_by); int iCode = (int)code.ReturnValue; if (iCode == 0) { if (bPerformSABMPInsert) { int?i = null; //int iCodeInsert = wac.bmp_ag_SA_add(Convert.ToInt32(fvBMPPlanning.DataKey.Value), iPH_PK_SA_TP, Session["userName"].ToString(), ref i); int iCodeInsert = wac.bmp_ag_SA_add(Convert.ToInt32(fvBMPPlanning.DataKey.Value), iPH_PK_SA_TP, a.fk_SAAssignType_code, Session["userName"].ToString(), ref i); } fvBMPPlanning.ChangeMode(FormViewMode.ReadOnly); BindData_BMPPlanning_FormView(Convert.ToInt32(fvBMPPlanning.DataKey.Value)); } else { WACAlert.Show("Update failed: ", iCode); } if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Bid_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sbErrorCollection = new StringBuilder(); FormView fv = fvAg_WFP3_Bid; DropDownList ddlContractor = fv.FindControl("ddlContractor") as DropDownList; TextBox tbBidAmount = fv.FindControl("tbBidAmount") as TextBox; CustomControls_AjaxCalendar tbCalBidAwardDate = fv.FindControl("tbCalBidAwardDate") as CustomControls_AjaxCalendar; TextBox tbModificationAmount = fv.FindControl("tbModificationAmount") as TextBox; TextBox tbBidRank = fv.FindControl("tbBidRank") as TextBox; TextBox tbNote = fv.FindControl("tbNote") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.form_wfp3_bids.Where(w => w.pk_form_wfp3_bid == Convert.ToInt32(fv.DataKey.Value)) select b).Single(); try { if (!string.IsNullOrEmpty(ddlContractor.SelectedValue)) { a.fk_participant_contractor = Convert.ToInt32(ddlContractor.SelectedValue); } else { sbErrorCollection.Append("Contractor was not updated. This is a required field. "); } try { if (!string.IsNullOrEmpty(tbBidAmount.Text)) { a.bid_amt = Convert.ToDecimal(tbBidAmount.Text); } } catch { sbErrorCollection.Append("Bid Amount was not updated. Must be a number (Decimal). "); } a.bid_awarded = tbCalBidAwardDate.CalDateNullable; a.modification_amt = 0; try { if (!string.IsNullOrEmpty(tbModificationAmount.Text)) { a.modification_amt = Convert.ToDecimal(tbModificationAmount.Text); } } catch { sbErrorCollection.Append("Modification Amount was not updated. Must be a number (Decimal). "); } try { if (!string.IsNullOrEmpty(tbBidRank.Text)) { a.bid_rank = Convert.ToByte(tbBidRank.Text); } } catch { sbErrorCollection.Append("Bid Rank was not updated. Must be a Number (Byte). "); } a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); if (!string.IsNullOrEmpty(sbErrorCollection.ToString())) { WACAlert.Show(sbErrorCollection.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvList_Ag_BMPPractice_ItemInserting(object sender, FormViewInsertEventArgs e) { int iCode = 0; TextBox tbPK = fvList_Ag_BMPPractice.FindControl("tbPK") as TextBox; TextBox tbPractice = fvList_Ag_BMPPractice.FindControl("tbPractice") as TextBox; DropDownList ddlAgency = fvList_Ag_BMPPractice.FindControl("ddlAgency") as DropDownList; DropDownList ddlLifespan = fvList_Ag_BMPPractice.FindControl("ddlLifespan") as DropDownList; DropDownList ddlAgronomic = fvList_Ag_BMPPractice.FindControl("ddlAgronomic") as DropDownList; DropDownList ddlUnit = fvList_Ag_BMPPractice.FindControl("ddlUnit") as DropDownList; DropDownList ddlWACPracticeCategory = fvList_Ag_BMPPractice.FindControl("ddlWACPracticeCategory") as DropDownList; TextBox tbABC = fvList_Ag_BMPPractice.FindControl("tbABC") as TextBox; TextBox tbABCNote = fvList_Ag_BMPPractice.FindControl("tbABCNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { decimal?dPracticeCode = null; if (!string.IsNullOrEmpty(tbPractice.Text)) { try { dPracticeCode = Convert.ToDecimal(tbPK.Text); } catch { sb.Append("Practice Code must be a number (Decimal). "); } } else { sb.Append("Practice Code is required. "); } string sAgency = null; if (!string.IsNullOrEmpty(ddlAgency.SelectedValue)) { sAgency = ddlAgency.SelectedValue; } else { sb.Append("Agency is required. "); } string sPractice = null; if (!string.IsNullOrEmpty(tbPractice.Text)) { sPractice = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbPractice.Text, 96); } else { sb.Append("Practice is required. "); } byte?byLifeRequiredYears = Convert.ToByte(ddlLifespan.SelectedValue); string sAgronomic = null; if (!string.IsNullOrEmpty(ddlAgronomic.SelectedValue)) { sAgronomic = ddlAgronomic.SelectedValue; } string sUnit = null; if (!string.IsNullOrEmpty(ddlUnit.SelectedValue)) { sUnit = ddlUnit.SelectedValue; } else { sb.Append("Units is required. "); } int?iWACPracticeCategory = null; if (!string.IsNullOrEmpty(ddlWACPracticeCategory.SelectedValue)) { iWACPracticeCategory = Convert.ToInt32(ddlWACPracticeCategory.SelectedValue); } decimal?dABC = null; if (!string.IsNullOrEmpty(tbABC.Text)) { try { dABC = Convert.ToDecimal(tbABC.Text); } catch { sb.Append("ABC must be a number (Interger). "); } } string sABCNote = null; if (!string.IsNullOrEmpty(tbABCNote.Text)) { sABCNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbABCNote.Text, 255); } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.list_bmpPractice_add(dPracticeCode, sAgency, sPractice, byLifeRequiredYears, sAgronomic, sUnit, iWACPracticeCategory, dABC, sABCNote); if (iCode == 0) { fvList_Ag_BMPPractice.ChangeMode(FormViewMode.ReadOnly); BindData_Ag_BMPPractice(Convert.ToDecimal(dPracticeCode)); } else { WACAlert.Show("Error Returned from Database.", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); } } }
protected void fvList_Ag_BMPPractice_ItemUpdating(object sender, FormViewUpdateEventArgs e) { TextBox tbPractice = fvList_Ag_BMPPractice.FindControl("tbPractice") as TextBox; DropDownList ddlAgency = fvList_Ag_BMPPractice.FindControl("ddlAgency") as DropDownList; DropDownList ddlLifespan = fvList_Ag_BMPPractice.FindControl("ddlLifespan") as DropDownList; DropDownList ddlAgronomic = fvList_Ag_BMPPractice.FindControl("ddlAgronomic") as DropDownList; DropDownList ddlUnit = fvList_Ag_BMPPractice.FindControl("ddlUnit") as DropDownList; DropDownList ddlWACPracticeCategory = fvList_Ag_BMPPractice.FindControl("ddlWACPracticeCategory") as DropDownList; TextBox tbABC = fvList_Ag_BMPPractice.FindControl("tbABC") as TextBox; TextBox tbABCNote = fvList_Ag_BMPPractice.FindControl("tbABCNote") as TextBox; DropDownList ddlActive = fvList_Ag_BMPPractice.FindControl("ddlActive") as DropDownList; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { var a = wDataContext.list_bmpPractices.Where(w => w.pk_bmpPractice_code == Convert.ToDecimal(fvList_Ag_BMPPractice.DataKey.Value)).Select(s => s).Single(); if (!string.IsNullOrEmpty(tbPractice.Text)) { a.practice = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbPractice.Text, 96); } else { sb.Append("Practice was not updated. Practice is required. "); } if (!string.IsNullOrEmpty(ddlAgency.SelectedValue)) { a.fk_agency_code = ddlAgency.SelectedValue; } else { a.fk_agency_code = null; } a.life_reqd_yr = Convert.ToByte(ddlLifespan.SelectedValue); if (!string.IsNullOrEmpty(ddlAgronomic.SelectedValue)) { a.agronomic = ddlAgronomic.SelectedValue; } else { a.agronomic = null; } if (!string.IsNullOrEmpty(ddlUnit.SelectedValue)) { a.fk_unit_code = ddlUnit.SelectedValue; } else { a.fk_unit_code = null; } if (!string.IsNullOrEmpty(ddlWACPracticeCategory.SelectedValue)) { a.fk_list_wacPracticeCategory = Convert.ToInt32(ddlWACPracticeCategory.SelectedValue); } else { a.fk_list_wacPracticeCategory = null; } if (!string.IsNullOrEmpty(tbABC.Text)) { try { a.ABC = Convert.ToDecimal(tbABC.Text); } catch { sb.Append("ABC was not updated. Must be a number (Interger). "); } } if (!string.IsNullOrEmpty(tbABCNote.Text)) { a.ABC_note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbABCNote.Text, 255); } else { a.ABC_note = null; } a.active = ddlActive.SelectedValue; wDataContext.SubmitChanges(); fvList_Ag_BMPPractice.ChangeMode(FormViewMode.ReadOnly); BindData_Ag_BMPPractice(Convert.ToDecimal(fvList_Ag_BMPPractice.DataKey.Value)); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Encumbrance_ItemInserting(object sender, FormViewInsertEventArgs e) { int? i = null; int iCode = 0; FormView fv = fvAg_WFP3_Encumbrance; DropDownList ddlEncumbrance = fv.FindControl("ddlEncumbrance") as DropDownList; CustomControls_AjaxCalendar ecDate = fvAg_WFP3_Encumbrance.FindControl("tbCalEncumbranceDate") as CustomControls_AjaxCalendar; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; TextBox tbNote = fv.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { if (wDataContext.form_wfp3_get_okToEncumber(FK_Wfp3) != "N") { string sEncumbrance = null; if (!string.IsNullOrEmpty(ddlEncumbrance.SelectedValue)) { sEncumbrance = ddlEncumbrance.SelectedValue; } else { sb.Append("Encumbrance is required. "); } DateTime?dtDate = ecDate.CalDateNotNullable; if (dtDate == null) { sb.Append("Date is required. "); } decimal?dAmount = null; if (!string.IsNullOrEmpty(tbAmount.Text)) { try { dAmount = Convert.ToDecimal(tbAmount.Text); if (dAmount < (decimal)0.01) { sb.Append("Encumbrance ammount must be greater than zero"); } } catch { sb.Append("Amount is incorrect. Must be a number (Decimal). "); } } else { sb.Append("Amount is required. "); } string sNote = null; if (!string.IsNullOrEmpty(tbNote.Text)) { sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.form_wfp3_encumbrance_add(FK_Wfp3, sEncumbrance, dtDate, dAmount, sNote, Session["userName"].ToString(), ref i); if (iCode != 0) { WACAlert.Show("Error Returned from Database.", iCode); } else { PK_Wfp3Encumbrance = Convert.ToInt32(i); } } else { WACAlert.Show(sb.ToString(), iCode); } } else { WACAlert.Show("It is not okay to encumber this package. ", 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvParticipant_ItemUpdating(object sender, FormViewUpdateEventArgs e) { DropDownList ddlActive = fvParticipant.FindControl("ddlActive") as DropDownList; DropDownList ddlPrefix = fvParticipant.FindControl("ddlPrefix") as DropDownList; TextBox tbNameFirst = fvParticipant.FindControl("tbNameFirst") as TextBox; TextBox tbNameMiddle = fvParticipant.FindControl("tbNameMiddle") as TextBox; TextBox tbNameLast = fvParticipant.FindControl("tbNameLast") as TextBox; DropDownList ddlSuffix = fvParticipant.FindControl("ddlSuffix") as DropDownList; TextBox tbNickname = fvParticipant.FindControl("tbNickname") as TextBox; DropDownList ddlOrganization = fvParticipant.FindControl("UC_DropDownListByAlphabet_Organization").FindControl("ddl") as DropDownList; TextBox tbEmail = fvParticipant.FindControl("tbEmail") as TextBox; TextBox tbWeb = fvParticipant.FindControl("tbWeb") as TextBox; DropDownList ddlRegionWAC = fvParticipant.FindControl("ddlRegionWAC") as DropDownList; DropDownList ddlMailingStatus = fvParticipant.FindControl("ddlMailingStatus") as DropDownList; DropDownList ddlGender = fvParticipant.FindControl("ddlGender") as DropDownList; DropDownList ddlEthnicity = fvParticipant.FindControl("ddlEthnicity") as DropDownList; DropDownList ddlRace = fvParticipant.FindControl("ddlRace") as DropDownList; DropDownList ddlDiversityData = fvParticipant.FindControl("ddlDiversityData") as DropDownList; Calendar calFormW9SignedDate = fvParticipant.FindControl("UC_EditCalendar_Participant_FormW9SignedDate").FindControl("cal") as Calendar; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { var a = wDataContext.participants.Where(o => o.pk_participant == Convert.ToInt32(fvParticipant.DataKey.Value)).Select(s => s).Single(); if (!string.IsNullOrEmpty(ddlActive.SelectedValue)) { a.active = ddlActive.SelectedValue; } if (!string.IsNullOrEmpty(ddlPrefix.SelectedValue)) { a.fk_prefix_code = ddlPrefix.SelectedValue; } else { a.fk_prefix_code = null; } a.fname = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNameFirst.Text, 48).Trim(); a.mname = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNameMiddle.Text, 24).Trim(); a.lname = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNameLast.Text, 48).Trim(); if (!string.IsNullOrEmpty(ddlSuffix.SelectedValue)) { a.fk_suffix_code = ddlSuffix.SelectedValue; } else { a.fk_suffix_code = null; } a.nickname = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNickname.Text, 24).Trim(); if (!string.IsNullOrEmpty(ddlOrganization.SelectedValue)) { a.fk_organization = Convert.ToInt32(ddlOrganization.SelectedValue); } else { a.fk_organization = null; } a.email = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbEmail.Text, 48).Trim(); a.web = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbWeb.Text, 96).Trim(); if (!string.IsNullOrEmpty(ddlRegionWAC.SelectedValue)) { a.fk_regionWAC_code = ddlRegionWAC.SelectedValue; } else { a.fk_regionWAC_code = null; } a.fk_mailingStatus_code = ddlMailingStatus.SelectedValue; a.fk_gender_code = ddlGender.SelectedValue; a.fk_ethnicity_code = ddlEthnicity.SelectedValue; a.fk_race_code = ddlRace.SelectedValue; a.fk_diversityData_code = ddlDiversityData.SelectedValue; if (calFormW9SignedDate.SelectedDate.Year > 1900) { a.form_W9_signed_date = calFormW9SignedDate.SelectedDate; } else { a.form_W9_signed_date = null; } //if (!string.IsNullOrEmpty(hfPropertyPK.Value)) a.fk_property = Convert.ToInt32(hfPropertyPK.Value); //else a.fk_property = null; a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fvParticipant.ChangeMode(FormViewMode.ReadOnly); BindParticipant(Convert.ToInt32(fvParticipant.DataKey.Value)); } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Encumbrance_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sb = new StringBuilder(); FormView fv = fvAg_WFP3_Encumbrance; DropDownList ddlEncumbrance = fv.FindControl("ddlEncumbrance") as DropDownList; CustomControls_AjaxCalendar ecDate = fv.FindControl("tbCalEncumbranceDate") as CustomControls_AjaxCalendar; DropDownList ddlType = fv.FindControl("ddlType") as DropDownList; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; CustomControls_AjaxCalendar approvedDate = fv.FindControl("tbCalEncumbranceApprovedDate") as CustomControls_AjaxCalendar; TextBox tbNote = fv.FindControl("tbNote") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.form_wfp3_encumbrances.Where(w => w.pk_form_wfp3_encumbrance == Convert.ToInt32(fv.DataKey.Value)).Select(s => s).Single(); try { if (!string.IsNullOrEmpty(ddlEncumbrance.SelectedValue)) { a.fk_encumbrance_code = ddlEncumbrance.SelectedValue; } else { sb.Append("Encumbrance was not updated. Encumbrance is required. "); } DateTime?dt = ecDate.CalDateNullable; if (dt == null) { sb.Append("Date was not updated. Date is required. "); } else { a.date = (DateTime)ecDate.CalDateNullable; } if (!string.IsNullOrEmpty(ddlType.SelectedValue)) { a.fk_encumbranceType_code = ddlType.SelectedValue; } else { a.fk_encumbranceType_code = null; } if (!string.IsNullOrEmpty(tbAmount.Text)) { try { a.amt = Convert.ToDecimal(tbAmount.Text); } catch { sb.Append("Amount was not updated. Must be a number (Decimal). "); } } else { sb.Append("Amount was not updated. Amount is required. "); } a.approved = approvedDate.CalDateNullable; if (!string.IsNullOrEmpty(tbNote.Text)) { a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); } else { a.note = null; } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_PaymentBMP_ItemUpdating(object sender, FormViewUpdateEventArgs e) { FormView fv = fvAg_WFP3_PaymentBMP; DropDownList ddlPaymentStatus = fv.FindControl("ddlPaymentStatus") as DropDownList; TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; TextBox tbAmountFundingAgency = fv.FindControl("tbAmountFundingAgency") as TextBox; DropDownList ddlFundingAgency = fv.FindControl("ddlFundingAgency") as DropDownList; DropDownList ddlReimbursementYN = fv.FindControl("ddlReimbursementYN") as DropDownList; DropDownList ddlBMPPractice = fv.FindControl("ddlBMPPractice") as DropDownList; TextBox tbNote = fv.FindControl("tbNote") as TextBox; TextBox tbNMCPPurchase = fv.FindControl("tbNMCPPurchase") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.form_wfp3_paymentBMPs.Where(w => w.pk_form_wfp3_paymentBMP == Convert.ToInt32(fv.DataKey.Value)) select b).Single(); try { if (!string.IsNullOrEmpty(ddlPaymentStatus.SelectedValue)) { a.fk_paymentStatus_code = ddlPaymentStatus.SelectedValue; } else { sb.Append("Payment Status was not updated. This field is required. "); } try { a.amt = Convert.ToDecimal(tbAmount.Text); } catch { sb.Append("Amount was not updated. This field is required. Data type is number (Decimal). "); } try { if (!string.IsNullOrEmpty(tbAmountFundingAgency.Text)) { a.amt_agencyFunding = Convert.ToDecimal(tbAmountFundingAgency.Text); } else { a.amt_agencyFunding = null; } } catch { } if (!string.IsNullOrEmpty(ddlFundingAgency.SelectedValue)) { a.fk_agencyFunding_code = ddlFundingAgency.SelectedValue; } if (!string.IsNullOrEmpty(ddlBMPPractice.SelectedValue)) { a.fk_bmpPractice_code = Convert.ToDecimal(ddlBMPPractice.SelectedValue); } else { a.fk_bmpPractice_code = null; } if (!string.IsNullOrEmpty(tbNMCPPurchase.Text)) { a.purchaseNMCP = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNMCPPurchase.Text, 255); } else { a.purchaseNMCP = null; } if (!string.IsNullOrEmpty(tbNote.Text)) { a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); } else { a.note = null; } a.reimbursement = ddlReimbursementYN.SelectedValue; a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Payment_ItemUpdating(object sender, FormViewUpdateEventArgs e) { FormView fv = fvAg_WFP3_Payment; DropDownList ddlPayee = fv.FindControl("ddlPayee") as DropDownList; DropDownList ddlInvoice = fv.FindControl("ddlInvoice") as DropDownList; CustomControls_AjaxCalendar tbCalPaymentDate = fv.FindControl("tbCalPaymentDate") as CustomControls_AjaxCalendar; TextBox tbCheckNumber = fv.FindControl("tbCheckNumber") as TextBox; DropDownList ddlEncumbrance = fv.FindControl("ddlEncumbrance") as DropDownList; //DropDownList ddlIsContractor = fv.FindControl("ddlIsContractor") as DropDownList; //DropDownList ddlFlood2006 = fv.FindControl("ddlFlood2006") as DropDownList; TextBox tbNote = fv.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.form_wfp3_payments.Where(w => w.pk_form_wfp3_payment == Convert.ToInt32(fv.DataKey.Value)) select b).Single(); try { if (!string.IsNullOrEmpty(ddlPayee.SelectedValue)) { a.fk_participant_payee = Convert.ToInt32(ddlPayee.SelectedValue); } else { sb.Append("Payee was not updated. This is a required field. "); } if (!string.IsNullOrEmpty(ddlInvoice.SelectedValue)) { a.fk_form_wfp3_invoice = Convert.ToInt32(ddlInvoice.SelectedValue); } else { a.fk_form_wfp3_invoice = null; } a.date = (DateTime)tbCalPaymentDate.CalDateNullable; if (!string.IsNullOrEmpty(tbCheckNumber.Text)) { a.check_nbr = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbCheckNumber.Text, 16); } else { sb.Append("Check Number was not updated. This is a required field. "); } if (!string.IsNullOrEmpty(ddlEncumbrance.SelectedValue)) { a.fk_encumbrance_code = ddlEncumbrance.SelectedValue; } else { sb.Append("Encumbrance was not updated. This is a required field. "); } //if (!string.IsNullOrEmpty(ddlIsContractor.SelectedValue)) a.is_contractor = ddlIsContractor.SelectedValue; //else a.is_contractor = null; //if (!string.IsNullOrEmpty(ddlFlood2006.SelectedValue)) a.flood_2006 = ddlFlood2006.SelectedValue; //else a.flood_2006 = null; a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 400); a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Bid_ItemInserting(object sender, FormViewInsertEventArgs e) { int? i = null; int iCode = 0; FormView fv = fvAg_WFP3_Bid; DropDownList ddlContractor = fv.FindControl("ddlContractor") as DropDownList; TextBox tbBidAmount = fv.FindControl("tbBidAmount") as TextBox; CustomControls_AjaxCalendar tbCalBidAwardDate = fv.FindControl("tbCalBidAwardDate") as CustomControls_AjaxCalendar; TextBox tbModificationAmount = fv.FindControl("tbModificationAmount") as TextBox; TextBox tbBidRank = fv.FindControl("tbBidRank") as TextBox; TextBox tbNote = fv.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { int?iContractorFK = null; if (!string.IsNullOrEmpty(ddlContractor.SelectedValue)) { iContractorFK = Convert.ToInt32(ddlContractor.SelectedValue); } else { sb.Append("Contractor is required. "); } decimal?dBidAmount = null; try { if (!string.IsNullOrEmpty(tbBidAmount.Text)) { dBidAmount = Convert.ToDecimal(tbBidAmount.Text); } } catch { } if (dBidAmount == null || dBidAmount == 0) { sb.Append("Bid Amount is required and must be greater than 0. "); } decimal?dModificationAmount = null; try { if (!string.IsNullOrEmpty(tbModificationAmount.Text)) { dModificationAmount = Convert.ToDecimal(tbModificationAmount.Text); } } catch { } string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); byte?byBidRank = null; try { if (!string.IsNullOrEmpty(tbBidRank.Text)) { byBidRank = Convert.ToByte(tbBidRank.Text); } } catch { } DateTime?dtBidAwarded = tbCalBidAwardDate.CalDateNullable; if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.form_wfp3_bid_add(FK_Wfp3, iContractorFK, dBidAmount, dModificationAmount, sNote, byBidRank, dtBidAwarded, Session["userName"].ToString(), ref i); if (iCode != 0) { WACAlert.Show("Error Returned from Database.", iCode); } else { PK_Wfp3Bid = Convert.ToInt32(i); } } else { WACAlert.Show(sb.ToString(), iCode); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvAg_WFP3_Payment_ItemInserting(object sender, FormViewInsertEventArgs e) { int? i = null; int iCode = 0; FormView fv = fvAg_WFP3_Payment; DropDownList ddlPayee = fv.FindControl("ddlPayee") as DropDownList; DropDownList ddlInvoice = fv.FindControl("ddlInvoice") as DropDownList; CustomControls_AjaxCalendar tbCalPaymentDate = fv.FindControl("tbCalPaymentDate") as CustomControls_AjaxCalendar; TextBox tbCheckNumber = fv.FindControl("tbCheckNumber") as TextBox; DropDownList ddlEncumbrance = fv.FindControl("ddlEncumbrance") as DropDownList; //DropDownList ddlIsContractor = fv.FindControl("ddlIsContractor") as DropDownList; TextBox tbNote = fv.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { int?iPayee = null; if (!string.IsNullOrEmpty(ddlPayee.SelectedValue)) { iPayee = Convert.ToInt32(ddlPayee.SelectedValue); } else { sb.Append("Payee is required. "); } int?iInvoice = null; if (!string.IsNullOrEmpty(ddlInvoice.SelectedValue)) { iInvoice = Convert.ToInt32(ddlInvoice.SelectedValue); } DateTime?dtDate = tbCalPaymentDate.CalDateNullable; string sCheckNumber = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbCheckNumber.Text, 16); if (string.IsNullOrEmpty(sCheckNumber)) { sb.Append("Check Number is required. "); } string sEncumbrance = null; if (!string.IsNullOrEmpty(ddlEncumbrance.SelectedValue)) { sEncumbrance = ddlEncumbrance.SelectedValue; } else { sb.Append("Encumbrance is required. "); } //string sIsContractor = null; //if (!string.IsNullOrEmpty(ddlIsContractor.SelectedValue)) sIsContractor = ddlIsContractor.SelectedValue; string sNote = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 400); if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.form_wfp3_payment_add(FK_Wfp3, iPayee, iInvoice, dtDate, sCheckNumber, sEncumbrance, sNote, Session["userName"].ToString(), ref i); if (iCode != 0) { WACAlert.Show("Error Returned from Database. " + sb.ToString(), iCode); } else { PK_Wfp3Payment = Convert.ToInt32(i); } } else { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }
protected void fvBMPPlanning_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; DropDownList ddlFarm = fvBMPPlanning.FindControl("ddlFarm") as DropDownList; DropDownList ddlBMPSource = fvBMPPlanning.FindControl("ddlBMPSource") as DropDownList; DropDownList ddlRevisionDescription = fvBMPPlanning.FindControl("ddlRevisionDescription") as DropDownList; DropDownList ddlPollutantCategory = fvBMPPlanning.FindControl("ddlPollutantCategory") as DropDownList; TextBox tbBMPNumber = fvBMPPlanning.FindControl("tbBMPNumber") as TextBox; TextBox tbDescription = fvBMPPlanning.FindControl("tbDescription") as TextBox; TextBox tbSubIssueStatement = fvBMPPlanning.FindControl("tbSubIssueStatement") as TextBox; DropDownList ddlBMPPractice = fvBMPPlanning.FindControl("ddlBMPPractice") as DropDownList; TextBox tbUnitsPlanned = fvBMPPlanning.FindControl("tbUnitsPlanned") as TextBox; TextBox tbPriorPlanningEstimate = fvBMPPlanning.FindControl("tbPriorPlanningEstimate") as TextBox; TextBox tbPlanningEstimate = fvBMPPlanning.FindControl("tbPlanningEstimate") as TextBox; //DropDownList ddlImplementationYear = fvBMPPlanning.FindControl("ddlImplementationYear") as DropDownList; TextBox tbLocation = fvBMPPlanning.FindControl("tbLocation") as TextBox; DropDownList ddlCREP = fvBMPPlanning.FindControl("ddlCREP") as DropDownList; //DropDownList ddlNMCPType = fvBMPPlanning.FindControl("ddlNMCPType") as DropDownList; DropDownList ddlSAA = fvBMPPlanning.FindControl("ddlSAA") as DropDownList; DropDownList ddlSA = fvBMPPlanning.FindControl("ddlSA") as DropDownList; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { int?iPK_FarmBusiness = null; if (!string.IsNullOrEmpty(ddlFarm.SelectedValue)) { iPK_FarmBusiness = Convert.ToInt32(ddlFarm.SelectedValue); } else { sb.Append("Farm is required. "); } string sBMPSource = ddlBMPSource.SelectedValue; string sPollutant = null; if (!string.IsNullOrEmpty(ddlPollutantCategory.SelectedValue)) { sPollutant = ddlPollutantCategory.SelectedValue; } else { sb.Append("Pollutant is required. "); } string sBMPNumber = null; if (!string.IsNullOrEmpty(tbBMPNumber.Text)) { sBMPNumber = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbBMPNumber.Text, 24); } else { sb.Append("BMP Number is required. "); } string sDescription = null; if (!string.IsNullOrEmpty(tbDescription.Text)) { sDescription = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbDescription.Text, 400); } string sSubIssueStatement = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbSubIssueStatement.Text, 1000); decimal?dPractice = null; if (!string.IsNullOrEmpty(ddlBMPPractice.SelectedValue)) { dPractice = Convert.ToDecimal(ddlBMPPractice.SelectedValue); } else { sb.Append("Practice is required. "); } decimal?dUnitsPlanned = null; if (!string.IsNullOrEmpty(tbUnitsPlanned.Text)) { try { dUnitsPlanned = Convert.ToDecimal(tbUnitsPlanned.Text); } catch { } } decimal?dEstPlanPrior = null; if (!string.IsNullOrEmpty(tbPriorPlanningEstimate.Text)) { try { dEstPlanPrior = Convert.ToDecimal(tbPriorPlanningEstimate.Text); } catch { } } else { sb.Append("Prior Planning Estimate is required. "); } decimal?dCurrentPlanningEstimate = null; if (!string.IsNullOrEmpty(tbPlanningEstimate.Text)) { try { dCurrentPlanningEstimate = Convert.ToDecimal(tbPlanningEstimate.Text); } catch { sb.Append("Current Planning Estimate must be a number (Decimal). "); } } else { sb.Append("Current Planning Estimate is required. "); } string sCREP = null; if (!string.IsNullOrEmpty(ddlCREP.SelectedValue)) { sCREP = ddlCREP.SelectedValue; } string sBMPStatus = "DR"; //short? shScheduledImplementationYear = null; //if (!string.IsNullOrEmpty(ddlImplementationYear.SelectedValue)) shScheduledImplementationYear = Convert.ToInt16(ddlImplementationYear.SelectedValue); //else sb.Append("Implementation Year is required. "); //string sNMCPType = null; //if (!string.IsNullOrEmpty(ddlNMCPType.SelectedValue)) sNMCPType = ddlNMCPType.SelectedValue; string sLocation = null; if (!string.IsNullOrEmpty(tbLocation.Text)) { sLocation = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbLocation.Text, 96); } string sRevisionDescription = null; if (!string.IsNullOrEmpty(ddlRevisionDescription.SelectedValue)) { sRevisionDescription = ddlRevisionDescription.SelectedValue; } string sSAAssignType = null; int? iPK_SupplementalAgreementTaxParcel = null; if (!string.IsNullOrEmpty(ddlSAA.SelectedValue) && !string.IsNullOrEmpty(ddlSA.SelectedValue)) { sSAAssignType = ddlSAA.SelectedValue; iPK_SupplementalAgreementTaxParcel = Convert.ToInt32(ddlSA.SelectedValue); } else { if ((!string.IsNullOrEmpty(ddlSAA.SelectedValue) && string.IsNullOrEmpty(ddlSA.SelectedValue)) || (string.IsNullOrEmpty(ddlSAA.SelectedValue) && !string.IsNullOrEmpty(ddlSA.SelectedValue))) { sb.Append("Both Supplemental Agreement Assignment and Supplemental Agreement must be defined when attaching a Supplemental Agreement. "); } } string sfk_BMPSortGroup_code = null; //if (!string.IsNullOrEmpty(sfk_BMPSortGroup_code.Text)) sLocation = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbLocation.Text, 96); if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.bmp_ag_add_express(iPK_FarmBusiness, sPollutant, sBMPNumber, sDescription, dPractice, dUnitsPlanned, dEstPlanPrior, dCurrentPlanningEstimate, sCREP, sBMPStatus, sBMPSource, sLocation, sRevisionDescription, sSAAssignType, iPK_SupplementalAgreementTaxParcel, sfk_BMPSortGroup_code, null, null, sSubIssueStatement, Session["userName"].ToString(), ref i); if (iCode == 0) { fvBMPPlanning.ChangeMode(FormViewMode.ReadOnly); BindData_BMPPlanning_FormView(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); } } }
protected void fvVenue_ItemUpdating(object sender, FormViewUpdateEventArgs e) { TextBox tbLocation = fvVenue.FindControl("tbLocation") as TextBox; TextBox tbNote = fvVenue.FindControl("tbNote") as TextBox; DropDownList ddlPhone = fvVenue.FindControl("UC_Communication_EditInsert_Phone").FindControl("ddlNumber") as DropDownList; DropDownList ddlFax = fvVenue.FindControl("UC_Communication_EditInsert_Fax").FindControl("ddlNumber") as DropDownList; TextBox tbEmail = fvVenue.FindControl("tbEmail") as TextBox; HiddenField hfPropertyPK = fvVenue.FindControl("UC_Property_EditInsert1").FindControl("hfPropertyPK") as HiddenField; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = (from b in wDataContext.eventVenues.Where(w => w.pk_eventVenue == Convert.ToInt32(fvVenue.DataKey.Value)) select b).Single(); if (!string.IsNullOrEmpty(tbLocation.Text)) { a.location = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbLocation.Text, 48).Trim(); } else { sb.Append("Location was not updated. This is a required field. "); } if (!string.IsNullOrEmpty(ddlPhone.SelectedValue)) { a.fk_communication_phone = Convert.ToInt32(ddlPhone.SelectedValue); } else { a.fk_communication_phone = null; } if (!string.IsNullOrEmpty(ddlFax.SelectedValue)) { a.fk_communication_fax = Convert.ToInt32(ddlFax.SelectedValue); } else { a.fk_communication_fax = null; } a.email = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbEmail.Text, 48).Trim(); a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255).Trim(); if (!string.IsNullOrEmpty(hfPropertyPK.Value)) { a.fk_property = Convert.ToInt32(hfPropertyPK.Value); } else { a.fk_property = null; } a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); try { wDataContext.SubmitChanges(); fvVenue.ChangeMode(FormViewMode.ReadOnly); BindVenue(Convert.ToInt32(fvVenue.DataKey.Value)); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }