Example #1
0
        /// <summary>
        /// Receives a HashTable of Element objects that is received
        /// from the XMLParser class, breaks down the Elements that are relevant,
        /// and fills necessary text boxes
        /// </summary>
        /// <param name="table"></param>
        public Constants.XMLResultReturnValue FillFromXMLResults(Element element)
        {
            Element bookListElement = element.GetFirstElementOf("BookList");
            Element bookDataElement = element.GetFirstElementOf("BookData");
            Element titleElement = element.GetFirstElementOf("Title");
            Element titleLongElement = element.GetFirstElementOf("TitleLong");
            Element authorsTextElement = element.GetFirstElementOf("Authors");
            Element authorElement = element.GetFirstElementOf("AuthorsText");
            Element publisherTextElement = element.GetFirstElementOf("PublisherText");
            Element detailsElement = element.GetFirstElementOf("Details");
            Element summaryElement = element.GetFirstElementOf("Summary");
            Element notesElement = element.GetFirstElementOf("Notes");
            Element awardsTextElement = element.GetFirstElementOf("AwardsText");
            Element urlsTextElement = element.GetFirstElementOf("UrlsText");
            Element editorsElement = element.GetFirstElementOf("EditorsText");
            Element subjectsElement = element.GetFirstElementOf("Subjects");
            Element pricesElement = element.GetFirstElementOf("Prices");

            if (bookListElement.GetAttribute("total_results").Equals("0"))
                return Constants.XMLResultReturnValue.NOT_FOUND; 
           
            this.Id = bookDataElement.GetAttribute("book_id");
            this.ISBN = bookDataElement.GetAttribute("isbn");
            this.ShortTitle = titleElement.Value;
            this.LongTitle = titleLongElement.Value;
            this.PublisherInfo = publisherTextElement.Value;
            this.PublisherId = publisherTextElement.GetAttribute("publisher_id");
            this.PhysicalDescription = detailsElement.GetAttribute("physical_description_text");
            this.Language = detailsElement.GetAttribute("language");
            this.Dewey = detailsElement.GetAttribute("dewey_decimal");
            this.DeweyNormalized = detailsElement.GetAttribute("dewey_decimal_normalized");
            this.Edition = detailsElement.GetAttribute("edition_info");
            this.LibraryOfCongress = detailsElement.GetAttribute("lcc_number");
            this.Summary = summaryElement.Value;
            this.Notes = notesElement.Value;
            //do subject info
            this.Urls = urlsTextElement.Value;
            this.Awards = awardsTextElement.Value;

            //if there isn't any person elements, we do the best we can with what we have
            if (authorsTextElement.Children.Count == 0 && !authorElement.Value.Equals(""))
            {
                Person p = new Person();
                p.FirstName = Person.GetFirstNameFromPersonValue(authorElement.Value);
                p.LastName = Person.GetLastNameFromPersonValue(authorElement.Value);
                p.Id = Utils.CreateIdFromString(authorElement.Value);
                this.Authors.Add(p);
            }
            else
            {
                foreach (Element child in authorsTextElement.FindChildElements("Person"))
                {
                    Person p = new Person();
                    p.FillFromElement(child);
                    this.Authors.Add(p);
                }
            }

            if (editorsElement.Children.Count == 0 && !editorsElement.Value.Equals(""))
            {
                Person p = new Person();
                p.FirstName = Person.GetFirstNameFromPersonValue(editorsElement.Value);
                p.LastName = Person.GetLastNameFromPersonValue(editorsElement.Value);
                p.Id = Utils.CreateIdFromString(editorsElement.Value);
                this.Editors.Add(p);
            }
            else
            {
                foreach (Element child in editorsElement.FindChildElements("Person"))
                {
                    Person p = new Person();
                    p.FillFromElement(child);
                    this.Editors.Add(p);
                }
            }

            foreach (Element subject in subjectsElement.FindChildElements("Subject"))
            {
                Subject s = new Subject();
                s.Id = subject.GetAttribute("subject_id");
                s.Name = subject.Value;
                this.Subjects.Add(s);
            }

            int newCount = 0;
            int usedCount = 0;
            double newTotal = 0.0;
            double usedTotal = 0.0;
            foreach (Element price in pricesElement.FindChildElements("Price"))
            {
                string val = price.GetAttribute("price");
                string isNew = price.GetAttribute("is_new");
                if(isNew.Equals("1"))
                {
                    try
                    {
                        newTotal += Double.Parse(val);
                        newCount++;
                    }
                    catch(Exception e)
                    {
                    	Log.Instance.Out(e);
                    }
                }
                else if (isNew.Equals("0"))
                {
                    try
                    {
                        usedTotal += Double.Parse(val);
                        usedCount++;
                    }
                    catch (Exception e)
                    {
                    	Log.Instance.Out(e);
                    }
                }
            }
            double newAvg = newTotal / newCount;
            double usedAvg = usedTotal / usedCount;
          
            this.NewPrice = newAvg.ToString("C");
            this.UsedPrice = usedAvg.ToString("C");

            if (this.NewPrice.Contains("NaN"))
                this.NewPrice = "";

            if (this.UsedPrice.Contains("NaN"))
                this.UsedPrice = "";

            return Constants.XMLResultReturnValue.SUCCESS;
        }
        /// <summary>
        /// Receives a DataSet, and fills the domain objects Properties from it
        /// </summary>
        /// <param name="ds"></param>
        /// <param name="book"></param>
        /// <returns></returns>
        public bool FillBookFromDataSet(DataSet ds, Book book)
        {
            if (ds == null || ds.Tables[0].Rows.Count < 1)
                return false;
            DataRow dr = ds.Tables[0].Rows[0];

            book.Id = dr["id"].ToString();
            book.ISBN = dr["isbn"].ToString();
            book.Language = dr["language"].ToString();
            book.LibraryOfCongress = dr["lcc_number"].ToString();
            book.LongTitle = dr["long_title"].ToString();
            book.Notes = dr["notes"].ToString();
            book.PhysicalDescription = dr["physical_desc"].ToString();
            book.PublisherId = dr["publisher_id"].ToString();
            book.ShortTitle = dr["short_title"].ToString();
            book.Summary = dr["summary"].ToString();
            book.Urls = dr["urls"].ToString();
            book.NewPrice = dr["new_price"].ToString();
            book.UsedPrice = dr["used_price"].ToString();
            book.PricePaid = dr["price_paid"].ToString();

            //get book_subject data
            DataSet subjectDS = this.ExecuteQuery(SQL.Subject.SELECT_BY_BOOK_ID, new object[] { book.Id });
            if (subjectDS != null)
                foreach (DataRow dr1 in subjectDS.Tables[0].Rows)
                {
                    Subject s = new Subject();
                    s.Id = dr1["id"].ToString();
                    s.Name = dr1["subject"].ToString();
                    book.Subjects.Add(s);
                }

            //get publisher data
            DataSet publisherDS = this.ExecuteQuery(SQL.Publisher.SELECT_PUBLISHER_BY_ID, new object[] { book.PublisherId });
            if (publisherDS != null)
                foreach (DataRow dr2 in publisherDS.Tables[0].Rows)
                {
                    book.PublisherInfo = dr2["publisher_info"].ToString();
                }

            //get author data
            DataSet authorDS = this.ExecuteQuery(SQL.Person.SELECT_AUTHORS_BY_BOOK_ID, new object[] { book.Id });
            if (authorDS != null)
                foreach (DataRow dr3 in authorDS.Tables[0].Rows)
                {
                    Person p = new Person();
                    p.Id = dr3["id"].ToString();
                    p.FirstName = dr3["first_name"].ToString();
                    p.LastName = dr3["last_name"].ToString();
                    book.Authors.Add(p);
                }

            //get editor data
            DataSet editorDS = this.ExecuteQuery(SQL.Person.SELECT_EDITORS_BY_BOOK_ID, new object[] { book.Id });
            if (editorDS != null)
                foreach (DataRow dr4 in editorDS.Tables[0].Rows)
                {
                    Person p = new Person();
                    p.Id = dr4["id"].ToString();
                    p.FirstName = dr4["first_name"].ToString();
                    p.LastName = dr4["last_name"].ToString();
                    book.Editors.Add(p);
                }
            return true;
        }
        private void fillDataFromForm()
        {
            string[] authors = this.txtAuthors.Text.Replace("\r\n",";").Split(new char[]{ ';' });
            string[] editors = this.txtEditors.Text.Replace("\r\n", ";").Split(new char[] { ';' });
            string[] subjects = this.txtSubjects.Text.Replace("\r\n", ";").Split(new char[] { ';' });
            
            _book.Authors.Clear();
            _book.Editors.Clear();
            _book.Subjects.Clear();
            
            foreach(string s in authors)
            {
                if(s.Equals("")) 
                    continue;
                Person p = new Person();
                p.FirstName = Person.GetFirstNameFromFull(s);
                p.LastName = Person.GetLastNameFromFull(s);
                p.Id = Utils.CreateIdFromString(p.FullName);
                _book.Authors.Add(p);
            }

            foreach (string s in editors)
            {
                if (s.Equals(""))
                    continue;
                Person p = new Person();
                p.FirstName = Person.GetFirstNameFromFull(s);
                p.LastName = Person.GetLastNameFromFull(s);
                p.Id = Utils.CreateIdFromString(p.FullName);
                _book.Editors.Add(p);
            }

            foreach (string s in subjects)
            {
                if (s.Equals(""))
                    continue;
                Subject su = new Subject();
                su.Name = s;
                su.Id = Utils.CreateIdFromString(s);
                _book.Subjects.Add(su);
            }

            _book.ShortTitle = this.txtShortTitle.Text.Trim();
            _book.LongTitle = this.txtLongTitle.Text.Trim();
            _book.ISBN = this.txtISBN.Text;
            _book.Language = this.txtLanguage.Text;
            _book.LibraryOfCongress = this.txtLCC.Text;
            _book.Notes = this.txtNotes.Text;
            _book.PhysicalDescription = this.txtPhysDesc.Text;
            _book.PublisherInfo = this.txtPublisher.Text;
            if (!_book.PublisherInfo.Equals(""))
                _book.PublisherId = Utils.CreateIdFromString(_book.PublisherInfo);

            _book.Summary = this.txtSummary.Text;
            _book.Urls = this.txtURLs.Text;
            _book.Awards = this.txtAwards.Text;
            _book.DateAdded = DateTime.Now.ToShortDateString();
            _book.Dewey = this.txtDewey.Text;
            _book.NewPrice = this.txtNewPrice.Text;
            _book.UsedPrice = this.txtUsedPrice.Text;
            _book.PricePaid = this.txtPricePaid.Text;
            _book.DeweyNormalized = this.txtDeweyNorm.Text;
            _book.Edition = this.txtEdition.Text;
            string title = this.txtShortTitle.Text.Equals("") ? this.txtLongTitle.Text : this.txtShortTitle.Text;
            _book.Id = Utils.CreateIdFromString(title);
        }