private void grd_order_Allocated_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.RowIndex != -1)
     {
         if (e.ColumnIndex == 2)
         {
             string             Order_Id     = grd_order_Allocated.Rows[e.RowIndex].Cells[14].Value.ToString();
             string             Order_Number = grd_order_Allocated.Rows[e.RowIndex].Cells[2].Value.ToString();
             Tax.Tax_Order_View taxorview    = new Tax_Order_View(Order_Id, User_Id, Order_Number, User_Role);
             taxorview.Show();
         }
     }
 }
 private void grd_All_Tax_Completed_orders_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.RowIndex != -1)
     {
         if (e.ColumnIndex == 2)
         {
             //view the order information
             string         Order_Id     = grd_All_Tax_Completed_orders.Rows[e.RowIndex].Cells[12].Value.ToString();
             string         Order_Number = grd_All_Tax_Completed_orders.Rows[e.RowIndex].Cells[2].Value.ToString();
             Tax_Order_View txview       = new Tax_Order_View(Order_Id, userid, Order_Number, user_role);
             txview.Show();
         }
         if (e.ColumnIndex == 10)
         {
             //view pdf
             //htorder.Clear(); dtorder.Clear();
             //htorder.Add("@Trans", "SELECT_MAX_UPLOAD_DOCUMENTS");
             //htorder.Add("@Order_Id", int.Parse(grd_All_Tax_Completed_orders.Rows[e.RowIndex].Cells[12].Value.ToString()));
             //dtorder = dataAccess.ExecuteSP("Sp_Tax_Order_Status", htorder);
             //if (dtorder.Rows.Count > 0)
             //{
             //    string path = dtorder.Rows[0]["Document_Path"].ToString();
             //    System.Diagnostics.Process.Start(path);
             //}
             //SELECT_MAX_UPLOAD_DOCUMENTS
         }
         else if (e.ColumnIndex == 11)
         {
             //send email
             DialogResult dialog = MessageBox.Show("Do you want to send Tax certificate mail", "Mail Confirmation", MessageBoxButtons.YesNo);
             if (dialog == DialogResult.Yes)
             {
                 form_loader.Start_progres();
                 int    orderid = int.Parse(grd_All_Tax_Completed_orders.Rows[e.RowIndex].Cells[12].Value.ToString());
                 string orderno = grd_All_Tax_Completed_orders.Rows[e.RowIndex].Cells[2].Value.ToString();
                 string emailid = grd_All_Tax_Completed_orders.Rows[e.RowIndex].Cells[13].Value.ToString();
                 Ordermanagement_01.Tax.Tax_mail mail = new Ordermanagement_01.Tax.Tax_mail(orderid, userid, user_role, orderno, "", emailid);
             }
             else
             {
             }
             Bind_All_tax_completed();
         }
     }
 }
        private void gridViewTaxOrders_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
        {
            if (e.Column.FieldName == "Client_Order_Number")
            {
                if (Operation == "My_Orders")
                {
                    string Order_Id         = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_ID").ToString();
                    string Order_Task_Id    = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_Task").ToString();
                    string Tax_TAsk_Id      = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Task_Id").ToString();
                    string Tax_Status       = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Status_Id").ToString();
                    string Order_Number     = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Client_Order_Number").ToString();
                    string Check_Tax_Status = "";
                    if (Order_Process == "Internal_Tax_Request")
                    {
                        Hashtable htcheck_Order_Status = new Hashtable();
                        DataTable dtcheck_Order_Status = new DataTable();

                        htcheck_Order_Status.Add("@Trans", "GET_INTERNAL_TAX_ORDER_STATUS");
                        htcheck_Order_Status.Add("@Order_Id", Order_Id);
                        dtcheck_Order_Status = dataaccess.ExecuteSP("Sp_Tax_Orders", htcheck_Order_Status);
                        string Order_Status = dtcheck_Order_Status.Rows[0]["Order_Progress"].ToString();
                        if (dtcheck_Order_Status.Rows.Count > 0)
                        {
                            Check_Tax_Status = dtcheck_Order_Status.Rows[0]["Search_Tax_Request"].ToString();
                        }
                        else
                        {
                            Check_Tax_Status = "False";
                        }
                        if (Order_Status != "4")
                        {
                            if (Check_Tax_Status == "True")
                            {
                                // Inserting Order Timings for the user
                                Hashtable ht_InserT_Time = new Hashtable();
                                DataTable dt_Insert_Time = new DataTable();
                                ht_InserT_Time.Add("@Trans", "INSERT");
                                ht_InserT_Time.Add("@Order_Id", Order_Id);
                                ht_InserT_Time.Add("@Tax_Task", Tax_TAsk_Id);
                                ht_InserT_Time.Add("@Tax_Status", Tax_Status);
                                ht_InserT_Time.Add("@User_Id", User_Id);
                                ht_InserT_Time.Add("@Status", "True");
                                var Time_Id = dataaccess.ExecuteSPForScalar("Sp_Tax_Order_User_Timings", ht_InserT_Time);

                                int Order_Time_Id         = int.Parse(Time_Id.ToString());
                                Tax_Order_Processing txpr = new Tax_Order_Processing(Order_Id, Order_Task_Id, Tax_TAsk_Id, Tax_Status, User_Id, Order_Number, User_Role, Order_Time_Id);
                                txpr.Show();
                                this.Close();
                            }
                            else
                            {
                                MessageBox.Show("This Order has been cancelled from the internal Search Team");
                            }
                        }
                        else
                        {
                            MessageBox.Show("This Order has been cancelled from the internal Search Team");
                        }
                    }
                    else
                    {
                        // Inserting Order Timings for the user

                        Hashtable ht_InserT_Time = new Hashtable();
                        DataTable dt_Insert_Time = new DataTable();
                        ht_InserT_Time.Add("@Trans", "INSERT");
                        ht_InserT_Time.Add("@Order_Id", Order_Id);
                        ht_InserT_Time.Add("@Tax_Task", Tax_TAsk_Id);
                        ht_InserT_Time.Add("@Tax_Status", Tax_Status);
                        ht_InserT_Time.Add("@User_Id", User_Id);
                        ht_InserT_Time.Add("@Status", "True");
                        var Time_Id               = dataaccess.ExecuteSPForScalar("Sp_Tax_Order_User_Timings", ht_InserT_Time);
                        int Order_Time_Id         = int.Parse(Time_Id.ToString());
                        Tax_Order_Processing txpr = new Tax_Order_Processing(Order_Id, Order_Task_Id, Tax_TAsk_Id, Tax_Status, User_Id, Order_Number, User_Role, Order_Time_Id);
                        txpr.Show();
                        this.Close();
                    }
                }
                else
                {
                    string         Order_Id      = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_ID").ToString();
                    string         Order_Task_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_Task").ToString();
                    string         Tax_TAsk_Id   = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Task_Id").ToString();
                    string         Tax_Status    = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Status_Id").ToString();
                    string         Order_Number  = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Client_Order_Number").ToString();
                    Tax_Order_View txview        = new Tax_Order_View(Order_Id, User_Id, Order_Number, User_Role);
                    txview.Show();
                }
            }
        }