Exemplo n.º 1
0
 protected void ddl_State_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (ddl_State.SelectedIndex > 0)
     {
         dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedValue.ToString()));
     }
 }
Exemplo n.º 2
0
    protected void grd_Orders_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "EditDetails")
        {
            DivCreate.Visible       = true;
            DivView.Visible         = false;
            ddl_ordersTask.Enabled  = false;
            ddl_orderstatus.Enabled = false;
            GridViewRow row          = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
            Label       lbl_Order_ID = (Label)row.FindControl("lblOrder_id");
            ViewState["Orderid"] = lbl_Order_ID.Text;
            btn_Save.Text        = "Edit Order";
            Hashtable htselect = new Hashtable();
            DataTable dtselect = new DataTable();
            htselect.Add("@Trans", "SELECT_ORDER_WISE");
            htselect.Add("@Order_ID", lbl_Order_ID.Text);
            dtselect = dataaccess.ExecuteSP("Sp_Order", htselect);
            if (dtselect.Rows.Count > 0)
            {
                txt_OrderNumber.Text = dtselect.Rows[0]["Client_Order_Number"].ToString();

                ddl_ordertype.SelectedValue  = dtselect.Rows[0]["Order_Type"].ToString();
                ddl_ordersTask.SelectedValue = dtselect.Rows[0]["Order_Task_Id"].ToString();
                ddl_ClientName.SelectedValue = dtselect.Rows[0]["Client_Id"].ToString();
                dbc.BindSubProcessName(ddl_SubProcess, int.Parse(ddl_ClientName.SelectedValue.ToString()));
                ddl_SubProcess.SelectedValue = dtselect.Rows[0]["Sub_ProcessId"].ToString();
                txt_PhoneNumber.Text         = dtselect.Rows[0]["Phone_Number"].ToString();
                txt_ParcelNumber.Text        = dtselect.Rows[0]["Parecel_Id"].ToString();
                txt_ContractNumber.Text      = dtselect.Rows[0]["Contract_Number"].ToString();
                txt_BatchNumber.Text         = dtselect.Rows[0]["Batch_Number"].ToString();
                txt_LoanNumber.Text          = dtselect.Rows[0]["Loan_Number"].ToString();
                txt_ZipCode.Text             = dtselect.Rows[0]["Barrower_Zip"].ToString();
                txt_City.Text           = dtselect.Rows[0]["Barrower_City"].ToString();
                ddl_State.SelectedValue = dtselect.Rows[0]["Barrower_State"].ToString();
                dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedValue.ToString()));
                ddl_County.SelectedValue      = dtselect.Rows[0]["Barrower_County"].ToString();
                ddl_orderstatus.SelectedValue = dtselect.Rows[0]["Order_Status"].ToString();
                txt_BorrowerFirstname.Text    = dtselect.Rows[0]["Borrower_Name"].ToString();
                txt_BorrowerLastname.Text     = dtselect.Rows[0]["Last_Name"].ToString();
                txt_Date.Text            = dtselect.Rows[0]["Date"].ToString();
                txt_Notes.Text           = dtselect.Rows[0]["Notes"].ToString();
                txt_BarrowerAddress.Text = dtselect.Rows[0]["Barrower_Address"].ToString();
            }
        }
        else if (e.CommandName == "DeleteRecord")
        {
            GridViewRow row          = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
            Label       lbl_Order_ID = (Label)row.FindControl("lblOrder_id");
            Hashtable   ht           = new Hashtable();
            DataTable   dt           = new DataTable();
            ht.Add("@Trans", "DELETE");
            ht.Add("@Order_ID", lbl_Order_ID.Text);
            dt = dataaccess.ExecuteSP("Sp_Order", ht);
            Gridview_Bind_Orders();
        }
    }
Exemplo n.º 3
0
        private void Create_County_Load(object sender, EventArgs e)
        {
            dbc.BindState(ddl_State);

            BindGridCounty();
            ddl_State.Focus();
            clear();
            dbc.BindState(ddl_SearchbyState);
            dbc.BindCounty(ddl_searchCounty, int.Parse(ddl_SearchbyState.SelectedValue.ToString()));
        }
Exemplo n.º 4
0
 private void clear()
 {
     txt_Clientname.Text     = "";
     btn_Save.Text           = "Submit";
     txt_EmailId.Text        = "";
     txt_Phoneno.Text        = "";
     txt_Search_Client.Text  = "";
     txt_Zipcode.Text        = "";
     ddl_State.SelectedIndex = 0;
     dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedValue.ToString()));
     lbl_RecordAddedBy.Text = "";
     lbl_RecordAddedOn.Text = ""; AddParent();
 }
 private void cmb_State_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (cmb_State.SelectedIndex > 0)
     {
         dbc.BindCounty(Cmb_County, int.Parse(cmb_State.SelectedValue.ToString()));
     }
 }
        private void Bind_Individual_Invoice_Info()
        {
            Hashtable ht = new Hashtable();
            DataTable dt = new DataTable();

            ht.Add("@Trans", "SELECT_TAX_INVOICE_GEN_RECORD");
            ht.Add("@Tax_Invoice_Id", orderid);
            dt = dataaccess.ExecuteSP("Sp_Tax_Invoice_Entry", ht);
            if (dt.Rows.Count > 0)
            {
                ddl_ClientName.SelectedValue = int.Parse(dt.Rows[0]["Client_Id"].ToString());
                dbc.BindSubProcessName(ddl_SubProcess, int.Parse(ddl_ClientName.SelectedValue.ToString()));
                ddl_SubProcess.SelectedValue = int.Parse(dt.Rows[0]["Subclient_Id"].ToString());
                ddl_ordertype.SelectedValue  = int.Parse(dt.Rows[0]["Order_type_Id"].ToString());
                txt_OrderNumber.Text         = dt.Rows[0]["Client_Order_Number"].ToString();
                txt_APN.Text = dt.Rows[0]["APN"].ToString();
                txt_Client_order_ref.Text = dt.Rows[0]["Client_Order_Ref"].ToString();
                txt_Address.Text          = dt.Rows[0]["Address"].ToString();
                txt_Borrowername.Text     = dt.Rows[0]["Borrower_Name"].ToString();
                ddl_State.SelectedValue   = int.Parse(dt.Rows[0]["State"].ToString());
                dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedIndex.ToString()));
                ddl_County.SelectedValue = int.Parse(dt.Rows[0]["County"].ToString());

                txt_City.Text = dt.Rows[0]["City"].ToString();
                txt_Zip.Text  = dt.Rows[0]["Zip"].ToString();
                ddl_ordertask.SelectedValue = int.Parse(dt.Rows[0]["Order_Status"].ToString());
                txt_Notes.Text  = dt.Rows[0]["Notes"].ToString();
                txt_Date.Text   = dt.Rows[0]["Received_Date"].ToString();
                ddl_Hour.Text   = dt.Rows[0]["Hour"].ToString();
                ddl_Minute.Text = dt.Rows[0]["Minute"].ToString();
                ddl_Sec.Text    = dt.Rows[0]["Sec"].ToString();
                //ddl_Order_Source.SelectedValue = int.Parse(dt.Rows[0]["Order_source"].ToString());
                txt_Search_cost.Text = dt.Rows[0]["Base_Cost"].ToString();
                txt_Copy_cost.Text   = dt.Rows[0]["Maily_way_Cost"].ToString();

                txt_Tax_Invoice_baseCost.Text  = dt.Rows[0]["Base_Cost"].ToString();
                txt_Tax_Invoice_Mail_Cost.Text = dt.Rows[0]["Maily_way_Cost"].ToString();
                txt_Invoice_Date.Text          = dt.Rows[0]["Invoice_Date"].ToString();
                txt_Invoice_comments.Text      = dt.Rows[0]["Comments"].ToString();

                Indiv_Orderid = int.Parse(dt.Rows[0]["Tax_Invoice_Id"].ToString());
                orderid       = int.Parse(dt.Rows[0]["Order_ID"].ToString());
                Control_Enable_false();
            }
        }
