Find the manufacture name according to the ManufacturerId

Discussion area for and about AbleCommerce hosting and development providers. If you provide AbleCommerce services let our users know.
Post Reply
berry.lai
Ensign (ENS)
Ensign (ENS)
Posts: 1
Joined: Tue Aug 16, 2011 1:49 am

Find the manufacture name according to the ManufacturerId

Post by berry.lai » Tue Aug 16, 2011 2:02 am

In EditProduct.aspx.cs 'Manufacturer' is a dropdown list, and we can select the type.
Now I need to write a data feed script. I got the ManufacturerId the table 'products', and the Manufacturer data store in table 'Manufacturer'.
So how do i use ManufacturerId to find out the Manufacturer 'Name'.
Here is my the code, but didn't work.


using System;
using System.IO;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CommerceBuilder.Web.UI;
using CommerceBuilder.DataFeeds;
using CommerceBuilder.Common;
using System.Collections.Generic;
using CommerceBuilder.Products;
using CommerceBuilder.Stores;
using CommerceBuilder.Utility;

public partial class Admin_Marketing_Feeds_GetPrice : AbleCommerceAdminPage
{

protected void Page_Init(object sender, EventArgs e)
{

bool success = true;
String temp;
String filePath = "..\\..\\..\\feed\\getprice.txt";

dataFeedLink.Text = "<a href='" + filePath + "'>Download</a>";

String fieldBreak = "\t";

TextWriter tw = new StreamWriter(Server.MapPath(filePath));
ProductCollection products = ProductDataSource.LoadForCriteria("");

tw.WriteLine("MPN "+fieldBreak+
"Product name"+fieldBreak+
"Product ID"+fieldBreak+
"Description"+fieldBreak+
"Price"+fieldBreak+
"Category"+fieldBreak+
"ProductURL"+fieldBreak+
"Image Link"+fieldBreak+
"Model"+fieldBreak+
"Manufacturer"+fieldBreak+
"SalesPrice"+fieldBreak+
"AVAILABILITY");

foreach (Product product in products){
temp = ManufacturerDataSource.LoadForStore("Name").ToString();
tw.WriteLine(product.ModelNumber+fieldBreak+
product.Name+fieldBreak+
product.ProductId+fieldBreak+
product.Description+fieldBreak+
product.Price+fieldBreak+
temp+fieldBreak+
product.DisplayPage+fieldBreak+
product.ImageUrl+fieldBreak+
product.ModelNumber+fieldBreak+
"Manufacturer"+fieldBreak+
product.Price+fieldBreak+
"Y");
}
tw.Close();
SuccessMessageHeader.Visible = success;
dataFeedLink.Visible = success;
FailureMessageHeader.Visible = !success;

}
}

Please tell me the solution. Thank you

plugables
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Sat Aug 15, 2009 4:04 am
Contact:

Re: Find the manufacture name according to the ManufacturerId

Post by plugables » Sat Sep 10, 2011 11:58 am

Use this

Code: Select all

product.ModelNumber+fieldBreak+
(product.Manufacturer == null ? string.Empty : product.Manufacturer.Name) +fieldBreak+
product.Price+fieldBreak

Post Reply