protected static void SendEmails(Tuple <int, string, string, string, string>[] messagesInfo)
    {
        for (int i = 0; i < messagesInfo.Length; i++)
        {
            Tuple <int, string, string, string, string> messageInfo = (Tuple <int, string, string, string, string>)messagesInfo[i];
            int    patientID = messageInfo.Item1;
            string orgName   = messageInfo.Item2;
            string email     = messageInfo.Item3;
            string message   = messageInfo.Item4;
            string subject   = messageInfo.Item5;

            try
            {
                SendEmail(orgName, email, subject, message);
                EmailHistoryDataDB.Insert(2, patientID, -1, email, message);
            }
            catch (Exception ex)
            {
                Logger.LogSMSSend(
                    email + Environment.NewLine + Environment.NewLine +
                    message + Environment.NewLine + Environment.NewLine +
                    subject + Environment.NewLine + Environment.NewLine +
                    ex.ToString(),
                    true);

                Logger.LogException(ex, true);
            }
        }
    }
    protected void FillGrid()
    {
        DataTable dt = EmailHistoryDataDB.GetDataTable(2, false);

        Session["data_email_history"] = dt;

        if (dt.Rows.Count > 0)
        {
            if (IsPostBack && Session["sortExpression_email_history"] != null && Session["sortExpression_email_history"].ToString().Length > 0)
            {
                DataView dataView = new DataView(dt);
                dataView.Sort = Session["sortExpression_email_history"].ToString();
                GrdEmailHistory.DataSource = dataView;
            }
            else
            {
                GrdEmailHistory.DataSource = dt;
            }


            try
            {
                GrdEmailHistory.DataBind();
                GrdEmailHistory.PagerSettings.FirstPageText = "1";
                GrdEmailHistory.PagerSettings.LastPageText  = GrdEmailHistory.PageCount.ToString();
                GrdEmailHistory.DataBind();
            }
            catch (Exception ex)
            {
                SetErrorMessage(ex.ToString());
            }
        }
        else
        {
            dt.Rows.Add(dt.NewRow());
            GrdEmailHistory.DataSource = dt;
            GrdEmailHistory.DataBind();

            int TotalColumns = GrdEmailHistory.Rows[0].Cells.Count;
            GrdEmailHistory.Rows[0].Cells.Clear();
            GrdEmailHistory.Rows[0].Cells.Add(new TableCell());
            GrdEmailHistory.Rows[0].Cells[0].ColumnSpan = TotalColumns;
            GrdEmailHistory.Rows[0].Cells[0].Text       = "No Record Found";
        }
    }
    protected static void SendEmails(Tuple <int, string, string, string, string>[] messagesInfo)
    {
        for (int i = 0; i < messagesInfo.Length; i++)
        {
            Tuple <int, string, string, string, string> messageInfo = (Tuple <int, string, string, string, string>)messagesInfo[i];
            int    bookingID = messageInfo.Item1;
            string orgName   = messageInfo.Item2;
            string email     = messageInfo.Item3;
            string message   = messageInfo.Item4;
            string subject   = messageInfo.Item5;

            try
            {
                if (Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["LogSMSSending"]))
                {
                    Logger.LogSMSSend(
                        System.Web.HttpContext.Current.Session["DB"].ToString() + Environment.NewLine + Environment.NewLine +
                        email + Environment.NewLine + Environment.NewLine +
                        message + Environment.NewLine + Environment.NewLine +
                        subject + Environment.NewLine + Environment.NewLine,
                        true);
                }

                SendEmail(orgName, email, subject, message);
                EmailHistoryDataDB.Insert(1, -1, bookingID, email, message);
            }
            catch (Exception ex)
            {
                Logger.LogSMSSend(
                    email + Environment.NewLine + Environment.NewLine +
                    message + Environment.NewLine + Environment.NewLine +
                    subject + Environment.NewLine + Environment.NewLine +
                    ex.ToString(),
                    true);

                Logger.LogException(ex, true);
            }
        }
    }