public override List <ProductPhoto> GetProductPhotoList() { List <ProductPhoto> list = new List <ProductPhoto>(); using (SqlConnection connection = this.GetSqlConnection()) { string cmdText = "select * from SuCommerce_Photos"; SqlCommand command = new SqlCommand(cmdText, connection) { CommandType = CommandType.Text }; connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { ProductPhoto photo = null; while (reader.Read()) { photo = new ProductPhoto(); CommerceDataProvider.PopulateProductPhotoList(reader, photo); list.Add(photo); } reader.Close(); connection.Close(); } } return(list); }
/// <summary> /// Insert a photo as product pictures. /// </summary> /// <remarks> /// This method is called directly by UI using ASP.NET ObjectDataSource. /// </remarks> public static int InsertPhoto(int productID, byte[] bytesFull, byte[] bytesMedium, byte[] bytesSmall, bool useAsPreview) { int photoId = -1; if (bytesFull != null && bytesMedium != null && bytesSmall != null) { var productPhoto = new ProductPhoto { ProductID = productID, IsMainPreview = useAsPreview }; photoId = AddPhoto(productPhoto); string fullSizePath = ImageHelper.GetFilePath(photoId, false, SueetiePhotoSize.Full, SueetiePhotoType.ProductPhoto); string mediumSizePath = ImageHelper.GetFilePath(photoId, false, SueetiePhotoSize.Medium, SueetiePhotoType.ProductPhoto); string smallSizePath = ImageHelper.GetFilePath(photoId, false, SueetiePhotoSize.Small, SueetiePhotoType.ProductPhoto); ImageHelper.WriteToFile(fullSizePath, bytesFull); ImageHelper.WriteToFile(mediumSizePath, bytesMedium); ImageHelper.WriteToFile(smallSizePath, bytesSmall); CommerceCommon.ClearMarketplaceCache(); } return(photoId); }
public static int AddPhoto(ProductPhoto productPhoto) { int num = -1; num = CommerceDataProvider.LoadProvider().AddPhoto(productPhoto); ClearProductPhotoListCache(); return(num); }
public static void SetAdPreviewPhoto(int productID, int photoID) { CommerceDataProvider provider = CommerceDataProvider.LoadProvider(); ProductPhoto productPhoto = new ProductPhoto { PhotoID = photoID, ProductID = productID }; provider.SetPreviewPhoto(productPhoto); CommerceCommon.ClearMarketplaceCache(); }
public override void SetPreviewPhoto(ProductPhoto productPhoto) { using (SqlConnection connection = this.GetSqlConnection()) { using (SqlCommand command = new SqlCommand("SuCommerce_PreviewPhoto_Set", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@PhotoID", SqlDbType.Int, 4).Value = productPhoto.PhotoID; command.Parameters.Add("@ProductID", SqlDbType.Int, 4).Value = productPhoto.ProductID; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } } }
public override int AddPhoto(ProductPhoto productPhoto) { int num = 0; using (SqlConnection connection = this.GetSqlConnection()) { using (SqlCommand command = new SqlCommand("SuCommerce_Photo_Add", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ProductID", SqlDbType.Int, 4).Value = productPhoto.ProductID; command.Parameters.Add("@IsMainPreview", SqlDbType.Bit, 1).Value = productPhoto.IsMainPreview; command.Parameters.Add("@PhotoID", SqlDbType.Int).Direction = ParameterDirection.Output; connection.Open(); command.ExecuteNonQuery(); num = (int)command.Parameters["@PhotoId"].Value; connection.Close(); } } return(num); }
public abstract void SetPreviewPhoto(ProductPhoto productPhoto);
public abstract int AddPhoto(ProductPhoto productPhoto);