private DBNewsLetterSubscription GetNewsLetterSubscriptionFromReader(IDataReader dataReader)
{
var item = new DBNewsLetterSubscription();
item.NewsLetterSubscriptionId = NopSqlDataHelper.GetInt(dataReader, "NewsLetterSubscriptionID");
item.NewsLetterSubscriptionGuid = NopSqlDataHelper.GetGuid(dataReader, "NewsLetterSubscriptionGuid");
item.Email = NopSqlDataHelper.GetString(dataReader, "Email");
item.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "Active");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}
/// <summary>
/// Gets the newsletter subscription by email
/// </summary>
/// <param name="email">The Email</param>
/// <returns>NewsLetterSubscription entity</returns>
public override DBNewsLetterSubscription GetNewsLetterSubscriptionByEmail(string email)
{
DBNewsLetterSubscription item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsLetterSubscriptionLoadByEmail");
db.AddInParameter(dbCommand, "Email", DbType.String, email);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetNewsLetterSubscriptionFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets the newsletter subscription by newsletter subscription identifier
/// </summary>
/// <param name="newsLetterSubscriptionId">The newsletter subscription identifier</param>
/// <returns>NewsLetterSubscription entity</returns>
public override DBNewsLetterSubscription GetNewsLetterSubscriptionById(int newsLetterSubscriptionId)
{
DBNewsLetterSubscription item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsLetterSubscriptionLoadByPrimaryKey");
db.AddInParameter(dbCommand, "NewsLetterSubscriptionID", DbType.Int32, newsLetterSubscriptionId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetNewsLetterSubscriptionFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Updates the newsletter subscription
/// </summary>
/// <param name="newsLetterSubscriptionId">The newsletter subscription identifier</param>
/// <param name="newsLetterSubscriptionGuid">The newsletter subscription GUID</param>
/// <param name="email">The subscriber email</param>
/// <param name="isActive">A value indicating whether subscription is active</param>
/// <param name="createdOn">The date and time of instance creation</param>
/// <returns>NewsLetterSubscription entity</returns>
public override DBNewsLetterSubscription UpdateNewsLetterSubscription(int newsLetterSubscriptionId,
Guid newsLetterSubscriptionGuid, string email, bool isActive, DateTime createdOn)
{
DBNewsLetterSubscription item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsLetterSubscriptionUpdate");
db.AddInParameter(dbCommand, "NewsLetterSubscriptionID", DbType.Int32, newsLetterSubscriptionId);
db.AddInParameter(dbCommand, "NewsLetterSubscriptionGuid", DbType.Guid, newsLetterSubscriptionGuid);
db.AddInParameter(dbCommand, "Email", DbType.String, email);
db.AddInParameter(dbCommand, "Active", DbType.Boolean, isActive);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetNewsLetterSubscriptionById(newsLetterSubscriptionId);
}
return(item);
}
