/// <summary>
/// Updates the payment method
/// </summary>
/// <param name="paymentMethodId">The payment method identifer</param>
/// <param name="name">The name</param>
/// <param name="visibleName">The visible name</param>
/// <param name="description">The description</param>
/// <param name="configureTemplatePath">The configure template path</param>
/// <param name="userTemplatePath">The user template path</param>
/// <param name="className">The class name</param>
/// <param name="systemKeyword">The system keyword</param>
/// <param name="isActive">A value indicating whether the payment method is active</param>
/// <param name="displayOrder">The display order</param>
/// <returns>Payment method</returns>
public override DBPaymentMethod UpdatePaymentMethod(int paymentMethodId,
string name, string visibleName, string description, string configureTemplatePath,
string userTemplatePath, string className, string systemKeyword,
bool isActive, int displayOrder)
{
DBPaymentMethod item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodUpdate");
db.AddInParameter(dbCommand, "PaymentMethodID", DbType.Int32, paymentMethodId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "VisibleName", DbType.String, visibleName);
db.AddInParameter(dbCommand, "Description", DbType.String, description);
db.AddInParameter(dbCommand, "ConfigureTemplatePath", DbType.String, configureTemplatePath);
db.AddInParameter(dbCommand, "UserTemplatePath", DbType.String, userTemplatePath);
db.AddInParameter(dbCommand, "ClassName", DbType.String, className);
db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, systemKeyword);
db.AddInParameter(dbCommand, "IsActive", DbType.Boolean, isActive);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetPaymentMethodById(paymentMethodId);
}
return(item);
}
private DBPaymentMethod GetPaymentMethodFromReader(IDataReader dataReader)
{
DBPaymentMethod paymentMethod = new DBPaymentMethod();
paymentMethod.PaymentMethodID = NopSqlDataHelper.GetInt(dataReader, "PaymentMethodID");
paymentMethod.Name = NopSqlDataHelper.GetString(dataReader, "Name");
paymentMethod.VisibleName = NopSqlDataHelper.GetString(dataReader, "VisibleName");
paymentMethod.Description = NopSqlDataHelper.GetString(dataReader, "Description");
paymentMethod.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath");
paymentMethod.UserTemplatePath = NopSqlDataHelper.GetString(dataReader, "UserTemplatePath");
paymentMethod.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName");
paymentMethod.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
paymentMethod.IsActive = NopSqlDataHelper.GetBoolean(dataReader, "IsActive");
paymentMethod.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(paymentMethod);
}
/// <summary>
/// Gets all payment methods
/// </summary>
/// <returns>Payment method collection</returns>
public override DBPaymentMethodCollection GetAllPaymentMethods(bool showHidden)
{
DBPaymentMethodCollection paymentMethodCollection = new DBPaymentMethodCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadAll");
db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBPaymentMethod paymentMethod = GetPaymentMethodFromReader(dataReader);
paymentMethodCollection.Add(paymentMethod);
}
}
return(paymentMethodCollection);
}
/// <summary>
/// Gets a payment method
/// </summary>
/// <param name="SystemKeyword">Payment method system keyword</param>
/// <returns>Payment method</returns>
public override DBPaymentMethod GetPaymentMethodBySystemKeyword(string SystemKeyword)
{
DBPaymentMethod paymentMethod = null;
if (String.IsNullOrEmpty(SystemKeyword))
{
return(paymentMethod);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadBySystemKeyword");
db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, SystemKeyword);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
paymentMethod = GetPaymentMethodFromReader(dataReader);
}
}
return(paymentMethod);
}
/// <summary>
/// Gets a payment method
/// </summary>
/// <param name="PaymentMethodID">Payment method identifier</param>
/// <returns>Payment method</returns>
public override DBPaymentMethod GetPaymentMethodByID(int PaymentMethodID)
{
DBPaymentMethod paymentMethod = null;
if (PaymentMethodID == 0)
{
return(paymentMethod);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodLoadByPrimaryKey");
db.AddInParameter(dbCommand, "PaymentMethodID", DbType.Int32, PaymentMethodID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
paymentMethod = GetPaymentMethodFromReader(dataReader);
}
}
return(paymentMethod);
}
/// <summary>
/// Updates the payment method
/// </summary>
/// <param name="PaymentMethodID">The payment method identifer</param>
/// <param name="Name">The name</param>
/// <param name="VisibleName">The visible name</param>
/// <param name="Description">The description</param>
/// <param name="ConfigureTemplatePath">The configure template path</param>
/// <param name="UserTemplatePath">The user template path</param>
/// <param name="ClassName">The class name</param>
/// <param name="SystemKeyword">The system keyword</param>
/// <param name="IsActive">A value indicating whether the payment method is active</param>
/// <param name="DisplayOrder">The display order</param>
/// <returns>Payment method</returns>
public override DBPaymentMethod UpdatePaymentMethod(int PaymentMethodID, string Name, string VisibleName, string Description,
string ConfigureTemplatePath, string UserTemplatePath, string ClassName, string SystemKeyword, bool IsActive, int DisplayOrder)
{
DBPaymentMethod paymentMethod = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentMethodUpdate");
db.AddInParameter(dbCommand, "PaymentMethodID", DbType.Int32, PaymentMethodID);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "VisibleName", DbType.String, VisibleName);
db.AddInParameter(dbCommand, "Description", DbType.String, Description);
db.AddInParameter(dbCommand, "ConfigureTemplatePath", DbType.String, ConfigureTemplatePath);
db.AddInParameter(dbCommand, "UserTemplatePath", DbType.String, UserTemplatePath);
db.AddInParameter(dbCommand, "ClassName", DbType.String, ClassName);
db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, SystemKeyword);
db.AddInParameter(dbCommand, "IsActive", DbType.Boolean, IsActive);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
paymentMethod = GetPaymentMethodByID(PaymentMethodID);
}
return(paymentMethod);
}