コード例 #1
0
        public void update()
        {
            try
            {
                contactBase.ContactId = Convert.ToInt64(contMasters[0].ContactId);
                //status = contactBase.AMMFormUpdate();

                status = contactBase.Wheelock_Widener_FormsUpdate();

                GetValuesOfCustomControls();
                //contactID = Convert.ToInt32(contMasters[0].ContactId);
                statusmessage.Append(string.Format("Contact has been updated successfully"));
                lbMsg.ForeColor = System.Drawing.Color.Green;
                lbMsg.Text = statusmessage.ToString();
                if (hddIntendedMajor.Value.ToString() == "--Select--")
                    hddIntendedMajor.Value = string.Empty;
                if (hddSports.Value.ToString() == "--Select--")
                    hddSports.Value = string.Empty;
                //Get the AssignCampaignId for Mailing
                CampaignMasterPrimaryKey pk = new CampaignMasterPrimaryKey(Convert.ToInt64(Request.QueryString["CampaignID"].ToString()));
                CampaignMaster objCampMaster = CampaignMaster.SelectOneWithCampaignJobUsingCampaignMasterID(pk, connectionString);
                string CampId= objCampMaster.AssignedCampaignID.ToString().Trim();

                string WheelockLink = ConfigurationManager.AppSettings["WheelockLink"].ToString();
                string RedirectUrl = ConfigurationManager.AppSettings["WheelockSubmitLink"].ToString();
                string parameters = "FirstName=" + txtFirstName.Text.ToString().Trim() + "&LastName=" + txtLastName.Text.ToString().Trim() + "&Address1=" + txtAddress1.Text.ToString().Trim() + "&IntendedMajor=" + hddIntendedMajor.Value.ToString().Trim() +
                    "&Sport=" + hddSports.Value.ToString().Trim() + "&Facebook=False&WNews=False&StudentBlogs=False&ScholarshipInfo=False&MajorInfo=False&StudentVideos=False&Email=" + txtEmailAddress.Text + "&InstName=Wheelock"
                    + "&UniqueIdentifier=" + txtFirstName.Text.ToString().Trim() + txtLastName.Text.ToString().Trim() + contactID.ToString().Trim()
                    + "&LetterCode=" + hdLetterCode.Value.ToString().Trim() + "&Rep=" + hdRep.Value.ToString().Trim() + "&EID=" + hdEID.Value.ToString().Trim() + "&PURL=" + purlValue.ToString().Trim();
                string qStrValues = "?ContactID=" + Request.QueryString["ContactID"].ToString() + "&CampaignID=" + Request.QueryString["CampaignID"].ToString() + "&CampID=" + CampId.ToString() + "&Username="******"Username"].ToString() + "&direct=no";
                string Rstr = RedirectUrl + parameters + "&URL=" + WheelockLink.ToString().Trim() + qStrValues;//CampaignID

                //Insert formsubmit details in FormSubmitClicks
                FormSubmitClick objFormSubmitClick = new FormSubmitClick(connectionString);
                objFormSubmitClick.ContactID =Convert.ToInt64( Request.QueryString["ContactID"].ToString());
                objFormSubmitClick.MailingID = Convert.ToInt64(Request.QueryString["CampaignID"].ToString());
                objFormSubmitClick.DirectMail = false;
                objFormSubmitClick.LinkID = 2;
                objFormSubmitClick.SubmitDate = DateTime.Now;
                objFormSubmitClick.Insert();

                Response.Redirect(Rstr);
            }
            catch (Exception ex)
            { throw ex; }
        }
コード例 #2
0
        /// <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 FormSubmitClicks</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/29/2012 12:32:23 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        internal static FormSubmitClicks PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper, string ConnectionString)
        {
            FormSubmitClicks list = new FormSubmitClicks();

            if (rdr.Read())
            {
                FormSubmitClick obj = new FormSubmitClick(ConnectionString);
                PopulateObjectFromReader(obj, rdr);
                list.Add(obj);
                while (rdr.Read())
                {
                    obj = new FormSubmitClick(ConnectionString);
                    PopulateObjectFromReader(obj, rdr);
                    list.Add(obj);
                }
                oDatabaseHelper.Dispose();
                return list;
            }
            else
            {
                oDatabaseHelper.Dispose();
                return null;
            }
        }
コード例 #3
0
        /// <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 FormSubmitClicks</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/29/2012 12:32:23 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        internal static FormSubmitClicks PopulateObjectsFromReader(IDataReader rdr, string ConnectionString)
        {
            FormSubmitClicks list = new FormSubmitClicks();

            while (rdr.Read())
            {
                FormSubmitClick obj = new FormSubmitClick(ConnectionString);
                PopulateObjectFromReader(obj,rdr);
                list.Add(obj);
            }
            return list;
        }
