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