public static void PopulateSueetieProductList(IDataReader dr, SueetieProduct _sueetieProduct) { _sueetieProduct.ProductID = (int)dr["productid"]; _sueetieProduct.UserID = (int)dr["userid"]; _sueetieProduct.CategoryID = (int)dr["categoryid"]; _sueetieProduct.Title = dr["title"] as string; _sueetieProduct.SubTitle = dr["subtitle"] as string; _sueetieProduct.ProductDescription = dr["productdescription"] as string; _sueetieProduct.DownloadURL = dr["downloadurl"] as string; _sueetieProduct.Price = (decimal)dr["price"]; _sueetieProduct.ExpirationDate = DataHelper.DateOrNull(dr["expirationdate"].ToString()); _sueetieProduct.DateCreated = DataHelper.DateOrNull(dr["datecreated"].ToString()); _sueetieProduct.DateApproved = DataHelper.DateOrNull(dr["dateapproved"].ToString()); _sueetieProduct.NumViews = (int)dr["numviews"]; _sueetieProduct.NumDownloads = (int)dr["numdownloads"]; _sueetieProduct.PurchaseTypeID = (int)dr["purchasetypeid"]; _sueetieProduct.PreviewImageID = (int)dr["previewimageid"]; _sueetieProduct.DocumentationURL = dr["documentationurl"] as string; _sueetieProduct.ImageGalleryURL = dr["imagegalleryurl"] as string; _sueetieProduct.StatusTypeID = (int)dr["statustypeid"]; _sueetieProduct.UserName = dr["username"] as string; _sueetieProduct.Email = dr["email"] as string; _sueetieProduct.DisplayName = dr["displayname"] as string; _sueetieProduct.ContentID = (int)dr["contentid"]; _sueetieProduct.ContentTypeID = (int)dr["contenttypeid"]; _sueetieProduct.ApplicationID = (int)dr["applicationid"]; _sueetieProduct.StatusTypeCode = dr["statustypecode"] as string; _sueetieProduct.CategoryName = dr["categoryname"] as string; _sueetieProduct.CategoryPath = dr["categorypath"] as string; _sueetieProduct.PurchaseTypeCode = dr["purchasetypecode"] as string; _sueetieProduct.ProductTypeID = (int)dr["producttypeid"]; _sueetieProduct.ProductTypeCode = dr["producttypecode"] as string; _sueetieProduct.ProductTypeDescription = dr["producttypedescription"] as string; }
public override void UpdateSueetieProduct(SueetieProduct sueetieProduct) { using (var connection = this.GetSqlConnection(true)) { connection.Execute(GetSqlScript("Product.Update"), sueetieProduct); } }
public static int ActionType(this SueetieProduct product) { int num = -1; if ((product.ProductTypeID == 5) || (product.ProductTypeID == 2)) { return(2); } if (product.ProductTypeID == 4) { return(4); } if ((product.ProductTypeID == 6) || (product.ProductTypeID == 1)) { return(3); } if (product.ProductTypeID == 3) { return(5); } if (product.ProductTypeID == 7) { num = 6; } return(num); }
public override List <SueetieProduct> GetSueetieProductsByCategoryTree(int categoryID) { List <SueetieProduct> list = new List <SueetieProduct>(); using (SqlConnection connection = this.GetSqlConnection()) { using (SqlCommand command = new SqlCommand("SuCommerce_ProductsByCategory_Get", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@categoryID", SqlDbType.Int, 4).Value = categoryID; command.Parameters.Add("@contentTypeID", SqlDbType.Int, 4).Value = 0x12; connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { SueetieProduct product = null; while (reader.Read()) { product = new SueetieProduct(); CommerceDataProvider.PopulateSueetieProductList(reader, product); list.Add(product); } reader.Close(); connection.Close(); } return(list); } } }
public static int CreateSueetieProduct(SueetieProduct sueetieProduct) { int num = CommerceDataProvider.LoadProvider().CreateSueetieProduct(sueetieProduct); CommerceCommon.ClearMarketplaceCache(); return(num); }
public override int CreateSueetieProduct(SueetieProduct sueetieProduct) { using (SqlConnection connection = this.GetSqlConnection(true)) { var id = (int)connection.Query(GetSqlScript("Product.Insert"), sueetieProduct).First().Id; sueetieProduct.ProductID = id; connection.Execute("INSERT INTO SuCommerce_CartLinks select @ProductID, -1 as [PackageTypeID], -1 as [LicenseTypeID], @Price as [Price], 1.0 as [Version], 1 as [IsActive]", new { ProductId = id, Price = sueetieProduct.Price }); return(id); } }
public static void DownloadProductFile(int _productID, string _purchaseKey, int _cartLinkID) { int num2; HttpContext current = HttpContext.Current; Stream stream = null; SueetieProduct sueetieProduct = Products.GetSueetieProduct(_productID); ProductPurchase productPurchase = new ProductPurchase { ProductID = _productID, UserID = SueetieContext.Current.User.UserID, PurchaseKey = _purchaseKey, CartLinkID = _cartLinkID, ActionID = 1 }; Purchases.RecordPurchase(productPurchase); string marketplaceFolderName = SueetieConfiguration.Get().Core.MarketplaceFolderName; string str = sueetieProduct.DateCreated.Year.ToString(); string str2 = Guid.NewGuid() + ".zip"; string sourceFileName = siteRootPath + @"util\marketplace\downloads\" + str + @"\" + sueetieProduct.DownloadURL; string destFileName = siteRootPath + @"util\marketplace\downloads\tmp\" + str2; File.Copy(sourceFileName, destFileName); int num = 0x8000; byte[] buffer = new byte[num]; stream = File.OpenRead(destFileName); current.Response.AddHeader("Content-Disposition", "attachment; filename=" + sueetieProduct.DownloadURL); current.Response.Clear(); current.Response.ContentType = "application/zip"; current.Response.Buffer = false; stream.Position = 0L; while ((num2 = stream.Read(buffer, 0, buffer.Length)) > 0) { if (current.Response.IsClientConnected) { current.Response.OutputStream.Write(buffer, 0, num2); current.Response.Flush(); } else { return; } } if (stream != null) { stream.Close(); } current.Response.End(); }
public static bool SendAdResponse(int productID, string senderName, string senderAddress, string comments) { bool flag = false; SueetieProduct sueetieProduct = Products.GetSueetieProduct(productID); if (sueetieProduct == null) { return(flag); } StringBuilder builder = new StringBuilder(); builder.AppendFormat("A user has sent a response to your Ad '{0}' at {1}", sueetieProduct.Title, SiteSettings.Instance.SiteName); builder.AppendLine(); builder.AppendLine(); builder.AppendLine("The contact information of the user is below:"); builder.AppendLine(); builder.AppendLine("Name: " + senderName); builder.AppendLine("Email: " + senderAddress); builder.AppendLine(); builder.AppendLine("User comments/questions:"); builder.AppendLine(comments); builder.AppendLine(); builder.AppendLine("You can respond to the user by using the Reply feature of your email client."); builder.AppendLine(); builder.AppendLine(SiteSettings.Instance.SiteName); builder.AppendLine(string.Format("http://{0}", HttpContext.Current.Request.Url.Host)); string from = string.Format("{0} <{1}>", senderName, senderAddress); try { EmailHelper.AsyncSendEmail(new MailMessage(from, sueetieProduct.Email) { Subject = "Response for Ad: " + sueetieProduct.Title, Body = builder.ToString() }); return(true); } catch { return(false); } }
public abstract void UpdateSueetieProduct(SueetieProduct sueetieProduct);
public abstract int CreateSueetieProduct(SueetieProduct sueetieProduct);
public static void UpdateSueetieProduct(SueetieProduct sueetieProduct) { CommerceDataProvider.LoadProvider().UpdateSueetieProduct(sueetieProduct); CommerceCommon.ClearMarketplaceCache(); }