コード例 #4
0
        /// <summary>
        /// This method will return an object representing the record matching the primary key information specified.
        /// </summary>
        ///
        /// <param name="pk" type="FormSubmitClickPrimaryKey">Primary Key information based on which data is to be fetched.</param>
        ///
        /// <returns>object of class FormSubmitClick</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/29/2012 12:32:23 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public static FormSubmitClick SelectOne(FormSubmitClickPrimaryKey pk,String ConnectionString)
        {
            DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);
            bool ExecutionState = false;

            // Pass the values of all key parameters to the stored procedure.
            System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues();
            foreach (string key in nvc.Keys)
            {
                oDatabaseHelper.AddParameter("@" + key,nvc[key] );
            }
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            IDataReader dr=oDatabaseHelper.ExecuteReader("sp_FormSubmitClicks_SelectbyPrimaryKey", ref ExecutionState);
            if (dr.Read())
            {
                FormSubmitClick obj = new FormSubmitClick(ConnectionString);
                PopulateObjectFromReader(obj,dr);
                dr.Close();
                oDatabaseHelper.Dispose();
                return obj;
            }
            else
            {
                dr.Close();
                oDatabaseHelper.Dispose();
                return null;
            }
        }
コード例 #5
0
        private void updateContactInDirectMail()
        {
            RecipientBase.ContactId = Convert.ToInt64(objRecipientMasters[0].ContactId);
            status =RecipientBase.Wheelock_Widener_FormsUpdateDirectMail();

            //GetValuesOfCustomControls();
            //contactID = Convert.ToInt32(contMasters[0].ContactId);
            statusmessage.Append(string.Format("Contact has been updated successfully"));
            lbMsg.ForeColor = System.Drawing.Color.Green;
            lbMsg.Text = statusmessage.ToString();
            if (hddIntendedMajor.Value.ToString() == "--Select--")
                hddIntendedMajor.Value = string.Empty;
            else
                hddIntendedMajor.Value = ddlMajor.SelectedValue;

            if (hddSports.Value.ToString() == "--Select--")
                hddSports.Value = string.Empty;
            else
                hddSports.Value = ddlSports.SelectedValue;
            if (RecipientBase.LetterCode != null)
                hdLetterCode.Value = RecipientBase.LetterCode;

            string WheelockLink = ConfigurationManager.AppSettings["WheelockLink"].ToString();
            string RedirectUrl = ConfigurationManager.AppSettings["WheelockSubmitLink"].ToString();
            string parameters = "FirstName=" + txtFirstName.Text.ToString().Trim() + "&LastName=" + txtLastName.Text.ToString().Trim() + "&Address1=" + txtAddress1.Text.ToString().Trim() + "&IntendedMajor=" + hddIntendedMajor.Value.ToString().Trim() +
                "&Sport=" + hddSports.Value.ToString().Trim() + "&Facebook=False&WNews=False&StudentBlogs=False&ScholarshipInfo=False&MajorInfo=False&StudentVideos=False&Email=" + txtEmailAddress.Text + "&InstName=Wheelock"
                + "&UniqueIdentifier=" + txtFirstName.Text.ToString().Trim() + txtLastName.Text.ToString().Trim() + contactID.ToString().Trim()
                + "&LetterCode=" + hdLetterCode.Value.ToString().Trim() + "&Rep=" + hdRep.Value.ToString().Trim() + "&EID=" + hdEID.Value.ToString().Trim() + "&PURL=" + purlValue.ToString().Trim();
            string CamId = (Request.QueryString["CampID"] != null) ? Request.QueryString["CampID"].ToString() : string.Empty;
            string mailingId = (Request.QueryString["CampaignID"] != null) ? Request.QueryString["CampaignID"].ToString() : string.Empty;
            string qStrValues = "?ContactID=" + Request.QueryString["ContactID"].ToString() + "&CampaignID=" + mailingId + "&CampID=" + CamId + "&Username="******"Username"].ToString() + "&direct=yes";
            string Rstr = RedirectUrl + parameters + "&URL=" + WheelockLink.ToString().Trim() + qStrValues;//CampaignID

            FormSubmitClick objFormSubmitClick = new FormSubmitClick(connectionString);
            objFormSubmitClick.ContactID = Convert.ToInt64(Request.QueryString["ContactID"].ToString());
            objFormSubmitClick.DirectMail = true;
            objFormSubmitClick.MailingID = Convert.ToInt64(Request.QueryString["CampaignID"].ToString());
            objFormSubmitClick.LinkID = 2;
            objFormSubmitClick.SubmitDate = DateTime.Now;
            objFormSubmitClick.Insert();

            Response.Redirect(Rstr);
        }