private DBTaxProvider GetTaxProviderFromReader(IDataReader dataReader) { DBTaxProvider taxProvider = new DBTaxProvider(); taxProvider.TaxProviderID = NopSqlDataHelper.GetInt(dataReader, "TaxProviderID"); taxProvider.Name = NopSqlDataHelper.GetString(dataReader, "Name"); taxProvider.Description = NopSqlDataHelper.GetString(dataReader, "Description"); taxProvider.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath"); taxProvider.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName"); taxProvider.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return taxProvider; }
private DBTaxProvider GetTaxProviderFromReader(IDataReader dataReader) { DBTaxProvider taxProvider = new DBTaxProvider(); taxProvider.TaxProviderID = NopSqlDataHelper.GetInt(dataReader, "TaxProviderID"); taxProvider.Name = NopSqlDataHelper.GetString(dataReader, "Name"); taxProvider.Description = NopSqlDataHelper.GetString(dataReader, "Description"); taxProvider.ConfigureTemplatePath = NopSqlDataHelper.GetString(dataReader, "ConfigureTemplatePath"); taxProvider.ClassName = NopSqlDataHelper.GetString(dataReader, "ClassName"); taxProvider.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return(taxProvider); }
/// <summary> /// Gets all tax providers /// </summary> /// <returns>Shipping rate computation method collection</returns> public override DBTaxProviderCollection GetAllTaxProviders() { DBTaxProviderCollection taxProviderCollection = new DBTaxProviderCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxProviderLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBTaxProvider taxProvider = GetTaxProviderFromReader(dataReader); taxProviderCollection.Add(taxProvider); } } return(taxProviderCollection); }
/// <summary> /// Updates the tax provider /// </summary> /// <param name="TaxProviderID">The tax provider identifier</param> /// <param name="Name">The name</param> /// <param name="Description">The description</param> /// <param name="ConfigureTemplatePath">The configure template path</param> /// <param name="ClassName">The class name</param> /// <param name="DisplayOrder">The display order</param> /// <returns>Tax provider</returns> public override DBTaxProvider UpdateTaxProvider(int TaxProviderID, string Name, string Description, string ConfigureTemplatePath, string ClassName, int DisplayOrder) { DBTaxProvider taxProvider = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxProviderUpdate"); db.AddInParameter(dbCommand, "TaxProviderID", DbType.Int32, TaxProviderID); db.AddInParameter(dbCommand, "Name", DbType.String, Name); db.AddInParameter(dbCommand, "Description", DbType.String, Description); db.AddInParameter(dbCommand, "ConfigureTemplatePath", DbType.String, ConfigureTemplatePath); db.AddInParameter(dbCommand, "ClassName", DbType.String, ClassName); db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder); if (db.ExecuteNonQuery(dbCommand) > 0) { taxProvider = GetTaxProviderByID(TaxProviderID); } return(taxProvider); }
/// <summary> /// Inserts a tax provider /// </summary> /// <param name="name">The name</param> /// <param name="description">The description</param> /// <param name="configureTemplatePath">The configure template path</param> /// <param name="className">The class name</param> /// <param name="displayOrder">The display order</param> /// <returns>Tax provider</returns> public override DBTaxProvider InsertTaxProvider(string name, string description, string configureTemplatePath, string className, int displayOrder) { DBTaxProvider item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxProviderInsert"); db.AddOutParameter(dbCommand, "TaxProviderID", DbType.Int32, 0); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "Description", DbType.String, description); db.AddInParameter(dbCommand, "ConfigureTemplatePath", DbType.String, configureTemplatePath); db.AddInParameter(dbCommand, "ClassName", DbType.String, className); db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder); if (db.ExecuteNonQuery(dbCommand) > 0) { int taxProviderId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TaxProviderID")); item = GetTaxProviderById(taxProviderId); } return(item); }
/// <summary> /// Gets a tax provider /// </summary> /// <param name="TaxProviderID">Tax provider identifier</param> /// <returns>Tax provider</returns> public override DBTaxProvider GetTaxProviderByID(int TaxProviderID) { DBTaxProvider taxProvider = null; if (TaxProviderID == 0) { return(taxProvider); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxProviderLoadByPrimaryKey"); db.AddInParameter(dbCommand, "TaxProviderID", DbType.Int32, TaxProviderID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { taxProvider = GetTaxProviderFromReader(dataReader); } } return(taxProvider); }