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); } }