protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["d"] != null && Request.QueryString["sd"] != null)
        {
            DataSet ds            = new DataSet();
            DataSet dsTransporter = SpecimanDetails.Get_SpecTransporterAndDetails(Convert.ToDecimal(Request.QueryString["sd"].ToString().Trim()), "approved");
            ds = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), "approved");
            DataView dv = new DataView(ds.Tables[1]);
            dv.RowFilter            = "SubConfirmID = " + Request.QueryString["sd"].ToString().Trim();
            DocumentNo.InnerHtml    = ds.Tables[1].Rows[0]["DocumentNo"].ToString();
            Todaydate.InnerHtml     = DateTime.Now.ToString("dd/MM/yyyy");
            Subconfirmid.InnerHtml  = Request.QueryString["sd"].ToString();
            empname.InnerHtml       = ds.Tables[2].Rows[0][0].ToString() + " " + ds.Tables[2].Rows[0][1].ToString() + " " + ds.Tables[2].Rows[0][2].ToString();
            spnaddress.InnerHtml    = ds.Tables[2].Rows[0]["Address"].ToString().ToUpper() + "</br> " + ds.Tables[2].Rows[0]["City"].ToString().ToUpper() + ", " + ds.Tables[2].Rows[0]["State"].ToString().ToUpper();
            SpInstruction.InnerHtml = ds.Tables[2].Rows[0]["SpInstruction"].ToString();
            Description.InnerHtml   = ds.Tables[2].Rows[0]["Description"].ToString();

            lbltransporter.InnerHtml = dsTransporter.Tables[0].Rows[0]["Transporter"].ToString();
            lbllrno.InnerHtml        = dsTransporter.Tables[0].Rows[0]["LrNo"].ToString();
            lblbundles.InnerHtml     = dsTransporter.Tables[0].Rows[0]["Bundles"].ToString();

            grdapproval.DataSource = dv;
            grdapproval.DataBind();
            DataSet ds1 = new DataSet();
            ds1 = ActualInvoiceDetails.GetConvertion_fromnumber(tamount);
            lblrupees.InnerHtml = ds1.Tables[0].Rows[0][0].ToString() + " Only";
        }
    }
Example #2
0
 protected void btnget_Click(object sender, EventArgs e)
 {
     pnlDetails.Visible = true;
     stDS                         = new DataSet();
     docno.InnerHtml              = txtDocno.Text.Trim();
     stDS                         = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "approved");
     ViewState["staticDS"]        = stDS;
     RepDetailsConfirm.DataSource = stDS.Tables[0];
     RepDetailsConfirm.DataBind();
 }
    protected void btnget_Click(object sender, EventArgs e)
    {
        stDS            = new DataSet();
        docno.InnerHtml = txtDocno.Text.Trim();
        stDS            = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed");
        RepDetailsConfirm.DataSource = stDS.Tables[0];
        RepDetailsConfirm.DataBind();

        if (txtFisrt != null)
        {
            txtFisrt.Focus();
        }
        // lblfright.Visible = true;
        // txtfrieght.Visible = true;
        //  lbltax.Visible = true;
        //  txttax.Visible = true;
        //string jv = "";
        //if (RepDetailsConfirm.Items.Count <= 0)
        //{
        //    jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='none';";
        //}
        //else
        //{
        //    jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='block';";
        //}
        //ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true);
        //ds = SpecimanDetails.Idv_Get_SpecimenDetails_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed");
        //DataTable dt = ds.Tables[0];
        //if (dt.Rows.Count != 0)
        //{
        //    btnapproval.Enabled = true;
        //}
        //else
        //{
        //    bool Auth = Specimen.Get_DocumentNum_Authentication(Convert.ToInt32(txtDocno.Text));
        //    if (Auth)
        //    {
        //        MessageBox("Document no is not available");
        //        txtDocno.Focus();
        //    }
        //    else
        //    {
        //    }
        //}
    }
    protected void btnget_Click(object sender, EventArgs e)
    {
        pnlDetails.Visible = true;
        stDS            = new DataSet();
        docno.InnerHtml = txtDocno.Text.Trim();
        stDS            = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "approved");
        RepDetailsApprove.DataSource = stDS.Tables[0];
        RepDetailsApprove.DataBind();
        string jv = "";

        if (RepDetailsApprove.Items.Count <= 0)
        {
            jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='none';";
        }
        else
        {
            jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='block';";
        }
        ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true);
    }
    protected void RepDetailsConfirm_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        bool Auth = Specimen.Get_DocumentNum_Authentication(Convert.ToInt32(txtDocno.Text));

        if (Auth)
        {
            MessageBox("Document no is not available");
            txtDocno.Focus();
        }
        else
        {
            SpecimenConfirmQtyDetails _objSpecimenConfirmQtyDetails = new SpecimenConfirmQtyDetails();
            Specimen _objspecimen = new Specimen();
            SpecimenConfirmQtyDetails _objSpecimenFT = new SpecimenConfirmQtyDetails();

            try
            {
                decimal subconfirmdoc = Convert.ToDecimal(e.CommandArgument.ToString().Trim());
                _objSpecimenConfirmQtyDetails.IsCreateInvoice  = true;
                _objSpecimenConfirmQtyDetails.CreatedInvoiceBy = "admin";
                _objSpecimenConfirmQtyDetails.SubDocNo         = Convert.ToDecimal(e.CommandArgument.ToString().Trim());
                _objspecimen.DocNo = Convert.ToInt32(txtDocno.Text);
                _objSpecimenConfirmQtyDetails.Transporter = ((TextBox)e.Item.FindControl("txtTransporter")).Text;
                _objSpecimenConfirmQtyDetails.LrNo        = ((TextBox)e.Item.FindControl("txtlrno")).Text;
                _objSpecimenConfirmQtyDetails.Bundles     = ((TextBox)e.Item.FindControl("txtbundles")).Text;
                TextBox txtdateabc = (TextBox)e.Item.FindControl("txtdateabc");
                string  date1;
                if (txtdateabc.Text == "")
                {
                    date1 = "01/01/2001";
                }
                else
                {
                    date1 = txtdateabc.Text.Split('/')[1] + "/" + txtdateabc.Text.Split('/')[0] + "/" + txtdateabc.Text.Split('/')[2];
                }
                _objSpecimenConfirmQtyDetails.InvoiceDate = Convert.ToDateTime(date1);
                _objSpecimenConfirmQtyDetails.SaveConfirmDetails();
                Cleardata();
                stDS            = new DataSet();
                docno.InnerHtml = txtDocno.Text.Trim();
                stDS            = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed");
                RepDetailsConfirm.DataSource = stDS.Tables[0];
                RepDetailsConfirm.DataBind();

                MessageBox("DC approved successfully for document no. " + subconfirmdoc);
                docno.InnerHtml = "Last confirm doc no. : " + subconfirmdoc;

                if (Rptrpending.Items.Count == 1)
                {
                    Rptrpending.DataSource = Specimen.Get_ApprovedDocNo();
                    Rptrpending.DataBind();
                    //updateapprove.Update();
                }
                if (RepDetailsConfirm.Items.Count == 0)
                {
                    Rptrpending.DataSource = Specimen.Get_ApprovedDocNo();
                    Rptrpending.DataBind();
                    upDocNo.Update();
                    docno.InnerHtml = "";
                    //lblcustname.InnerHtml = "";
                    lblempname1.InnerHtml = "";
                    //updateapprove.Update();
                }

                updateapprove.Update();
            }
            catch (Exception ex)
            {
                MessageBox(ex.Message.ToString());
            }
        }
    }