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;
}
