protected void btnSave_Click(object sender, EventArgs e)
        {
            string act = Request.QueryString["act"];

            BLibraryPro.BookLot BBookLot = new BLibraryPro.BookLot();
            BBookLot.BookCode = Convert.ToInt32(ddlBookCode.SelectedValue);
            BBookLot.EditionCode = ddlEdition.SelectedValue;
            BBookLot.YearOfPublication = Convert.ToInt32(txtYearOfPublication.Text);
            BBookLot.ISBN = txtIsbn.Text;
            BBookLot.Price = float.Parse(txtPrice.Text);
            BBookLot.NoOfPage = Convert.ToInt32(txtPages.Text);
            BBookLot.SourceTypeCode = ddlSource.SelectedValue;

            BBookLot.NoOfBooks = Convert.ToInt32(txtNoOfBooks.Text);

            if (act == "add")
            {
                BBookLot.ReceivedOn = DateTime.Now;
                msgBox.Message = BBookLot.SaveBookLot(Session["login_user"].ToString(), Request.QueryString["AuthorId"]);
            }
            else if (act == "edit")
            {
                BBookLot.BookLotNo = Convert.ToInt32(Request.QueryString["code"]);
                msgBox.Message = BBookLot.UpdateBookLot();

            }
            else if (act == "del")
            {
                BBookLot.BookLotNo = Convert.ToInt32(Request.QueryString["code"]);
                msgBox.Message = BBookLot.DeleteBookLot();
            }
            Response.Redirect("~/GUI/Setup/BookLot.aspx?act=list");
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                string act = Request.QueryString["act"];
                if (act == "edit")
                {
                    string code = Request.QueryString["code"];
                    BLibraryPro.BookLot BookLotBLL = new BLibraryPro.BookLot(code);
                    txtYearOfPublication.Text = BookLotBLL.YearOfPublication.ToString();
                    txtIsbn.Text = BookLotBLL.ISBN;
                    txtPrice.Text = BookLotBLL.Price.ToString();
                    txtPages.Text = BookLotBLL.NoOfPage.ToString();
                    txtNoOfBooks.Text = BookLotBLL.NoOfBooks.ToString();

                    DataTable dtEdition = BLibraryPro.Edition.GetEditions("");
                    ddlEdition.DataSource = dtEdition;
                    ddlEdition.DataTextField = "EDITION_DESC";
                    ddlEdition.DataValueField = "EDITION_CODE";
                    ddlEdition.DataBind();
                    ddlEdition.Items.Insert(0, new ListItem("Please Select Edition", "0"));
                    ddlEdition.SelectedValue = BookLotBLL.EditionCode;

                    DataTable dtBook = BLibraryPro.Book.GetBooks("");
                    ddlBookCode.DataSource = dtBook;
                    ddlBookCode.DataTextField = "BOOK_DESC";
                    ddlBookCode.DataValueField = "BOOK_CODE";
                    ddlBookCode.DataBind();
                    ddlBookCode.Items.Insert(0, new ListItem("Please Select Edition", "0"));
                    ddlBookCode.SelectedValue = BookLotBLL.BookCode.ToString();

                    DataTable dtSource = BLibraryPro.BookSource.GetSources("");
                    ddlSource.DataSource = dtSource;
                    ddlSource.DataTextField = "SOURCE_DESC";
                    ddlSource.DataValueField = "SOURCE_TYPE_CODE";
                    ddlSource.DataBind();
                    ddlSource.Items.Insert(0, new ListItem("Please Select Source", "0"));
                    ddlSource.SelectedValue = BookLotBLL.SourceTypeCode;

                    if (Request.QueryString["view"]=="true")
                    {
                        ddlBookCode.Enabled = false;
                        ddlEdition.Enabled = false;
                        ddlSource.Enabled = false;
                        txtIsbn.ReadOnly = true;
                        txtNoOfBooks.ReadOnly = true;
                        txtPages.ReadOnly = true;
                        txtPrice.ReadOnly = true;
                        txtYearOfPublication.ReadOnly = true;
                    }

                }
                else if (act == "del")
                {
                    string code = Request.QueryString["code"];
                    BLibraryPro.BookLot BookLotBLL = new BLibraryPro.BookLot(code);
                    BookLotBLL.BookLotNo = Convert.ToInt32(code);
                    BookLotBLL.DeleteBookLot();
                    Response.Redirect("~/GUI/Setup/BookLot.aspx?act=list&show=1");
                }
                else if (act == "list")
                {
                    if (Request.QueryString["show"] == "1")
                    {
                        btnFilter_Click(sender, new EventArgs());
                    }
                    btnFilter_Click(sender, new EventArgs());
                }
                else if (act == "add")
                {
                    DataTable dtEdition = BLibraryPro.Edition.GetEditions("");
                    ddlEdition.DataSource = dtEdition;
                    ddlEdition.DataTextField = "EDITION_DESC";
                    ddlEdition.DataValueField = "EDITION_CODE";
                    ddlEdition.DataBind();
                    ddlEdition.Items.Insert(0, new ListItem("Please Select Edition", "0"));
                    ddlEdition.SelectedValue ="0";

                    DataTable dtBook = BLibraryPro.Book.GetDDLBooks("");
                    ddlBookCode.DataSource = dtBook;
                    ddlBookCode.DataTextField = "BOOK_DESC";
                    ddlBookCode.DataValueField = "BOOK_CODE";
                    ddlBookCode.DataBind();
                    ddlBookCode.Items.Insert(0, new ListItem("Please Select Book", "0"));
                    ddlBookCode.SelectedValue = Request.QueryString["BookId"];

                    DataTable dtSource = BLibraryPro.BookSource.GetSources("");
                    ddlSource.DataSource = dtSource;
                    ddlSource.DataTextField = "SOURCE_DESC";
                    ddlSource.DataValueField = "SOURCE_TYPE_CODE";
                    ddlSource.DataBind();
                    ddlSource.Items.Insert(0, new ListItem("Please Select Source", "0"));
                    ddlSource.SelectedValue = "0";
                }
            }
        }