示例#1
0
 private void GetBookInfo()
 {
     try
     {
         ds            = new DataSet();
         objBL         = new BL_IssueBook();
         objEWA        = new EWA_IssueBook();
         objEWA.BookId = Convert.ToInt32(ddlBookName.SelectedValue.ToString());
         ds            = objBL.GetBookInfo_BL(objEWA);
         if (ds.Tables[0].Rows.Count > 0)
         {
             txtAuthor.Text      = ds.Tables[0].Rows[0]["Author"].ToString();
             txtPublisher.Text   = ds.Tables[0].Rows[0]["Publisher"].ToString();
             txtPublishYear.Text = ds.Tables[0].Rows[0]["PublishingYear"].ToString();
             txtEdition.Text     = ds.Tables[0].Rows[0]["Edition"].ToString();
             txtPrice.Text       = ds.Tables[0].Rows[0]["Price"].ToString();
             float stock = db.getDb_Value("select qty from  tblLibAddBook where BookId='" + objEWA.BookId + "' and OrgId='" + Convert.ToInt32(Session["OrgId"]) + "'");
             lblstock.Text = stock.ToString();
         }
         else
         {
             txtAuthor.Text      = "";
             txtPublisher.Text   = "";
             txtPublishYear.Text = "";
             txtEdition.Text     = "";
             txtPrice.Text       = "";
         }
     }
     catch (Exception ex)
     {
     }
 }
示例#2
0
 protected void txtIssueTo_TextChanged(object sender, EventArgs e)
 {
     ds                 = new DataSet();
     objBL              = new BL_IssueBook();
     objEWA             = new EWA_IssueBook();
     objEWA.StudentCode = txtIssueTo.Text.ToString();
     ds                 = objBL.GetStudentInfo_BL(objEWA);
     if (ds.Tables[0].Rows.Count > 0)
     {
         ViewState["StudentId"] = ds.Tables[0].Rows[0]["StudentId"].ToString();
         txtIssueName.Text      = ds.Tables[0].Rows[0]["StdName"].ToString();
     }
     else
     {
         ViewState["StudentId"] = "0";
         txtIssueName.Text      = "";
     }
 }
示例#3
0
 private void GetBookGroup()
 {
     try
     {
         ds                          = new DataSet();
         objBL                       = new BL_IssueBook();
         objEWA.OrgId                = Convert.ToInt32(orgId.ToString());
         ds                          = objBL.GetBookGroup_BL(objEWA);
         ddlGroupName.DataSource     = ds;
         ddlGroupName.DataTextField  = "GroupCode";
         ddlGroupName.DataValueField = "GroupId";
         ddlGroupName.DataBind();
         ddlGroupName.Items.Insert(0, new ListItem("Select", "0"));
     }
     catch (Exception ex)
     {
     }
 }
示例#4
0
 private void GetIsueeBook()
 {
     try
     {
         ds           = new DataSet();
         objBL        = new BL_IssueBook();
         objEWA.OrgId = Convert.ToInt32(orgId.ToString());
         ds           = objBL.GetIsueeBook_BL(objEWA);
         if (ds != null)
         {
             GrdBook.DataSource = ds;
             GrdBook.DataBind();
         }
         GrdBook.EmptyDataText = "Record Not Found ";
         GrdBook.DataBind();
     }
     catch (Exception ex)
     {
     }
 }