private DBCreditCardType GetCreditCardTypeFromReader(IDataReader dataReader)
{
DBCreditCardType creditCardType = new DBCreditCardType();
creditCardType.CreditCardTypeID = NopSqlDataHelper.GetInt(dataReader, "CreditCardTypeID");
creditCardType.Name = NopSqlDataHelper.GetString(dataReader, "Name");
creditCardType.SystemKeyword = NopSqlDataHelper.GetString(dataReader, "SystemKeyword");
creditCardType.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
creditCardType.Deleted = NopSqlDataHelper.GetBoolean(dataReader, "Deleted");
return(creditCardType);
}
private static CreditCardType DBMapping(DBCreditCardType dbItem)
{
if (dbItem == null)
return null;
CreditCardType item = new CreditCardType();
item.CreditCardTypeID = dbItem.CreditCardTypeID;
item.Name = dbItem.Name;
item.SystemKeyword = dbItem.SystemKeyword;
item.DisplayOrder = dbItem.DisplayOrder;
item.Deleted = dbItem.Deleted;
return item;
}
/// <summary>
/// Gets a credit card type
/// </summary>
/// <param name="CreditCardTypeID">Credit card type identifier</param>
/// <returns>Credit card type</returns>
public override DBCreditCardType GetCreditCardTypeByID(int CreditCardTypeID)
{
DBCreditCardType creditCardType = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CreditCardTypeLoadByPrimaryKey");
db.AddInParameter(dbCommand, "CreditCardTypeID", DbType.Int32, CreditCardTypeID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
creditCardType = GetCreditCardTypeFromReader(dataReader);
}
}
return(creditCardType);
}
/// <summary>
/// Gets all credit card types
/// </summary>
/// <returns>Credit card type collection</returns>
public override DBCreditCardTypeCollection GetAllCreditCardTypes()
{
DBCreditCardTypeCollection creditCardTypeCollection = new DBCreditCardTypeCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CreditCardTypeLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBCreditCardType creditCardType = GetCreditCardTypeFromReader(dataReader);
creditCardTypeCollection.Add(creditCardType);
}
}
return(creditCardTypeCollection);
}
/// <summary>
/// Inserts a credit card type
/// </summary>
/// <param name="Name">The name</param>
/// <param name="SystemKeyword">The system keyword</param>
/// <param name="DisplayOrder">The display order</param>
/// <param name="Deleted">A value indicating whether the entity has been deleted</param>
/// <returns>A credit card type</returns>
public override DBCreditCardType InsertCreditCardType(string Name, string SystemKeyword, int DisplayOrder, bool Deleted)
{
DBCreditCardType creditCardType = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CreditCardTypeInsert");
db.AddOutParameter(dbCommand, "CreditCardTypeID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, SystemKeyword);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
db.AddInParameter(dbCommand, "Deleted", DbType.Boolean, Deleted);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int CreditCardTypeID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@CreditCardTypeID"));
creditCardType = GetCreditCardTypeByID(CreditCardTypeID);
}
return(creditCardType);
}
/// <summary>
/// Updates the credit card type
/// </summary>
/// <param name="creditCardTypeId">Credit card type identifier</param>
/// <param name="name">The name</param>
/// <param name="systemKeyword">The system keyword</param>
/// <param name="displayOrder">The display order</param>
/// <param name="deleted">A value indicating whether the entity has been deleted</param>
/// <returns>A credit card type</returns>
public override DBCreditCardType UpdateCreditCardType(int creditCardTypeId,
string name, string systemKeyword, int displayOrder, bool deleted)
{
DBCreditCardType item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CreditCardTypeUpdate");
db.AddInParameter(dbCommand, "CreditCardTypeID", DbType.Int32, creditCardTypeId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "SystemKeyword", DbType.String, systemKeyword);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
db.AddInParameter(dbCommand, "Deleted", DbType.Boolean, deleted);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetCreditCardTypeById(creditCardTypeId);
}
return(item);
}
