public void ChangeItemNumberTest()
{
ChangeItemNumber cin = new ChangeItemNumber();
cin.ItemID = GetItemID();
cin.NewItemNumber = "TESTNUMBER2";
cin.IsTest = "1";
int result = controller.ChangeItemNumber(cin);
Assert.AreEqual(result, 1);
}
public int ChangeItemNumber(ChangeItemNumber cin)
{
SqlConnection connection = new SqlConnection(Connection.connectionString());
SqlCommand command = new SqlCommand("usp_changeItemNumber");
command.CommandType = CommandType.StoredProcedure;
if (cin.IsTest == "0")
{
XmlDocument doc = new XmlDocument();
doc.Load("http://open.api.ebay.com/shopping?callname=GetSingleItem&responseencoding=XML&appid=GregoryM-mailer-PRD-a45ed6035-97c14545&siteid=0&version=967&ItemID=" + cin.NewItemNumber);
string title;
try
{
title = ((XmlElement)doc.GetElementsByTagName("GetSingleItemResponse")[0]).GetElementsByTagName("Title")[0].InnerText;
}
catch
{
title = "No Title Found";
}
ChangeItemTitle(int.Parse(cin.ItemID), title);
}
else
{
ChangeItemTitle(int.Parse(cin.ItemID), "TESTITEMTITLE");
}
command.Parameters.Add(new SqlParameter("@ItemID", cin.ItemID));
command.Parameters.Add(new SqlParameter("@NewItemNumber", cin.NewItemNumber));
command.Connection = connection;
connection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
connection.Close();
if (table.Rows.Count > 0 && table.Rows[0][0].ToString() == cin.NewItemNumber)
{
return(1);
}
else
{
return(0);
}
}
