예제 #1
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (txtRecNo.Text == "")
        {
            msgBox1.alert("Please enter reciept number!");
            txtRecNo.Focus();
            return;
        }
        else if (txtPartNo.Text == "")
        {
            msgBox1.alert("Please enter Part No!");
            txtPartNo.Focus();
            return;
        }
        else if (txtProcby.Text == "")
        {
            msgBox1.alert("Please enter name of procurement officer!");
            txtProcby.Focus();
            return;
        }
        else if (RadRecDate.SelectedDate == null)
        {
            msgBox1.alert("Please reciept date!");
            RadRecDate.Focus();
            return;
        }
        else if (txtPartname.Text == "")
        {
            msgBox1.alert("Please enter part name!");
            return;
        }
        else if (txtVendor.Text == "")
        {
            msgBox1.alert("Please enter vendor name");
            return;
        }

        else if (txtform.Text == "")
        {
            txtform.Focus();
            msgBox1.alert("Please select a tax form!");
            return;
        }
        else if (cmbFlag.Text == "")
        {
            msgBox1.alert("Please select a flag!");
            return;
        }
        else if (txtQtyRec.Text == "")
        {
            txtQtyRec.Focus();
            msgBox1.alert("Please select quantity recieved!");
            return;
        }
        else if (txtamt.Text == "")
        {
            txtamt.Focus();
            msgBox1.alert("Please enter amount");
            return;
        }
        else if (txtQty.Text == "")
        {
            txtQty.Focus();
            msgBox1.alert("Please enter quantity!");
            return;
        }

        qry = "UPDATE MRN SET procuredby = '" + txtProcby.Text.Trim() + "',Vendor = '" + txtVendor.Text.Trim() + "',RecieptNo = '" + txtRecNo.Text + "',Flag = '" + cmbFlag.Text + "',PartNo = '" + txtPartNo.Text.Trim() + "', Partname = '" + txtPartname.Text.Trim() + "', TaxForm = '" + txtform.Text.Trim() + "', Qty = '" + txtQty.Text + "', QtyRecieved ='" + txtQtyRec.Text + "', Amt ='" + txtamt.Text + "', RecieptDate = '" + String.Format("{0:MM/dd/yyyy}", RadRecDate.SelectedDate) + "' WHERE MRNNo=" + Convert.ToInt32(Session["MRNNo"].ToString()) + "";
        con.SqlDs(qry, 2);
        Response.Redirect("MRNOrder.aspx");
    }
예제 #2
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (txtRecNo.Text == "")
        {
            msgBox1.alert("Please enter reciept number!");
            txtRecNo.Focus();
            return;
        }
        else if (txtPartNo.Text == "")
        {
            msgBox1.alert("Please enter part no!");
            txtPartNo.Focus();
            return;
        }
        else if (txtProcby.Text == "")
        {
            msgBox1.alert("Please enter name of procurement officer!");
            txtProcby.Focus();
            return;
        }
        else if (RadRecDate.SelectedDate == null)
        {
            msgBox1.alert("Please reciept date!");
            RadRecDate.Focus();
            return;
        }
        else if (txtPartname.Text == "")
        {
            msgBox1.alert("Please enter part name!");
            return;
        }
        else if (txtVendor.Text == "")
        {
            msgBox1.alert("Please enter vendor name");
            return;
        }


        else if (txtform.Text == "")
        {
            txtform.Focus();
            msgBox1.alert("Please select a tax form!");
            return;
        }
        else if (cmbFlag.Text == "")
        {
            msgBox1.alert("Please select a flag!");
            return;
        }
        else if (txtQtyRec.Text == "")
        {
            txtQtyRec.Focus();
            msgBox1.alert("Please select quantity recieved!");
            return;
        }
        else if (txtamt.Text == "")
        {
            txtamt.Focus();
            msgBox1.alert("Please enter amount");
            return;
        }
        else if (txtQty.Text == "")
        {
            txtQty.Focus();
            msgBox1.alert("Please enter quantity!");
            return;
        }

        qry = "insert into MRN(Vendor,RecieptNo,Flag,PartNo,Partname,TaxForm,Qty,QtyRecieved,Amt,RecieptDate,procuredby) VALUES('" + txtVendor.Text.Trim() + "','" + txtRecNo.Text.Trim() + "','" + cmbFlag.Text + "','" + txtPartNo.Text.Trim() + "','" + txtPartname.Text.Trim() + "','" + txtform.Text.Trim() + "','" + txtQty.Text + "','" + txtQtyRec.Text + "','" + txtamt.Text + "','" + String.Format("{0:MM/dd/yyyy}", RadRecDate.SelectedDate) + "','" + txtProcby.Text.Trim() + "')";
        con.SqlDs(qry, 2);
        grid1.DataSource = GetDataTablebydate();
        grid1.DataBind();
        clear();
    }