private void btn_New_Monthlyinvoice_Click(object sender, EventArgs e)
 {
     Ordermanagement_01.Tax.Tax_Monthly_Invoice monthly_invoice = new Ordermanagement_01.Tax.Tax_Monthly_Invoice(userid, "Insert", "0000", 0, 0, 0, "", "", "");
     monthly_invoice.Show();
 }
        private void grd_Monthly_Invoice_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1)
            {
                if (e.ColumnIndex == 2)
                {
                    //viewing the information
                    string invoiceno    = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[2].Value.ToString();
                    int    invoiceid    = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[13].Value.ToString());
                    int    clientid     = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[14].Value.ToString());
                    int    subprocessid = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[15].Value.ToString());
                    string invoicedate  = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[10].Value.ToString();
                    string invoice_cmt  = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[16].Value.ToString();
                    string invoice_mon  = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[17].Value.ToString();
                    Ordermanagement_01.Tax.Tax_Monthly_Invoice monthly = new Ordermanagement_01.Tax.Tax_Monthly_Invoice(userid, "VIEW", invoiceno, invoiceid, clientid, subprocessid, invoicedate, invoice_cmt, invoice_mon);
                    monthly.Show();
                }

                else if (e.ColumnIndex == 11)
                {
                    //view the reports
                    int invoiceid = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[13].Value.ToString());
                    int clientid  = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[14].Value.ToString());
                    Ordermanagement_01.Tax.Tax_Invoice_Reports.Tax_Monthly_Invoice_rpt monthly11 = new Ordermanagement_01.Tax.Tax_Invoice_Reports.Tax_Monthly_Invoice_rpt(invoiceid, clientid);
                    monthly11.Show();
                }
                else if (e.ColumnIndex == 12)
                {
                    //email sending
                    form_loader.Start_progres();
                    DialogResult dialog = MessageBox.Show("Do you want to send Tax Monthly Invoice", "Send mail Confirmation", MessageBoxButtons.YesNo);
                    if (dialog == DialogResult.Yes)
                    {
                        int    invoiceid    = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[13].Value.ToString());
                        int    clientid     = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[14].Value.ToString());
                        int    subprocessid = int.Parse(grd_Monthly_Invoice.Rows[e.RowIndex].Cells[15].Value.ToString());
                        string invoiceno    = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[2].Value.ToString();
                        string invoicedate  = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[10].Value.ToString();
                        string invoice_cmt  = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[16].Value.ToString();
                        string invoice_mon  = grd_Monthly_Invoice.Rows[e.RowIndex].Cells[17].Value.ToString();
                        //int USER_ID, string OPERATION, string INV_NUM,int INVOICE_ID,int CLIENT_ID,int SUB_PROCESS_ID,string INVOICE_DATE,string INVOICE_COMMENTS,string INVOICE_MONTH
                        Ordermanagement_01.Tax.Tax_Invoice_Send_Email email = new Ordermanagement_01.Tax.Tax_Invoice_Send_Email(invoiceid, clientid, subprocessid, userid, invoiceno, invoicedate, invoice_cmt, invoice_mon);
                        // email.Show();
                        Hashtable htck = new Hashtable();
                        DataTable dtck = new DataTable();
                        htck.Add("@Trans", "CHECK_TAX_INVOICE_EMAIL_STATUS");
                        htck.Add("@Tax_MonthlyInvoice_Id", invoiceid);
                        dtck = dataaccess.ExecuteSP("Sp_Tax_Monthly_Invoice_Entry", htck);
                        if (dtck.Rows.Count > 0)
                        {
                            if (dtck.Rows[0]["Email_Status"].ToString() == "True")
                            {
                                MessageBox.Show("Tax Monthly Invoice Sent successfully");
                            }
                            else
                            {
                                //MessageBox.Show("Tax Monthly Invoice ");
                            }
                        }
                    }
                    Bind_Monthly_Invoice_data();
                }
            }
        }