Exemplo n.º 1
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            bl.vch_id   = Convert.ToInt32(DropDownList1.SelectedValue.ToString());
            bl.vch_nm   = DropDownList1.SelectedItem.Text;
            bl.inv_no   = txt_inv.Text;
            bl.inv_date = txt_inv_dt.Text;
            bl.comp_nm  = txt_comp_nm.Text;
            int cmp = Convert.ToInt32(dl.slelct_cust_id_bill(bl));
            bl.cust_id    = cmp;
            bl.brock_name = txt_brok_nm.Text;
            int bro = Convert.ToInt32(dl.slelct_brock_id_bill(bl));
            bl.brock_id = bro;
            bl.trp_naem = txt_trp_nm.Text;
            int trp_id = Convert.ToInt32(dl.slelct_transport_id_bill(bl));
            bl.trp_id   = trp_id;
            bl.rn_no    = txt_dc_no.Text;
            bl.l_r_no   = txt_lr_no.Text;
            bl.p_o_no   = txt_pr_no.Text;
            bl.rn_date  = txt_dc_date.Text;
            bl.l_r_date = txt_lr_date.Text;
            bl.p_o_date = txt_po_date.Text;

            if (txt_tax4.Text != string.Empty)
            {
                bl.tax_4 = txt_tax4.Text;
                bl.vat_1 = txt_vat1.Text;
            }
            else
            {
                bl.tax_4 = "";
                bl.vat_1 = "";
            }
            if (txt_txt12.Text != string.Empty)
            {
                bl.tax_12 = txt_txt12.Text;
                bl.vat_2  = txt_vat2.Text;
            }
            else
            {
                bl.tax_12 = "";
                bl.vat_2  = "";
            }
            if (txt_tax2.Text != string.Empty)
            {
                bl.cst_2 = txt_tax2.Text;
            }
            else
            {
                bl.cst_2 = "";
            }
            if (TextBox9.Text != string.Empty)
            {
                bl.disc = TextBox9.Text;
            }
            else
            {
                bl.disc = "";
            }
            TextBox txt_total_qty = (TextBox)grid_array.FooterRow.FindControl("txt_tt");
            TextBox txt_total_net = (TextBox)grid_array.FooterRow.FindControl("txt_ttt");
            bl.total_qty  = txt_total_qty.Text;
            bl.total      = txt_total_net.Text;
            bl.dic        = TextBox9.Text;
            bl.net_amount = txt_net_amt.Text;
            bl.credit_amt = txt_net_amt.Text;
            dl.insert_puch_inv(bl);
            DataSet   ds = new DataSet();
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                TextBox t1 = (TextBox)grid_array.Rows[i].FindControl("TextBox1");
                TextBox t2 = (TextBox)grid_array.Rows[i].FindControl("TextBox2");
                TextBox t3 = (TextBox)grid_array.Rows[i].FindControl("TextBox3");
                TextBox t4 = (TextBox)grid_array.Rows[i].FindControl("TextBox4");
                TextBox t5 = (TextBox)grid_array.Rows[i].FindControl("TextBox5");
                TextBox t6 = (TextBox)grid_array.Rows[i].FindControl("TextBox6");
                TextBox t7 = (TextBox)grid_array.Rows[i].FindControl("TextBox7");
                TextBox t8 = (TextBox)grid_array.Rows[i].FindControl("TextBox8");

                if (t1.Text != string.Empty)
                {
                    int pch = Convert.ToInt32(dl.get__puch_inv_no(bl));
                    bl.puch_id   = Convert.ToString(pch);
                    bl.item_name = t1.Text;
                    int id = Convert.ToInt32(dl.slelct_item_id_bill(bl));
                    bl.item_id = id;
                    bl.dcsr    = t2.Text;
                    bl.qty     = t3.Text;
                    bl.rate    = t4.Text;
                    bl.per     = t5.Text;
                    bl.disc    = t7.Text;
                    bl.tax     = t8.Text;
                    bl.amount  = t6.Text;
                    dl.insert_puch_item(bl);
                }
                else
                {
                    break;
                }
            }
            DataSet   ds2 = new DataSet();
            DataTable dt2 = (DataTable)ViewState["CurrentTable2"];
            for (int i = 0; i < dt2.Rows.Count; i++)
            {
                TextBox t1 = (TextBox)grd_add.Rows[i].FindControl("txt_lg");
                TextBox t2 = (TextBox)grd_add.Rows[i].FindControl("txt_amt");


                if (t1.Text != string.Empty)
                {
                    int pch = Convert.ToInt32(dl.get__puch_inv_no(bl));
                    bl.puch_id = Convert.ToString(pch);
                    bl.ld_nm   = t1.Text;
                    int id = Convert.ToInt32(dl.slelct_ld_id_bill(bl));
                    bl.ld_id    = id;
                    bl.extra_rs = t2.Text;
                    dl.insert_puch_extra(bl);
                }
                else
                {
                    break;
                }
            }
            stockmange();
            ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Invoice Created successfully'); window.location='puch_genrate.aspx';", true);
        }
        catch
        {
        }
    }