Exemplo n.º 7
0
    protected void Bind_Order_Details()
    {
        Hashtable htselect = new Hashtable();
        DataTable dtselect = new DataTable();

        htselect.Add("@Trans", "SELECT_ORDER_WISE");
        htselect.Add("@Order_ID", Order_Id);
        dtselect = dataaccess.ExecuteSP("Sp_Order", htselect);
        if (dtselect.Rows.Count > 0)
        {
            txt_OrderNumber.Text = dtselect.Rows[0]["Client_Order_Number"].ToString();

            ddl_ordertype.SelectedValue  = dtselect.Rows[0]["Order_Type"].ToString();
            ddl_ordersTask.SelectedValue = dtselect.Rows[0]["Order_Task_Id"].ToString();
            ddl_ClientName.SelectedValue = dtselect.Rows[0]["Client_Id"].ToString();
            dbc.BindSubProcessName(ddl_SubProcess, int.Parse(ddl_ClientName.SelectedValue.ToString()));
            ddl_SubProcess.SelectedValue = dtselect.Rows[0]["Sub_ProcessId"].ToString();
            txt_PhoneNumber.Text         = dtselect.Rows[0]["Phone_Number"].ToString();
            txt_ParcelNumber.Text        = dtselect.Rows[0]["Parecel_Id"].ToString();
            txt_ContractNumber.Text      = dtselect.Rows[0]["Contract_Number"].ToString();
            txt_BatchNumber.Text         = dtselect.Rows[0]["Batch_Number"].ToString();
            txt_LoanNumber.Text          = dtselect.Rows[0]["Loan_Number"].ToString();
            txt_ZipCode.Text             = dtselect.Rows[0]["Barrower_Zip"].ToString();
            txt_City.Text           = dtselect.Rows[0]["Barrower_City"].ToString();
            ddl_State.SelectedValue = dtselect.Rows[0]["Barrower_State"].ToString();
            dbc.BindCounty(ddl_County, int.Parse(ddl_State.SelectedValue.ToString()));
            ddl_County.SelectedValue      = dtselect.Rows[0]["Barrower_County"].ToString();
            ddl_orderstatus.SelectedValue = dtselect.Rows[0]["Order_Status"].ToString();
            txt_BorrowerFirstname.Text    = dtselect.Rows[0]["Borrower_Name"].ToString();
            txt_BorrowerLastname.Text     = dtselect.Rows[0]["Last_Name"].ToString();
            txt_Date.Text            = dtselect.Rows[0]["Date"].ToString();
            txt_Notes.Text           = dtselect.Rows[0]["Notes"].ToString();
            txt_BarrowerAddress.Text = dtselect.Rows[0]["Barrower_Address"].ToString();

            grd_Bind_Order_Task_Details();
            grd_Bind_Comment_Details();
        }
    }
