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();
}
}
}
