private DBTaxCategory GetTaxCategoryFromReader(IDataReader dataReader) { DBTaxCategory taxCategory = new DBTaxCategory(); taxCategory.TaxCategoryID = NopSqlDataHelper.GetInt(dataReader, "TaxCategoryID"); taxCategory.Name = NopSqlDataHelper.GetString(dataReader, "Name"); taxCategory.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); taxCategory.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); taxCategory.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); return(taxCategory); }
private DBTaxCategory GetTaxCategoryFromReader(IDataReader dataReader) { var item = new DBTaxCategory(); item.TaxCategoryId = NopSqlDataHelper.GetInt(dataReader, "TaxCategoryID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); item.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); return(item); }
/// <summary> /// Deletes a tax category /// </summary> /// <param name="TaxCategoryID">The tax category identifier</param> public override void DeleteTaxCategory(int TaxCategoryID) { Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DBTaxCategory taxCategory = GetTaxCategoryByID(TaxCategoryID); if (taxCategory != null) { DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryDelete"); db.AddInParameter(dbCommand, "TaxCategoryID", DbType.Int32, TaxCategoryID); int retValue = db.ExecuteNonQuery(dbCommand); } }
/// <summary> /// Gets all tax categories /// </summary> /// <returns>Tax category collection</returns> public override DBTaxCategoryCollection GetAllTaxCategories() { DBTaxCategoryCollection taxCategoryCollection = new DBTaxCategoryCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBTaxCategory taxCategory = GetTaxCategoryFromReader(dataReader); taxCategoryCollection.Add(taxCategory); } } return(taxCategoryCollection); }
/// <summary> /// Updates the tax category /// </summary> /// <param name="TaxCategoryID">The tax category identifier</param> /// <param name="Name">The name</param> /// <param name="DisplayOrder">The display order</param> /// <param name="CreatedOn">The date and time of instance creation</param> /// <param name="UpdatedOn">The date and time of instance update</param> /// <returns>Tax category</returns> public override DBTaxCategory UpdateTaxCategory(int TaxCategoryID, string Name, int DisplayOrder, DateTime CreatedOn, DateTime UpdatedOn) { DBTaxCategory taxCategory = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryUpdate"); db.AddInParameter(dbCommand, "TaxCategoryID", DbType.Int32, TaxCategoryID); db.AddInParameter(dbCommand, "Name", DbType.String, Name); db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn); db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, UpdatedOn); if (db.ExecuteNonQuery(dbCommand) > 0) { taxCategory = GetTaxCategoryByID(TaxCategoryID); } return(taxCategory); }
/// <summary> /// Updates the tax category /// </summary> /// <param name="taxCategoryId">The tax category identifier</param> /// <param name="name">The name</param> /// <param name="displayOrder">The display order</param> /// <param name="createdOn">The date and time of instance creation</param> /// <param name="updatedOn">The date and time of instance update</param> /// <returns>Tax category</returns> public override DBTaxCategory UpdateTaxCategory(int taxCategoryId, string name, int displayOrder, DateTime createdOn, DateTime updatedOn) { DBTaxCategory item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryUpdate"); db.AddInParameter(dbCommand, "TaxCategoryID", DbType.Int32, taxCategoryId); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn); db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, updatedOn); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetTaxCategoryById(taxCategoryId); } return(item); }
/// <summary> /// Gets a tax category /// </summary> /// <param name="TaxCategoryID">Tax category identifier</param> /// <returns>Tax category</returns> public override DBTaxCategory GetTaxCategoryByID(int TaxCategoryID) { DBTaxCategory taxCategory = null; if (TaxCategoryID == 0) { return(taxCategory); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryLoadByPrimaryKey"); db.AddInParameter(dbCommand, "TaxCategoryID", DbType.Int32, TaxCategoryID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { taxCategory = GetTaxCategoryFromReader(dataReader); } } return(taxCategory); }