private DBPaymentStatus GetPaymentStatusFromReader(IDataReader dataReader)
{
var item = new DBPaymentStatus();
item.PaymentStatusId = NopSqlDataHelper.GetInt(dataReader, "PaymentStatusID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
return(item);
}
private DBPaymentStatus GetPaymentStatusFromReader(IDataReader dataReader)
{
DBPaymentStatus paymentStatus = new DBPaymentStatus();
paymentStatus.PaymentStatusID = NopSqlDataHelper.GetInt(dataReader, "PaymentStatusID");
paymentStatus.Name = NopSqlDataHelper.GetString(dataReader, "Name");
return(paymentStatus);
}
private static PaymentStatus DBMapping(DBPaymentStatus dbItem)
{
if (dbItem == null)
return null;
PaymentStatus item = new PaymentStatus();
item.PaymentStatusID = dbItem.PaymentStatusID;
item.Name = dbItem.Name;
return item;
}
/// <summary>
/// Gets all payment statuses
/// </summary>
/// <returns>Payment status collection</returns>
public override DBPaymentStatusCollection GetAllPaymentStatuses()
{
DBPaymentStatusCollection paymentStatusCollection = new DBPaymentStatusCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentStatusLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBPaymentStatus paymentStatus = GetPaymentStatusFromReader(dataReader);
paymentStatusCollection.Add(paymentStatus);
}
}
return(paymentStatusCollection);
}
/// <summary>
/// Gets a payment status by identifier
/// </summary>
/// <param name="paymentStatusId">payment status identifier</param>
/// <returns>Payment status</returns>
public override DBPaymentStatus GetPaymentStatusById(int paymentStatusId)
{
DBPaymentStatus item = null;
if (paymentStatusId == 0)
{
return(item);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PaymentStatusLoadByPrimaryKey");
db.AddInParameter(dbCommand, "PaymentStatusID", DbType.Int32, paymentStatusId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetPaymentStatusFromReader(dataReader);
}
}
return(item);
}
