public static DataTable GetTop5AutomationJobs(int Status, String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@Status", Status); // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); SqlDataReader drCampaigns = (SqlDataReader)oDatabaseHelper.ExecuteReader("sp_AutomationJob_GetTop5CampaignJobs", ref ExecutionState); //CampaignJobs CampaignJobs = PopulateObjectsFromReader(dr, ConnectionString); //dr.Close(); DataTable dt = new DataTable(); // Add the table columns. for (int i = 0; i < drCampaigns.FieldCount; i++) dt.Columns.Add(drCampaigns.GetName(i), drCampaigns.GetFieldType(i)); while (drCampaigns.Read()) { DataRow r = dt.NewRow(); // Assign DataReader values to DataRow. for (int i = 0; i < drCampaigns.FieldCount; i++) r[i] = drCampaigns[i]; dt.Rows.Add(r); } drCampaigns.Close(); oDatabaseHelper.Dispose(); return dt; }
public static DataTable SearchDomainLookup(string ConnectionString, string Domain, string ListIds) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; //StringBuilder whereCondition = new StringBuilder(); //Domain = Domain.Replace("'", "''"); //Domain = Domain.Replace("%", "[%]"); //Domain = Domain.Replace("_", "[_]"); //if (!string.IsNullOrEmpty(Domain)) //{ // if (whereCondition.Length > 0) // whereCondition.Append(" OR %" + Domain + "%"); // else whereCondition.Append(" %" + Domain + "%"); //} //if (whereCondition.Length == 0) //{ // whereCondition.Append("1=1"); //} string whereCondition = "%" + Domain + "%"; oDatabaseHelper.AddParameter("@ListIDs", ListIds.ToString()); oDatabaseHelper.AddParameter("@whereCondition", whereCondition.ToString()); DataSet dataSet = oDatabaseHelper.ExecuteDataSet("sp_ListMaster_SearchDomainName", ref ExecutionState); return dataSet.Tables[0]; } } catch (Exception ex) { throw ex; } }
public static DataTable getSegmentDetails(long segmentId, string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@SegmentID", segmentId); oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_SegmentMaster_GetSegmentDetails", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
public static DataTable SelectAllTemplateNames(string ConnectionString, int CategoryID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@CategoryID", CategoryID); // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_CategoryTemplateMaster_SelectAllTemplateNames", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
public static DataTable GetUnSubDetailsByContactId(string ConnectionString, string ContactID, string EmailID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ContactID", ContactID); if (EmailID != string.Empty) oDatabaseHelper.AddParameter("@EmailId", EmailID); else oDatabaseHelper.AddParameter("@EmailId", DBNull.Value); oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_GetGlobalUnSubscribeDetails_ByContactId", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
public static ContactDeleteds SelectAllByMonths(DateTime FromDate, DateTime ToDate, String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@FromDate", FromDate); oDatabaseHelper.AddParameter("@ToDate", ToDate); IDataReader dr = oDatabaseHelper.ExecuteReader("sp_ContactDeleted_SelectAll_ByMonths", ref ExecutionState); ContactDeleteds ContactMasters = PopulateObjectsFromReader(dr, ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return ContactMasters; }
public static ImportJobs SelectAllBasedOnListID(string listID,string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; // Pass the specified field and its value to the stored procedure. oDatabaseHelper.AddParameter("@ListID", listID); // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("sp_ImportJob_SelectAllBasedOnListID", ref ExecutionState); ImportJobs ImportJobs = PopulateObjectsFromReader(dr,ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return ImportJobs; }
public static DataTable BindAllContactsTargetedByAssignCamp_Unsub_Search(string where, string ConnectionString, string CampignID, string orderby, string dir, int pageIndex, int pageSize, out int Count) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@whereCondition", where); oDatabaseHelper.AddParameter("@AssignedCampaignID", CampignID); oDatabaseHelper.AddParameter("@orderby", orderby); oDatabaseHelper.AddParameter("@dir", dir); oDatabaseHelper.AddParameter("@PageIndex", pageIndex); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@Count", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_ListContactMaster_ShowContactsTargetedWithAssignCampaignID_Pagewise_Search", ref ExecutionState); Count = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@Count"].Value); oDatabaseHelper.Dispose(); return ds.Tables[0]; } } catch (Exception ex) { throw ex; } }
public static DataTable GetContactStatusByEmailIdsWithActiveStatus(string ConnectionString, DataTable tblEmailAddress) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@TableEmailIds", tblEmailAddress); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_SelectContactStatusByEmailId_Active", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
public static DataTable GetAllBounceAndUnsubDetailsByType(string ConnectionString, string Type) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@Type", Type); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_GetAllBounceAndUnsubRecipientsByType", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
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 static DataTable GetAllRecipientsByListMasterIds(StringBuilder strbSelectedLists, string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@listids", strbSelectedLists.ToString()); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_GetAllRecipientsByListMasterIds", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
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 DataTable getAllMailingLinkUrls(String ConnectionString, string MailingName, string orderby, string dir) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@MailingName", MailingName); oDatabaseHelper.AddParameter("@orderby", orderby); oDatabaseHelper.AddParameter("@dir", dir); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_ContactMaster_GetLinkURLsByCampName_AMMRpt", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; } } catch (Exception ex) { throw ex; } }
public static DataTable AdvanceSearchSelectLookup(string ConnectionString, string ListName) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; StringBuilder whereCondition = new StringBuilder(); ListName = ListName.Replace("'", "''"); ListName = ListName.Replace("%", "[%]"); ListName = ListName.Replace("_", "[_]"); if (!string.IsNullOrEmpty(ListName)) { if (whereCondition.Length > 0) whereCondition.Append(" OR ListName LIKE '%" + ListName + "%'"); else whereCondition.Append(" ListName LIKE '%" + ListName + "%'"); } if (whereCondition.Length == 0) { whereCondition.Append("1=1"); } oDatabaseHelper.AddParameter("@whereCondition", whereCondition.ToString()); oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); DataSet dataSet = oDatabaseHelper.ExecuteDataSet("sp_AdvanceListMaster_SearchSelectNew", ref ExecutionState); return dataSet.Tables[0]; } } catch (Exception ex) { throw ex; } }
public int SelectEmailCount(string ClientName, string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@ClientName", ClientName); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_Material_GetTierSizeByClient", ref ExecutionState); //we get only single column and row value in this so return single value return Convert.ToInt32(ds.Tables[0].Rows[0][0]); }
public DataTable getCustomLabel(Int64 TemplateID, Int64 CampaignID) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@CampaignID", CampaignID.ToString()); oDatabaseHelper.AddParameter("@TemplateID", TemplateID.ToString()); DataSet dataSet = oDatabaseHelper.ExecuteDataSet("sp_GetCustomLabel", ref ExecutionState); return dataSet.Tables[0]; } } catch (Exception ex) { throw ex; } }
//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; }
public DataTable getAllCountsOfCampaignsWithFilePagewise(String ConnectionString, string orderby, string dir, int pageIndex, int pageSize, out int count) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@orderby", orderby); oDatabaseHelper.AddParameter("@dir", dir); oDatabaseHelper.AddParameter("@PageIndex", pageIndex); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@TotalRowsCount", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_getAllCountsOfCampaignsWithFile_Pagewise", ref ExecutionState); count = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@TotalRowsCount"].Value); oDatabaseHelper.Dispose(); return ds.Tables[0]; } } catch (Exception ex) { throw ex; } }
public static AutomationJobs SelectAllByDays(int days, String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@DAYS", days); IDataReader dr = oDatabaseHelper.ExecuteReader("sp_AutomationJob_SelectAll_ByDays", ref ExecutionState); AutomationJobs ContactMasters = PopulateObjectsFromReader(dr, ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return ContactMasters; }
//This method will Select all te campaigns from the table CampaignMaster which are not included in CampaignJob public static CampaignMasters selectAllForLaunchCampaigns(String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr = oDatabaseHelper.ExecuteReader("sp_CampaignJob_selectAllForLaunchCampaigns", ref ExecutionState); CampaignMasters CampaignMasters = PopulateObjectsFromReader(dr,ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return CampaignMasters; }
//Ganesh on 30nov09 //This method will insert a new job in CampaignMaster table. public int insertAutomationMaster(AutomationMaster objAutomationMaster) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@CampaignName", objAutomationMaster.CampaignName); oDatabaseHelper.AddParameter("@CampaignDescription", objAutomationMaster.CampaignDescription); oDatabaseHelper.AddParameter("@FromAddress", objAutomationMaster.FromAddress); oDatabaseHelper.AddParameter("@FromName", objAutomationMaster.FromName); oDatabaseHelper.AddParameter("@ReplytoAddress", objAutomationMaster.ReplytoAddress); oDatabaseHelper.AddParameter("@ReplaytoName", objAutomationMaster.ReplaytoName); oDatabaseHelper.AddParameter("@TemplateId", objAutomationMaster.TemplateId); oDatabaseHelper.AddParameter("@Subject", objAutomationMaster.Subject); oDatabaseHelper.AddParameter("@TrackReads", objAutomationMaster.TrackReads); oDatabaseHelper.AddParameter("@SelectCondition", objAutomationMaster.SelectCondition); oDatabaseHelper.AddParameter("@HTMLContent", objAutomationMaster.HTMLContent); oDatabaseHelper.AddParameter("@TextContent", objAutomationMaster.TextContent); oDatabaseHelper.AddParameter("@AutomationScheduledDate", objAutomationMaster.AutomationScheduledDate); oDatabaseHelper.AddParameter("@DayOfWeek", objAutomationMaster.DayOfWeek); oDatabaseHelper.AddParameter("@ExpAutomationScheduledDate", objAutomationMaster.ExpAutomationScheduledDate); oDatabaseHelper.AddParameter("@SuppressDomain", objAutomationMaster.SuppressDomain); oDatabaseHelper.AddParameter("@URLText", objAutomationMaster.URLText); oDatabaseHelper.AddParameter("@CampaignID", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.ExecuteScalar("sp_AutomationMaster_Insert_CustomProc", ref ExecutionState); int CampaignID = (int)oDatabaseHelper.GetParameterValue("@CampaignID"); oDatabaseHelper.Dispose(); return CampaignID; } } catch (Exception ex) { throw ex; } }
public static DataTable getAllSentCampaignsOlderThan90Days(String ConnectionString, string orderby, string dir,int pageIndex, int pageSize, out int count) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; //oDatabaseHelper.AddParameter("@status", status); oDatabaseHelper.AddParameter("@orderby", orderby); oDatabaseHelper.AddParameter("@dir", dir); oDatabaseHelper.AddParameter("@PageIndex", pageIndex); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@Count", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_CampaignJob_SelectAll_OlderThan90Days", ref ExecutionState); count = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@Count"].Value); oDatabaseHelper.Dispose(); return ds.Tables[0]; } } catch (Exception ex) { throw ex; } }
public static DataTable SelectAllCategoryNames(string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); //IDataReader dr = oDatabaseHelper.ExecuteReader("sp_CategoryTemplateMaster_SelectAllCategoryNames", ref ExecutionState); //CategoryTemplateMasters CategoryTemplateMasters = PopulateObjectsFromReader(dr, ConnectionString); //dr.Close(); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_CategoryTemplateMaster_SelectAllCategoryNames", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
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 DataSet GetTemplatesInDraftByTemplateIds(string TemplateIds, string ConnectionString) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@TemplateIDs", TemplateIds); DataSet dataSet = oDatabaseHelper.ExecuteDataSet("sp_TemplateMaster_ShowTemplatesUsedInDraftMails_CustomProc", ref ExecutionState); return dataSet; } } catch (Exception ex) { throw ex; } }
public static DataTable GetAllAdvancedImportContactsPageWise(string ConnectionString, string OrderBy, string sortdir, int pageSize, int pageIndex, out int rowCount) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@orderby", OrderBy); oDatabaseHelper.AddParameter("@dir", sortdir); oDatabaseHelper.AddParameter("@PageIndex", pageIndex); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@Count", -1, System.Data.ParameterDirection.Output); oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_RecipienMaster_GetAllContacts_PageWise", ref ExecutionState); rowCount = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@Count"].Value); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
public static DataTable getAllSentCampaignsOlderThan90Days_Search(string ConnectionString, string CampaignName,string orderby, string dir,int pageIndex, int pageSize, out int count) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; StringBuilder whereCondition = new StringBuilder(); CampaignName = CampaignName.Replace("'", "''"); CampaignName = CampaignName.Replace("%", "[%]"); CampaignName = CampaignName.Replace("_", "[_]"); if (!string.IsNullOrEmpty(CampaignName)) { if (whereCondition.Length > 0) whereCondition.Append(" OR CampaignName LIKE '%" + CampaignName + "%'"); else whereCondition.Append("CampaignName LIKE '%" + CampaignName + "%'"); } if (whereCondition.Length == 0) { whereCondition.Append("1=1"); } oDatabaseHelper.AddParameter("@orderby", orderby); oDatabaseHelper.AddParameter("@dir", dir); oDatabaseHelper.AddParameter("@PageIndex", pageIndex); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@whereCondition", whereCondition.ToString()); oDatabaseHelper.AddParameter("@Count", -1, System.Data.ParameterDirection.Output); DataSet dataSet = oDatabaseHelper.ExecuteDataSet("sp_CampaignJob_OlderThan90Days_Search_Pagewise", ref ExecutionState); count = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@Count"].Value); return dataSet.Tables[0]; } } catch (Exception ex) { throw ex; } }
public static DataSet GetSegmentResult(string ConString, string CampaignIds, string whereCondition, string orderBy, string dir, string keyValue, string segType) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@CampaignIds", CampaignIds); oDatabaseHelper.AddParameter("@whereCondition", whereCondition); oDatabaseHelper.AddParameter("@orderby", orderBy); oDatabaseHelper.AddParameter("@dir", dir); oDatabaseHelper.AddParameter("@keyValue", keyValue); oDatabaseHelper.AddParameter("@segType", segType); DataSet dataSet = oDatabaseHelper.ExecuteDataSet("sp_ListContactMaster_ShowRecipientsOfCampaign_CustomProc", ref ExecutionState); return dataSet; } } catch (Exception ex) { throw ex; } }
public static DataTable BindAllContactsTargeted(string ConnectionString, string ListIds, string orderby, string dir, int pageIndex, int pageSize, out int Count) { try { using (DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString)) { bool ExecutionState = false; oDatabaseHelper.AddParameter("@ListID", ListIds); oDatabaseHelper.AddParameter("@orderby", orderby); oDatabaseHelper.AddParameter("@dir", dir); oDatabaseHelper.AddParameter("@PageIndex", pageIndex); oDatabaseHelper.AddParameter("@PageSize", pageSize); oDatabaseHelper.AddParameter("@Count", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_ListContactMaster_ShowListRecipientsWithCampaignID_Pagewise", ref ExecutionState); Count = Convert.ToInt32(oDatabaseHelper.Command.Parameters["@Count"].Value); oDatabaseHelper.Dispose(); return ds.Tables[0]; } } catch (Exception ex) { throw ex; } }