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 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 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;
}
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;
}
//Vikas Kumar Bhatnagar on 04thJuly2011
public static CampaignJobs SelectAllDomianLast90Days(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("TotalDeliverCountByDomainLast90Days", ref ExecutionState);
CampaignJobs CampaignJobs = PopulateObjectsFromReaderNew(dr, ConnectionString);
dr.Close();
oDatabaseHelper.Dispose();
return CampaignJobs;
}
/// <summary>
/// </summary>
/// <param name="days"></param>
/// <param name="ConnectionString"></param>
/// <returns></returns>
//Vikas Kumar Bhatnagar on 04thJuly2011
public static CampaignJobs SelectAllDomianByWeek(String ConnectionString, ref DateTime from, ref DateTime to)
{
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("TotalDeliverCountByDomainLast7Days", ref ExecutionState);
CampaignJobs ContactMasters = PopulateObjectsFromReaderNew(dr, ConnectionString);
dr.Close();
oDatabaseHelper.Dispose();
return ContactMasters;
}
//swaraj on 23rd apr 2010
//this method is used to search the contacts depends on search criteria
public static DataTable SearchContacts(string WhereCondn, string connectionstring, int ListId)
{
bool ExcutionState = false;
DatabaseHelper obDatahelper = new DatabaseHelper(connectionstring);
obDatahelper.AddParameter("@whereCondition", WhereCondn);
obDatahelper.AddParameter("@ListId", ListId);
obDatahelper.AddParameter("@ErrorCode", -1, System.Data.ParameterDirection.Output);
SqlDataReader drContactMaster = (SqlDataReader)obDatahelper.ExecuteReader("sp_ListContactMaster_SelectBySearchCondition_Proc", ref ExcutionState);
DataTable dt = new DataTable();
// Add the table columns.
for (int i = 0; i < drContactMaster.FieldCount; i++)
dt.Columns.Add(drContactMaster.GetName(i), drContactMaster.GetFieldType(i));
while (drContactMaster.Read())
{
DataRow r = dt.NewRow();
// Assign DataReader values to DataRow.
for (int i = 0; i < drContactMaster.FieldCount; i++)
r[i] = drContactMaster[i];
dt.Rows.Add(r);
}
drContactMaster.Close();
return dt;
}
/// <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;
}
/// <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;
}
/// <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="AdvancedImportJobPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class AdvancedFieldMaps</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 7/4/2012 2:40:13 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static AdvancedFieldMaps SelectAllByForeignKeyFromAdvancedImportJob(AdvancedImportJobPrimaryKey pk)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
bool ExecutionState = false;
AdvancedFieldMaps 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_AdvancedFieldMap_SelectAllByForeignKeyAdvancedImportJob", ref ExecutionState);
obj = new AdvancedFieldMaps();
obj = AdvancedFieldMap.PopulateObjectsFromReaderWithCheckingReader(dr, oDatabaseHelper);
dr.Close();
oDatabaseHelper.Dispose();
return obj;
}
/// <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;
}
/// <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 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;
}
/// <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 12/17/2012 12:22:55 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public bool InsertWithDefaultValues(bool getBackValues)
{
bool ExecutionState = false;
oDatabaseHelper = new DatabaseHelper();
// Pass the value of '_mailingID' as parameter 'MailingID' of the stored procedure.
oDatabaseHelper.AddParameter("@MailingID", _mailingIDNonDefault);
// Pass the value of '_approvalMail' as parameter 'ApprovalMail' of the stored procedure.
oDatabaseHelper.AddParameter("@ApprovalMail", _approvalMailNonDefault);
// Pass the value of '_reportMailTo' as parameter 'ReportMailTo' of the stored procedure.
oDatabaseHelper.AddParameter("@ReportMailTo", _reportMailToNonDefault);
// Pass the value of '_approvalStatus' as parameter 'ApprovalStatus' of the stored procedure.
oDatabaseHelper.AddParameter("@ApprovalStatus", _approvalStatusNonDefault);
// Pass the value of '_approvedDate' as parameter 'ApprovedDate' of the stored procedure.
oDatabaseHelper.AddParameter("@ApprovedDate", _approvedDateNonDefault);
// Pass the value of '_isApprovalSent' as parameter 'IsApprovalSent' of the stored procedure.
oDatabaseHelper.AddParameter("@IsApprovalSent", _isApprovalSentNonDefault);
// Pass the value of '_isReportMailied' as parameter 'IsReportMailied' of the stored procedure.
oDatabaseHelper.AddParameter("@IsReportMailied", _isReportMailiedNonDefault);
// Pass the value of '_reportSentDate' as parameter 'ReportSentDate' of the stored procedure.
oDatabaseHelper.AddParameter("@ReportSentDate", _reportSentDateNonDefault);
// 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_MailApproval_Insert_WithDefaultValues", ref ExecutionState);
}
else
{
IDataReader dr=oDatabaseHelper.ExecuteReader("sp_MailApproval_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
if (dr.Read())
{
PopulateObjectFromReader(this,dr);
}
dr.Close();
}
oDatabaseHelper.Dispose();
return ExecutionState;
}
//This method is used to retrieve the ListContactMaster details based on listID and ContactID
public static ListContactMasters SelectAllByListIDAndContactID(Int64 listMasterID, Int64 contactID, string ConnectionString)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);
bool ExecutionState = false;
// Pass the specified field and its value to the stored procedure.
oDatabaseHelper.AddParameter("@ListMasterID", listMasterID);
oDatabaseHelper.AddParameter("@ContactId", contactID);
// 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_ListContactMaster_SelectAllByListIDAndContactID", ref ExecutionState);
ListContactMasters ListContactMasters = PopulateObjectsFromReader(dr, ConnectionString);
dr.Close();
oDatabaseHelper.Dispose();
return ListContactMasters;
}
public static CampaignJobs SelectSingleByToday(int CampaignId, 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("@CampaignId", CampaignId);
IDataReader dr = oDatabaseHelper.ExecuteReader("sp_CampaignJob_SelectAll_ByToday_Single", ref ExecutionState);
CampaignJobs CampaignJobs = PopulateObjectsFromReader(dr, ConnectionString);
dr.Close();
oDatabaseHelper.Dispose();
return CampaignJobs;
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class AdvancedFieldMap in the form of object of AdvancedFieldMaps </returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 7/4/2012 2:40:13 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static AdvancedFieldMaps SelectAll()
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper();
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_AdvancedFieldMap_SelectAll", ref ExecutionState);
AdvancedFieldMaps AdvancedFieldMaps = PopulateObjectsFromReader(dr);
dr.Close();
oDatabaseHelper.Dispose();
return AdvancedFieldMaps;
}
/// <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;
}
/// <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;
}
/// <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 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 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 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 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/29/2012 12:32:23 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 '_linkID' as parameter 'LinkID' of the stored procedure.
oDatabaseHelper.AddParameter("@LinkID", _linkIDNonDefault);
// Pass the value of '_mailingID' as parameter 'MailingID' of the stored procedure.
oDatabaseHelper.AddParameter("@MailingID", _mailingIDNonDefault);
// Pass the value of '_contactID' as parameter 'ContactID' of the stored procedure.
oDatabaseHelper.AddParameter("@ContactID", _contactIDNonDefault);
// Pass the value of '_ditectMail' as parameter 'DirectMail' of the stored procedure.
oDatabaseHelper.AddParameter("@DirectMail", _ditectMailNonDefault);
// Pass the value of '_submitDate' as parameter 'SubmitDate' of the stored procedure.
oDatabaseHelper.AddParameter("@SubmitDate", _submitDateNonDefault);
// 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_FormSubmitClicks_Insert_WithDefaultValues", ref ExecutionState);
}
else
{
IDataReader dr=oDatabaseHelper.ExecuteReader("sp_FormSubmitClicks_Insert_WithDefaultValues_AndReturn", ref ExecutionState);
if (dr.Read())
{
PopulateObjectFromReader(this,dr);
}
dr.Close();
}
oDatabaseHelper.Dispose();
return ExecutionState;
}
/// <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;
}
/// <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="TemplateMasterPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class TemplateMaster</returns>
///
/// <remarks>
///
/// <RevisionHistory>
/// Author Date Description
/// DLGenerator 11/24/2009 12:37:33 PM Created function
///
/// </RevisionHistory>
///
/// </remarks>
///
public static TemplateMaster SelectOneWithCampaignMasterUsingTemplateId(TemplateMasterPrimaryKey pk, string ConnectionString)
{
DatabaseHelper oDatabaseHelper = new DatabaseHelper(ConnectionString);
bool ExecutionState = false;
TemplateMaster 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_TemplateMaster_SelectOneWithCampaignMasterUsingTemplateId", ref ExecutionState);
if (dr.Read())
{
obj= new TemplateMaster(ConnectionString);
PopulateObjectFromReader(obj,dr);
dr.NextResult();
//Get the child records.
obj.CampaignMasters=CampaignMaster.PopulateObjectsFromReader(dr,ConnectionString);
}
dr.Close();
oDatabaseHelper.Dispose();
return obj;
}
/// <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 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;
}
