protected void btnSubmit_Click(object sender, EventArgs e) { if (Request.QueryString["ContactID"] != null && Request.QueryString["CampaignID"] != null && Request.QueryString["Username"] != null) { if (Request.QueryString["direct"] == null || Request.QueryString["direct"] == "no") { ContactMasters contemail = ContactMaster.SelectByField("EmailAddress", txtEmailAddress.Text, connectionString); contMasters = ContactMaster.SelectByField("ContactId", Convert.ToInt64(Request.QueryString["ContactID"]), connectionString); contactBase = new ContactMaster(connectionString); contactBase.FirstName = txtFirstName.Text; contactBase.LastName = txtLastName.Text; contactBase.EmailAddress = txtEmailAddress.Text; contactBase.City = txtCity.Text; contactBase.Country = txtCountry.Text; contactBase.MobilePhone = txtMobilePhone.Text; contactBase.PostalCode = txtZipCode.Text; contactBase.State = txtState.Text; contactBase.Address1 = txtAddress1.Text; contactBase.Address2 = txtAddress2.Text; contactBase.ModifiedDate = DateTime.Now; if (contMasters.Count > 0) { List<ContactMaster> cm1 = contemail.ToList().FindAll(delegate(ContactMaster contact) { return (contact.IsDeleted == false || contact.IsDeleted == null); }); if (cm1.Count == 0) { update(); } else { List<ContactMaster> cm2 = cm1.FindAll(delegate(ContactMaster contact) { return (contact.ContactId == contMasters[0].ContactId); }); if (cm2.Count > 0) { update(); } else { statusmessage.Append(string.Format("Contact already exists with EmailAddress - {0}", txtEmailAddress.Text)); lbMsg.Text = statusmessage.ToString(); lbMsg.ForeColor = System.Drawing.Color.Red; } } } } else if (Request.QueryString["direct"] != null || Request.QueryString["direct"] == "yes") { objRecipientMasters = RecipientMaster.SelectByField("ContactId", Convert.ToInt64(Request.QueryString["ContactID"]), connectionString); RecipientBase =new RecipientMaster(connectionString); RecipientBase.Firstname= txtFirstName.Text; RecipientBase.Lastname = txtLastName.Text; RecipientBase.EmailAddress = txtEmailAddress.Text; RecipientBase.City = txtCity.Text; RecipientBase.Country = txtCountry.Text; RecipientBase.CellPhone = txtMobilePhone.Text; RecipientBase.Postal_Code = txtZipCode.Text; RecipientBase.State = txtState.Text; RecipientBase.Address1 = txtAddress1.Text; RecipientBase.Address2 = txtAddress2.Text; RecipientBase.Major1_Intended_College_Major_Description = ddlMajor.SelectedValue; RecipientBase.Sports1 = ddlSports.SelectedValue; RecipientBase.Parent1eml = txtParentEmail.Text; updateContactInDirectMail(); } } }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of RecipientMasters</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 9/19/2012 10:48:08 AM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static RecipientMasters PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper, string ConnectionString) { RecipientMasters list = new RecipientMasters(); if (rdr.Read()) { RecipientMaster obj = new RecipientMaster(ConnectionString); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new RecipientMaster(ConnectionString); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return list; } else { oDatabaseHelper.Dispose(); return null; } }
protected void Page_Load(object sender, EventArgs e) { txtMobilePhone.Attributes.Add("onkeypress", "return isNumberKey(event)"); if (Request.QueryString["ContactID"] != null && Request.QueryString["CampaignID"] != null && Request.QueryString["Username"] != null) { //get cleint database credentials. userName = Request.QueryString["Username"].ToString(); ProfileBase objProfileBase = ProfileBase.Create(userName, true); string dbName = objProfileBase.GetPropertyValue("DBName").ToString(); string dbUserID = objProfileBase.GetPropertyValue("DBUserID").ToString(); string dbPassword = objProfileBase.GetPropertyValue("DBPassword").ToString(); string dbServerName = objProfileBase.GetPropertyValue("DBServerName").ToString(); connectionString = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3};Pooling=True", dbServerName, dbName, dbUserID, dbPassword); ConnectionStringHelper.ConStr = connectionString; contactID = Convert.ToInt64(Request.QueryString["ContactID"]); campaignID = Convert.ToInt64(Request.QueryString["CampaignID"]); if (!IsPostBack) { if (Request.QueryString["direct"]==null || Request.QueryString["direct"] == "no")//1Point { ContactMasterPrimaryKey pk = new ContactMasterPrimaryKey(contactID); ContactMaster contMaster = ContactMaster.SelectOne(pk, connectionString); txtFirstName.Text = contMaster.FirstName; txtLastName.Text = contMaster.LastName; txtAddress1.Text = contMaster.Address1; txtAddress2.Text = contMaster.Address2; txtEmailAddress.Text = contMaster.EmailAddress; txtCity.Text = contMaster.City; txtCountry.Text = (contMaster.Country!=null)?contMaster.Country.ToUpper():string.Empty; txtState.Text = contMaster.State; txtZipCode.Text = contMaster.PostalCode; txtMobilePhone.Text = contMaster.MobilePhone; DisplayCustomControlValues(contMaster); DataTable dt = ManageFieldsBase.SelectCustomFields(connectionString); lblmsg.Text = txtFirstName.Text.ToString().Trim(); } else if (Request.QueryString["direct"] == "yes") //AMM_Adv. { objRecipientMasters = RecipientMaster.SelectByField("ContactId", Convert.ToInt64(Request.QueryString["ContactID"]), connectionString); if (objRecipientMasters.Count > 0) { txtFirstName.Text = objRecipientMasters[0].Firstname; txtLastName.Text = objRecipientMasters[0].Lastname; txtAddress1.Text = objRecipientMasters[0].Address1; txtAddress2.Text = objRecipientMasters[0].Address2; txtEmailAddress.Text = objRecipientMasters[0].EmailAddress; txtParentEmail.Text = objRecipientMasters[0].Parent1eml; txtCity.Text = objRecipientMasters[0].City; txtCountry.Text =(objRecipientMasters[0].Country!=null)?objRecipientMasters[0].Country.ToUpper():string.Empty; txtState.Text = objRecipientMasters[0].State; txtZipCode.Text = objRecipientMasters[0].Postal_Code; txtMobilePhone.Text = objRecipientMasters[0].CellPhone; txtParentEmail.Text = objRecipientMasters[0].Parent1eml; purlValue = objRecipientMasters[0].Purl; DisplayCustomControlValuesForDirectMail(objRecipientMasters[0]); lblmsg.Text = txtFirstName.Text.ToString().Trim(); if (objRecipientMasters[0].Major1_Intended_College_Major_Description != null && objRecipientMasters[0].Major1_Intended_College_Major_Description.ToString().Trim().Length>0) { ListItem mapItem = ddlMajor.Items.FindByValue(objRecipientMasters[0].Major1_Intended_College_Major_Description); if (mapItem != null && mapItem.Value != "--Select--") ddlMajor.Items.FindByValue(mapItem.Value).Selected = true; } if (objRecipientMasters[0].Sports1 != null && objRecipientMasters[0].Sports1.Trim().Length>0) { ListItem mapItem = ddlSports.Items.FindByValue(objRecipientMasters[0].Sports1); if (mapItem != null && mapItem.Value!="--Select--") ddlSports.Items.FindByValue(mapItem.Value).Selected = true; } } } } } }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of RecipientMasters</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 9/19/2012 10:48:08 AM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static RecipientMasters PopulateObjectsFromReader(IDataReader rdr, string ConnectionString) { RecipientMasters list = new RecipientMasters(); while (rdr.Read()) { RecipientMaster obj = new RecipientMaster(ConnectionString); PopulateObjectFromReader(obj,rdr); list.Add(obj); } return list; }