protected void fvCommunication_PhoneNumber_ItemInserting(object sender, FormViewInsertEventArgs e) { int?i = null; int iCode = 0; TextBox tbAreaCode = fvCommunication_PhoneNumber.FindControl("tbAreaCode") as TextBox; TextBox tbPhoneNumber = fvCommunication_PhoneNumber.FindControl("tbPhoneNumber") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { string sAreaCode = null; if (!string.IsNullOrEmpty(tbAreaCode.Text)) { sAreaCode = WACGlobal_Methods.Format_Global_PhoneNumber_StripToNumbers(tbAreaCode.Text, WACGlobal_Methods.Enum_Number_Type.AREACODE); } else { sb.Append("Area Code is required. "); } if (string.IsNullOrEmpty(sAreaCode)) { sb.Append("Area Code not in correct format. "); } string sPhoneNumber = null; if (!string.IsNullOrEmpty(tbPhoneNumber.Text)) { sPhoneNumber = WACGlobal_Methods.Format_Global_PhoneNumber_StripToNumbers(tbPhoneNumber.Text, WACGlobal_Methods.Enum_Number_Type.PHONENUMBER); } else { sb.Append("Phone Number is required. "); } if (string.IsNullOrEmpty(sPhoneNumber)) { sb.Append("Phone Number not in correct format. "); } if (string.IsNullOrEmpty(sb.ToString())) { iCode = wDataContext.communication_add(sAreaCode, sPhoneNumber, Session["userName"].ToString(), ref i); if (iCode == 0) { fvCommunication_PhoneNumber.ChangeMode(FormViewMode.ReadOnly); BindCommunication_PhoneNumber(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_Communications() { lblGlobal_Insert_Communications.ForeColor = System.Drawing.Color.ForestGreen; StringBuilder sb = new StringBuilder(); try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { string sAreaCode = null; if (!string.IsNullOrEmpty(tbCommunications_AreaCode.Text)) { sAreaCode = WACGlobal_Methods.Format_Global_PhoneNumber_StripToNumbers(tbCommunications_AreaCode.Text, WACGlobal_Methods.Enum_Number_Type.AREACODE); } else { sb.Append("Area Code is required. "); } if (string.IsNullOrEmpty(sAreaCode)) { sb.Append("Area Code not in correct format. "); } string sPhoneNumber = null; if (!string.IsNullOrEmpty(tbCommunications_PhoneNumber.Text)) { sPhoneNumber = WACGlobal_Methods.Format_Global_PhoneNumber_StripToNumbers(tbCommunications_PhoneNumber.Text, WACGlobal_Methods.Enum_Number_Type.PHONENUMBER); } else { sb.Append("Phone Number is required. "); } if (string.IsNullOrEmpty(sPhoneNumber)) { sb.Append("Phone Number not in correct format. "); } if (string.IsNullOrEmpty(sb.ToString())) { int?i = null; int iCode = wac.communication_add(sAreaCode, sPhoneNumber, Session["userName"].ToString(), ref i); if (iCode == 0) { tbCommunications_AreaCode.Text = ""; tbCommunications_PhoneNumber.Text = ""; lblGlobal_Insert_Communications.Text = "Successfully added Communication: " + WACGlobal_Methods.Format_Global_PhoneNumberSeparateAreaCode(sAreaCode, sPhoneNumber); } else { WACAlert.Show("Error Inserting Communication: ", iCode); } } else { WACAlert.Show(sb.ToString(), 0); } } } catch (Exception ex) { lblGlobal_Insert_Communications.ForeColor = System.Drawing.Color.Red; lblGlobal_Insert_Communications.Text = "Error Inserting Communication: " + ex.Message; } }
protected void fvParticipant_Communication_ItemUpdating(object sender, FormViewUpdateEventArgs e) { DropDownList ddlType = fvParticipant_Communication.FindControl("ddlType") as DropDownList; DropDownList ddlUsage = fvParticipant_Communication.FindControl("ddlUsage") as DropDownList; TextBox tbAreaCode = fvParticipant_Communication.FindControl("tbAreaCode") as TextBox; TextBox tbPhoneNumber = fvParticipant_Communication.FindControl("tbPhoneNumber") as TextBox; //DropDownList ddlPhone = fvParticipant_Communication.FindControl("UC_Communication_EditInsert_Phone").FindControl("ddlNumber") as DropDownList; TextBox tbExtension = fvParticipant_Communication.FindControl("tbExtension") as TextBox; TextBox tbNote = fvParticipant_Communication.FindControl("tbNote") as TextBox; StringBuilder sb = new StringBuilder(); using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { try { int?i = null; int iCode = 0; iCode = wDataContext.communication_add(tbAreaCode.Text, tbPhoneNumber.Text, Session["userName"].ToString(), ref i); if (iCode != 0) { i = null; } var a = wDataContext.participantCommunications.Where(w => w.pk_participantCommunication == Convert.ToInt32(fvParticipant_Communication.DataKey.Value)).Select(s => s).Single(); if (!string.IsNullOrEmpty(ddlType.SelectedValue)) { a.fk_communicationType_code = ddlType.SelectedValue; } else { sb.Append("Type was not updated. Type is required. "); } if (!string.IsNullOrEmpty(ddlUsage.SelectedValue)) { a.fk_communicationUsage_code = ddlUsage.SelectedValue; } else { sb.Append("Usage was not updated. Usage is required. "); } if (i != null) { a.fk_communication = Convert.ToInt32(i); } else { sb.Append("Phone Number was not updated. Bad Phone Number. "); } //if (!string.IsNullOrEmpty(ddlPhone.SelectedValue)) a.fk_communication = Convert.ToInt32(ddlPhone.SelectedValue); //else sb.Append("Phone Number was not updated. Phone Number is required. "); a.extension = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbExtension.Text, 8).Trim(); a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 48).Trim(); a.modified = DateTime.Now; a.modified_by = Session["userName"].ToString(); wDataContext.SubmitChanges(); fvParticipant_Communication.ChangeMode(FormViewMode.ReadOnly); Participant_Communication_BindRecord(Convert.ToInt32(fvParticipant_Communication.DataKey.Value)); if (!string.IsNullOrEmpty(sb.ToString())) { WACAlert.Show(sb.ToString(), 0); } } catch (Exception ex) { WACAlert.Show(ex.Message, 0); } } }