private DBManufacturerTemplate GetManufacturerTemplateFromReader(IDataReader dataReader) { DBManufacturerTemplate manufacturerTemplate = new DBManufacturerTemplate(); manufacturerTemplate.ManufacturerTemplateID = NopSqlDataHelper.GetInt(dataReader, "ManufacturerTemplateID"); manufacturerTemplate.Name = NopSqlDataHelper.GetString(dataReader, "Name"); manufacturerTemplate.TemplatePath = NopSqlDataHelper.GetString(dataReader, "TemplatePath"); manufacturerTemplate.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); manufacturerTemplate.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); manufacturerTemplate.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); return(manufacturerTemplate); }
private DBManufacturerTemplate GetManufacturerTemplateFromReader(IDataReader dataReader) { var item = new DBManufacturerTemplate(); item.ManufacturerTemplateId = NopSqlDataHelper.GetInt(dataReader, "ManufacturerTemplateID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); item.TemplatePath = NopSqlDataHelper.GetString(dataReader, "TemplatePath"); item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); item.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); return(item); }
/// <summary> /// Deletes a manufacturer template /// </summary> /// <param name="ManufacturerTemplateID">Manufacturer template identifier</param> public override void DeleteManufacturerTemplate(int ManufacturerTemplateID) { Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DBManufacturerTemplate manufacturerTemplate = GetManufacturerTemplateByID(ManufacturerTemplateID); if (manufacturerTemplate != null) { DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerTemplateDelete"); db.AddInParameter(dbCommand, "ManufacturerTemplateID", DbType.Int32, ManufacturerTemplateID); int retValue = db.ExecuteNonQuery(dbCommand); } }
/// <summary> /// Gets all manufacturer templates /// </summary> /// <returns>Manufacturer template collection</returns> public override DBManufacturerTemplateCollection GetAllManufacturerTemplates() { DBManufacturerTemplateCollection manufacturerTemplateCollection = new DBManufacturerTemplateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerTemplateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBManufacturerTemplate manufacturerTemplate = GetManufacturerTemplateFromReader(dataReader); manufacturerTemplateCollection.Add(manufacturerTemplate); } } return(manufacturerTemplateCollection); }
/// <summary> /// Inserts a manufacturer template /// </summary> /// <param name="name">The manufacturer template identifier</param> /// <param name="templatePath">The template path</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>Manufacturer template</returns> public override DBManufacturerTemplate InsertManufacturerTemplate(string name, string templatePath, int displayOrder, DateTime createdOn, DateTime updatedOn) { DBManufacturerTemplate item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerTemplateInsert"); db.AddOutParameter(dbCommand, "ManufacturerTemplateID", DbType.Int32, 0); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "TemplatePath", DbType.String, templatePath); 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) { int manufacturerTemplateId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@ManufacturerTemplateID")); item = GetManufacturerTemplateById(manufacturerTemplateId); } return(item); }
/// <summary> /// Updates the manufacturer template /// </summary> /// <param name="ManufacturerTemplateID">Manufacturer template identifer</param> /// <param name="Name">The manufacturer template identifier</param> /// <param name="TemplatePath">The template path</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>Manufacturer template</returns> public override DBManufacturerTemplate UpdateManufacturerTemplate(int ManufacturerTemplateID, string Name, string TemplatePath, int DisplayOrder, DateTime CreatedOn, DateTime UpdatedOn) { DBManufacturerTemplate manufacturerTemplate = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerTemplateUpdate"); db.AddInParameter(dbCommand, "ManufacturerTemplateID", DbType.Int32, ManufacturerTemplateID); db.AddInParameter(dbCommand, "Name", DbType.String, Name); db.AddInParameter(dbCommand, "TemplatePath", DbType.String, TemplatePath); 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) { manufacturerTemplate = GetManufacturerTemplateByID(ManufacturerTemplateID); } return(manufacturerTemplate); }
/// <summary> /// Gets a manufacturer template /// </summary> /// <param name="manufacturerTemplateId">Manufacturer template identifier</param> /// <returns>Manufacturer template</returns> public override DBManufacturerTemplate GetManufacturerTemplateById(int manufacturerTemplateId) { DBManufacturerTemplate item = null; if (manufacturerTemplateId == 0) { return(item); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerTemplateLoadByPrimaryKey"); db.AddInParameter(dbCommand, "ManufacturerTemplateID", DbType.Int32, manufacturerTemplateId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetManufacturerTemplateFromReader(dataReader); } } return(item); }