rendered paste body /// <summary>
/// Reads in the XML file defied in the GlobalConstants Class and walks
/// through it looking for any Products which have been flagged "Dirty"
/// and passes that data to the SmartMart WebService
/// </summary>
/// <returns>
/// String containing the results of the UpdateProduct calls made
/// to the SmartMart WebService if any Rows have been flagged as "Dirty"
/// </returns>
public static string saveAllProductData()
{
bool hasErrors = false;
string errorMessage = "";
string returnMessage;
try
{
SmartMartWebService.SmartMartWebServices SmartMart = new SmartMartWebService.SmartMartWebServices();
DataSet AllProductData = Products.readAllProductData();
foreach (DataRow MyRow in AllProductData.Tables["Products"].Rows)
{
if (int.Parse(MyRow["Dirty"].ToString()) == 1)
{
int ProductId = int.Parse(MyRow["ProductId"].ToString());
string BrandName = MyRow["BrandName"].ToString();
string ProductName = MyRow["ProductName"].ToString();
double SRP = double.Parse(MyRow["SRP"].ToString());
double GrossWeight = double.Parse(MyRow["GrossWeight"].ToString());
double NetWeight = double.Parse(MyRow["NetWeight"].ToString());
double ShelfWidth = double.Parse(MyRow["ShelfWidth"].ToString());
double ShelfHeight = double.Parse(MyRow["ShelfHeight"].ToString());
double ShelfDepth = double.Parse(MyRow["ShelfDepth"].ToString());
string LastUpdated = MyRow["LastUpdated"].ToString();
if (!SmartMart.updateProduct(ProductId, BrandName, ProductName, SRP, GrossWeight, NetWeight, ShelfWidth, ShelfHeight, ShelfDepth, LastUpdated))
{
hasErrors = true;
errorMessage = errorMessage + MyRow["ProductId"].ToString() + " - " + MyRow["BrandName"].ToString() + " - " + MyRow["ProductName"].ToString() + "\r\n";
}
}
}
if (hasErrors == true)
{
returnMessage = "The following products could not be updated\r\n\r\n" + errorMessage;
}
else
{
returnMessage = "All Products updated Successfully";
}
return returnMessage;
}
catch (Exception ex)
{
throw ex;
}
}