C# DatabaseHelper.ExecuteNonQuery方法代码示例

        public bool DeleteAllContactsFromList(long listId)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@ListID", listId);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_AdvanceListContactMaster_DeleteAllContactsByListId_CustomProc", ref ExecutionState);

                }
                return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public static bool ChangeContactStatusByList(long contactID, bool status, string ConnectionString)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@ContactID", contactID);
                    oDatabaseHelper.AddParameter("@Status", status);
                    oDatabaseHelper.ExecuteNonQuery("sp_ListContactMaster_ChangeContactStatus", ref ExecutionState);

                }
                return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public void insertEmailOpenedDetails(Int64 contactID, Int64 campaignID, string ipAddress, string userAgent)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper())
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@ContactID", contactID);
                    oDatabaseHelper.AddParameter("@CampaignID", campaignID);
                    oDatabaseHelper.AddParameter("@IPAddress", ipAddress);
                    oDatabaseHelper.AddParameter("@UserAgent", userAgent);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_EmailOpenDetails_CustomProc", ref ExecutionState);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public void deleteListFromListContactMaster(Int64 listIDToBeDeleted, Int64 contactID)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@ListID", listIDToBeDeleted);
                    oDatabaseHelper.AddParameter("@ContactID", contactID);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_ListContactMaster_ListID_Delete_CustomProc", ref ExecutionState);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

 public void UpdateColumnByNulls(string customfield)
 {
     DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);
     bool ExecutionState = false;
     oDatabaseHelper.AddParameter("@customfield", customfield);
     oDatabaseHelper.ExecuteNonQuery("sp_ContactMaster_Update_Column", ref ExecutionState);
     oDatabaseHelper.Dispose();
 }

 public void RemoveMultipleContacts(string ContactsTobeRemoved)
 {
     try
     {
         bool ExecutionState = false;
         DatabaseHelper ObDatabaseHelper = new DatabaseHelper(ConnectionString);
         ObDatabaseHelper.AddParameter("@ContactIDs", ContactsTobeRemoved);
         int IsSuccess = ObDatabaseHelper.ExecuteNonQuery("sp_ContactMaster_DeleteMultipleContacts_CustomProc", ref ExecutionState);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

        private void unSubscribeContact(Int64 contactID, Int64 campaignID, string ipAddress, string reason, string notes, string whatToUnSub)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper())
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@ContactID", contactID);
                    oDatabaseHelper.AddParameter("@CampaignID", campaignID);
                    oDatabaseHelper.AddParameter("@IPAddress", ipAddress);
                    oDatabaseHelper.AddParameter("@OptOutReasonDesc", reason);
                    oDatabaseHelper.AddParameter("@OptOutAdditionalNotes", notes);
                    oDatabaseHelper.AddParameter("@WhatToUnSub", whatToUnSub);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_UnSubscribeDetails_Insert_CustomProc", ref ExecutionState);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        //Ganesh on 09feb10
        //This method will insert recipients forwarded to ForwardDetails table..
        public void InsertForwardDetails(Int64 campaignID, string forwardXMLData, int forwardCount, String ConnectionString)
        {
            try
            {

                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@CampaignMasterID", campaignID);
                    oDatabaseHelper.AddParameter("@ForwardXML", forwardXMLData);
                    oDatabaseHelper.AddParameter("@ForwardCount", forwardCount);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_ForwardDetals_Insert_CustomProc", ref ExecutionState);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

 public static void RemoveMultipleFields(string FieldIds, String ConnectionString)
 {
     try
     {
         bool ExecutionState = false;
         DatabaseHelper ObDatabaseHelper = new DatabaseHelper(ConnectionString);
         ObDatabaseHelper.AddParameter("@FieldIds", FieldIds);
         int IsSuccess = ObDatabaseHelper.ExecuteNonQuery("sp_ManageFields_DeleteMultipleByField", ref ExecutionState);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 private void CreateClientInBilling()
 {
     try
     {
         bool ExecutionState = false;
         string constr = ConfigurationManager.ConnectionStrings["BillingConnection"].ToString();
         DatabaseHelper objDbHelper = new DatabaseHelper(constr);
         objDbHelper.AddParameter("@firstName", txtCreateFirstName.Text);
         objDbHelper.AddParameter("@lastName", txtCreateLastname.Text);
         objDbHelper.AddParameter("@email", txtCreateEmail.Text);
         objDbHelper.AddParameter("@phone", "");
         objDbHelper.AddParameter("@stateCode", "");
         objDbHelper.AddParameter("@country", "");
         objDbHelper.AddParameter("@Active", ChkCreateStatus.Checked.ToString());
         objDbHelper.AddParameter("@ParentCompanyId", "");
         objDbHelper.AddParameter("@ClientCode", txtCreateUsername.Text);
         objDbHelper.AddParameter("@IntegratedSystemClientId", txtCreateUsername.Text);
         objDbHelper.AddParameter("@Option", "Add");
         objDbHelper.ExecuteNonQuery("addClientsFromIntegratedApplication", ref ExecutionState);
     }
     catch
     {
     }
 }

 public static void RemoveDuplicates(string ConnectionString)
 {
     bool ExecutionState = false;
     using (DatabaseHelper ObjDbase = new DatabaseHelper(ConnectionString))
     {
         int i = ObjDbase.ExecuteNonQuery("Sp_SuppressContacts_RemoveDuplicates_Proc", ref ExecutionState);
     }
 }

        //Anwar
        private void unSubscribeContactCheck(Int64 contactID, Int64 campaignID, string ipAddress, string reason, string notes, string whatToUnSub, out int Count)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper())
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@ContactID", contactID);
                    oDatabaseHelper.AddParameter("@CampaignID", campaignID);
                    oDatabaseHelper.AddParameter("@IPAddress", ipAddress);
                    oDatabaseHelper.AddParameter("@OptOutReasonDesc", reason);
                    oDatabaseHelper.AddParameter("@OptOutAdditionalNotes", notes);
                    oDatabaseHelper.AddParameter("@WhatToUnSub", whatToUnSub);
                    oDatabaseHelper.AddParameter("@Count", -1, System.Data.ParameterDirection.Output);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_UnSubscribeDetails_CheckAndInsert_CustomProc", ref ExecutionState);
                    Count = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@Count"].Value);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// End Here
        /// 
        public int InsertInToDomainSuppress_Bulk(int CompaignId, string ListMasterIds, DataTable SupressedDomain)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@CampaignId", CompaignId);
                    oDatabaseHelper.AddParameter("@ListIds", ListMasterIds);
                    oDatabaseHelper.AddParameter("@DtDomainNames", SupressedDomain);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("sp_InsertInToDomainSuppress", ref ExecutionState);

                    return IsSuccess;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public int InsertReturnID()
        {
            bool ExecutionState = false;
            DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);

            // 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.AddParameter("@Id", -1, System.Data.ParameterDirection.Output);

            oDatabaseHelper.ExecuteNonQuery("sp_TemplateMaster_Insert_ReturnId", ref ExecutionState);

            int id = (int)oDatabaseHelper.GetParameterValue("@Id");
            oDatabaseHelper.Dispose();

            return id;
        }

        public int SaveSuppressDomain(long ID, string SuppressDomain)
        {
            try
            {
                using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString))
                {
                    bool ExecutionState = false;
                    oDatabaseHelper.AddParameter("@CampaignId", ID);
                    oDatabaseHelper.AddParameter("@SuppressDomain", SuppressDomain);
                    int IsSuccess = oDatabaseHelper.ExecuteNonQuery("USP_SaveSuppressDomain", ref ExecutionState);

                    return IsSuccess;

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }