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;

namespace Newdelhibarassocia.dhadmin
{
    public partial class newnotice : 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
            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 = "Ndbano";

            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='Notice'
        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 = "";

            foreach (ListItem item in CheckBoxList1.Items)
            {
                if (item.Selected)
                {
                    selectedmember += item.Text + "<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 = "Notice Sent Successfully";

            TextBox1.Text = "";

            DropDownList1.SelectedIndex = 0;

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

            CheckBox1.Checked = false;
        }
    }
}