void PrintAction(Item item)
{
System.Console.WriteLine("Performing action on " + item.ToString());
}
// ----------------------------------------------------------------------------
// Processes the given Item.
// ----------------------------------------------------------------------------
private StarTeam.Item RunItem(Server stServer, Project stProject, StarTeam.View stView, Item.Type stType, Folder stFolder, Item stItem)
{
StarTeam.Item item = null;
File temp = (File)stItem;
if (temp.Name == "revision.txt")
item = stItem;
if (stItem.ToString() == "revision.txt")
item = stItem;
return item;
}
public static void refreshData()
{
items.Clear();
int index = 0;
try
{
SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.IV00101 ORDER BY ITEMNMBR", connection);
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
while (reader.Read())
{
Item i = new Item();
i.itemcode = reader["ITEMNMBR"].ToString().Trim();
i.itemname = reader["ITEMDESC"].ToString().Trim();
i.pricegroup = reader["PriceGroup"].ToString().Trim();
string temp = reader["STNDCOST"].ToString();
i.cost = Convert.ToDouble(temp);
items.Add(i);
table.Add(i.ToString(), index);
index++;
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine("Oops! " + e.ToString());
}
try
{
SqlCommand cmd2 = new SqlCommand("SELECT * FROM dbo.IV00108 WHERE PRCLEVEL = 'RETAIL' ORDER BY ITEMNMBR", connection);
SqlDataReader reader2 = null;
reader2 = cmd2.ExecuteReader();
while (reader2.Read())
{
Price p = new Price();
String tempItemNumber = "";
tempItemNumber = reader2["ITEMNMBR"].ToString().Trim();
p.uofm = reader2["UOFM"].ToString().Trim();
p.Toqty = Convert.ToDouble(reader2["TOQTY"].ToString().Trim());
p.Fromqty = Convert.ToDouble(reader2["FROMQTY"].ToString().Trim());
p.Uomprice = Convert.ToDouble(reader2["UOMPRICE"].ToString().Trim());
p.Qtybsoum = Convert.ToDouble(reader2["QTYBSUOM"].ToString().Trim());
Item found = items.Find(delegate(Item it) { return it.itemcode.Equals(tempItemNumber); });
found.priceList.prices.Add(p);
}
reader2.Close();
}
catch (Exception e)
{
Console.WriteLine("Oops! " + e.ToString());
}
}
private StarTeam.Item FindItem(Server stServer, Project stProject, StarTeam.View stView, Item.Type stType, Folder stFolder, Item stItem, String fileName)
{
StarTeam.Item item = null;
File temp = (File)stItem;
if (temp.Name == fileName)
item = stItem;
if (stItem.ToString() == fileName)
item = stItem;
return item;
}
