C# SQLHandler.ExecuteNonQuery方法代码示例

        public void SaveBannerContent(SageBannerInfo obj)
        {
            try
            {
                List<KeyValuePair<string, object>> param = new List<KeyValuePair<string, object>>();
                param.Add(new KeyValuePair<string, object>("@Caption", obj.Caption));
                param.Add(new KeyValuePair<string, object>("@ImagePath", obj.ImagePath));
                param.Add(new KeyValuePair<string, object>("@ReadMorePage", obj.ReadMorePage));
                param.Add(new KeyValuePair<string, object>("@LinkToImage", obj.LinkToImage));
                param.Add(new KeyValuePair<string, object>("@UserModuleID", obj.UserModuleID));
                param.Add(new KeyValuePair<string, object>("@BannerID", obj.BannerID));
                param.Add(new KeyValuePair<string, object>("@ImageID", obj.ImageID));
                param.Add(new KeyValuePair<string, object>("@ReadButtonText", obj.ReadButtonText));
                param.Add(new KeyValuePair<string, object>("@NavigationImage", obj.NavigationImage));
                param.Add(new KeyValuePair<string, object>("@Description", obj.Description));
                param.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID));
                param.Add(new KeyValuePair<string, object>("@CultureCode", obj.CultureCode));
                SQLHandler sagesql = new SQLHandler();
                sagesql.ExecuteNonQuery("usp_SageBannerSaveBannerContent", param);
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }

 /// <summary>
 /// Connect to database and save Suspended IP.
 /// </summary>
 /// <param name="IpAddress">IpAddress</param>
 public void SaveSuspendedIP(string IpAddress)
 {
     List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@IpAddress", IpAddress));
     SQLHandler sageSQL = new SQLHandler();
     sageSQL.ExecuteNonQuery("usp_SaveSuspendedIP", ParaMeterCollection);
 }

 public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
                                                  AspxCommonInfo aspxCommonObj)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
         parameter.Add(new KeyValuePair<string, object>("@RewardPointSettingsID",
                                                        rewardPointsCommonObj.RewardPointSettingsID));
         parameter.Add(new KeyValuePair<string, object>("@RewardRuleName", rewardPointsCommonObj.RewardRuleName));
         parameter.Add(new KeyValuePair<string, object>("@RewardRuleID", rewardPointsCommonObj.RewardRuleID));
         parameter.Add(new KeyValuePair<string, object>("@RewardRuleType", rewardPointsCommonObj.RewardRuleType));
         parameter.Add(new KeyValuePair<string, object>("@RewardPoints", rewardPointsCommonObj.RewardPoints));
         parameter.Add(new KeyValuePair<string, object>("@PurchaseAmount", rewardPointsCommonObj.PurchaseAmount));
         parameter.Add(new KeyValuePair<string, object>("@IsActive", rewardPointsCommonObj.IsActive));
         parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
         parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
         parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
         parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
         sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveUpdateNewRule", parameter);
     }
     catch (Exception e)
     {
         throw e;
     }
 }

        public static void RewardPointsSaveGeneralSettings(GeneralSettingsCommonInfo generalSettingobj,
                                                           AspxCommonInfo aspxCommonObj)
        {
            try
            {
                SQLHandler sqlH = new SQLHandler();
                List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
                parameter.Add(new KeyValuePair<string, object>("@RewardPoints", generalSettingobj.RewardPoints));
                parameter.Add(new KeyValuePair<string, object>("@RewardAmount", generalSettingobj.RewardExchangeRate));
                parameter.Add(new KeyValuePair<string, object>("@AddOrderStatusID", generalSettingobj.AddOrderStatusID));
                parameter.Add(new KeyValuePair<string, object>("@SubOrderStatusID", generalSettingobj.SubOrderStatusID));
                parameter.Add(new KeyValuePair<string, object>("@RewardPointsExpiresInDays",
                                                               generalSettingobj.RewardPointsExpiresInDays));
                parameter.Add(new KeyValuePair<string, object>("@MinRedeemBalance", generalSettingobj.MinRedeemBalance));
                parameter.Add(new KeyValuePair<string, object>("@BalanceCapped", generalSettingobj.BalanceCapped));
                parameter.Add(new KeyValuePair<string, object>("@IsActive", generalSettingobj.IsActive));
                parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
                parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
                parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
                parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
                sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveGeneralSettings", parameter);
            }
            catch (Exception e)
            {
                throw e;
            }

        }

        public void SaveLinks(List<CDNInfo> objInfo)
        {
            SQLHandler sagesql = new SQLHandler();
            string sp = "[dbo].[usp_CDNSaveLink]";
            foreach (CDNInfo cdn in objInfo)
            {
                List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
                ParamCollInput.Add(new KeyValuePair<string, object>("@URL", cdn.URL));
                ParamCollInput.Add(new KeyValuePair<string, object>("@IsJS", cdn.IsJS));
                ParamCollInput.Add(new KeyValuePair<string, object>("@URLOrder", cdn.URLOrder));
                ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", cdn.PortalID));
                ParamCollInput.Add(new KeyValuePair<string, object>("@Mode", cdn.Mode));
                try
                {
                    sagesql.ExecuteNonQuery(sp, ParamCollInput);

                }
                catch (Exception)
                {

                    throw;
                }

            }

        }

 public static bool UpdateStoreLocation(AspxCommonInfo aspxCommonObj, string storeName, String storeDescription, string streetName, string localityName, string city, string state, string country, string zip, double latitude, double longitude)
 {
     List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
     parameterCollection.Add(new KeyValuePair<string, object>("@StoreName", storeName));
     parameterCollection.Add(new KeyValuePair<string, object>("@StoreDescription", storeDescription));
     parameterCollection.Add(new KeyValuePair<string, object>("@StreetName", streetName));
     parameterCollection.Add(new KeyValuePair<string, object>("@LocalityName", localityName));
     parameterCollection.Add(new KeyValuePair<string, object>("@City", city));
     parameterCollection.Add(new KeyValuePair<string, object>("@State", state));
     parameterCollection.Add(new KeyValuePair<string, object>("@Country", country));
     parameterCollection.Add(new KeyValuePair<string, object>("@ZIP", zip));
     parameterCollection.Add(new KeyValuePair<string, object>("@Latitude", latitude));
     parameterCollection.Add(new KeyValuePair<string, object>("@Longitude", longitude));
     try
     {
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("usp_Aspx_StoreLocatorLocationUpdate", parameterCollection);
         return true;
     }
     catch (Exception e)
     {
         return false;
         throw e;
     }
 }

        public void SaveTransactionLog(TransactionLogInfo tinfo)
        {
            try
            {
                List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
                parameterCollection.Add(new KeyValuePair<string, object>("@TransactionID", tinfo.TransactionID));
                parameterCollection.Add(new KeyValuePair<string, object>("@PaymentGateWayID", tinfo.PaymentGatewayID));
                parameterCollection.Add(new KeyValuePair<string, object>("@PayerEmail", tinfo.PayerEmail));
                parameterCollection.Add(new KeyValuePair<string, object>("@RecieverEmail", tinfo.RecieverEmail));
                parameterCollection.Add(new KeyValuePair<string, object>("@TotalAmount", tinfo.TotalAmount));
                parameterCollection.Add(new KeyValuePair<string, object>("@CurrencyCode", tinfo.CurrencyCode));
                parameterCollection.Add(new KeyValuePair<string, object>("@PaymentStatus", tinfo.PaymentStatus));
                parameterCollection.Add(new KeyValuePair<string, object>("@OrderID", tinfo.OrderID));
                parameterCollection.Add(new KeyValuePair<string, object>("@CustomerID", tinfo.CustomerID));
                parameterCollection.Add(new KeyValuePair<string, object>("@SessionCode", tinfo.SessionCode));
                parameterCollection.Add(new KeyValuePair<string, object>("@ResponseCode", tinfo.ResponseCode));
                parameterCollection.Add(new KeyValuePair<string, object>("@ResponseReasonText", tinfo.ResponseReasonText));
                parameterCollection.Add(new KeyValuePair<string, object>("@AuthCode", tinfo.AuthCode));
                parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", tinfo.StoreID));
                parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", tinfo.PortalID));               
                parameterCollection.Add(new KeyValuePair<string, object>("@AddedBy", tinfo.AddedBy));

                SQLHandler sqlH = new SQLHandler();
                sqlH.ExecuteNonQuery("usp_Aspx_SaveTransactionLog", parameterCollection);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

 public void AddUpdateUserAddress(AddressInfo addressObj,AspxCommonInfo aspxCommonObj)
 {
     List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
     parameter.Add(new KeyValuePair<string, object>("@AddressID", addressObj.AddressID));
     parameter.Add(new KeyValuePair<string, object>("@CustomerID", aspxCommonObj.CustomerID));
     parameter.Add(new KeyValuePair<string, object>("@FirstName", addressObj.FirstName));
     parameter.Add(new KeyValuePair<string, object>("@LastName", addressObj.LastName));
     parameter.Add(new KeyValuePair<string, object>("@Email", addressObj.Email));
     parameter.Add(new KeyValuePair<string, object>("@Company", addressObj.Company));
     parameter.Add(new KeyValuePair<string, object>("@Address1", addressObj.Address1));
     parameter.Add(new KeyValuePair<string,object>("@Address2",addressObj.Address2));
     parameter.Add(new KeyValuePair<string, object>("@City", addressObj.City));
     parameter.Add(new KeyValuePair<string, object>("@State", addressObj.State));
     parameter.Add(new KeyValuePair<string, object>("@Zip", addressObj.Zip));
     parameter.Add(new KeyValuePair<string, object>("@Phone", addressObj.Phone));
     parameter.Add(new KeyValuePair<string, object>("@Mobile", addressObj.Mobile));
     parameter.Add(new KeyValuePair<string, object>("@Fax", addressObj.Fax));
     parameter.Add(new KeyValuePair<string, object>("@WebSite", addressObj.Website));
     parameter.Add(new KeyValuePair<string, object>("@Country", addressObj.Country));
     parameter.Add(new KeyValuePair<string, object>("@IsDefaultShipping", addressObj.DefaultShipping));
     parameter.Add(new KeyValuePair<string, object>("@IsDefaultBilling", addressObj.DefaultBilling));
     parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
     parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
     parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
     parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
     SQLHandler sqlH = new SQLHandler();
     sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter);
 }

     public void AddUpdateUserAddress(int addressID, int customerID, string firstName, string lastName, string email, string company,
      string address1, string address2, string city, string state, string zip, string phone, string mobile,
 string fax,string webSite,string countryName, bool isDefaultShipping, bool isDefaultBilling, int storeID, int portalID, string userName, string cultureName)
     {
         List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
         parameter.Add(new KeyValuePair<string, object>("@AddressID", addressID));
         parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID));
         parameter.Add(new KeyValuePair<string, object>("@FirstName", firstName));
         parameter.Add(new KeyValuePair<string, object>("@LastName", lastName));
         parameter.Add(new KeyValuePair<string, object>("@Email", email));
         parameter.Add(new KeyValuePair<string, object>("@Company", company));
         parameter.Add(new KeyValuePair<string, object>("@Address1", address1));
         parameter.Add(new KeyValuePair<string,object>("@Address2",address2));
         parameter.Add(new KeyValuePair<string, object>("@City", city));
         parameter.Add(new KeyValuePair<string, object>("@State", state));
         parameter.Add(new KeyValuePair<string, object>("@Zip", zip));
         parameter.Add(new KeyValuePair<string, object>("@Phone", phone));
         parameter.Add(new KeyValuePair<string, object>("@Mobile", mobile));
         parameter.Add(new KeyValuePair<string, object>("@Fax", fax));
         parameter.Add(new KeyValuePair<string, object>("@WebSite", webSite));
         parameter.Add(new KeyValuePair<string, object>("@Country", countryName));
         parameter.Add(new KeyValuePair<string, object>("@IsDefaultShipping", isDefaultShipping));
         parameter.Add(new KeyValuePair<string, object>("@IsDefaultBilling", isDefaultBilling));
         parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
         parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
         parameter.Add(new KeyValuePair<string, object>("@UserName", userName));
         parameter.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("usp_Aspx_AddUpdateUserAddress", parameter);
     }

 public static int AddNewSchedule(Schedule objSchedule)
 {
     int id = 0;
     List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@ScheduleName", objSchedule.ScheduleName));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@FullNameSpace", objSchedule.FullNamespace));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@StartDate", objSchedule.StartDate));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@EndDate", objSchedule.EndDate));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@StartHour", objSchedule.StartHour));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@StartMin", objSchedule.StartMin));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@RepeatWeeks", objSchedule.RepeatWeeks));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@RepeatDays", objSchedule.RepeatDays));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@WeekOfMonth", objSchedule.WeekOfMonth));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@EveryHour", objSchedule.EveryHours));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@EveryMin", objSchedule.EveryMin));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@ObjectDependencies", objSchedule.ObjectDependencies));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@RetryTimeLapse", objSchedule.RetryTimeLapse));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@RetryFrequencyUnit", objSchedule.RetryFrequencyUnit));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@AttachToEvent", objSchedule.AttachToEvent));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@CatchUpEnabled", objSchedule.CatchUpEnabled));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@Servers", objSchedule.Servers));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsEnable", objSchedule.IsEnable));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@RunningMode", (int)objSchedule.RunningMode));
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@AssemblyFileName", objSchedule.AssemblyFileName));
     try
     {
         SQLHandler sagesql = new SQLHandler();
         id = sagesql.ExecuteNonQuery("usp_SchedulerAddJob", ParaMeterCollection, "@ScheduleID");
     }
     catch (Exception)
     {
         throw;
     }
     return id;
 }

        public int InsertLog(int logTypeID, int severity, string message, string exception, string clientIPAddress, string pageURL, bool isActive, int portalID, string addedBy)
        {
            string sp = "[dbo].[sp_LogInsert]";
            SQLHandler sagesql = new SQLHandler();
            try
            {
                List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();

                ParamCollInput.Add(new KeyValuePair<string, object>("@LogTypeID", logTypeID));
                ParamCollInput.Add(new KeyValuePair<string, object>("@Severity", severity));
                ParamCollInput.Add(new KeyValuePair<string, object>("@Message", message));

                ParamCollInput.Add(new KeyValuePair<string, object>("@Exception", exception));
                ParamCollInput.Add(new KeyValuePair<string, object>("@ClientIPAddress", clientIPAddress));
                ParamCollInput.Add(new KeyValuePair<string, object>("@PageURL", pageURL));
                ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", isActive));
                ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", portalID));
                ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", addedBy));

                return sagesql.ExecuteNonQuery(sp, ParamCollInput, "@LogID");


            }
            catch (Exception)
            {

                throw;
            }

        }

        public void AddUpdateSageFrameSearchSetting(SageFrameSearchSettingInfo objSearchSettingInfo, int PortalID, string CultureName, string AddedBy)
        {            
            
            try
            {
                string SettingKeys = string.Empty;
                string SettingValues = string.Empty;
                //Pre pare Key value for the save;
                SettingKeys = "SearchButtonType#SearchButtonText#SearchButtonImage#SearchResultPerPage#SearchResultPageName#MaxSearchChracterAllowedWithSpace";
                SettingValues = objSearchSettingInfo.SearchButtonType.ToString() + "#" + objSearchSettingInfo.SearchButtonText + "#" +
                    objSearchSettingInfo.SearchButtonImage + "#" + objSearchSettingInfo.SearchResultPerPage.ToString() + 
                    "#" + objSearchSettingInfo.SearchResultPageName +
                    "#" + objSearchSettingInfo.MaxSearchChracterAllowedWithSpace.ToString();

                List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();

                ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingKeys", SettingKeys));
                ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingValues", SettingValues));

                ParaMeterCollection.Add(new KeyValuePair<string, string>("@CultureName", CultureName));
                ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString()));
                ParaMeterCollection.Add(new KeyValuePair<string, string>("@AddedBy", AddedBy));
                SQLHandler sagesql = new SQLHandler();
                sagesql.ExecuteNonQuery("dbo.sp_SageFrameSearchSettingValueAddUpdate", ParaMeterCollection);
            }
            catch (Exception e)
            {
                throw e;
            }
        }

        public static void NotificationSaveUpdateSettings(NotificationSettingsInfo saveUpdateInfo, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
                parameterCollection.Add(new KeyValuePair<string, object>("@AllActive", saveUpdateInfo.AllActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@UserNotificationActive", saveUpdateInfo.UserNotificationActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@UserNotificationCount", saveUpdateInfo.UserNotificationCount));
                parameterCollection.Add(new KeyValuePair<string, object>("@SubscriptionNotificationActive ", saveUpdateInfo.SubscriptionNotificationActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@SubscriptionNotificationCount", saveUpdateInfo.SubscriptionNotificationCount));
                parameterCollection.Add(new KeyValuePair<string, object>("@OutofStockNotificationActive", saveUpdateInfo.OutofStockNotificationActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@OutofStockNotificationCount", saveUpdateInfo.OutofStockNotificationCount));
                parameterCollection.Add(new KeyValuePair<string, object>("@ItemsLowStockNotificationActive", saveUpdateInfo.ItemsLowStockNotificationActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@ItemsLowStockCount", saveUpdateInfo.ItemsLowStockCount));
                parameterCollection.Add(new KeyValuePair<string, object>("@OrdersNotificationAtive", saveUpdateInfo.OrdersNotificationAtive));
                parameterCollection.Add(new KeyValuePair<string, object>("@OrdersNotificationCount", saveUpdateInfo.OrdersNotificationCount));
                SQLHandler sqlH = new SQLHandler();
                sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_NotificationSaveUpdateSettings]", parameterCollection);

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

        public static void AddFile(ATTFile file)
        {
            List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalId", file.PortalId));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@UniqueId", file.UniqueId));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@VersionGuid", file.VersionGuid));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@FileName", file.FileName));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@Extension", file.Extension));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@Size", file.Size));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@ContentType", file.ContentType));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@Folder", file.Folder));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@FolderId", file.FolderId));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", file.IsActive));
            ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", file.AddedBy));
            if (file.StorageLocation == 2)
            {
                ParaMeterCollection.Add(new KeyValuePair<string, object>("@Content", file.Content));
                SQLHandler sagesql = new SQLHandler();
                sagesql.ExecuteNonQuery("usp_FileManagerAddDatabaseFile", ParaMeterCollection);
            }
            else
            {
                SQLHandler sagesql = new SQLHandler();
                sagesql.ExecuteNonQuery("usp_FileManagerAddFile", ParaMeterCollection);

            }
        }

 public static void DeleteSearchTerm(string Ids, AspxCommonInfo aspxCommonObj)
 {
     List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
     parameter.Add(new KeyValuePair<string, object>("@SearchTermID", Ids));
     SQLHandler sqlH = new SQLHandler();
     sqlH.ExecuteNonQuery("usp_Aspx_DeleteSearchTerm", parameter);
 }