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.IO;

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

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

        protected void Button1_Click(object sender, EventArgs e)
        {
            string photo = "";

            if (FileUpload1.HasFile)
            {
                photo = DateTime.Now.Ticks +
                        Path.GetExtension(FileUpload1.FileName);

                FileUpload1.SaveAs(Server.MapPath("~/TemplatePhoto/" + photo));
            }

            // INSERT
            if (hdnid.Value == "0")
            {
                SqlCommand cmd = new SqlCommand(@"
        INSERT INTO D_TemplateMaster
        (
            TemplateType,
            Subject,
            BodyMessage,
            Photo,
            Variables,
            uid
        )
        VALUES
        (
            @TemplateType,
            @Subject,
            @BodyMessage,
            @Photo,
            @Variables,
            @uid
        )", con);

                cmd.Parameters.AddWithValue("@TemplateType", ddlType.SelectedItem.Text);
                cmd.Parameters.AddWithValue("@Subject", txtSubject.Text);
                cmd.Parameters.AddWithValue("@BodyMessage", txtBody.Text);
                cmd.Parameters.AddWithValue("@Photo", photo);
                cmd.Parameters.AddWithValue("@Variables", txtVariable.Text);
                cmd.Parameters.AddWithValue("@uid", "Admin");

                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }

            // UPDATE
            else
            {
                SqlCommand cmd = new SqlCommand(@"
        UPDATE D_TemplateMaster
        SET
            TemplateType=@TemplateType,
            Subject=@Subject,
            BodyMessage=@BodyMessage,
            Variables=@Variables
        WHERE Id=@Id", con);

                cmd.Parameters.AddWithValue("@TemplateType", ddlType.SelectedItem.Text);
                cmd.Parameters.AddWithValue("@Subject", txtSubject.Text);
                cmd.Parameters.AddWithValue("@BodyMessage", txtBody.Text);
                cmd.Parameters.AddWithValue("@Variables", txtVariable.Text);
                cmd.Parameters.AddWithValue("@Id", hdnid.Value);

                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();

                Button1.Text = "Save Template";

                hdnid.Value = "0";
            }

            clear();

            bindgrid();
        }
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "SelectData")
            {
                SqlDataAdapter da = new SqlDataAdapter(
                "select * from D_TemplateMaster where Id='" + e.CommandArgument.ToString() + "'",
                con);

                DataTable dt = new DataTable();

                da.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    hdnid.Value = dt.Rows[0]["Id"].ToString();

                    ddlType.SelectedItem.Text =
                        dt.Rows[0]["TemplateType"].ToString();

                    txtSubject.Text =
                        dt.Rows[0]["Subject"].ToString();

                    txtBody.Text =
                        dt.Rows[0]["BodyMessage"].ToString();

                    txtVariable.Text =
                        dt.Rows[0]["Variables"].ToString();

                    Button1.Text = "Update Template";
                }
            }
        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);

            SqlCommand cmd = new SqlCommand(
            "delete from D_TemplateMaster where Id=@Id", con);

            cmd.Parameters.AddWithValue("@Id", id);

            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();

            bindgrid();
        }
        void clear()
        {
            txtSubject.Text = "";
            txtBody.Text = "";
            txtVariable.Text = "";

            ddlType.SelectedIndex = 0;

            hdnid.Value = "0";

            Button1.Text = "Save Template";
        }

        void bindgrid()
        {
            SqlDataAdapter da = new SqlDataAdapter(
            "select * from D_TemplateMaster order by Id desc", con);

            DataTable dt = new DataTable();

            da.Fill(dt);

            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }
}