private DBShippingStatus GetShippingStatusFromReader(IDataReader dataReader) { DBShippingStatus shippingStatus = new DBShippingStatus(); shippingStatus.ShippingStatusID = NopSqlDataHelper.GetInt(dataReader, "ShippingStatusID"); shippingStatus.Name = NopSqlDataHelper.GetString(dataReader, "Name"); return(shippingStatus); }
private DBShippingStatus GetShippingStatusFromReader(IDataReader dataReader) { var item = new DBShippingStatus(); item.ShippingStatusId = NopSqlDataHelper.GetInt(dataReader, "ShippingStatusID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); return(item); }
private static ShippingStatus DBMapping(DBShippingStatus dbItem) { if (dbItem == null) return null; ShippingStatus item = new ShippingStatus(); item.ShippingStatusID = dbItem.ShippingStatusID; item.Name = dbItem.Name; return item; }
/// <summary> /// Gets all shipping statuses /// </summary> /// <returns>Shipping status collection</returns> public override DBShippingStatusCollection GetAllShippingStatuses() { DBShippingStatusCollection shippingStatusCollection = new DBShippingStatusCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingStatusLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBShippingStatus shippingStatus = GetShippingStatusFromReader(dataReader); shippingStatusCollection.Add(shippingStatus); } } return(shippingStatusCollection); }
/// <summary> /// Gets a shipping status by ID /// </summary> /// <param name="ShippingStatusID">Shipping status identifier</param> /// <returns>Shipping status</returns> public override DBShippingStatus GetShippingStatusByID(int ShippingStatusID) { DBShippingStatus shippingStatus = null; if (ShippingStatusID == 0) { return(shippingStatus); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShippingStatusLoadByPrimaryKey"); db.AddInParameter(dbCommand, "ShippingStatusID", DbType.Int32, ShippingStatusID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { shippingStatus = GetShippingStatusFromReader(dataReader); } } return(shippingStatus); }