示例#1
0
        public bool InsertandReturnID(ref int JobId)
        {
            bool ExecutionState = false;
            DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_importJobID' as parameter 'ImportJobID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ImportJobID", ImportJobID);
            // Pass the value of '_staus' as parameter 'Staus' of the stored procedure.
            oDatabaseHelper.AddParameter("@Staus", Staus);
            // Pass the value of '_statusMessage' as parameter 'StatusMessage' of the stored procedure.
            oDatabaseHelper.AddParameter("@StatusMessage", StatusMessage);
            // Pass the value of '_updatedCount' as parameter 'UpdatedCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@UpdatedCount", UpdatedCount);
            // Pass the value of '_insertedCount' as parameter 'InsertedCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@InsertedCount", InsertedCount);
            // Pass the value of '_duplicateCount' as parameter 'DuplicateCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@DuplicateCount", DuplicateCount);
            // Pass the value of '_invalidCount' as parameter 'InvalidCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@InvalidCount", InvalidCount);
            // Pass the value of '_startTime' as parameter 'StartTime' of the stored procedure.
            oDatabaseHelper.AddParameter("@StartTime", StartTime);
            // Pass the value of '_endTime' as parameter 'EndTime' of the stored procedure.
            oDatabaseHelper.AddParameter("@EndTime", EndTime);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);
            oDatabaseHelper.AddParameter("@Id", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_ImportHistory_Insert_ReturnId", ref ExecutionState);
            JobId = Convert.ToInt32(oDatabaseHelper.GetParameterValue("@Id"));
            oDatabaseHelper.Dispose();

            return ExecutionState;
        }
示例#2
0
        //prashanth
        //Insertion of Links and returning the PK after insertion.
        public int InsertandReturnPrimaryKey()
        {
            bool ExecutionState = false;
            DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_linkURL' as parameter 'LinkURL' of the stored procedure.
            oDatabaseHelper.AddParameter("@LinkURL", this.LinkURL);
            // Pass the value of '_linkName' as parameter 'LinkName' of the stored procedure.
            oDatabaseHelper.AddParameter("@LinkName", this.LinkName);
            // Pass the value of '_recordClicks' as parameter 'RecordClicks' of the stored procedure.
            oDatabaseHelper.AddParameter("@RecordClicks", this.RecordClicks);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);
            // The parameter '@LinkDetailID' will contain the LinkDetailID after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@LinkDetailID", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_LinkDetails_InsertandReturnPrimarykey", ref ExecutionState);//ExecuteNonQuery("sp_ContactMaster_InsertandReturnPrimarykey", ref ExecutionState);
            int intLinkDetailID = (int)oDatabaseHelper.GetParameterValue("@LinkDetailID");
            oDatabaseHelper.Dispose();

            return intLinkDetailID;
        }
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/8/2010 12:24:52 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _idNonDefault);
            // Pass the value of '_campaignID' as parameter 'CampaignID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignID", _campaignIDNonDefault);
            // Pass the value of '_contactID' as parameter 'ContactID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactID", _contactIDNonDefault);
            // Pass the value of '_openedDate' as parameter 'OpenedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@OpenedDate", _openedDateNonDefault);
            // Pass the value of '_iPAddress' as parameter 'IPAddress' of the stored procedure.
            oDatabaseHelper.AddParameter("@IPAddress", _iPAddressNonDefault);
            // Pass the value of '_userAgent' as parameter 'UserAgent' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserAgent", _userAgentNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_EmailOpenDetails_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_EmailOpenDetails_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
        /// <summary>
        /// This method will Delete row(s) from the database using the value of the field specified
        /// </summary>
        ///
        /// <param name="field" type="EmailOpenDetailFields">Field of the class EmailOpenDetail</param>
        /// <param name="fieldValue" type="object">Value for the field specified.</param>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/8/2010 12:24:52 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public static bool DeleteByField(string field, object fieldValue, String ConnectionString)
        {
            DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);
            bool ExecutionState = false;

            // Pass the specified field and its value to the stored procedure.
            oDatabaseHelper.AddParameter("@Field",field);
            oDatabaseHelper.AddParameter("@Value", fieldValue );
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_EmailOpenDetails_DeleteByField", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#5
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/21/2009 4:19:24 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _id);
            // Pass the value of '_importJobID' as parameter 'ImportJobID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ImportJobID", _importJobID);
            // Pass the value of '_sourceField' as parameter 'SourceField' of the stored procedure.
            oDatabaseHelper.AddParameter("@SourceField", _sourceField);
            // Pass the value of '_destinationField' as parameter 'DestinationField' of the stored procedure.
            oDatabaseHelper.AddParameter("@DestinationField", _destinationField);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_FieldMap_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#6
