using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Globalization;

namespace Saleorder
{
    public partial class BalesAssignForm : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection("Data Source=server;Integrated Security=SSPI;Initial Catalog=SilverProduction;MultipleActiveResultSets=True;");

        QryMgmt dm = new QryMgmt();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                // this.BindGrid();

                txtentrydate.Text = DateTime.Today.ToShortDateString();
                txtentrydate.Enabled = false;
                txttime.Text = DateTime.Now.ToString("hh\\:mm");
                prdqty.Text = "1";
               
                Loadddpcus();
                Loadddpitem();
                LoadFloor();
                Loadcust();
                Loaditemba();
                Loadsection();
                Loadworker();
                this.StoreVisitorIPDetails();

            }
            Response.AppendHeader("Cache-Control", "no-store");
        }

        private void StoreVisitorIPDetails()
        {
            string ipaddress;
            ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            if (ipaddress == "" || ipaddress == null)
                ipaddress = Request.ServerVariables["REMOTE_ADDR"];
            lblIP.Text = ipaddress;
        }

        private void Loadworker()
        {
            con.Open();
            SqlDataAdapter adpwn = new SqlDataAdapter("select * from Worker", con);
            DataSet dswn = new DataSet();
            adpwn.Fill(dswn);
            DDlWrknam.DataSource = dswn.Tables[0];
            DDlWrknam.DataTextField = "Namworker";
            DDlWrknam.DataValueField = "IDwokrer";
            DDlWrknam.DataBind();
            DDlWrknam.Items.Insert(0, new ListItem("Select Worker", "0"));

            con.Close();
        }

        private void Loadsection()
        {
            con.Open();
            SqlDataAdapter adpbas = new SqlDataAdapter("select * from Sections", con);
            DataSet dsbas = new DataSet();
            adpbas.Fill(dsbas);
            DDSecbas.DataSource = dsbas.Tables[0];
            DDSecbas.DataTextField = "Secnam";
            DDSecbas.DataValueField = "SecID";
            DDSecbas.DataBind();
            DDSecbas.Items.Insert(0, new ListItem("Select Section", "0"));

            con.Close();
        }

        private void Loaditemba()
        {
            con.Open();
            SqlDataAdapter adpBAim = new SqlDataAdapter("select * from ItemMasterFile where Packsize='small'", con);
            DataSet dsBAim = new DataSet();
            adpBAim.Fill(dsBAim);
            DDItemba.DataSource = dsBAim.Tables[0];
            DDItemba.DataTextField = "Descriptionitem";
            DDItemba.DataValueField = "Codeitem";
            DDItemba.DataBind();
            DDItemba.Items.Insert(0, new ListItem("Select Item", "0"));

            con.Close();
        }

        private void Loadcust()
        {
            con.Open();
            SqlDataAdapter adpBA2 = new SqlDataAdapter("select * from Customer", con);
            DataSet dsBA2 = new DataSet();
            adpBA2.Fill(dsBA2);
            DDCus.DataSource = dsBA2.Tables[0];
            DDCus.DataTextField = "CustomerName";
            DDCus.DataValueField = "CustomerID";
            DDCus.DataBind();
            // DDOCustomer.Items.Insert(0, new ListItem("Select Customer", "0"));

            con.Close();
        }

        private void LoadFloor()
        {
            con.Open();
            SqlDataAdapter adprfl = new SqlDataAdapter("select * from Floor", con);
            DataSet dsprfl = new DataSet();
            adprfl.Fill(dsprfl);
            DDLFl.DataSource = dsprfl.Tables[0];
            DDLFl.DataTextField = "FName";
            DDLFl.DataValueField = "FID";
            DDLFl.DataBind();
            // DDOCustomer.Items.Insert(0, new ListItem("Select Customer", "0"));

            con.Close();
        }

        private void Loadddpitem()
        {
            con.Open();
            SqlDataAdapter adpr1 = new SqlDataAdapter("select * from ItemMasterFile where Packsize='small' ", con);
            DataSet dspr1 = new DataSet();
            adpr1.Fill(dspr1);
            ddpitem.DataSource = dspr1.Tables[0];
            ddpitem.DataTextField = "Descriptionitem";
            ddpitem.DataValueField = "Codeitem";
            ddpitem.DataBind();
            ddpitem.Items.Insert(0, new ListItem("Select Item", "0"));

            con.Close();
        }

        private void Loadddpcus()
        {

            con.Open();
            SqlDataAdapter adpr2 = new SqlDataAdapter("select * from Customer", con);
            DataSet dspr2 = new DataSet();
            adpr2.Fill(dspr2);
            ddpcus.DataSource = dspr2.Tables[0];
            ddpcus.DataTextField = "CustomerName";
            ddpcus.DataValueField = "CustomerID";
            ddpcus.DataBind();
            // DDOCustomer.Items.Insert(0, new ListItem("Select Customer", "0"));

            con.Close();
        }
        



        protected void tbsv_Click(object sender, EventArgs e)
        {


            int P = int.Parse(prdqty.Text);

            if (txtpno.Text == "")
            {
                Response.Write("<script>alert('Please Select Order No')</script>");

            }
            else if (ddpitem.SelectedValue == "0")
            {
                Response.Write("<script>alert('Please Select Item')</script>");
            }
            else if (DDSecbas.SelectedValue == "0")
            {
                Response.Write("<script>alert('Please Select Section')</script>");
            }
            else if (DDlWrknam.SelectedValue == "0")
            {
                Response.Write("<script>alert('Please Select Worker')</script>");
            }
            else if (P > 1 && txtrmk.Text == "")
            {
                Response.Write("<script>alert('Please Input Remarks')</script>");
            }

            else
            {
                btn_n.Visible = false;
                btnsogo.Visible = false;
                btn_SD.Visible = false;
                tbsv.Visible = false;
                btn_BNV.Visible = false;
                IB_Apple.Visible = false;
                btn_F.Visible = false;
                SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                cmd.CommandType = CommandType.StoredProcedure;
                // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);
                // cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);

                cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                //     cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm"));
                cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                cmd.Parameters.Add("@OID", SqlDbType.Int);
                cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                con.Open();
                cmd.ExecuteNonQuery();
                int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);

                if (ResultValue > 1)
                {

                    string Url = "CRBigbal.aspx?OID=" + ResultValue;
                    Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                    Response.Write("</script>");

                }
                else
                {
                    Response.Write("<script>alert('Record Not save')</script>");


                }
                con.Close();
                txtpno.Text = "";
            }

        }




        protected void DDCus_SelectedIndexChanged(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmdba = new SqlCommand("searchcustomerwise", con);

            cmdba.CommandType = CommandType.StoredProcedure;
            cmdba.Parameters.AddWithValue("customerid", DDCus.SelectedValue);
            SqlDataAdapter adptba = new SqlDataAdapter(cmdba);
            DataTable dtba = new DataTable();
            adptba.Fill(dtba);
            GVPrd.DataSource = dtba;
            GVPrd.DataBind();
            cmdba.Dispose();
            con.Close();
        }


        protected void GVPrd_SelectedIndexChanged(object sender, EventArgs e)
        {
            txtpno.Text = GVPrd.SelectedRow.Cells[9].Text;
            string SesnId1 = dm.GetData("select SecID from dbo.Sections where Secnam='" + GVPrd.SelectedRow.Cells[12].Text.Trim() + "'").Rows[0][0].ToString();

            string SesnId2 = dm.GetData("select Codeitem from dbo.ItemMasterFile where Packsize='small' and  Descriptionitem=replace(REPLACE('" + GVPrd.SelectedRow.Cells[2].Text.Trim() + "','amp;',''),'&#39;','''')").Rows[0][0].ToString();
            DDSecbas.SelectedValue = SesnId1;
            ddpitem.SelectedValue = SesnId2;
            string SesnId3 = dm.GetData("select CustomerID from dbo.Customer where CustomerName='" + GVPrd.SelectedRow.Cells[7].Text.Trim() + "'").Rows[0][0].ToString();
            ddpcus.SelectedValue = SesnId3;

            opqty.Text = GVPrd.SelectedRow.Cells[3].Text;
            txtbs.Text = GVPrd.SelectedRow.Cells[11].Text;
            txtpbs.Text = GVPrd.SelectedRow.Cells[13].Text;


            sectionfilter();
            // txtpbs.Text = "";
            txtbnv.Text = "";
            txttw.Text = "";
            //txtweight.Text = GVPrd.SelectedRow.Cells[9].Text;
        }

        protected void DDItemba_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (DDItemba.SelectedIndex != 0)
            {
                con.Open();
                SqlCommand cmdbai = new SqlCommand("searchitemwise", con);

                cmdbai.CommandType = CommandType.StoredProcedure;
                cmdbai.Parameters.AddWithValue("Codeitem", DDItemba.SelectedValue);
                SqlDataAdapter adptbai = new SqlDataAdapter(cmdbai);
                DataTable dtbai = new DataTable();
                adptbai.Fill(dtbai);
                GVPrd.DataSource = dtbai;
                GVPrd.DataBind();
                cmdbai.Dispose();
                con.Close();
            }

            else if (DDItemba.SelectedIndex == 0)
            {


                SqlCommand cmdba = new SqlCommand("ALLOrder", con);

                cmdba.CommandType = CommandType.StoredProcedure;
                //  cmdba.Parameters.AddWithValue("Codeitem", DDCus.SelectedValue);
                SqlDataAdapter adptba = new SqlDataAdapter(cmdba);
                DataTable dtba = new DataTable();
                adptba.Fill(dtba);
                GVPrd.DataSource = dtba;
                GVPrd.DataBind();
                cmdba.Dispose();
                con.Close();

            }
        }

        protected void ddpitem_SelectedIndexChanged(object sender, EventArgs e)
        {

            //   not done

            String strQuery = "select SecID from ItemMasterFile where" +
                              " Codeitem = @Codeitem";
            // SqlConnection con = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedItem.Value);
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = strQuery;
            cmd.Connection = con;
            try
            {
                con.Open();
                SqlDataReader sdr = cmd.ExecuteReader();
                while (sdr.Read())
                {
                    //txtsecbas.Text = sdr[0].ToString();
                    DDSecbas.SelectedValue = sdr["SecID"].ToString();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
                con.Dispose();
            }
        }

        protected void txtrefab_TextChanged(object sender, EventArgs e)
        {

            SqlCommand cmdbrf = new SqlCommand("searchbyrefno_ab", con);

            cmdbrf.CommandType = CommandType.StoredProcedure;
            cmdbrf.Parameters.AddWithValue("Order_Ref_No", txtrefab.Text.ToString());
            SqlDataAdapter adptrf = new SqlDataAdapter(cmdbrf);
            DataTable dtbnorf = new DataTable();
            adptrf.Fill(dtbnorf);
            GVPrd.DataSource = dtbnorf;
            GVPrd.DataBind();
            cmdbrf.Dispose();
            con.Close();
        }

        protected void tbupdate_Click(object sender, EventArgs e)
        {

        }

        protected void txttw_TextChanged(object sender, EventArgs e)
        {

        }

        protected void txttwgh_TextChanged(object sender, EventArgs e)
        {
            int a = int.Parse(txttw.Text);
            int b = int.Parse(txttwgh.Text);
            txtpbs.Text = (a - b).ToString();
        }

        protected void LinkButton1_Click(object sender, EventArgs e)
        {
            Response.Redirect("StockStatusGV.aspx");
        }

        protected void btnsogo_Click(object sender, EventArgs e)
        {

                int P = int.Parse(prdqty.Text);

                if (txtpno.Text == "")
                {
                    Response.Write("<script>alert('Please Select Order No')</script>");

                }
                else if (DDlWrknam.SelectedValue == "0")
                {
                    Response.Write("<script>alert('Please Select Worker')</script>");
                }
                else if (P > 1 && txtrmk.Text == "")
                {
                    Response.Write("<script>alert('Please Input Remarks')</script>");
                }
                else
                {
                    btn_n.Visible = false;
                    btnsogo.Visible = false;
                    btn_SD.Visible = false;
                    tbsv.Visible = false;
                    btn_BNV.Visible = false;
                    IB_Apple.Visible = false;
                    btn_F.Enabled = false;
                    SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                    cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                    cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                    cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                    cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                    cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                    // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);
                    //  cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                    cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);
                    cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                    cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                    cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                    cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                    // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                    cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                    cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);

                    cmd.Parameters.Add("@OID", SqlDbType.Int);
                    cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                    con.Open();
                    cmd.ExecuteNonQuery();
                    int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);

                    if (ResultValue > 1)
                    {
                        //  Response.Write("<script>alert('Record save successuly')</script>");

                        //   Response.Redirect("CRSogo.aspx?OID=" + ResultValue + "");
                        string Url = "CRSogo.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");

                    }
                    else
                    {
                        Response.Write("<script>alert('Record Not save')</script>");


                    }
                    con.Close();
                    prdqty.Text = "";
                    txtpno.Text = "";
                }
            }
        

        protected void btn_SD_Click(object sender, EventArgs e)
        {

            btn_SD.Enabled = false;
            {
                int P = int.Parse(prdqty.Text);

                if (txtpno.Text == "")
                {
                    Response.Write("<script>alert('Please Select Order No')</script>");

                }
                else if (DDlWrknam.SelectedValue == "0")
                {
                    Response.Write("<script>alert('Please Select Worker')</script>");
                }
                else if (P > 1 && txtrmk.Text == "")
                {
                    Response.Write("<script>alert('Please Input Remarks')</script>");
                }
                else
                {
                    btn_n.Visible = false;
                    btnsogo.Visible = false;
                    btn_SD.Visible = false;
                    tbsv.Visible = false;
                    btn_BNV.Visible = false;
                    IB_Apple.Visible = false;
                    btn_F.Enabled = false;
                    SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                    cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                    cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                    cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                    cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                    cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                    // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);

                    //   cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                    cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);
                    cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                    cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                    cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                    cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                    // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                    cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                    cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);

                    cmd.Parameters.Add("@OID", SqlDbType.Int);
                    cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                    con.Open();
                    cmd.ExecuteNonQuery();
                    int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);


                    //string Url = "CRSD.aspx?OID=" + ResultValue;
                    //Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                    //Response.Write("</script>");


                    //string Url1 = "CRSBS.aspx?OID=" + ResultValue;
                    //Response.Write("<script language='javascript'>window.open('" + Url1 + "','_blank','');");
                    //Response.Write("</script>");

                    //cleartxt();



                    if (ResultValue > 1)
                    {
                        //  Response.Write("<script>alert('Record save successuly')</script>");

                        //   Response.Redirect("CRSD.aspx?OID=" + ResultValue + "");

                        string Url = "CRSD.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");


                    }
                    else
                    {
                        Response.Write("<script>alert('Record Not save')</script>");


                    }
                    con.Close();
                    prdqty.Text = "";
                    txtpno.Text = "";
                }
            }
        }
        //  private void cleartxt()
        //{
        //    prdqty.Text = "";
        //    //  txtpno.Text = "";
        //    txtpbs.Text = "";
        //}
        protected void btn_n_Click(object sender, EventArgs e)
        {

            btn_SD.Enabled = false;
            btn_n.Enabled = false;
            {
                int P = int.Parse(prdqty.Text);

                if (txtpno.Text == "")
                {
                    Response.Write("<script>alert('Please Select Order No')</script>");

                }
                else if (DDlWrknam.SelectedValue == "0")
                {
                    Response.Write("<script>alert('Please Select Worker')</script>");
                }
                else if (P > 1 && txtrmk.Text == "")
                {
                    Response.Write("<script>alert('Please Input Remarks')</script>");
                }
                else
                {
                    btn_n.Visible = false;
                    btnsogo.Visible = false;
                    btn_SD.Visible = false;
                    tbsv.Visible = false;
                    btn_BNV.Visible = false;
                    IB_Apple.Visible = false;
                    btn_F.Enabled = false;
                    SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                    cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                    cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                    cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                    cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                    cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                    // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);

                    // cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                    cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);
                    cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                    cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                    cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                    cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                    // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                    cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                    cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);

                    cmd.Parameters.Add("@OID", SqlDbType.Int);
                    cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                    con.Open();
                    cmd.ExecuteNonQuery();
                    int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);

                    if (ResultValue > 1)
                    {
                        //  Response.Write("<script>alert('Record save successuly')</script>");

                        //   Response.Redirect("SBPrintv.aspx?OID=" + ResultValue + "");
                        string Url = "SBPrintv.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");

                    }
                    else
                    {
                        Response.Write("<script>alert('Record Not save')</script>");


                    }
                    con.Close();
                    con.Dispose();
                    prdqty.Text = "";
                    txtpno.Text = "";
                }
            }

        }

        protected void DDSecbas_SelectedIndexChanged(object sender, EventArgs e)
        {
            sectionfilter();
        }

        private void sectionfilter()
        {
            con.Open();
            SqlDataAdapter adpwn = new SqlDataAdapter("select * from Worker where secid='" + DDSecbas.SelectedValue + "'", con);
            DataSet dswn = new DataSet();
            adpwn.Fill(dswn);
            DDlWrknam.DataSource = dswn.Tables[0];
            DDlWrknam.DataTextField = "Namworker";
            DDlWrknam.DataValueField = "IDwokrer";
            DDlWrknam.DataBind();
            // DDlWrknam.Items.Insert(0, new ListItem("Select Worker", "0"));
            con.Close();
            con.Dispose();
        }

        protected void btn_BNV_Click(object sender, EventArgs e)
        {

            btn_BNV.Enabled = false;
            {
                int P = int.Parse(prdqty.Text);

                if (txtpno.Text == "")
                {
                    Response.Write("<script>alert('Please Select Order No')</script>");

                }
                else if (DDlWrknam.SelectedValue == "0")
                {
                    Response.Write("<script>alert('Please Select Worker')</script>");
                }
                else if (P > 1 && txtrmk.Text == "")
                {
                    Response.Write("<script>alert('Please Input Remarks')</script>");
                }
                else if (txtpbs.Text == "")
                {
                    Response.Write("<script>alert('Please Input Weight')</script>");

                }
                else if (txtbnv.Text == "")
                {
                    Response.Write("<script>alert('Please Input Ref BNV')</script>");
                }
                else if (txttw.Text == "")
                {
                    Response.Write("<script>alert('Please Input Gross Weight')</script>");
                }

                else
                {
                    btn_n.Visible = false;
                    btnsogo.Visible = false;
                    btn_SD.Visible = false;
                    tbsv.Visible = false;
                    btn_BNV.Visible = false;
                    IB_Apple.Visible = false;
                    btn_F.Enabled = false;
                    SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                    cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                    cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                    cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                    cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                    cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                    // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);
                    cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                    // cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);

                    cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);
                    cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                    cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                    cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                    cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                    // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                    cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));

                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);

                    cmd.Parameters.Add("@OID", SqlDbType.Int);
                    cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                    con.Open();
                    cmd.ExecuteNonQuery();
                    int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);

                    if (ResultValue > 1)
                    {
                        //  Response.Write("<script>alert('Record save successuly')</script>");

                        //  Response.Redirect("BNVprntv.aspx?OID=" + ResultValue + "");
                        string Url = "BNVprntv.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");

                    }
                    else
                    {
                        Response.Write("<script>alert('Record Not save')</script>");


                    }
                    con.Close();
                    con.Dispose();
                    prdqty.Text = "";
                    txtpno.Text = "";
                }
            }
        }

        protected void GVPrd_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                e.Row.Attributes["onclick"] = Page.ClientScript.GetPostBackClientHyperlink(GVPrd, "Select$" + e.Row.RowIndex);
                e.Row.ToolTip = "Click ME .";


                //if (e.Row.Cells[14].Text.Equals("Close"))
                //{
                //    e.Row.Attributes.CssStyle.Value = "background-color: Red; color: White";
                //}
                //if (e.Row.Cells[14].Text.Equals("Hold"))
                //{
                //    e.Row.Attributes.CssStyle.Value = "background-color: Red; color: White";
                //}
            }


        }

        protected void txtbd_TextChanged(object sender, EventArgs e)
        {
            if (txtbd.Text.Trim().ToLower() == "ysn111@")
            {
                txtentrydate.Enabled = true;
            }
            else
            {
                txtentrydate.Enabled = false;
            }
        }

        protected void IB_Apple_Click(object sender, ImageClickEventArgs e)
        {


            IB_Apple.Enabled = false;
            {
                int P = int.Parse(prdqty.Text);

                if (txtpno.Text == "")
                {
                    Response.Write("<script>alert('Please Select Order No')</script>");

                }
                else if (DDlWrknam.SelectedValue == "0")
                {
                    Response.Write("<script>alert('Please Select Worker')</script>");
                }
                else if (P > 1 && txtrmk.Text == "")
                {
                    Response.Write("<script>alert('Please Input Remarks')</script>");
                }
                else
                {
                    btn_n.Visible = false;
                    btnsogo.Visible = false;
                    btn_SD.Visible = false;
                    tbsv.Visible = false;
                    btn_BNV.Visible = false;
                    IB_Apple.Visible = false;
                    btn_F.Enabled = false;
                    SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                    cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                    cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                    cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                    cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                    cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                    // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);

                    //   cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                    cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);
                    cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                    cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                    cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                    cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                    // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                    cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                    cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);

                    cmd.Parameters.Add("@OID", SqlDbType.Int);
                    cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                    con.Open();
                    cmd.ExecuteNonQuery();
                    int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);


                    //string Url = "CRSD.aspx?OID=" + ResultValue;
                    //Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                    //Response.Write("</script>");


                    //string Url1 = "CRSBS.aspx?OID=" + ResultValue;
                    //Response.Write("<script language='javascript'>window.open('" + Url1 + "','_blank','');");
                    //Response.Write("</script>");

                    //cleartxt();



                    if (ResultValue > 1)
                    {
                        //  Response.Write("<script>alert('Record save successuly')</script>");

                        //   Response.Redirect("CRap.aspx?OID=" + ResultValue + "");
                        string Url = "CRap.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");

                    }
                    else
                    {
                        Response.Write("<script>alert('Record Not save')</script>");


                    }
                    con.Close();
                    prdqty.Text = "";
                    txtpno.Text = "";
                }
            }

        }

        protected void Btn_New_Click(object sender, EventArgs e)
        {
            Cleartxt();
        }

        private void Cleartxt()
        {
            txtpno.Text = "";
            ddpitem.SelectedValue = "0";
            DDSecbas.SelectedValue = "0";
            txtbs.Text = "";
            DDItemba.SelectedValue = "0";
            txtbs.Text = "";
            prdqty.Text = "1";
            btn_n.Visible = true;
            btnsogo.Visible = true;
            btn_SD.Visible = true;
            tbsv.Visible = true;
            btn_BNV.Visible = true;
            tbsv.Visible = true;
            btn_F.Enabled = true;
       //     IB_Apple.Enabled = true;
            IB_Apple.Visible = true;
            btn_F.Visible = true;


        }

        protected void btn_F_Click(object sender, EventArgs e)
        {


            btn_F.Enabled = false;
            {
                int P = int.Parse(prdqty.Text);

                if (txtpno.Text == "")
                {
                    Response.Write("<script>alert('Please Select Order No')</script>");

                }
                else if (DDlWrknam.SelectedValue == "0")
                {
                    Response.Write("<script>alert('Please Select Worker')</script>");
                }
                else if (P > 1 && txtrmk.Text == "")
                {
                    Response.Write("<script>alert('Please Input Remarks')</script>");
                }
                else
                {
                    btn_n.Visible = false;
                    btnsogo.Visible = false;
                    btn_SD.Visible = false;
                    tbsv.Visible = false;
                    btn_BNV.Visible = false;
                    IB_Apple.Visible = false;
                    btn_F.Visible = false;
                    SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                    cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                    cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                    cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                    cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                    cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                    // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);

                    //   cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                    cmd.Parameters.AddWithValue("@Weight", 88);
                    cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                    cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                    cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                    cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                    // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                    cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                    cmd.Parameters.AddWithValue("@Gweigth", string.IsNullOrEmpty(txttw.Text) ? (object)DBNull.Value : txttw.Text);
                    //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);

                    cmd.Parameters.Add("@OID", SqlDbType.Int);
                    cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                    con.Open();
                    cmd.ExecuteNonQuery();
                    int ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);


                    //string Url = "CRSD.aspx?OID=" + ResultValue;
                    //Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                    //Response.Write("</script>");


                    //string Url1 = "CRSBS.aspx?OID=" + ResultValue;
                    //Response.Write("<script language='javascript'>window.open('" + Url1 + "','_blank','');");
                    //Response.Write("</script>");

                    //cleartxt();



                    if (ResultValue > 1)
                    {
                        //  Response.Write("<script>alert('Record save successuly')</script>");

                        //   Response.Redirect("CRap.aspx?OID=" + ResultValue + "");
                        string Url = "fortypv.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");

                    }
                    else
                    {
                        Response.Write("<script>alert('Record Not save')</script>");


                    }
                    con.Close();
                    prdqty.Text = "";
                    txtpno.Text = "";

                }
            }
        }
    }

}