public string AddBook(string BookGenre, string Name,string AuthorName,string Series,string Publisher,DateTime PublishDate,int NoOfCopies,int Cost)
        {
            if (ModelState.IsValid)
            {
                AdminBookDAL dalObj = new AdminBookDAL();
                AddBookViewModel bookObject = new AddBookViewModel();
                bookObject = dalObj.AddBook(BookGenre,Name,AuthorName,Series,Publisher,PublishDate,NoOfCopies,Cost);
                if (bookObject != null)
                {
                    if (bookObject.DataError== null)
                    {
                        ViewBag.message = "Book ID " + bookObject.BookId;
                    }
                    else
                    {
                        ViewBag.message = "-1";
                    }
                    return bookObject.BookId.ToString();
                }

            }
            return "false";
        }
        public AddBookViewModel AddBook(string BookGenre, string Name,string AuthorName,string Series,string Publisher,DateTime PublishDate,int NoOfCopies,int Cost)
        {
            //bool status = false;
            string conStr = ConfigurationManager.ConnectionStrings["ConnectToStopNShopDatabase"].ConnectionString;
            SqlConnection conn = new SqlConnection(conStr);
            AddBookViewModel bookObj = new AddBookViewModel();
            try
            {
                conn.Open();

                SqlCommand check = new SqlCommand("select count(*) from Books where BookGenre=@bookGenre and Name=@bookName and AuthorName=@authorName and Series=@series and Publisher=@publisher and PublishDate=@publishDate and NoOfCopies=@noOfCopies and Cost=@cost", conn);
                check.Parameters.AddWithValue("bookGenre", BookGenre);
                check.Parameters.AddWithValue("bookName", Name);
                check.Parameters.AddWithValue("authorName", AuthorName);
                check.Parameters.AddWithValue("series", Series);
                check.Parameters.AddWithValue("publisher", Publisher);
                check.Parameters.AddWithValue("publishDate", PublishDate);
                check.Parameters.AddWithValue("noOfCopies", NoOfCopies);
                check.Parameters.AddWithValue("cost", Cost);

                int num = (int)check.ExecuteScalar();

                if (num == 0)
                {
                    SqlCommand cmd = new SqlCommand("insert into Books values (@bookGenre,@bookName,@authorName,@series,@publisher,@publishDate,@noOfCopies,@cost)", conn);
                    cmd.Parameters.AddWithValue("bookGenre", BookGenre);
                    cmd.Parameters.AddWithValue("bookName", Name);
                    cmd.Parameters.AddWithValue("authorName", AuthorName);
                    cmd.Parameters.AddWithValue("series", Series);
                    cmd.Parameters.AddWithValue("publisher", Publisher);
                    cmd.Parameters.AddWithValue("publishDate", PublishDate);
                    cmd.Parameters.AddWithValue("noOfCopies", NoOfCopies);
                    cmd.Parameters.AddWithValue("cost", Cost);
                    int res = cmd.ExecuteNonQuery();
                    //status = true;
                    SqlCommand id = new SqlCommand("select Id from Books where BookGenre=@bookGenre and Name=@bookName and AuthorName=@authorName and Series=@series and Publisher=@publisher and PublishDate=@publishDate and NoOfCopies=@noOfCopies and Cost=@cost", conn);
                    id.Parameters.AddWithValue("bookGenre", BookGenre);
                    id.Parameters.AddWithValue("bookName", Name);
                    id.Parameters.AddWithValue("authorName", AuthorName);
                    id.Parameters.AddWithValue("series", Series);
                    id.Parameters.AddWithValue("publisher", Publisher);
                    id.Parameters.AddWithValue("publishDate", PublishDate);
                    id.Parameters.AddWithValue("noOfCopies", NoOfCopies);
                    id.Parameters.AddWithValue("cost", Cost);
                    var reader = id.ExecuteReader();
                    if (reader.HasRows)
                    {
                        reader.Read();

                        bookObj.BookId = Convert.ToInt32(reader[0]);
                        bookObj.DataError = null;

                    }
                }
                else
                {
                    bookObj = new AddBookViewModel();
                    bookObj.BookId = -1;
                }
            }
            catch (Exception exc)
            {
                HttpContext.Current.Session["ErrorMessage"] = exc.Message;
            }
            conn.Close();
            return bookObj;
        }