private void btn_Send_All_Click(object sender, EventArgs e) { if (grd_All_Tax_Completed_orders.Rows.Count > 0) { DialogResult send_all = MessageBox.Show("Do you want to send all Tax certificate mails", "Mail Confirmation", MessageBoxButtons.YesNo); if (send_all == DialogResult.Yes) { form_loader.Start_progres(); btn_Send_All.Enabled = false; //COUNT_SEND Hashtable ht_ntsend = new Hashtable(); DataTable dt_ntsend = new DataTable(); ht_ntsend.Add("@Trans", "COUNT_NOT_SEND"); dt_ntsend = dataAccess.ExecuteSP("Sp_Tax_Order_Status", ht_ntsend); if (dt_ntsend.Rows.Count > 0) { COUNT = int.Parse(dt_ntsend.Rows[0]["count_not_send"].ToString()); } else { COUNT = 0; } for (int i = 0; i < grd_All_Tax_Completed_orders.Rows.Count; i++) { bool ischeck = (bool)grd_All_Tax_Completed_orders[0, i].FormattedValue; if (ischeck) { try { int orderid = int.Parse(grd_All_Tax_Completed_orders.Rows[i].Cells[12].Value.ToString()); string orderno = grd_All_Tax_Completed_orders.Rows[i].Cells[2].Value.ToString(); string emailid = grd_All_Tax_Completed_orders.Rows[i].Cells[13].Value.ToString(); Ordermanagement_01.Tax.Tax_mail mail = new Ordermanagement_01.Tax.Tax_mail(orderid, userid, user_role, orderno, "Bulk", emailid); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } Bind_All_tax_completed(); if (COUNT > grd_All_Tax_Completed_orders.Rows.Count) { MessageBox.Show("Mail Sent Successfully"); } btn_Send_All.Enabled = true; } else { } } }
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(); } } }