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;
}
