protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request.QueryString["ContactID"] != null && Request.QueryString["CampaignID"] != null && Request.QueryString["Username"] != null)
{
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;
}
}
}
}
}
//add recipient to selected lists
public void SaveRecipient()
{
try
{
//collect selected lists, it is optional.
foreach (ListItem item in lstBoxListNames.Items)
{
list.Add(item.Value);
}
//create new contact, initializing new object.
contactBase = new ContactMaster(ConnectionString);
contactBase.FirstName = txtFirstName1.Text;
contactBase.LastName = txtLastName1.Text;
contactBase.EmailAddress = txtEmailAddress1.Text;
contactBase.Address1 = txtAddress11.Text;
contactBase.Address2 = txtAddress21.Text;
contactBase.City = txtCity.Text;
contactBase.Country = txtCountry.Text;
contactBase.EmailContentType = ddlEmailContentType.SelectedItem.Text;
contactBase.Fax = txtFax.Text;
if (ddlGender.SelectedItem.Text != "--Select--")
{
contactBase.Gender = ddlGender.SelectedItem.Text;
}
else
{
contactBase.Gender = null;
}
contactBase.HomePhone = txtHomePhone.Text;
if (ddlMaritalStatus.SelectedItem.Text != "--Select--")
{
contactBase.MaritalStatus = ddlMaritalStatus.SelectedItem.Text;
}
else
{
contactBase.MaritalStatus = null;
}
contactBase.MobilePhone = txtMobilePhone.Text;
contactBase.PostalCode = txtPostalCode.Text;
contactBase.State = txtState.Text;
contactBase.WorkPhone = txtWorkPhone.Text;
contactBase.IsActive = chkIsActive1.Checked;
contactBase.IsVerified = chkMakeVerified1.Checked;
//to get the values of the custom controls
GetValuesOfCustomControls();
//Edit Recipient
if (Convert.ToInt64(Request.QueryString["id"]) > 0)
{
ContactMasters contemail = ContactMaster.SelectByField("EmailAddress", txtEmailAddress1.Text, ConnectionString);
contMasters = ContactMaster.SelectByField("ContactId", Convert.ToInt64(Request.QueryString["id"]), ConnectionString);
if (contMasters[0].CreatedDate.ToString() == "")
contactBase.CreatedDate = DateTime.Now;
else
contactBase.CreatedDate = contMasters[0].CreatedDate;
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();
insert = false;
status = true;
}
else
{
List<ContactMaster> cm2 = cm1.FindAll(delegate(ContactMaster contact) { return (contact.ContactId == contMasters[0].ContactId); });
if (cm2.Count > 0)
{
update();
insert = false;
status = true;
}
else
{
statusmessage.Append(string.Format("Contact already exists with EmailAddress - {0}", txtEmailAddress1.Text));
lbMsg1.Text = statusmessage.ToString();
lbMsg1.ForeColor = System.Drawing.Color.Red;
lbMsg1.Visible = true;
status = false;
}
}
}
}
//Add New Recipient
else
{
//DataTable contselect = ContactMaster.SelectEmailAddressInNonDeletedContacts(ConnectionString, txtEmailAddress1.Text.ToString());
//The above line commented by Anwar to avoid duplicate mail ids(30/07/12)
ContactMasters contselect = ContactMaster.SelectByField("EmailAddress", txtEmailAddress1.Text, ConnectionString);
//Check email exist or not
if (contselect.Count == 0)
{
contactBase.CreatedDate = DateTime.Now;
contactBase.InsertWithDefaultValues(true);
contactID = Convert.ToInt64(contactBase.ContactId);
statusmessage.Append(string.Format("Contact has been inserted successfully. Email - {0}", txtEmailAddress1.Text));
lbMsg1.ForeColor = System.Drawing.Color.Green;
lbMsg1.Text = statusmessage.ToString();
lbMsg1.Visible = true;
checklistupdate();
ddlEmailContentType.SelectedItem.Text = contactBase.EmailContentType;
ddlGender.SelectedItem.Text = contactBase.Gender;
ddlMaritalStatus.SelectedItem.Text = contactBase.MaritalStatus;
insert = true;
status = true;
}
else
{
lbMsg1.ForeColor = System.Drawing.Color.Red;
statusmessage.Append(string.Format("Already existed Email - {0}", txtEmailAddress1.Text));
status = false;
}
}
lbMsg1.Text = statusmessage.ToString();
lbMsg1.Visible = true;
txtFirstName1.Text = contactBase.FirstName.ToString();
}
catch (Exception ex)
{
lbMsg1.Visible = true;
lbMsg1.Style.Add("color", "Red");
lbMsg1.Text = ex.Message;
}
}
public void getRecipientStatusSnapshotData()
{
try
{
List<string> xValues = new List<string>();
List<decimal> yValues = new List<decimal>();
if (ddlDays.SelectedIndex == 0)
{
objContactMaster = ContactMaster.SelectAllByToday(ConnectionString);
lblFromDate.Text = DateTime.Now.AddDays(0).ToString("dd/MM/yyyy");
//lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy");
lblToDate.Text = " - " + DateTime.Now.Date.AddDays(0).ToString("dd/MM/yyyy");
}
else if (ddlDays.SelectedIndex > 0 && ddlDays.SelectedIndex < 4)
{
objContactMaster = ContactMaster.SelectAllByDays(Convert.ToInt32(ddlDays.SelectedValue), ConnectionString);
lblFromDate.Text = DateTime.Now.AddDays(Convert.ToDouble(ddlDays.SelectedValue)).ToString("dd/MM/yyyy");
//lblToDate.Text = " - " + DateTime.Now.ToString("dd/MM/yyyy");
lblToDate.Text = " - " + DateTime.Now.Date.AddDays(-1).ToString("dd/MM/yyyy");
}
else if (ddlDays.SelectedIndex == 4)
{
objContactMaster = ContactMaster.SelectAllByWeek(ConnectionString, ref fdate, ref tdate);
lblFromDate.Text = fdate.ToString("dd/MM/yyyy");
lblToDate.Text = " - " + tdate.ToString("dd/MM/yyyy");
}
else
{
//FromDate = DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue));
objContactMaster = ContactMaster.SelectAllByMonths(DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue)), DateTime.Now.AddMonths(-1), ConnectionString);
arDates = new ArrayList();
arDates = FirstAndLastdates(Convert.ToInt32(ddlDays.SelectedValue));
lblFromDate.Text = Convert.ToDateTime(arDates[0]).ToString("dd/MM/yyyy");
lblToDate.Text = " - " + Convert.ToDateTime(arDates[1]).ToString("dd/MM/yyyy");
}
//get active contacts.
IEnumerable<ContactMaster> activeContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == true && (contact.IsDeleted == false || contact.IsDeleted == null); });
xValues.Add("Active");
yValues.Add(activeContacts.Count());
//get inactive contacts.
IEnumerable<ContactMaster> inactiveContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == false && (contact.IsDeleted == false || contact.IsDeleted == null); });
//ContactMasters contactmastersInActiveCount = ContactMaster.SelectByField("IsActive", false, ConnectionString);
//ContactMasters contactmastersInActive = ContactMaster.SelectAll(ConnectionString);
//IEnumerable<ContactMaster> inactiveContacts = (IEnumerable<ContactMaster>)contactmastersInActive.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == false && (contact.IsDeleted == false || contact.IsDeleted == null); });
//IEnumerable<ContactMaster> InActiveContacts = contactmastersInActive.ToList().FindAll(delegate(ContactMaster contact) { return (contact.IsActive == false) && (contact.IsDeleted = false); });
xValues.Add("InActive");
////yValues.Add(inactiveContacts.Count());
yValues.Add(inactiveContacts.Count());
//get deleted contacts
ContactDeleteds objContactsDeleted;// = ContactDeleted.SelectAll(ConnectionString);
//if (ddlDays.SelectedIndex == 0)
// objContactsDeleted = ContactDeleted.SelectAll(ConnectionString);
if (ddlDays.SelectedIndex == 0)
{
objContactsDeleted = ContactDeleted.SelectAllByToday(ConnectionString);
}
else if (ddlDays.SelectedIndex > 0 && ddlDays.SelectedIndex < 3)
{
objContactsDeleted = ContactDeleted.SelectAllByDays(Convert.ToInt32(ddlDays.SelectedValue), ConnectionString);
}
else if (ddlDays.SelectedIndex == 3)
{
objContactsDeleted = ContactDeleted.SelectAllByWeek(ConnectionString, ref fdate, ref tdate);
}
else
objContactsDeleted = ContactDeleted.SelectAllByMonths(DateTime.Now.AddMonths(Convert.ToInt32(ddlDays.SelectedValue)), DateTime.Now.AddMonths(-1), ConnectionString);
xValues.Add("Deleted Contacts");
yValues.Add(objContactsDeleted.Count());
//get unverified contacts
IEnumerable<ContactMaster> unverifiedContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsVerified != true && contact.IsDeleted != true; });
xValues.Add("UnVerified Contacts");
yValues.Add(unverifiedContacts.Count());
//get inactive and unverified contacts.
IEnumerable<ContactMaster> inactiveandunverifiedContacts = (IEnumerable<ContactMaster>)objContactMaster.ToList().FindAll(delegate(ContactMaster contact) { return contact.IsActive == false && contact.IsVerified != true && contact.IsDeleted != true; });
xValues.Add("InActive and UnVerified Contacts");
yValues.Add(inactiveandunverifiedContacts.Count());
//Show chart.
showChartRecipientStatusSnapshot(xValues.ToArray(), yValues.ToArray());
}
catch (Exception ex)
{
throw ex;
}
}
internal static ContactMasters PopulateelementsFromReader(IDataReader rdr, string ConnectionString)
{
ContactMasters list = new ContactMasters();
while (rdr.Read())
{
ContactMaster obj = new ContactMaster(ConnectionString);
PopulateelementFromReader(obj, rdr);
list.Add(obj);
}
return list;
}
/// <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 ContactMasters</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 1/11/2010 2:53:38 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
internal static ContactMasters PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper, string ConnectionString)
{
ContactMasters list = new ContactMasters();
if (rdr.Read())
{
ContactMaster obj = new ContactMaster(ConnectionString);
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
while (rdr.Read())
{
obj = new ContactMaster(ConnectionString);
PopulateObjectFromReader(obj, rdr);
list.Add(obj);
}
oDatabaseHelper.Dispose();
return list;
}
else
{
oDatabaseHelper.Dispose();
return null;
}
}
