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