Exemplo n.º 1
0
    protected void btnget_Click(object sender, EventArgs e)
    {
        Int32     count = 0;
        DataTable Ds    = new DataTable();
        DataRow   R;

        if (txtInvoiceNoGet.Text.ToString() != "")
        {
            Ds = CourierDetails.Get_CourierDetails(float.Parse(txtInvoiceNoGet.Text), "Invoice", Convert.ToInt32(strFY)).Tables[0];
            if (Ds.Rows.Count == 0)
            {
                lblMessage.Text = "Invoice Is Not Created.";
            }
        }
        else if (txtDocNoGet.Text.ToString() != "")
        {
            Ds = CourierDetails.Get_CourierDetails(float.Parse(txtDocNoGet.Text), "DocNoCheck", Convert.ToInt32(strFY)).Tables[0];
            if (Ds.Rows.Count != 0)
            {
                message_error.Visible = true;
                lblMessage.Text       = "Invoice Is Already Created.";
                count = Ds.Rows.Count;
            }

            else
            {
                Ds = CourierDetails.Get_CourierDetails(float.Parse(txtDocNoGet.Text), "DocNo", Convert.ToInt32(strFY)).Tables[0];
            }
        }
        if (count == 0)
        {
            if (Ds.Rows.Count != 0)
            {
                PnlSendCourier.Visible = true;

                for (int k = 0; k <= Ds.Rows.Count - 1; k++)
                {
                    R = Ds.Rows[k];

                    for (int i = 0; i <= Ds.Columns.Count - 1; i++)
                    {
                        if (txtInvoiceNoGet.Text.ToString() != "")
                        {
                            lblInvoiceNoH.Visible = true;
                            lblInvoiceNo.Visible  = true;
                            lblInvoiceNo.Text     = R[3].ToString();
                        }
                        else
                        {
                            lblInvoiceNoH.Visible = false;
                            lblInvoiceNo.Visible  = false;
                        }
                        lblDocumentNo.Text     = R[2].ToString();
                        lblAddress.Text        = R[13].ToString();
                        lblPhone1.Text         = R[14].ToString();
                        lblCustomerName.Text   = R[6].ToString();
                        lblPersonIncharge.Text = R[15].ToString();
                    }
                }
            }
        }
    }
Exemplo n.º 2
0
    protected void btnget_Click(object sender, EventArgs e)
    {
        Int32     count = 0;
        DataTable Ds    = new DataTable();
        DataRow   R;

        if (txtInvoiceNoGet.Text.ToString() != "")
        {
            String mInv = "";
            Ds = CourierDetails.Get_CourierDetails(float.Parse(txtInvoiceNoGet.Text), "Invoice", Convert.ToInt32(strFY)).Tables[0];
            if (Ds.Rows.Count == 0)
            {
                mInv = txtInvoiceNoGet.Text;
                if (mInv != null)
                {
                    mInv = mInv.Substring(0, mInv.IndexOf("."));
                }
                //Ds = CourierDetails.Get_CourierDetails(float.Parse(txtInvoiceNoGet.Text.Remove(txtInvoiceNoGet.Text.Length - 3, 3)), "DocNoCheck", Convert.ToInt32(strFY)).Tables[0];
                Ds = CourierDetails.Get_CourierDetails(float.Parse(mInv), "DocNoCheck", Convert.ToInt32(strFY)).Tables[0];
                if (Ds.Rows.Count == 0)
                {
                    MessageBox("Invoice is not created, type correct invoice no.");
                }
            }
            //if (Ds.Rows.Count == 0)
            //    MessageBox("Invoice is not created, type correct invoice no.");
        }
        else if (txtDocNoGet.Text.ToString() != "")
        {
            Ds = CourierDetails.Get_CourierDetails(float.Parse(txtDocNoGet.Text), "DocNoCheck", Convert.ToInt32(strFY)).Tables[0];
            if (Ds.Rows.Count != 0)
            {
                message_error.Visible = true;
                lblMessage.Text       = "Invoice Is Already Created.";
                count = Ds.Rows.Count;
            }

            else
            {
                Ds = CourierDetails.Get_CourierDetails(float.Parse(txtDocNoGet.Text), "DocNo", Convert.ToInt32(strFY)).Tables[0];
            }
        }
        if (count == 0)
        {
            if (Ds.Rows.Count != 0)
            {
                PnlSendCourier.Visible = true;
                divgrdCD.Visible       = true;

                for (int k = 0; k <= Ds.Rows.Count - 1; k++)
                {
                    R = Ds.Rows[k];

                    for (int i = 0; i <= Ds.Columns.Count - 1; i++)
                    {
                        if (txtInvoiceNoGet.Text.ToString() != "")
                        {
                            lblInvoiceNoH.Visible = true;
                            lblInvoiceNo.Visible  = true;
                            lblInvoiceNo.Text     = R[3].ToString();
                        }
                        else
                        {
                            lblInvoiceNoH.Visible = false;
                            lblInvoiceNo.Visible  = false;
                        }
                        //lblDocumentNo.Text = R[2].ToString();
                        lblDocumentNo.Text     = R[3].ToString();
                        lblAddress.Text        = R[13].ToString();
                        lblPhone1.Text         = R[14].ToString();
                        lblCustomerName.Text   = R[6].ToString();
                        lblPersonIncharge.Text = R[15].ToString();
                    }
                }
                divData.Visible = true;
            }
        }

        txtInvoiceNoGet.Text = "";
    }