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(); } } } } }
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 = ""; }