//protected void txtsalemanCode_TextChanged(object sender, EventArgs e)
    //{
    //    string ECode = txtsalemanCode.Text.ToString().Split(':')[0].Trim();


    //    DataTable dt = new DataTable();
    //    dt = DCMaster.Get_Name(ECode, "Employee").Tables[0];
    //    if (dt.Rows.Count != 0)
    //    {
    //        txtsalemanCode.Text = ECode;
    //        lblSalesManName.Text = dt.Rows[0]["FirstName"] + " " + dt.Rows[0]["MiddleName"] + " " + dt.Rows[0]["LastName"];
    //        txtpIncharge.Focus();
    //    }
    //    else
    //    {
    //        lblSalesManName.Text = "No such salesman code";
    //        txtsalemanCode.Focus();
    //        txtsalemanCode.Text = "";
    //    }


    //}
    protected void txtcustomer_TextChanged(object sender, EventArgs e)
    {
        string    CustCode = txtcustomer.Text.ToString().Split(':')[0].Trim();
        DataTable dt       = new DataTable();

        dt = DCMaster.Get_Name(CustCode, "Customer").Tables[0];
        if (dt.Rows.Count != 0)
        {
            txtcustomer.Text = CustCode;
            lblCustName.Text = Convert.ToString(dt.Rows[0]["CustName"]);
            if (dt.Rows[0]["State"].ToString().ToLower() == "maharashtra")
            {
                srate = "l";
            }
            else
            {
                srate = "m";
            }
            //txtsalemanCode.Focus();
            ACExttransporter.ContextKey = CustCode;
            DDlemployee.DataSource      = DCMaster.Get_Employee_By_Customer_Code(CustCode, "Employee");
            DDlemployee.DataBind();
            DDlemployee.Items.Insert(0, new ListItem("-Select-", "0"));
            DDlemployee.Focus();
            //   Bind_DDL_Transport();
        }


        else
        {
            lblCustName.Text = "No such Customer code";
            txtcustomer.Focus();
            txtcustomer.Text = "";
            srate            = "";
        }
    }