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; }
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 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 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 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 static ContactDeleteds SelectAllByToday(string ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. IDataReader dr = oDatabaseHelper.ExecuteReader("sp_ContactDeleted_SelectAll_ByToday", ref ExecutionState); ContactDeleteds ContactDeleteds = PopulateObjectsFromReader(dr, ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return ContactDeleteds; }
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]; }
//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; }
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; }
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 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 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 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 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; } }
//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 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; } }
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; } }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of EmailOpenDetails</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 1/8/2010 12:24:52 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static EmailOpenDetails PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper, string ConnectionString) { EmailOpenDetails list = new EmailOpenDetails(); if (rdr.Read()) { EmailOpenDetail obj = new EmailOpenDetail(ConnectionString); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new EmailOpenDetail(ConnectionString); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return list; } else { oDatabaseHelper.Dispose(); return null; } }
/// <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; }
/// <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 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; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="EmailOpenDetailPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class EmailOpenDetail</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 1/8/2010 12:24:52 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static EmailOpenDetail SelectOne(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); IDataReader dr=oDatabaseHelper.ExecuteReader("sp_EmailOpenDetails_SelectbyPrimaryKey", ref ExecutionState); if (dr.Read()) { EmailOpenDetail obj=new EmailOpenDetail(ConnectionString); PopulateObjectFromReader(obj,dr); dr.Close(); oDatabaseHelper.Dispose(); return obj; } else { dr.Close(); oDatabaseHelper.Dispose(); return null; } }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// </summary> /// /// <param name="field" type="string">Field of the class EmailOpenDetail</param> /// <param name="fieldValue" type="object">Value for the field specified.</param> /// /// <returns>List of object of class EmailOpenDetail in the form of an object of class EmailOpenDetails</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 1/8/2010 12:24:52 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static EmailOpenDetails SelectByField(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); IDataReader dr=oDatabaseHelper.ExecuteReader("sp_EmailOpenDetails_SelectByField", ref ExecutionState); EmailOpenDetails EmailOpenDetails = PopulateObjectsFromReader(dr,ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return EmailOpenDetails; }
public static DataTable SelectAllContactIdsByForeignKeyFromCampaignMaster(int CampId, String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; oDatabaseHelper.AddParameter("@CampaignId", CampId); oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); DataSet ds = oDatabaseHelper.ExecuteDataSet("sp_RPT_EmailOpenDetails_SelectDistinctContactIDByForeignKeyCampaignMaster", ref ExecutionState); oDatabaseHelper.Dispose(); return ds.Tables[0]; }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="ContactMasterPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class EmailOpenDetails</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 1/8/2010 12:24:52 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static EmailOpenDetails SelectAllByForeignKeyFromContactMaster(ContactMasterPrimaryKey pk, String ConnectionString) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString); bool ExecutionState = false; EmailOpenDetails obj = null; // Pass the values of all key parameters to the stored procedure. System.Collections.Specialized.NameValueCollection nvc = pk.GetKeysAndValues(); foreach (string key in nvc.Keys) { oDatabaseHelper.AddParameter("@" + key,nvc[key] ); } // The parameter '@ErrorCode' will contain the status after execution of the stored procedure. oDatabaseHelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader dr=oDatabaseHelper.ExecuteReader("sp_EmailOpenDetails_SelectAllByForeignKeyContactMaster", ref ExecutionState); obj = new EmailOpenDetails(); obj = EmailOpenDetail.PopulateObjectsFromReaderWithCheckingReader(dr, oDatabaseHelper,ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return obj; }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class EmailOpenDetail in the form of object of EmailOpenDetails </returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 1/8/2010 12:24:52 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// public static EmailOpenDetails SelectAll(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_EmailOpenDetails_SelectAll", ref ExecutionState); EmailOpenDetails EmailOpenDetails = PopulateObjectsFromReader(dr,ConnectionString); dr.Close(); oDatabaseHelper.Dispose(); return EmailOpenDetails; }
/// <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; }
/// <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; }