private void grd_Proposal_Email_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1)
            {
                if (e.ColumnIndex == 13)
                {
                    //mail sending code
                    form_loader.Start_progres();

                    string Clientname = grd_Proposal_Email.Rows[e.RowIndex].Cells[4].Value.ToString();
                    string clientid = grd_Proposal_Email.Rows[e.RowIndex].Cells[1].Value.ToString();
                    string emailid = grd_Proposal_Email.Rows[e.RowIndex].Cells[5].Value.ToString();
                    int proposal_clientid = int.Parse(grd_Proposal_Email.Rows[e.RowIndex].Cells[1].Value.ToString());
                    //Ordermanagement_01.Client_Proposal.Proposal_Email email = new Ordermanagement_01.Client_Proposal.Proposal_Email(clientid, Clientname, User_id, emailid, proposal_clientid);

                    Ordermanagement_01.Client_Proposal.Sample email = new Ordermanagement_01.Client_Proposal.Sample(clientid, Clientname, User_id, emailid, proposal_clientid, "", int.Parse(ddl_Proposal_From.SelectedValue.ToString()));

                    //email.Show();
                    if (rbtn_Proposal_NotSended.Checked == true)
                    {
                        Bind_Proposal_Not_send();
                    }
                    else
                    {
                        Bind_Proposal_send();
                    }

                    //Bind_Proposal_Not_send();
                }
                else if (e.ColumnIndex == 8)
                {
                    form_loader.Start_progres();

                    string Clientname = grd_Proposal_Email.Rows[e.RowIndex].Cells[4].Value.ToString();
                    string clientid = grd_Proposal_Email.Rows[e.RowIndex].Cells[1].Value.ToString();
                    string emailid = grd_Proposal_Email.Rows[e.RowIndex].Cells[5].Value.ToString();
                    int proposal_clientid = int.Parse(grd_Proposal_Email.Rows[e.RowIndex].Cells[1].Value.ToString());
                    string inserted_by = grd_Proposal_Email.Rows[e.RowIndex].Cells[9].Value.ToString();
                    string modified_by = grd_Proposal_Email.Rows[e.RowIndex].Cells[10].Value.ToString();

                    Ordermanagement_01.Client_Proposal.Client_Proposal_History history = new Ordermanagement_01.Client_Proposal.Client_Proposal_History(clientid, Clientname, User_id, emailid, proposal_clientid, inserted_by, modified_by, int.Parse(ddl_Proposal_From.SelectedValue.ToString()));
                    history.Show();

                }

            }
        }
        private void btn_Send_All_Click(object sender, EventArgs e)
        {
            //form_loader.Start_progres();
            loader.startProgress();
            btn_Send_All.Enabled = false;
            for (int i = 0; i < grd_Proposal_Email.Rows.Count; i++)
            {
                bool ischeck = (bool)grd_Proposal_Email[0, i].FormattedValue;
                if (ischeck == true)
                {
                    //sending mail
                    string client_name = grd_Proposal_Email.Rows[i].Cells[4].Value.ToString();
                    string client_id = grd_Proposal_Email.Rows[i].Cells[1].Value.ToString();
                    string emailid = grd_Proposal_Email.Rows[i].Cells[5].Value.ToString();
                    int proposal_clientid = int.Parse(grd_Proposal_Email.Rows[i].Cells[1].Value.ToString());

                    Ordermanagement_01.Client_Proposal.Sample email = new Ordermanagement_01.Client_Proposal.Sample(client_id, client_name, User_id, emailid, proposal_clientid, "bulk",int.Parse(ddl_Proposal_From.SelectedValue.ToString()));

                    //MessageBox.Show("Mail Sended Successfully");
                }
                else
                {
                    check = check + 1;
                }
            }
            if (check == grd_Proposal_Email.Rows.Count)
            {
                btn_Send_All.Enabled = true;
                loader.stopProgress();
                MessageBox.Show("Kindly select, whichever Email want to be send");
                check = 0;
                Bind_Proposal_Not_send();
            }
            else
            {
                btn_Send_All.Enabled = true;
                Bind_Proposal_Not_send();
                loader.stopProgress();
                MessageBox.Show("Mail Sent Successfully");
                check = 0;
                check_All.Checked = false;
            }
        }