protected void grdBookDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        setStateGridview();
        SpecimanDetails _objsd1 = new SpecimanDetails();

        SpecID = Convert.ToInt32(((Label)grdBookDetails.Rows[e.RowIndex].FindControl("lblspecDetailID")).Text);

        try
        {
            if (SpecID != 0)
            {
                _objsd1.SpecimenDetailID = SpecID;
                _objsd1.IsActive         = false;
                _objsd1.Amount           = 0;
                _objsd1.Rate             = 0;
                _objsd1.Discount         = 0;
                _objsd1.Save();
            }

            DataTable dt1 = new DataTable();
            dt1 = (DataTable)Session["tempBookData"];
            dt1.Rows[e.RowIndex].Delete();
            grdBookDetails.DataSource = dt1;
            grdBookDetails.DataBind();
            Session["tempBookData"] = dt1;
            loder("Successfully Deleted...");
        }
        catch
        {
        }
    }
    public void SaveSpecimanDetails(int docNo)
    {
        setStateGridview();

        DataTable dt1 = new DataTable();

        dt1 = (DataTable)Session["tempBookData"];
        grdBookDetails.DataSource = dt1;
        grdBookDetails.DataBind();


        SpecimanDetails _objSD = new SpecimanDetails();

        XmlDocument doc   = new XmlDocument();
        XmlNode     inode = doc.CreateElement("f");
        XmlNode     fnode = doc.CreateElement("r");

        foreach (GridViewRow row in grdBookDetails.Rows)
        {
            XmlNode element = doc.CreateElement("i");

            _objSD.SpecimenDetailID = Convert.ToInt32(((Label)row.FindControl("lblspecDetailID")).Text);
            _objSD.DocumentNo       = docNo;
            _objSD.BookCode         = ((Label)row.FindControl("lblBookCode")).Text;
            _objSD.BookName         = ((Label)row.FindControl("lblBookName")).Text;
            _objSD.Standard         = ((Label)row.FindControl("lblStandard")).Text;
            _objSD.Medium           = ((Label)row.FindControl("lblMedium")).Text;
            Reqty           = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text);
            givqty          = Convert.ToInt32(((Label)row.FindControl("lblgivedqty")).Text);
            _objSD.Quantity = Reqty + givqty;

            _objSD.Rate = Convert.ToDecimal(((Label)row.FindControl("lblRate")).Text);
            if (((Label)row.FindControl("lblAmt")).Text != "")
            {
                _objSD.Amount = Convert.ToDecimal(((Label)row.FindControl("lblAmt")).Text);
            }
            else
            {
                _objSD.Amount = 0;
            }
            _objSD.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtDiscount")).Text);
            //_objSD.Publisher = ((Label)row.FindControl("lblPublisher")).Text;
            _objSD.IsActive = true;
            _objSD.Save();

            inode           = doc.CreateElement("bsi");
            inode.InnerText = Convert.ToInt32(((TextBox)row.FindControl("txtbooksetid")).Text).ToString();
            element.AppendChild(inode);

            inode           = doc.CreateElement("q");
            inode.InnerText = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text).ToString();
            element.AppendChild(inode);

            fnode.AppendChild(element);
        }
        xmlstr = fnode.OuterXml.ToString();
    }
Example #3
0
    public void SaveSpecimanDetails(int docNo)
    {
        setStateGridview();

        DataTable dt1 = new DataTable();

        dt1 = (DataTable)Session["tempBookData"];
        grdBookDetails.DataSource = dt1;
        grdBookDetails.DataBind();


        SpecimanDetails _objSD = new SpecimanDetails();

        foreach (GridViewRow row in grdBookDetails.Rows)
        {
            _objSD.SpecimenDetailID = Convert.ToInt32(((Label)row.FindControl("lblspecDetailID")).Text);
            _objSD.DocumentNo       = docNo;
            _objSD.BookCode         = ((Label)row.FindControl("lblBookCode")).Text;
            _objSD.BookName         = ((Label)row.FindControl("lblBookName")).Text;
            _objSD.Standard         = ((Label)row.FindControl("lblStandard")).Text;
            _objSD.Medium           = ((Label)row.FindControl("lblMedium")).Text;
            Reqty           = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text);
            givqty          = Convert.ToInt32(((Label)row.FindControl("lblgivedqty")).Text);
            _objSD.Quantity = Reqty + givqty;

            _objSD.Rate = Convert.ToDecimal(((Label)row.FindControl("lblRate")).Text);
            if (((Label)row.FindControl("lblAmt")).Text != "")
            {
                _objSD.Amount = Convert.ToDecimal(((Label)row.FindControl("lblAmt")).Text);
            }
            else
            {
                _objSD.Amount = 0;
            }
            _objSD.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtDiscount")).Text);
            //_objSD.Publisher = ((Label)row.FindControl("lblPublisher")).Text;
            _objSD.IsActive = true;
            _objSD.Save();
        }
    }