0
        public bool UpdateDeliveryTabCampJob()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _id);
            // Pass the value of '_scheduledDatetime' as parameter 'ScheduledDatetime' of the stored procedure.
            oDatabaseHelper.AddParameter("@ScheduledDatetime", _scheduledDatetime);
            // Pass the value of '_status' as parameter 'Status' of the stored procedure.
            oDatabaseHelper.AddParameter("@Status", _status);
            // Pass the value of '_sendType' as parameter 'SendType' of the stored procedure.
            oDatabaseHelper.AddParameter("@SendType", _sendType);
            oDatabaseHelper.ExecuteScalar("sp_CampaignJob_Update_DeliveryTab", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#7
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			2/3/2010 4:14:00 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _idNonDefault);
            // Pass the value of '_campaignMasterID' as parameter 'CampaignMasterID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignMasterID", _campaignMasterIDNonDefault);
            // Pass the value of '_scheduledDatetime' as parameter 'ScheduledDatetime' of the stored procedure.
            oDatabaseHelper.AddParameter("@ScheduledDatetime", _scheduledDatetimeNonDefault);
            // Pass the value of '_createdDatetime' as parameter 'CreatedDatetime' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDatetime", _createdDatetimeNonDefault);
            // Pass the value of '_status' as parameter 'Status' of the stored procedure.
            oDatabaseHelper.AddParameter("@Status", _statusNonDefault);
            // Pass the value of '_statusMessage' as parameter 'StatusMessage' of the stored procedure.
            oDatabaseHelper.AddParameter("@StatusMessage", _statusMessageNonDefault);
            // Pass the value of '_deliveredCount' as parameter 'DeliveredCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@DeliveredCount", _deliveredCountNonDefault);
            // Pass the value of '_openCount' as parameter 'OpenCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@OpenCount", _openCountNonDefault);
            // Pass the value of '_clickCount' as parameter 'ClickCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClickCount", _clickCountNonDefault);
            // Pass the value of '_bounceCount' as parameter 'BounceCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@BounceCount", _bounceCountNonDefault);
            // Pass the value of '_optoutCount' as parameter 'OptoutCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@OptoutCount", _optoutCountNonDefault);
            // Pass the value of '_sendType' as parameter 'SendType' of the stored procedure.
            oDatabaseHelper.AddParameter("@SendType", _sendTypeNonDefault);
            // Pass the value of '_totalRecipients' as parameter 'TotalRecipients' of the stored procedure.
            oDatabaseHelper.AddParameter("@TotalRecipients", _totalRecipientsNonDefault);
            // Pass the value of '_unSubscribeCount' as parameter 'UnSubscribeCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@UnSubscribeCount", _unSubscribeCountNonDefault);
            // Pass the value of '_startTime' as parameter 'StartTime' of the stored procedure.
            oDatabaseHelper.AddParameter("@StartTime", _startTimeNonDefault);
            // Pass the value of '_completionTime' as parameter 'CompletionTime' of the stored procedure.
            oDatabaseHelper.AddParameter("@CompletionTime", _completionTimeNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_CampaignJob_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_CampaignJob_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			7/28/2012 02:17:32 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_listContactId' as parameter 'ListContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListContactId", _listContactIdNonDefault);
            // Pass the value of '_listMasterID' as parameter 'ListMasterID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListMasterID", _listMasterIDNonDefault);
            // Pass the value of '_contactId' as parameter 'ContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactId", _contactIdNonDefault);
            // Pass the value of '_clientId' as parameter 'ClientId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClientId", _clientIdNonDefault);
            // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDate", _createdDateNonDefault);
            // Pass the value of '_modifiedDate' as parameter 'ModifiedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedDate", _modifiedDateNonDefault);
            // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault);
            // Pass the value of '_modifiedBy' as parameter 'ModifiedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedBy", _modifiedByNonDefault);
            // Pass the value of '_isActive' as parameter 'IsActive' of the stored procedure.
            oDatabaseHelper.AddParameter("@IsActive", _isActiveNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_AdvanceListContactMaster_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_AdvanceListContactMaster_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#9
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			07/27/2010 11:57:21 AM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_exceptionLogID' as parameter 'ExceptionLogID' of the stored procedure.
            //oDatabaseHelper.AddParameter("@ExceptionLogID", _exceptionLogIDNonDefault);
            // Pass the value of '_date' as parameter 'Date' of the stored procedure.
            oDatabaseHelper.AddParameter("@Date", _dateNonDefault);
            // Pass the value of '_type' as parameter 'Type' of the stored procedure.
            oDatabaseHelper.AddParameter("@Type", _typeNonDefault);
            // Pass the value of '_message' as parameter 'Message' of the stored procedure.
            oDatabaseHelper.AddParameter("@Message", _messageNonDefault);
            // Pass the value of '_stackTrace' as parameter 'StackTrace' of the stored procedure.
            oDatabaseHelper.AddParameter("@StackTrace", _stackTraceNonDefault);
            // Pass the value of '_userID' as parameter 'UserID' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserID", _userIDNonDefault);
            // Pass the value of '_isCompleted' as parameter 'IsCompleted' of the stored procedure.
            oDatabaseHelper.AddParameter("@IsCompleted", _isCompletedNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_ExceptionLog_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_ExceptionLog_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#10
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			07/27/2010 11:57:21 AM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Insert()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_exceptionLogID' as parameter 'ExceptionLogID' of the stored procedure.
            //oDatabaseHelper.AddParameter("@ExceptionLogID", _exceptionLogID);
            // Pass the value of '_date' as parameter 'Date' of the stored procedure.
            oDatabaseHelper.AddParameter("@Date", _date);
            // Pass the value of '_type' as parameter 'Type' of the stored procedure.
            oDatabaseHelper.AddParameter("@Type", _type);
            // Pass the value of '_message' as parameter 'Message' of the stored procedure.
            oDatabaseHelper.AddParameter("@Message", _message);
            // Pass the value of '_stackTrace' as parameter 'StackTrace' of the stored procedure.
            oDatabaseHelper.AddParameter("@StackTrace", _stackTrace);
            // Pass the value of '_userID' as parameter 'UserID' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserID", _userID);
            // Pass the value of '_isCompleted' as parameter 'IsCompleted' of the stored procedure.
            oDatabaseHelper.AddParameter("@IsCompleted", _isCompleted);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_ExceptionLog_Insert", ref ExecutionState);
            oDatabaseHelper.Dispose();

            return ExecutionState;
        }
示例#11
0
 //Ganesh on 30nov09
 //This method will insert a new job in CampaignMaster table.
 public int insertCampainMaster(CampaignMaster objCampaignMaster)
 {
     try
     {
         using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
         {
             bool ExecutionState = false;
             oDatabaseHelper.AddParameter("@CampaignName", objCampaignMaster.CampaignName);
             oDatabaseHelper.AddParameter("@CampaignDescription", objCampaignMaster.CampaignDescription);
             oDatabaseHelper.AddParameter("@FromAddress", objCampaignMaster.FromAddress);
             oDatabaseHelper.AddParameter("@FromName", objCampaignMaster.FromName);
             oDatabaseHelper.AddParameter("@ReplytoAddress", objCampaignMaster.ReplytoAddress);
             oDatabaseHelper.AddParameter("@ReplaytoName", objCampaignMaster.ReplaytoName);
             oDatabaseHelper.AddParameter("@TemplateId", objCampaignMaster.TemplateId);
             oDatabaseHelper.AddParameter("@Subject", objCampaignMaster.Subject);
             oDatabaseHelper.AddParameter("@TrackReads", objCampaignMaster.TrackReads);
             oDatabaseHelper.AddParameter("@SelectCondition", objCampaignMaster.SelectCondition);
             oDatabaseHelper.AddParameter("@HTMLContent", objCampaignMaster.HTMLContent);
             oDatabaseHelper.AddParameter("@TextContent", objCampaignMaster.TextContent);
             oDatabaseHelper.AddParameter("@SuppressDomain", objCampaignMaster.SuppressDomain);
             oDatabaseHelper.AddParameter("@UnsubscribeText", objCampaignMaster.UnsubscribeText);
             oDatabaseHelper.AddParameter("@UnsubscribeLinkText", objCampaignMaster.UnsubscribeLinkText);
             oDatabaseHelper.AddParameter("@SuppressLists", objCampaignMaster.SuppressSelection);
             oDatabaseHelper.AddParameter("@AssignedCampaignID", objCampaignMaster.AssignedCampaignID);
             oDatabaseHelper.AddParameter("@CampaignID", -1, System.Data.ParameterDirection.Output);
             oDatabaseHelper.ExecuteScalar("sp_CampaignMaster_Insert_CustomProc", ref ExecutionState);
             int CampaignID = (int)oDatabaseHelper.GetParameterValue("@CampaignID");
             oDatabaseHelper.Dispose();
             return CampaignID;
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
示例#12
0
        public bool UpdateUserDetails()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);
            //// Pass the value of '_id' as parameter 'Id' of the stored procedure.
            //oDatabaseHelper.AddParameter("@Id", _id);
            //// Pass the value of '_userId' as parameter 'UserId' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserId", _userId);
            // Pass the value of '_userName' as parameter 'UserName' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserName", _userName);
            // Pass the value of '_firstName' as parameter 'FirstName' of the stored procedure.
            oDatabaseHelper.AddParameter("@FirstName", _firstName);
            // Pass the value of '_lastName' as parameter 'LastName' of the stored procedure.
            oDatabaseHelper.AddParameter("@LastName", _lastName);
            // Pass the value of '_address1' as parameter 'Address1' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address1", _address1);
            // Pass the value of '_address2' as parameter 'Address2' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address2", _address2);
            // Pass the value of '_workPhone' as parameter 'WorkPhone' of the stored procedure.
            oDatabaseHelper.AddParameter("@WorkPhone", _workPhone);
            // Pass the value of '_cellPhone' as parameter 'CellPhone' of the stored procedure.
            oDatabaseHelper.AddParameter("@CellPhone", _cellPhone);
            // Pass the value of '_Fax' as parameter 'Fax' of the stored procedure.
            oDatabaseHelper.AddParameter("@Fax", _fax);
            // Pass the value of '_homePhone' as parameter 'HomePhone' of the stored procedure.
            oDatabaseHelper.AddParameter("@HomePhone", _homePhone);
            oDatabaseHelper.AddParameter("@City", _city);
            // Pass the value of '_state' as parameter 'State' of the stored procedure.
            oDatabaseHelper.AddParameter("@State", _state);
            // Pass the value of '_country' as parameter 'Country' of the stored procedure.
            oDatabaseHelper.AddParameter("@Country", _country);
            // Pass the value of '_postalCode' as parameter 'PostalCode' of the stored procedure.
            oDatabaseHelper.AddParameter("@PostalCode", _postalCode);
            // Pass the value of '_emailAddress' as parameter 'EmailAddress' of the stored procedure.
            oDatabaseHelper.AddParameter("@EmailAddress", _emailAddress);

            // Pass the value of '_listTab' as parameter 'ListTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListTab", _listTab);
            // Pass the value of '_campaignTab' as parameter 'CampaignTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignTab", _campaignTab);
            // Pass the value of '_advancedTab' as parameter 'AdvancedTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@AdvancedTab", _advancedTab);
            // Pass the value of '_reportsTab' as parameter 'ReportsTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@ReportsTab", _reportsTab);
            // Pass the value of '_campaignReportsTab' as parameter 'CampaignReportsTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignReportsTab", _campaignReportsTab);

            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_UserInfo_UpdateUserDetails", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#13
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			2/15/2012 12:52:22 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_id' as parameter 'Id' of the stored procedure.
            oDatabaseHelper.AddParameter("@Id", _idNonDefault);
            // Pass the value of '_userId' as parameter 'UserId' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserId", _userIdNonDefault);
            // Pass the value of '_userName' as parameter 'UserName' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserName", _userNameNonDefault);
            // Pass the value of '_firstName' as parameter 'FirstName' of the stored procedure.
            oDatabaseHelper.AddParameter("@FirstName", _firstNameNonDefault);
            // Pass the value of '_lastName' as parameter 'LastName' of the stored procedure.
            oDatabaseHelper.AddParameter("@LastName", _lastNameNonDefault);
            // Pass the value of '_address1' as parameter 'Address1' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address1", _address1NonDefault);
            // Pass the value of '_address2' as parameter 'Address2' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address2", _address2NonDefault);
            // Pass the value of '_workPhone' as parameter 'WorkPhone' of the stored procedure.
            oDatabaseHelper.AddParameter("@WorkPhone", _workPhoneNonDefault);
            // Pass the value of '_cellPhone' as parameter 'CellPhone' of the stored procedure.
            oDatabaseHelper.AddParameter("@CellPhone", _cellPhoneNonDefault);
            // Pass the value of '_Fax' as parameter 'Fax' of the stored procedure.
            oDatabaseHelper.AddParameter("@Fax", _fax);
            // Pass the value of '_homePhone' as parameter 'HomePhone' of the stored procedure.
            oDatabaseHelper.AddParameter("@HomePhone", _homePhone);
            oDatabaseHelper.AddParameter("@City", _cityNonDefault);
            // Pass the value of '_state' as parameter 'State' of the stored procedure.
            oDatabaseHelper.AddParameter("@State", _stateNonDefault);
            // Pass the value of '_country' as parameter 'Country' of the stored procedure.
            oDatabaseHelper.AddParameter("@Country", _countryNonDefault);
            // Pass the value of '_postalCode' as parameter 'PostalCode' of the stored procedure.
            oDatabaseHelper.AddParameter("@PostalCode", _postalCodeNonDefault);
            // Pass the value of '_emailAddress' as parameter 'EmailAddress' of the stored procedure.
            oDatabaseHelper.AddParameter("@EmailAddress", _emailAddressNonDefault);

            // Pass the value of '_listTab' as parameter 'ListTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListTab", _listTabNonDefault);
            // Pass the value of '_campaignTab' as parameter 'CampaignTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignTab", _campaignTabNonDefault);
            // Pass the value of '_advancedTab' as parameter 'AdvancedTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@AdvancedTab", _advancedTabNonDefault);
            // Pass the value of '_reportsTab' as parameter 'ReportsTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@ReportsTab", _reportsTabNonDefault);
            // Pass the value of '_campaignReportsTab' as parameter 'CampaignReportsTab' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignReportsTab", _campaignReportsTabNonDefault);

            // Pass the value of '_logo' as parameter 'Logo' of the stored procedure.
            oDatabaseHelper.AddParameter("@Logo", _logoNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_UserInfo_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_UserInfo_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/27/2010 1:13:46 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_contactId' as parameter 'ContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactId", _contactId);
            // Pass the value of '_importJobID' as parameter 'ImportJobID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ImportJobID", _importJobID);
            // Pass the value of '_emailAddress' as parameter 'EmailAddress' of the stored procedure.
            oDatabaseHelper.AddParameter("@EmailAddress", _emailAddress);
            // Pass the value of '_firstName' as parameter 'FirstName' of the stored procedure.
            oDatabaseHelper.AddParameter("@FirstName", _firstName);
            // Pass the value of '_lastName' as parameter 'LastName' of the stored procedure.
            oDatabaseHelper.AddParameter("@LastName", _lastName);
            // Pass the value of '_address1' as parameter 'Address1' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address1", _address1);
            // Pass the value of '_address2' as parameter 'Address2' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address2", _address2);
            // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDate", _createdDate);
            // Pass the value of '_modifiedDate' as parameter 'ModifiedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedDate", _modifiedDate);
            // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedBy", _createdBy);
            // Pass the value of '_modifiedBy' as parameter 'ModifiedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedBy", _modifiedBy);
            // Pass the value of '_clientId' as parameter 'ClientId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClientId", _clientId);
            // Pass the value of '_active' as parameter 'Active' of the stored procedure.
            oDatabaseHelper.AddParameter("@Active", _active);
            // Pass the value of '_makeVerified' as parameter 'MakeVerified' of the stored procedure.
            oDatabaseHelper.AddParameter("@MakeVerified", _makeVerified);
            // Pass the value of '_customField1' as parameter 'CustomField1' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField1", _customField1);
            // Pass the value of '_customField2' as parameter 'CustomField2' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField2", _customField2);
            // Pass the value of '_customField3' as parameter 'CustomField3' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField3", _customField3);
            // Pass the value of '_customField4' as parameter 'CustomField4' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField4", _customField4);
            // Pass the value of '_customField5' as parameter 'CustomField5' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField5", _customField5);
            // Pass the value of '_customField6' as parameter 'CustomField6' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField6", _customField6);
            // Pass the value of '_customField7' as parameter 'CustomField7' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField7", _customField7);
            // Pass the value of '_customField8' as parameter 'CustomField8' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField8", _customField8);
            // Pass the value of '_customField9' as parameter 'CustomField9' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField9", _customField9);
            // Pass the value of '_customField10' as parameter 'CustomField10' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField10", _customField10);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_ContactMasterTemp_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/27/2010 1:13:46 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_contactId' as parameter 'ContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactId", _contactIdNonDefault);
            // Pass the value of '_importJobID' as parameter 'ImportJobID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ImportJobID", _importJobIDNonDefault);
            // Pass the value of '_emailAddress' as parameter 'EmailAddress' of the stored procedure.
            oDatabaseHelper.AddParameter("@EmailAddress", _emailAddressNonDefault);
            // Pass the value of '_firstName' as parameter 'FirstName' of the stored procedure.
            oDatabaseHelper.AddParameter("@FirstName", _firstNameNonDefault);
            // Pass the value of '_lastName' as parameter 'LastName' of the stored procedure.
            oDatabaseHelper.AddParameter("@LastName", _lastNameNonDefault);
            // Pass the value of '_address1' as parameter 'Address1' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address1", _address1NonDefault);
            // Pass the value of '_address2' as parameter 'Address2' of the stored procedure.
            oDatabaseHelper.AddParameter("@Address2", _address2NonDefault);
            // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDate", _createdDateNonDefault);
            // Pass the value of '_modifiedDate' as parameter 'ModifiedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedDate", _modifiedDateNonDefault);
            // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault);
            // Pass the value of '_modifiedBy' as parameter 'ModifiedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedBy", _modifiedByNonDefault);
            // Pass the value of '_clientId' as parameter 'ClientId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClientId", _clientIdNonDefault);
            // Pass the value of '_active' as parameter 'Active' of the stored procedure.
            oDatabaseHelper.AddParameter("@Active", _activeNonDefault);
            // Pass the value of '_makeVerified' as parameter 'MakeVerified' of the stored procedure.
            oDatabaseHelper.AddParameter("@MakeVerified", _makeVerifiedNonDefault);
            // Pass the value of '_customField1' as parameter 'CustomField1' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField1", _customField1NonDefault);
            // Pass the value of '_customField2' as parameter 'CustomField2' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField2", _customField2NonDefault);
            // Pass the value of '_customField3' as parameter 'CustomField3' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField3", _customField3NonDefault);
            // Pass the value of '_customField4' as parameter 'CustomField4' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField4", _customField4NonDefault);
            // Pass the value of '_customField5' as parameter 'CustomField5' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField5", _customField5NonDefault);
            // Pass the value of '_customField6' as parameter 'CustomField6' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField6", _customField6NonDefault);
            // Pass the value of '_customField7' as parameter 'CustomField7' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField7", _customField7NonDefault);
            // Pass the value of '_customField8' as parameter 'CustomField8' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField8", _customField8NonDefault);
            // Pass the value of '_customField9' as parameter 'CustomField9' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField9", _customField9NonDefault);
            // Pass the value of '_customField10' as parameter 'CustomField10' of the stored procedure.
            oDatabaseHelper.AddParameter("@CustomField10", _customField10NonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_ContactMasterTemp_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_ContactMasterTemp_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr,ConnectionString);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#16
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			7/31/2012 02:55:35 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _id);
            // Pass the value of '_campaignId' as parameter 'CampaignId' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignId", _campaignId);
            // Pass the value of '_listMasterID' as parameter 'ListMasterID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListMasterID", _listMasterID);
            // Pass the value of '_contactId' as parameter 'ContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactId", _contactId);
            // Pass the value of '_supressedDomain' as parameter 'SupressedDomain' of the stored procedure.
            oDatabaseHelper.AddParameter("@SupressedDomain", _supressedDomain);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_DomineSupress_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
        /// <summary>
        /// This method will Delete one row from the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			7/28/2012 02:17:32 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Delete()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_listContactId' as parameter 'ListContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListContactId", _listContactId);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_AdvanceListContactMaster_Delete", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#18
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/21/2011 3:16:54 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_categoryID' as parameter 'CategoryID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CategoryID", _categoryID);
            // Pass the value of '_categoryName' as parameter 'CategoryName' of the stored procedure.
            oDatabaseHelper.AddParameter("@CategoryName", _categoryName);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_CategoryMaster_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			7/28/2012 02:17:32 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_listContactId' as parameter 'ListContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListContactId", _listContactId);
            // Pass the value of '_listMasterID' as parameter 'ListMasterID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListMasterID", _listMasterID);
            // Pass the value of '_contactId' as parameter 'ContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactId", _contactId);
            // Pass the value of '_clientId' as parameter 'ClientId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClientId", _clientId);
            // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDate", _createdDate);
            // Pass the value of '_modifiedDate' as parameter 'ModifiedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedDate", _modifiedDate);
            // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedBy", _createdBy);
            // Pass the value of '_modifiedBy' as parameter 'ModifiedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedBy", _modifiedBy);
            // Pass the value of '_isActive' as parameter 'IsActive' of the stored procedure.
            oDatabaseHelper.AddParameter("@IsActive", _isActive);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_AdvanceListContactMaster_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#20
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			4/12/2012 11:16:28 AM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_complaintID' as parameter 'ComplaintID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ComplaintID", _complaintIDNonDefault);
            // Pass the value of '_contactID' as parameter 'ContactID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactID", _contactIDNonDefault);
            // Pass the value of '_bounceCategory' as parameter 'BounceCategory' of the stored procedure.
            oDatabaseHelper.AddParameter("@BounceCategory", _bounceCategoryNonDefault);
            // Pass the value of '_campaignID' as parameter 'CampaignID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignID", _campaignIDNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_MailComplaints_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_MailComplaints_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#21
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			2/3/2010 4:14:00 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _id);
            // Pass the value of '_campaignMasterID' as parameter 'CampaignMasterID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignMasterID", _campaignMasterID);
            // Pass the value of '_scheduledDatetime' as parameter 'ScheduledDatetime' of the stored procedure.
            oDatabaseHelper.AddParameter("@ScheduledDatetime", _scheduledDatetime);
            // Pass the value of '_createdDatetime' as parameter 'CreatedDatetime' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDatetime", _createdDatetime);
            // Pass the value of '_status' as parameter 'Status' of the stored procedure.
            oDatabaseHelper.AddParameter("@Status", _status);
            // Pass the value of '_statusMessage' as parameter 'StatusMessage' of the stored procedure.
            oDatabaseHelper.AddParameter("@StatusMessage", _statusMessage);
            // Pass the value of '_deliveredCount' as parameter 'DeliveredCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@DeliveredCount", _deliveredCount);
            // Pass the value of '_openCount' as parameter 'OpenCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@OpenCount", _openCount);
            // Pass the value of '_clickCount' as parameter 'ClickCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClickCount", _clickCount);
            // Pass the value of '_bounceCount' as parameter 'BounceCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@BounceCount", _bounceCount);
            // Pass the value of '_optoutCount' as parameter 'OptoutCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@OptoutCount", _optoutCount);
            // Pass the value of '_sendType' as parameter 'SendType' of the stored procedure.
            oDatabaseHelper.AddParameter("@SendType", _sendType);
            // Pass the value of '_totalRecipients' as parameter 'TotalRecipients' of the stored procedure.
            oDatabaseHelper.AddParameter("@TotalRecipients", _totalRecipients);
            // Pass the value of '_unSubscribeCount' as parameter 'UnSubscribeCount' of the stored procedure.
            oDatabaseHelper.AddParameter("@UnSubscribeCount", _unSubscribeCount);
            // Pass the value of '_startTime' as parameter 'StartTime' of the stored procedure.
            oDatabaseHelper.AddParameter("@StartTime", _startTime);
            // Pass the value of '_completionTime' as parameter 'CompletionTime' of the stored procedure.
            oDatabaseHelper.AddParameter("@CompletionTime", _completionTime);
            // Pass the value of '_IsBillable' as parameter 'IsBillable' of the stored procedure.
            oDatabaseHelper.AddParameter("@IsBillable", _IsBillable);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_CampaignJob_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#22
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			4/12/2012 11:16:28 AM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_complaintID' as parameter 'ComplaintID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ComplaintID", _complaintID);
            // Pass the value of '_contactID' as parameter 'ContactID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactID", _contactID);
            // Pass the value of '_bounceCategory' as parameter 'BounceCategory' of the stored procedure.
            oDatabaseHelper.AddParameter("@BounceCategory", _bounceCategory);
            // Pass the value of '_campaignID' as parameter 'CampaignID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignID", _campaignID);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_MailComplaints_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#23
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/21/2009 4:19:24 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _idNonDefault);
            // Pass the value of '_importJobID' as parameter 'ImportJobID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ImportJobID", _importJobIDNonDefault);
            // Pass the value of '_sourceField' as parameter 'SourceField' of the stored procedure.
            oDatabaseHelper.AddParameter("@SourceField", _sourceFieldNonDefault);
            // Pass the value of '_destinationField' as parameter 'DestinationField' of the stored procedure.
            oDatabaseHelper.AddParameter("@DestinationField", _destinationFieldNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_FieldMap_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_FieldMap_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#24
0
        public void insertCustomLabel(CustomLabel objCustomLabel)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@CampaignId", objCustomLabel.CampaignId);
                    oDatabaseHelper.AddParameter("@TemplateId", objCustomLabel.TemplateId);
                    oDatabaseHelper.AddParameter("@LinkURL", objCustomLabel.LinkURL);
                    oDatabaseHelper.AddParameter("@CustomLabel", objCustomLabel.CustomLabel);

                    oDatabaseHelper.ExecuteScalar("sp_CustomLabel", ref ExecutionState);
                    int CampaignID = (int)oDatabaseHelper.GetParameterValue("@CampaignID");
                    oDatabaseHelper.Dispose();

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#25
0
        /// <summary>
        /// This method will Delete one row from the database using the primary key information
        /// </summary>
        ///
        /// <param name="pk" type="EmailOpenDetailPrimaryKey">Primary Key information based on which data is to be fetched.</param>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/8/2010 12:24:52 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public static bool Delete(EmailOpenDetailPrimaryKey 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);

            oDatabaseHelper.ExecuteScalar("sp_EmailOpenDetails_Delete", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#26
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/24/2009 12:37:33 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_templateId' as parameter 'TemplateId' of the stored procedure.
            oDatabaseHelper.AddParameter("@TemplateId", _templateIdNonDefault);
            // Pass the value of '_templateName' as parameter 'TemplateName' of the stored procedure.
            oDatabaseHelper.AddParameter("@TemplateName", _templateNameNonDefault);
            // Pass the value of '_templateDescription' as parameter 'TemplateDescription' of the stored procedure.
            oDatabaseHelper.AddParameter("@TemplateDescription", _templateDescriptionNonDefault);
            // Pass the value of '_clientId' as parameter 'ClientId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClientId", _clientIdNonDefault);
            // Pass the value of '_hTMLContent' as parameter 'HTMLContent' of the stored procedure.
            oDatabaseHelper.AddParameter("@HTMLContent", _hTMLContentNonDefault);
            // Pass the value of '_textContent' as parameter 'TextContent' of the stored procedure.
            oDatabaseHelper.AddParameter("@TextContent", _textContentNonDefault);
            // Pass the value of '_modifiedBy' as parameter 'ModifiedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedBy", _modifiedByNonDefault);
            // Pass the value of '_modifiedDate' as parameter 'ModifiedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedDate", _modifiedDateNonDefault);
            // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDate", _createdDateNonDefault);
            // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedBy", _createdByNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_TemplateMaster_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_TemplateMaster_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#27
0
        /// <summary>
        /// This method will Delete one row from the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/8/2010 12:24:52 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Delete()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _id);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_EmailOpenDetails_Delete", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#28
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			11/24/2009 12:37:33 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_templateId' as parameter 'TemplateId' of the stored procedure.
            oDatabaseHelper.AddParameter("@TemplateId", _templateId);
            // Pass the value of '_templateName' as parameter 'TemplateName' of the stored procedure.
            oDatabaseHelper.AddParameter("@TemplateName", _templateName);
            // Pass the value of '_templateDescription' as parameter 'TemplateDescription' of the stored procedure.
            oDatabaseHelper.AddParameter("@TemplateDescription", _templateDescription);
            // Pass the value of '_clientId' as parameter 'ClientId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ClientId", _clientId);
            // Pass the value of '_hTMLContent' as parameter 'HTMLContent' of the stored procedure.
            oDatabaseHelper.AddParameter("@HTMLContent", _hTMLContent);
            // Pass the value of '_textContent' as parameter 'TextContent' of the stored procedure.
            oDatabaseHelper.AddParameter("@TextContent", _textContent);
            // Pass the value of '_modifiedBy' as parameter 'ModifiedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedBy", _modifiedBy);
            // Pass the value of '_modifiedDate' as parameter 'ModifiedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@ModifiedDate", _modifiedDate);
            // Pass the value of '_createdDate' as parameter 'CreatedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedDate", _createdDate);
            // Pass the value of '_createdBy' as parameter 'CreatedBy' of the stored procedure.
            oDatabaseHelper.AddParameter("@CreatedBy", _createdBy);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_TemplateMaster_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#29
0
        /// <summary>
        /// This method will Update one new row into the database using the property Information
        /// </summary>
        ///
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			1/8/2010 12:24:52 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool Update()
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _id);
            // Pass the value of '_campaignID' as parameter 'CampaignID' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignID", _campaignID);
            // Pass the value of '_contactID' as parameter 'ContactID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactID", _contactID);
            // Pass the value of '_openedDate' as parameter 'OpenedDate' of the stored procedure.
            oDatabaseHelper.AddParameter("@OpenedDate", _openedDate);
            // Pass the value of '_iPAddress' as parameter 'IPAddress' of the stored procedure.
            oDatabaseHelper.AddParameter("@IPAddress", _iPAddress);
            // Pass the value of '_userAgent' as parameter 'UserAgent' of the stored procedure.
            oDatabaseHelper.AddParameter("@UserAgent", _userAgent);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteScalar("sp_EmailOpenDetails_Update", ref ExecutionState);
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }
示例#30
0
        /// <summary>
        /// This method will insert one new row into the database using the property Information
        /// </summary>
        /// <param name="getBackValues" type="bool">Whether to get the default values inserted, from the database</param>
        /// <returns>True if succeeded</returns>
        ///
        /// <remarks>
        ///
        /// <RevisionHistory>
        /// Author				Date			Description
        /// DLGenerator			7/31/2012 02:55:35 PM		Created function
        /// 
        /// </RevisionHistory>
        ///
        /// </remarks>
        ///
        public bool InsertWithDefaultValues(bool getBackValues)
        {
            bool ExecutionState = false;
            oDatabaseHelper = new DatabaseHelper();

            // Pass the value of '_id' as parameter 'ID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ID", _idNonDefault);
            // Pass the value of '_campaignId' as parameter 'CampaignId' of the stored procedure.
            oDatabaseHelper.AddParameter("@CampaignId", _campaignIdNonDefault);
            // Pass the value of '_listMasterID' as parameter 'ListMasterID' of the stored procedure.
            oDatabaseHelper.AddParameter("@ListMasterID", _listMasterIDNonDefault);
            // Pass the value of '_contactId' as parameter 'ContactId' of the stored procedure.
            oDatabaseHelper.AddParameter("@ContactId", _contactIdNonDefault);
            // Pass the value of '_supressedDomain' as parameter 'SupressedDomain' of the stored procedure.
            oDatabaseHelper.AddParameter("@SupressedDomain", _supressedDomainNonDefault);
            // The parameter '@ErrorCode' will contain the status after execution of the stored procedure.
            oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);

            if(!getBackValues )
            {
                oDatabaseHelper.ExecuteScalar("sp_DomineSupress_Insert_WithDefaultValues", ref ExecutionState);
            }
            else
            {
                IDataReader dr=oDatabaseHelper.ExecuteReader("sp_DomineSupress_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
                if (dr.Read())
                {
                    PopulateObjectFromReader(this,dr);
                }
                dr.Close();
            }
            oDatabaseHelper.Dispose();
            return ExecutionState;
        }