protected void fvSA_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sb = new StringBuilder(); //Calendar calAgreementDate = fvSA.FindControl("UC_EditCalendar_SA_AgreementDate").FindControl("cal") as Calendar; //Calendar calInactiveDate = fvSA.FindControl("UC_EditCalendar_SA_InactiveDate").FindControl("cal") as Calendar; CustomControls_AjaxCalendar tbCalAgreementDate = (CustomControls_AjaxCalendar)fvSA.FindControl("tbCalAgreementDate"); CustomControls_AjaxCalendar tbCalInactiveDate = (CustomControls_AjaxCalendar)fvSA.FindControl("tbCalInactiveDate"); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.supplementalAgreements.Where(w => w.pk_supplementalAgreement == Convert.ToInt32(fvSA.DataKey.Value)).Select(s => s).Single(); try { a.agreement_date = tbCalAgreementDate.CalDateNotNullable; //if (calInactiveDate.SelectedDate.Year > 1900) a.inactive_date = calInactiveDate.SelectedDate; //else a.inactive_date = null; a.inactive_date = tbCalInactiveDate.CalDateNullable; a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fvSA.ChangeMode(FormViewMode.ReadOnly); Populate_SA_FormView(Convert.ToInt32(fvSA.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); } } }
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); } } }
protected void fvSA_TaxParcel_ItemUpdating(object sender, FormViewUpdateEventArgs e) { StringBuilder sb = new StringBuilder(); FormView fv = fvSA.FindControl("fvSA_TaxParcel") as FormView; DropDownList ddlTaxParcelID = fv.FindControl("ddlTaxParcelID") as DropDownList; //Calendar calCancelDate = fv.FindControl("UC_EditCalendar_SA_TaxParcel_CancelDate").FindControl("cal") as Calendar; CustomControls_AjaxCalendar tbCalCancelDate = (CustomControls_AjaxCalendar)fv.FindControl("tbCalTaxParcelCancelDate"); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = wDataContext.supplementalAgreementTaxParcels.Where(w => w.pk_supplementalAgreementTaxParcel == Convert.ToInt32(fv.DataKey.Value)).Select(s => s).Single(); try { if (!string.IsNullOrEmpty(ddlTaxParcelID.SelectedValue)) { a.fk_taxParcel = Convert.ToInt32(ddlTaxParcelID.SelectedValue); } else { sb.Append("Tax Parcel ID was not updated. Tax Parcel ID is required. "); } //if (calCancelDate.SelectedDate.Year > 1900) a.cancel_date = calCancelDate.SelectedDate; //else a.cancel_date = null; a.cancel_date = tbCalCancelDate.CalDateNullable; a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fv.ChangeMode(FormViewMode.ReadOnly); Populate_SA_TaxParcel_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); } } }
private void fvItemInserting(FormView fv) { try { CustomControls_AjaxCalendar agreementDate = (CustomControls_AjaxCalendar)fv.FindControl("tbCalAgreementDate"); WACPR_TaxParcelPicker taxParcelPicker = fv.FindControl("WACPR_TaxParcelPicker") as WACPR_TaxParcelPicker; sReq.ParmList.Clear(); List <WACParameter> taxParcelProps = taxParcelPicker.GetContents(); sReq.ParmList.Add(WACParameter.GetParameter(taxParcelProps, "swis")); sReq.ParmList.Add(WACParameter.GetParameter(taxParcelProps, "printKey")); sReq.ParmList.Add(new WACParameter("agreement_date", agreementDate.CalDateNotNullable, WACParameter.ParameterType.Property)); sReq.ServiceRequested = ServiceFactory.ServiceTypes.InsertItem; sReq.ServiceFor = fv; ServiceFactory.Instance.ServiceRequest(sReq); taxParcelProps = null; } 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_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 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 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); } } }
public void fvHR_WACEmployee_Position_ItemUpdating(object sender, EventArgs e) { PK_ParticipantPosition = Convert.ToInt32(fvHR_WACEmployee_Position.DataKey.Value); DropDownList ddlPosition = fvHR_WACEmployee_Position.FindControl("ddlPosition") as DropDownList; //TextBox tbStartDate = fvHR_WACEmployee_Position.FindControl("AjaxCalendar_StartDate").FindControl("tb") as TextBox; CustomControls_AjaxCalendar calStartDate = fvHR_WACEmployee_Position.FindControl("AjaxCalendar_StartDate") as CustomControls_AjaxCalendar; //TextBox tbFinishDate = fvHR_WACEmployee_Position.FindControl("AjaxCalendar_FinishDate").FindControl("tb") as TextBox; CustomControls_AjaxCalendar calFinishDate = fvHR_WACEmployee_Position.FindControl("AjaxCalendar_FinishDate") as CustomControls_AjaxCalendar; TextBox tbStartSalary = fvHR_WACEmployee_Position.FindControl("tbStartSalary") as TextBox; TextBox tbNote = fvHR_WACEmployee_Position.FindControl("tbNote") as TextBox; CustomControls_AjaxCalendar calExitInterview = fvHR_WACEmployee_Position.FindControl("calExitInterview") as CustomControls_AjaxCalendar; TextBox tbExitInterviewNote = fvHR_WACEmployee_Position.FindControl("tbExitInterviewNote") as TextBox; string fk_positionWAC_code = null; DateTime startDate; DateTime?finishDate; Decimal startSalary; string note = null; DateTime?exitInterviewDate; string exitInterviewNote = null; DateTime modified; string modified_by; using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { //var x = wac.participantWAC_positions.Where(w => w.pk_participantWAC_position == PK_ParticipantPosition) // .Select(s => s).Single(); try { // Position if (!string.IsNullOrEmpty(ddlPosition.SelectedValue)) { fk_positionWAC_code = ddlPosition.SelectedValue; } else { throw new Exception("Position is a required Field"); } // Start Date startDate = calStartDate.CalDateNotNullable; if (startDate == null) { throw new Exception("Invalid or empty Start Date."); } // Finish Date - not required //try { x.finish_date= Convert.ToDateTime(tbFinishDate.Text); } //catch { x.finish_date = null; } finishDate = calFinishDate.CalDateNullable; // Starting Salary not required try { startSalary = Convert.ToDecimal(tbStartSalary.Text); } catch { throw new Exception("Invalid or empty Starting Salary."); } // Note not required if (!string.IsNullOrEmpty(tbNote.Text)) { note = tbNote.Text; } exitInterviewDate = calExitInterview.CalDateNullable; if (!string.IsNullOrEmpty(tbExitInterviewNote.Text)) { exitInterviewNote = tbExitInterviewNote.Text; } modified = DateTime.Now; modified_by = Session["userName"].ToString(); //wac.SubmitChanges(); int rCode = wac.participantWAC_position_update(PK_ParticipantPosition, fk_positionWAC_code, startDate, finishDate, startSalary, note, Session["userName"].ToString(), exitInterviewDate, exitInterviewNote); if (rCode == 0) { fvHR_WACEmployee_Position.ChangeMode(FormViewMode.ReadOnly); BindHR_WACEmployee_Position(); OnFormActionCompleted(this, new FormViewEventArgs(FK_ParticipantWAC, "position")); } else { throw new Exception("Error occurred updating HR:Position"); } // OnFormActionCompleted(this, new FormViewEventArgs(FK_ParticipantWAC, "position")); } catch (Exception ex) { WACAlert.Show("Error: " + 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 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 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 fvAg_WFP3_ItemUpdating(object sender, EventArgs e) { StringBuilder sbErrorCollection = new StringBuilder(); 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 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 tbCalCertificationDate = fvAg_WFP3.FindControl("tbCalCertificationDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalPrintDate = fvAg_WFP3.FindControl("tbCalPrintDate") as CustomControls_AjaxCalendar; CustomControls_AjaxCalendar tbCalBidDeadlineDate = fvAg_WFP3.FindControl("tbCalBidDeadlineDate") as CustomControls_AjaxCalendar; TextBox tbDescription = fvAg_WFP3.FindControl("tbDescription") as TextBox; DropDownList ddlSpecialProvisions = fvAg_WFP3.FindControl("ddlSpecialProvisions") as DropDownList; TextBox tbSpecialProvisionsCount = fvAg_WFP3.FindControl("tbSpecialProvisionsCount") 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 tbMessage2FreeForm = fvAg_WFP3.FindControl("tbMessage2FreeForm") as TextBox; TextBox tbNote = fvAg_WFP3.FindControl("tbNote") as TextBox; TextBox tbProjectLocation = fvAg_WFP3.FindControl("tbProjectLocation") as TextBox; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { var a = wDataContext.form_wfp3s.Where(w => w.pk_form_wfp3 == Convert.ToInt32(fvAg_WFP3.DataKey.Value)).Select(s => s).Single(); a.description = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbDescription.Text, 255); a.design_date = tbCalDesignDate.CalDateNullable; a.procurementPlan_date = tbCalProcurementPlanDate.CalDateNullable; a.outForBid_date = tbCalOutForBidDate.CalDateNullable; a.install_from = tbCalInstallFromDate.CalDateNullable; a.install_to = tbCalInstallToDate.CalDateNullable; a.construction_date = tbCalConstructionDate.CalDateNullable; a.certification_date = tbCalCertificationDate.CalDateNullable; a.print_date = tbCalPrintDate.CalDateNullable; a.bid_deadline_date = tbCalBidDeadlineDate.CalDateNullable; if (!string.IsNullOrEmpty(ddlSpecialProvisions.SelectedValue)) { a.specialProvisions = ddlSpecialProvisions.SelectedValue; } else { a.specialProvisions = null; } a.attachedPages_cnt = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAttachedPages.Text, 4); if (!string.IsNullOrEmpty(tbAttachedSpecifications.Text)) { a.attachedSpecifications = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbAttachedSpecifications.Text, 255); } else { a.attachedSpecifications = null; } if (!string.IsNullOrEmpty(ddlProcurementType.SelectedValue)) { a.fk_procurementType_code = ddlProcurementType.SelectedValue; } else { sbErrorCollection.Append("Procurement Type is required."); } a.message2_freeform = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbMessage2FreeForm.Text, 255); a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255); a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); if (!string.IsNullOrEmpty(sbErrorCollection.ToString())) { WACAlert.Show(sbErrorCollection.ToString(), 0); } else { int iCode = wDataContext.form_wfp3_update(a.pk_form_wfp3, a.description, a.specialProvisions, a.install_from, a.install_to, a.print_date, a.bid_deadline_date, a.design_date, a.procurementPlan_date, a.outForBid_date, a.construction_date, a.certification_date, a.attachedPages_cnt, a.attachedSpecifications, a.fk_procurementType_code, a.message2_freeform, a.note, a.modified_by); //wDataContext.SubmitChanges(); if (iCode != 0) { WACAlert.Show("Update failed", iCode); } fvAg_WFP3.ChangeMode(FormViewMode.ReadOnly); BindAg_WFP3(); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }