示例#1
0
        private int MaxBookId()
        {
            int output = 0;

            using (GuramDBEntities _ctx = new GuramDBEntities())
            {
                var ids   = _ctx.Books.Select(c => c.Id).ToList();
                var maxId = ids.Count == 0 ? 0 : ids.Max();


                output = maxId + 1;
            }
            return(output);
        }
示例#2
0
        public Form1()
        {
            InitializeComponent();
            using (var _ctx = new GuramDBEntities())
            {
                _ctx.Database.CommandTimeout = 200;
                comboBox1.DataSource         = _ctx.Authors.Select(y => y.Name).ToList();
                comboBox1.SelectedIndex      = -1;
            }


            using (var _ctx = new GuramDBEntities())
            {
                _ctx.Database.CommandTimeout = 200;
                comboBox2.DataSource         = _ctx.Books.Select(y => y.Name).ToList();
                comboBox2.SelectedIndex      = -1;
            }


            using (var _ctx = new GuramDBEntities())
            {
                _ctx.Database.CommandTimeout = 200;
                comboBox3.DataSource         = _ctx.Genres.Select(y => y.Name).ToList();
                comboBox3.SelectedIndex      = -1;
            }


            using (var _ctx = new GuramDBEntities())
            {
                _ctx.Database.CommandTimeout = 200;
                comboBox4.DataSource         = _ctx.Countries.Select(y => y.Name).ToList();
                comboBox4.SelectedIndex      = -1;
            }

            //comboBox7.Enabled = false;
            //comboBox6.Enabled = false;
            //comboBox5.Enabled = false;
        }
示例#3
0
        private void button1_Click(object sender, EventArgs e)
        {
            var name           = comboBox1.Text;
            var book           = comboBox2.Text;
            var genre          = comboBox3.Text;
            var country        = comboBox4.Text;
            var inputYear      = comboBox7.Text;
            var inputStartDate = comboBox5.Text;
            var inputEndDate   = comboBox6.Text;

            int yearResult = 0;
            int?year       = null;

            if (comboBox7.Text == string.Empty)
            {
                year = null;
            }
            else
            {
                if (Int32.TryParse(comboBox7.Text, out yearResult))
                {
                    year = yearResult;
                }
                else
                {
                    throw new Exception("გთხოვთ შეიყვანოთ სწორი წელი");
                }
            }



            int startDateResult = 0;
            int?startDate       = null;

            if (inputStartDate == string.Empty)
            {
                startDate = null;
            }
            else
            {
                if (Int32.TryParse(inputStartDate, out startDateResult))
                {
                    startDate = startDateResult;
                }
                else
                {
                    throw new Exception("გთხოვთ შეიყვანოთ სწორი წელი");
                }
            }



            int endDateResult = 0;
            int?endDate       = null;

            if (inputEndDate == string.Empty)
            {
                endDate = null;
            }
            else
            {
                if (Int32.TryParse(inputEndDate, out endDateResult))
                {
                    endDate = endDateResult;
                }
                else
                {
                    throw new Exception("გთხოვთ შეიყვანოთ სწორი წელი");
                }
            }

            #region
            //void Disabler()
            //{
            //    if (comboBox1.Text == string.Empty)
            //    {
            //        comboBox1.Enabled = false;
            //    }
            //    if (comboBox2.Text == string.Empty)
            //    {
            //        comboBox2.Enabled = false;
            //    }
            //    if (comboBox2.Text == string.Empty)
            //    {
            //        comboBox2.Enabled = false;
            //    }
            //    if (comboBox3.Text == string.Empty)
            //    {
            //        comboBox3.Enabled = false;
            //    }
            //    if (comboBox4.Text == string.Empty)
            //    {
            //        comboBox4.Enabled = false;
            //    }
            //    if (comboBox5.Text == string.Empty)
            //    {
            //        comboBox5.Enabled = false;
            //    }
            //    if (comboBox6.Text == string.Empty)
            //    {
            //        comboBox6.Enabled = false;
            //    }
            //    if (comboBox7.Text == string.Empty)
            //    {
            //        comboBox7.Enabled = false;
            //    }

            //}


            //void Enabler()
            //{
            //    comboBox1.Enabled = true;
            //    comboBox2.Enabled = true;
            //    comboBox3.Enabled = true;
            //    comboBox4.Enabled = true;
            //    comboBox5.Enabled = true;
            //    comboBox6.Enabled = true;
            //    comboBox7.Enabled = true;
            //}
            #endregion


            var specificBookForAuthor = new List <Book>();

            using (var _context = new GuramDBEntities())
            {
                _context.Database.CommandTimeout = 200;

                var First = name.Split(' ').First();
                var Last  = name.Remove(0, First.Length).TrimStart();



                specificBookForAuthor = _context.Books.Where(c =>
                                                             (c.Author.Name.Contains(First) || c.Author.Surname.Contains(Last)) &&
                                                             c.Name.Contains(book) &&
                                                             c.Author.Country.Name.Contains(country) &&
                                                             c.Genre.Name.Contains(genre)
                                                             //&& inputYear == string.Empty ? true : c.Year == year
                                                             //&& inputStartDate == string.Empty ? true : c.Year >= startDate
                                                             //&& inputEndDate == string.Empty ? true : c.Year <= endDate
                                                             ).Select(b => b).ToList();



                //specificBookForAuthor = _context.Books.Where(c =>
                //                                                    (c.Author.Name.Contains(First) || c.Author.Surname.Contains(Last))
                //                                                    && book == string.Empty ? true : c.Name.Contains(book)
                //                                                    && country == string.Empty ? true : c.Author.Country.Name.Contains(country)
                //                                                    && genre == string.Empty ? true : c.Genre.Name.Contains(genre)
                //                                                    //&& inputYear == string.Empty ? true : c.Year == year
                //                                                    //&& inputStartDate == string.Empty ? true : c.Year >= startDate
                //                                                    //&& inputEndDate == string.Empty ? true : c.Year <= endDate
                //                                                    ).Select(b => b).ToList();


                richTextBox1.Clear();

                foreach (var item in specificBookForAuthor)
                {
                    richTextBox1.AppendText($"Author :{item.Author.Name} {item.Author.Surname} \nBook : {item.Name}, \nGenre : {item.Genre.Name}, \nCountry : {item.Author.Country.Name} \nYear:{item.Year}  \n----------------------------------------------------\n");
                }
            }
        }
示例#4
0
        //ADD
        private void ADD_Click(object sender, EventArgs e)
        {
            var author  = comboBox1.Text;
            var book    = comboBox2.Text;
            var genre   = comboBox3.Text;
            var country = comboBox4.Text;
            var year    = Int32.Parse(comboBox7.Text);

            int?checkauthor;
            int?checkbook;
            int?checkgenre;
            int?checkcountry;


            var First = author.Split(' ').First();
            var Last  = author.Remove(0, First.Length).TrimStart();

            var FirstLast = First + Last;

            using (var _ctx = new GuramDBEntities())
            {
                checkauthor  = _ctx.Authors.Where(c => (c.Name.ToLower() + c.Surname.ToLower()) == FirstLast.ToLower()).Select(a => a.Id).FirstOrDefault();
                checkbook    = _ctx.Books.Where(c => c.Name.ToLower() == book.ToLower()).Select(a => a.Id).FirstOrDefault();
                checkgenre   = _ctx.Genres.Where(c => c.Name.ToLower() == genre.ToLower()).Select(a => a.Id).FirstOrDefault();
                checkcountry = _ctx.Countries.Where(c => c.Name.ToLower() == country.ToLower()).Select(a => a.Id).FirstOrDefault();
            }
            Country newCountry = new Country();


            Random rand = new Random();

            if (checkcountry == 0)
            {
                newCountry = new Country()
                {
                    Id   = MaxCountryId(),
                    Name = country
                };

                using (var _context = new GuramDBEntities())
                {
                    _context.Countries.Add(newCountry);

                    _context.SaveChanges();
                }

                checkcountry = newCountry.Id;
            }

            Author newAuthor = new Author();

            if (checkauthor == 0)
            {
                newAuthor = new Author()
                {
                    Id        = MaxAuthorId(),
                    Name      = First,
                    Surname   = Last,
                    CountryId = checkcountry
                };

                using (var _context = new GuramDBEntities())
                {
                    _context.Authors.Add(newAuthor);

                    _context.SaveChanges();
                }

                checkauthor = newAuthor.Id;
            }


            Genre newGenre = new Genre();

            if (checkgenre == 0)
            {
                newGenre = new Genre()
                {
                    Id   = MaxGenreId(),
                    Name = genre,
                };

                using (var _context = new GuramDBEntities())
                {
                    _context.Genres.Add(newGenre);

                    _context.SaveChanges();
                }

                checkgenre = newGenre.Id;
            }

            Book newBook = new Book();

            if (checkbook == 0)
            {
                newBook = new Book()
                {
                    Id       = MaxBookId(),
                    Name     = book,
                    GenreId  = checkgenre,
                    AuthorId = checkauthor,
                    Year     = year
                };

                using (var _context = new GuramDBEntities())
                {
                    _context.Books.Add(newBook);

                    _context.SaveChanges();
                }

                checkbook = newBook.Id;
            }
        }