public ActionResult Findid(string id) { BookCRUD.BookCRUDSoapClient client = new BookCRUD.BookCRUDSoapClient("BookCRUDSoap"); object result = client.ReadByID(Int32.Parse(id)); XDocument read = XDocument.Parse(result.ToString()); // Create object XDocument is read for object is gotten to string string id_ = ""; string price = ""; string isbn_13 = ""; string isbn_10 = ""; string title = ""; string author = ""; string year = ""; string category = ""; id_ = read.Element("book").Attribute("ID").Value.ToString(); price = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Price").Single().Value; isbn_13 = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("ISBN-13").Single().Value.ToString(); isbn_10 = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("ISBN-10").Single().Value.ToString(); title = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Title").Single().Value.ToString(); author = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Author").Single().Value.ToString(); year = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Year").Single().Value.ToString(); category = read.Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Category").Single().Value.ToString(); ViewBag.id = id_; ViewBag.isbn13 = isbn_13; ViewBag.title_ = title; ViewBag.isbn10 = isbn_10; ViewBag.author = author; ViewBag.year = year; ViewBag.category = category; ViewBag.price = price; return(View()); }
public void Read(float price_strat, float price_end) { BookCRUD.BookCRUDSoapClient client = new BookCRUD.BookCRUDSoapClient("BookCRUDSoap"); object result = client.Read(); DataTable dt = new DataTable(); // Create source for create table XDocument read = XDocument.Parse(result.ToString()); // Create object XDocument is read for object is gotten to string var count = read.Element("bookstore").Descendants(); // notice count variable for count element of bookstore ArrayList isbn13_list = new ArrayList(); ArrayList isbn10_list = new ArrayList(); ArrayList title_list_ = new ArrayList(); ArrayList author_list = new ArrayList(); ArrayList year_list = new ArrayList(); ArrayList category_list = new ArrayList(); ArrayList price_list = new ArrayList(); ArrayList id_list = new ArrayList(); // Read element of bookstore foreach (XElement item in count) { if (item.Name == "book") //check element == book ? { string id = item.Attribute("ID").Value.ToString(); string price = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Price").Single().Value; float price_float = float.Parse(price); if (price_float >= price_strat && price_float <= price_end) { string isbn_13 = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("ISBN-13").Single().Value.ToString(); string isbn_10 = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("ISBN-10").Single().Value.ToString(); string title = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Title").Single().Value.ToString(); string author = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Author").Single().Value.ToString(); string year = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Year").Single().Value.ToString(); string category = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Category").Single().Value.ToString(); //price = read.Elements("bookstore").Elements("book").Where(x => (string)x.Attribute("ID") == id).Elements("Price").Single().Value; id_list.Add(id); isbn13_list.Add(isbn_13); // add data of a books isbn10_list.Add(isbn_10); title_list_.Add(title); author_list.Add(author); year_list.Add(year); category_list.Add(category); price_list.Add(price); } } } ViewBag.id = id_list; ViewBag.isbn13 = isbn13_list; ViewBag.title_ = title_list_; ViewBag.isbn10 = isbn10_list; ViewBag.author = author_list; ViewBag.year = year_list; ViewBag.category = category_list; ViewBag.price = price_list; }
public ActionResult Delete(string id) { BookCRUD.BookCRUDSoapClient client = new BookCRUD.BookCRUDSoapClient("BookCRUDSoap"); client.Delete(Int32.Parse(id)); return(RedirectToAction("Index")); }
public ActionResult Save(string isbn10, string isbn13, string title, string author, string year, string category, string price) { BookCRUD.BookCRUDSoapClient client = new BookCRUD.BookCRUDSoapClient("BookCRUDSoap"); client.InsertAll(title, price, author, year, category, isbn10, isbn13); return(RedirectToAction("Index")); }
public ActionResult Update(string id, string name, string value) { BookCRUD.BookCRUDSoapClient client = new BookCRUD.BookCRUDSoapClient("BookCRUDSoap"); client.Update_Element(Int32.Parse(id), name, value); return(RedirectToAction("Index")); }