using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net;

namespace Newdelhibarassocia.dhadmin
{
    public partial class sendsms : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(
     ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindmember();
                bindtemplate();
            }
        }

        // ================= MEMBERS =================

        void bindmember()
        {
            SqlDataAdapter da = new SqlDataAdapter(@"
        select
Mobile_1,
            Ndbano,
            F_name,
            L_name,
            Resid_1,
            Bcdenroll
        from Memberslist where Bcdenroll!='' and Bcdenroll!='0'
        order by F_name asc", con);

            DataTable dt = new DataTable();

            da.Fill(dt);

            CheckBoxList1.DataSource = dt;

            CheckBoxList1.DataTextField = "F_name";

            CheckBoxList1.DataValueField = "Mobile_1";

            CheckBoxList1.DataBind();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                CheckBoxList1.Items[i].Text =
                    dt.Rows[i]["F_name"].ToString() + " " +
                    dt.Rows[i]["L_name"].ToString() +
                    " | Enroll : " +
                    dt.Rows[i]["Bcdenroll"].ToString()+
                " | NDBA No. : " +
                   dt.Rows[i]["Ndbano"].ToString();
            }
        }

        // ================= TEMPLATE =================

        void bindtemplate()
        {
            SqlDataAdapter da = new SqlDataAdapter(@"
        select Id,Subject
        from D_TemplateMaster where TemplateType='SMS'
        order by Id desc", con);

            DataTable dt = new DataTable();

            da.Fill(dt);

            DropDownList1.DataSource = dt;

            DropDownList1.DataTextField = "Subject";

            DropDownList1.DataValueField = "Id";

            DropDownList1.DataBind();

            DropDownList1.Items.Insert(0, "Select Template");
        }

        // ================= TEMPLATE MESSAGE =================

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (DropDownList1.SelectedIndex > 0)
            {
                SqlDataAdapter da = new SqlDataAdapter(@"
            select *
            from D_TemplateMaster
            where Id='" + DropDownList1.SelectedValue + "'", con);

                DataTable dt = new DataTable();

                da.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    TextBox1.Text =
                        dt.Rows[0]["BodyMessage"].ToString();
                }
            }
        }

        // ================= SELECT ALL =================

        protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
        {
            foreach (ListItem item in CheckBoxList1.Items)
            {
                item.Selected = CheckBox1.Checked;
            }
        }

        // ================= SEND =================

        protected void Button1_Click(object sender, EventArgs e)
        {
            string selectedmember = "";
            WebClient client = new WebClient();
            foreach (ListItem item in CheckBoxList1.Items)
            {
                if (item.Selected)
                {
                    selectedmember += item.Text + "<br/>";
                    // send sms
                    
                    if (item.Value != "0")
                    {
                        string URL = "http://www.canlog.in/api/mt/SendSMS?user=NDBA1234&password=NDBA1234&senderid=NDBATM&channel=Trans&DCS=0&flashsms=0&number=" + item.Value + "&text=" + TextBox1.Text + "&route=2";

                       //string SmsStatusMsg = client.DownloadString(URL);
                       // if (SmsStatusMsg.Contains("<br>"))
                       // {
                       //     SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", ");

                       // }
                    }
                }
            }

            // Example Save Circular History

            SqlCommand cmd = new SqlCommand(@"
        insert into D_CircularHistory
        (
            Subject,
            Message,
            MemberList,
            CreatedDate
        )
        values
        (
            @Subject,
            @Message,
            @MemberList,
            getdate()
        )", con);

            cmd.Parameters.AddWithValue("@Subject",
                DropDownList1.SelectedItem.Text);

            cmd.Parameters.AddWithValue("@Message",
                TextBox1.Text);

            cmd.Parameters.AddWithValue("@MemberList",
                selectedmember);

            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();

            Label1.Text = "SMS Sent Successfully";

            TextBox1.Text = "";

            DropDownList1.SelectedIndex = 0;

            foreach (ListItem item in CheckBoxList1.Items)
            {
                item.Selected = false;
            }

            CheckBox1.Checked = false;
        }
    }
}