Exemplo n.º 8
0
        private void Order_Load()
        {
            try
            {
                if (Order_Id != 0)
                {
                    Control_Enable_false();

                    Hashtable ht_Select_Order_Details = new Hashtable();
                    DataTable dt_Select_Order_Details = new DataTable();

                    ht_Select_Order_Details.Add("@Trans", "SELECT_ORDER_WISE");
                    ht_Select_Order_Details.Add("@Order_ID", Order_Id);
                    dt_Select_Order_Details = dataaccess.ExecuteSP("Sp_Order", ht_Select_Order_Details);

                    if (dt_Select_Order_Details.Rows.Count > 0)
                    {
                        //ViewState["Orderid"] = order_Id.ToString();
                        //Session["order_id"] = order_Id.ToString();
                        txt_OrderNumber.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Number"].ToString();
                        //string date = dt_Select_Order_Details.Rows[0]["Date"].ToString();
                        System.DateTime firstDate = DateTime.ParseExact(dt_Select_Order_Details.Rows[0]["Date"].ToString(), "MM/dd/yyyy", null);
                        txt_Date.Text = firstDate.ToString();

                        ddl_ordertype.SelectedValue  = dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString();
                        ddl_ClientName.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Id"].ToString();
                        if (ddl_ClientName.SelectedIndex > 0)
                        {
                            int clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());


                            if (User_Role_Id == 1)
                            {
                                dbc.BindSubProcessName(ddl_SubProcess, clientid);
                            }
                            else
                            {
                                dbc.BindSubProcessNumber(ddl_SubProcess, clientid);
                            }
                        }

                        ddl_SubProcess.SelectedValue = dt_Select_Order_Details.Rows[0]["Sub_ProcessId"].ToString();

                        txt_Address.Text        = dt_Select_Order_Details.Rows[0]["Address"].ToString();
                        txt_APN.Text            = dt_Select_Order_Details.Rows[0]["APN"].ToString();
                        txt_City.Text           = dt_Select_Order_Details.Rows[0]["City"].ToString();
                        txt_Zip.Text            = dt_Select_Order_Details.Rows[0]["Zip"].ToString();
                        ddl_State.SelectedValue = dt_Select_Order_Details.Rows[0]["stateid"].ToString();
                        //ddl_Search_Type.SelectedItem = lblSearch_Type.Text;
                        //  ddl_ordertask.Text = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                        //  ddl_Search_Type.Text = dt_Select_Order_Details.Rows[0]["Search_Type"].ToString();
                        txt_Client_order_ref.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Ref"].ToString();
                        lbl_County_Type.Text      = dt_Select_Order_Details.Rows[0]["County_Type"].ToString();
                        ddl_Hour.Text             = dt_Select_Order_Details.Rows[0]["HH"].ToString();
                        ddl_Minute.Text           = dt_Select_Order_Details.Rows[0]["MM"].ToString();
                        ddl_Sec.Text = dt_Select_Order_Details.Rows[0]["SS"].ToString();
                        if (ddl_State.SelectedIndex > 0)
                        {
                            int stateid = int.Parse(ddl_State.SelectedValue.ToString());
                            dbc.BindCounty(ddl_County, stateid);
                        }
                        if (dt_Select_Order_Details.Rows[0]["CountyId"].ToString() != "0")
                        {
                            ddl_County.SelectedValue = dt_Select_Order_Details.Rows[0]["CountyId"].ToString();
                        }
                        else
                        {
                            ddl_County.SelectedValue = "SELECT";
                        }
                        ddl_ordertask.Text    = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                        txt_Borrowername.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name"].ToString();

                        txt_Notes.Text = dt_Select_Order_Details.Rows[0]["Notes"].ToString();

                        txt_Vendor_Order_Notes.Text = dt_Select_Order_Details.Rows[0]["Vendor_Instructions"].ToString();
                        // chk_Expidate.Checked = Convert.ToBoolean(dt_Select_Order_Details.Rows[0]["Expidate"].ToString());
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Problem in loading Order check with administrator");
            }
        }
        private void Order_Load()
        {
            if (Order_Id != 0)
            {
                Control_Enable_false();

                Hashtable ht_Select_Order_Details = new Hashtable();
                DataTable dt_Select_Order_Details = new DataTable();

                ht_Select_Order_Details.Add("@Trans", "SELECT_ORDER_WISE");
                ht_Select_Order_Details.Add("@Order_ID", Order_Id);
                dt_Select_Order_Details = dataaccess.ExecuteSP("Sp_Order", ht_Select_Order_Details);

                if (dt_Select_Order_Details.Rows.Count > 0)
                {
                    //ViewState["Orderid"] = order_Id.ToString();
                    //Session["order_id"] = order_Id.ToString();
                    txt_OrderNumber.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Number"].ToString();
                    txt_Date.Text        = dt_Select_Order_Details.Rows[0]["Date"].ToString();

                    ddl_ordertype.SelectedValue  = dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString();
                    ddl_ClientName.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Id"].ToString();


                    client_Id = int.Parse(ddl_ClientName.SelectedValue.ToString());
                    dbc.BindSubProcessName(ddl_SubProcess, client_Id);


                    ddl_SubProcess.SelectedValue = dt_Select_Order_Details.Rows[0]["Sub_ProcessId"].ToString();

                    Subprocess_id = int.Parse(ddl_SubProcess.SelectedValue.ToString());



                    dbc.Bind_Client_Email(ddl_Client_Email, client_Id);
                    txt_Address.Text        = dt_Select_Order_Details.Rows[0]["Address"].ToString();
                    txt_APN.Text            = dt_Select_Order_Details.Rows[0]["APN"].ToString();
                    txt_City.Text           = dt_Select_Order_Details.Rows[0]["City"].ToString();
                    txt_Zip.Text            = dt_Select_Order_Details.Rows[0]["Zip"].ToString();
                    ddl_State.SelectedValue = dt_Select_Order_Details.Rows[0]["stateid"].ToString();
                    //ddl_Search_Type.SelectedItem = lblSearch_Type.Text;
                    //  ddl_ordertask.Text = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                    //  ddl_Search_Type.Text = dt_Select_Order_Details.Rows[0]["Search_Type"].ToString();
                    txt_Client_order_ref.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Ref"].ToString();
                    lbl_County_Type.Text      = dt_Select_Order_Details.Rows[0]["County_Type"].ToString();
                    ddl_Hour.Text             = dt_Select_Order_Details.Rows[0]["HH"].ToString();
                    ddl_Minute.Text           = dt_Select_Order_Details.Rows[0]["MM"].ToString();
                    ddl_Sec.Text = dt_Select_Order_Details.Rows[0]["SS"].ToString();
                    if (ddl_State.SelectedIndex > 0)
                    {
                        int stateid = int.Parse(ddl_State.SelectedValue.ToString());
                        dbc.BindCounty(ddl_County, stateid);
                    }
                    if (dt_Select_Order_Details.Rows[0]["CountyId"].ToString() != "0")
                    {
                        ddl_County.SelectedValue = dt_Select_Order_Details.Rows[0]["CountyId"].ToString();
                    }
                    else
                    {
                        ddl_County.SelectedValue = "SELECT";
                    }
                    ddl_ordertask.Text             = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                    txt_Borrowername.Text          = dt_Select_Order_Details.Rows[0]["Borrower_Name"].ToString();
                    ddl_Client_Email.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Email_Id"].ToString();
                    txt_Notes.Text           = dt_Select_Order_Details.Rows[0]["Notes"].ToString();
                    txt_Order_Cost_Date.Text = DateTime.Now.ToString();
                }
            }
        }
Exemplo n.º 10
0
        private void Order_Load()
        {
            if (Order_Id != 0)
            {
                Control_Enable_false();

                Hashtable ht_Select_Order_Details = new Hashtable();
                DataTable dt_Select_Order_Details = new DataTable();

                ht_Select_Order_Details.Add("@Trans", "SELECT_ORDER_WISE");
                ht_Select_Order_Details.Add("@Order_ID", Order_Id);
                dt_Select_Order_Details = dataaccess.ExecuteSP("Sp_Order", ht_Select_Order_Details);

                if (dt_Select_Order_Details.Rows.Count > 0)
                {
                    //ViewState["Orderid"] = order_Id.ToString();
                    //Session["order_id"] = order_Id.ToString();
                    txt_OrderNumber.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Number"].ToString();
                    txt_Date.Text        = dt_Select_Order_Details.Rows[0]["Date"].ToString();

                    ddl_ordertype.SelectedValue  = dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString();
                    Inhouse_Order_Type_Id        = int.Parse(dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString());
                    ddl_ClientName.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Id"].ToString();
                    if (ddl_ClientName.SelectedIndex > 0)
                    {
                        client_Id         = int.Parse(ddl_ClientName.SelectedValue.ToString());
                        Inhouse_Client_Id = client_Id;
                        dbc.BindSubProcessName(ddl_SubProcess, client_Id);
                    }

                    ddl_SubProcess.SelectedValue = dt_Select_Order_Details.Rows[0]["Sub_ProcessId"].ToString();

                    Subprocess_id = int.Parse(ddl_SubProcess.SelectedValue.ToString());


                    Subprocess_id = int.Parse(ddl_SubProcess.SelectedValue.ToString());

                    Inhouse_SubClient_Id    = Subprocess_id;
                    txt_Address.Text        = dt_Select_Order_Details.Rows[0]["Address"].ToString();
                    txt_APN.Text            = dt_Select_Order_Details.Rows[0]["APN"].ToString();
                    txt_City.Text           = dt_Select_Order_Details.Rows[0]["City"].ToString();
                    txt_Zip.Text            = dt_Select_Order_Details.Rows[0]["Zip"].ToString();
                    ddl_State.SelectedValue = dt_Select_Order_Details.Rows[0]["stateid"].ToString();
                    //ddl_Search_Type.SelectedItem = lblSearch_Type.Text;
                    //  ddl_ordertask.Text = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                    //  ddl_Search_Type.Text = dt_Select_Order_Details.Rows[0]["Search_Type"].ToString();
                    txt_Client_order_ref.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Ref"].ToString();
                    lbl_County_Type.Text      = dt_Select_Order_Details.Rows[0]["County_Type"].ToString();
                    ddl_Hour.Text             = dt_Select_Order_Details.Rows[0]["HH"].ToString();
                    ddl_Minute.Text           = dt_Select_Order_Details.Rows[0]["MM"].ToString();
                    ddl_Sec.Text = dt_Select_Order_Details.Rows[0]["SS"].ToString();
                    if (ddl_State.SelectedIndex > 0)
                    {
                        int stateid = int.Parse(ddl_State.SelectedValue.ToString());
                        Inhouse_State_Id = stateid;
                        dbc.BindCounty(ddl_County, stateid);
                    }
                    if (dt_Select_Order_Details.Rows[0]["CountyId"].ToString() != "0")
                    {
                        ddl_County.SelectedValue = dt_Select_Order_Details.Rows[0]["CountyId"].ToString();
                        Inhouse_County_Id        = int.Parse(dt_Select_Order_Details.Rows[0]["CountyId"].ToString());
                    }
                    else
                    {
                        ddl_County.SelectedValue = "SELECT";
                    }
                    ddl_ordertask.Text    = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                    txt_Borrowername.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name"].ToString();

                    txt_Notes.Text = dt_Select_Order_Details.Rows[0]["Notes"].ToString();
                    if (Operation != "Update")
                    {
                        txt_Invoice_Date.Text = DateTime.Now.ToString();
                    }
                    if (dt_Select_Order_Details.Rows[0]["External_Order_Id"] != "" && dt_Select_Order_Details.Rows[0]["External_Order_Id"] != null)
                    {
                        External_Order_Id      = int.Parse(dt_Select_Order_Details.Rows[0]["External_Order_Id"].ToString());
                        External_Client_Id     = int.Parse(dt_Select_Order_Details.Rows[0]["External_Client_Id"].ToString());
                        External_Sub_Client_Id = int.Parse(dt_Select_Order_Details.Rows[0]["External_Sub_Client_Id"].ToString());
                    }
                    else
                    {
                        txt_Invoice_Search_Cost.Text      = "";
                        txt_No_Of_Pages.Text              = "";
                        txt_Invoice_Copy_Cost.Text        = "";
                        txt_Inhouse_Search_Cost.Text      = "";
                        txt_Inhouse_Copy_Cost.Text        = "";
                        txt_Inhouse_No_of_page.Text       = "";
                        txt_Inhouse_Drn_Cost.Text         = "";
                        txt_Inhouse_Db_Cost.Text          = "";
                        ddl_Production_Unit.SelectedIndex = 1;
                    }
                }
            }
        }
        private void Order_Load()
        {
            if (Order_Id != 0)
            {
                Control_Enable_false();

                if (User_Role == "1" || User_Role == "6")
                {
                }
                else
                {
                    txt_Order_Cost.Enabled           = false;
                    txt_Order_Cost.PasswordChar      = '*';
                    txt_Search_cost.PasswordChar     = '*';
                    txt_Copy_cost.PasswordChar       = '*';
                    txt_Abstractor_Cost.PasswordChar = '*';
                    txt_noofpage.PasswordChar        = '*';
                }



                Hashtable ht_Select_Order_Details = new Hashtable();
                DataTable dt_Select_Order_Details = new DataTable();

                ht_Select_Order_Details.Add("@Trans", "SELECT_ORDER_WISE");
                ht_Select_Order_Details.Add("@Order_ID", Order_Id);
                dt_Select_Order_Details = dataaccess.ExecuteSP("Sp_Order", ht_Select_Order_Details);

                if (dt_Select_Order_Details.Rows.Count > 0)
                {
                    //ViewState["Orderid"] = order_Id.ToString();
                    //Session["order_id"] = order_Id.ToString();
                    txt_OrderNumber.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Number"].ToString();
                    txt_Date.Text        = dt_Select_Order_Details.Rows[0]["Date"].ToString();

                    ddl_ordertype.SelectedValue = dt_Select_Order_Details.Rows[0]["Order_Type_Id"].ToString();
                    int ordertype = int.Parse(ddl_ordertype.SelectedValue.ToString());


                    if (ordertype == 7 && txt_Order_Prior_Date.Text == " " && dt_Select_Order_Details.Rows[0]["Order_Prior_Date"].ToString() == "")
                    {
                        lbl_Order_Prior_Date.Visible = true;
                        txt_Order_Prior_Date.Visible = true;
                        lbl_order_Prior_mark.Visible = true;
                    }
                    else if (ordertype == 7 && dt_Select_Order_Details.Rows[0]["Order_Prior_Date"].ToString() != "")
                    {
                        DateCustom = 1;
                        lbl_Order_Prior_Date.Visible = true;
                        txt_Order_Prior_Date.Visible = true;
                        lbl_order_Prior_mark.Visible = true;

                        txt_Order_Prior_Date.Text = dt_Select_Order_Details.Rows[0]["Order_Prior_Date"].ToString();
                    }
                    else
                    {
                        lbl_Order_Prior_Date.Visible = false;
                        txt_Order_Prior_Date.Visible = false;
                        lbl_order_Prior_mark.Visible = false;
                    }



                    ddl_ClientName.SelectedValue = dt_Select_Order_Details.Rows[0]["Client_Id"].ToString();
                    if (ddl_ClientName.SelectedIndex > 0)
                    {
                        clientid = int.Parse(ddl_ClientName.SelectedValue.ToString());
                        if (User_Role == "1")
                        {
                            dbc.BindSubProcessName(ddl_SubProcess, clientid);
                        }
                        else

                        {
                            dbc.BindSubProcessNumber(ddl_SubProcess, clientid);
                        }
                    }

                    ddl_SubProcess.SelectedValue = dt_Select_Order_Details.Rows[0]["Sub_ProcessId"].ToString();
                    dbc.Bind_Order_Assign_Type(ddl_County_Type);
                    txt_Address.Text          = dt_Select_Order_Details.Rows[0]["Address"].ToString();
                    txt_APN.Text              = dt_Select_Order_Details.Rows[0]["APN"].ToString();
                    txt_City.Text             = dt_Select_Order_Details.Rows[0]["City"].ToString();
                    txt_Zip.Text              = dt_Select_Order_Details.Rows[0]["Zip"].ToString();
                    ddl_State.SelectedValue   = dt_Select_Order_Details.Rows[0]["stateid"].ToString();
                    txt_Abstractor_Notes.Text = dt_Select_Order_Details.Rows[0]["Abstractor_Note"].ToString();
                    ddl_Abstractor_Search_Type.SelectedValue = dt_Select_Order_Details.Rows[0]["Abstractor_Search_Type_ID"].ToString();
                    ddl_Client_Email.SelectedValue           = dt_Select_Order_Details.Rows[0]["Client_Email_Id"].ToString();
                    //ddl_Search_Type.SelectedItem = lblSearch_Type.Text;
                    //  ddl_ordertask.Text = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();
                    //  ddl_Search_Type.Text = dt_Select_Order_Details.Rows[0]["Search_Type"].ToString();
                    txt_Client_order_ref.Text = dt_Select_Order_Details.Rows[0]["Client_Order_Ref"].ToString();
                    lbl_County_Type.Text      = dt_Select_Order_Details.Rows[0]["County_Type"].ToString();
                    // Assign_County_Type = dt_Select_Order_Details.Rows[0]["Order_Assign_Type"].ToString();
                    ddl_County_Type.Text = dt_Select_Order_Details.Rows[0]["County_Type"].ToString();
                    ddl_Hour.Text        = dt_Select_Order_Details.Rows[0]["HH"].ToString();
                    ddl_Minute.Text      = dt_Select_Order_Details.Rows[0]["MM"].ToString();
                    ddl_Sec.Text         = dt_Select_Order_Details.Rows[0]["SS"].ToString();
                    //txt_Order_Prior_Date.Text = dt_Select_Order_Details.Rows[0]["Order_Prior_Date"].ToString();
                    if (ddl_State.SelectedIndex > 0)
                    {
                        int stateid = int.Parse(ddl_State.SelectedValue.ToString());
                        dbc.BindCounty(ddl_County, stateid);
                    }
                    if (dt_Select_Order_Details.Rows[0]["CountyId"].ToString() != "0")
                    {
                        ddl_County.SelectedValue = dt_Select_Order_Details.Rows[0]["CountyId"].ToString();
                    }
                    else
                    {
                        ddl_County.SelectedValue = "SELECT";
                    }

                    //if (dt_Select_Order_Details.Rows[0]["Order_Status"].ToString() == "15" || dt_Select_Order_Details.Rows[0]["Order_Status"].ToString() == "16")
                    //{
                    //    ddl_ordertask.SelectedValue = "3";

                    //}
                    //else
                    //{
                    //    ddl_ordertask.Text = dt_Select_Order_Details.Rows[0]["Order_Status"].ToString();

                    //}
                    Session_Order_Task    = int.Parse(dt_Select_Order_Details.Rows[0]["Order_Status_Id"].ToString());
                    txt_Borrowername.Text = dt_Select_Order_Details.Rows[0]["Borrower_Name"].ToString();

                    txt_Notes.Text = dt_Select_Order_Details.Rows[0]["Notes"].ToString();

                    ddl_County_Type.Text = dt_Select_Order_Details.Rows[0]["County_Type"].ToString();

                    if (dt_Select_Order_Details.Rows[0]["Copy_Type"].ToString() != "" && dt_Select_Order_Details.Rows[0]["Copy_Type"].ToString() != null)
                    {
                        ddl_Copy_Type.Text = dt_Select_Order_Details.Rows[0]["Copy_Type"].ToString();

                        if (dt_Select_Order_Details.Rows[0]["Copy_Type"].ToString() == "Full")
                        {
                            ddl_Copy_Type.SelectedIndex = 1;
                        }
                        else if (dt_Select_Order_Details.Rows[0]["Copy_Type"].ToString() == "Pertinent")
                        {
                            ddl_Copy_Type.SelectedIndex = 2;
                        }
                    }
                    else
                    {
                        ddl_Copy_Type.SelectedIndex = 0;
                    }
                }
                Hashtable ht_Task_Details = new Hashtable();
                DataTable dt_Task_Details = new DataTable();

                if (Entry_Type == "Rework")
                {
                    ht_Task_Details.Add("@Trans", "SELECT_REWORK_TASK");
                }
                else if (Entry_Type == "Superqc")
                {
                    ht_Task_Details.Add("@Trans", "SELECT_SUPERQC_TASK");
                }
                ht_Task_Details.Add("@Order_ID", Order_Id);
                dt_Task_Details = dataaccess.ExecuteSP("Sp_Order", ht_Task_Details);
                if (dt_Task_Details.Rows.Count > 0)
                {
                    ddl_ordertask.Text = dt_Task_Details.Rows[0]["Order_Status"].ToString();
                }
                Order_Controls_Load();
            }
            else
            {
                //btn_Save.Text = "Add New Order";
            }
        }