/// <summary> /// Gets a product template /// </summary> /// <param name="ProductTemplateID">Product template identifier</param> /// <returns>Product template</returns> public static ProductTemplate GetProductTemplateByID(int ProductTemplateID) { if (ProductTemplateID == 0) { return(null); } string key = string.Format(PRODUCTTEMPLATES_BY_ID_KEY, ProductTemplateID); object obj2 = NopCache.Get(key); if (TemplateManager.CacheEnabled && (obj2 != null)) { return((ProductTemplate)obj2); } DBProductTemplate dbItem = DBProviderManager <DBTemplateProvider> .Provider.GetProductTemplateByID(ProductTemplateID); ProductTemplate productTemplate = DBMapping(dbItem); if (TemplateManager.CacheEnabled) { NopCache.Max(key, productTemplate); } return(productTemplate); }
private DBProductTemplate GetProductTemplateFromReader(IDataReader dataReader) { DBProductTemplate productTemplate = new DBProductTemplate(); productTemplate.ProductTemplateID = NopSqlDataHelper.GetInt(dataReader, "ProductTemplateID"); productTemplate.Name = NopSqlDataHelper.GetString(dataReader, "Name"); productTemplate.TemplatePath = NopSqlDataHelper.GetString(dataReader, "TemplatePath"); productTemplate.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); productTemplate.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); productTemplate.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); return productTemplate; }
private static ProductTemplate DBMapping(DBProductTemplate dbItem) { if (dbItem == null) { return(null); } var item = new ProductTemplate(); item.ProductTemplateId = dbItem.ProductTemplateId; item.Name = dbItem.Name; item.TemplatePath = dbItem.TemplatePath; item.DisplayOrder = dbItem.DisplayOrder; item.CreatedOn = dbItem.CreatedOn; item.UpdatedOn = dbItem.UpdatedOn; return(item); }
/// <summary> /// Updates the product template /// </summary> /// <param name="ProductTemplateID">The product template identifier</param> /// <param name="Name">The name</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>Product template</returns> public static ProductTemplate UpdateProductTemplate(int ProductTemplateID, string Name, string TemplatePath, int DisplayOrder, DateTime CreatedOn, DateTime UpdatedOn) { CreatedOn = DateTimeHelper.ConvertToUtcTime(CreatedOn); UpdatedOn = DateTimeHelper.ConvertToUtcTime(UpdatedOn); DBProductTemplate dbItem = DBProviderManager <DBTemplateProvider> .Provider.UpdateProductTemplate(ProductTemplateID, Name, TemplatePath, DisplayOrder, CreatedOn, UpdatedOn); ProductTemplate productTemplate = DBMapping(dbItem); if (TemplateManager.CacheEnabled) { NopCache.RemoveByPattern(PRODUCTTEMPLATES_PATTERN_KEY); } return(productTemplate); }