using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Bulkmail_ServerConfig : System.Web.UI.Page
{
    Page p;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack == false)
        {
            if (Session["Bulkmail"] == null)
            {
                Response.Redirect("BulkmailLogin.aspx");
            }
            //TextBox1.AutoPostBack = false;
            p = this.Page;
            // Response.Write(p.Title);

            ModCommon.CancelClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
            ModCommon.Fill_Grid("Select * From BEM_Server", GridView1);
            btnDelete.Attributes.Add("onclick", "return FunctDelete();");
            enablecontrol(false);
            clearfields();
            ScriptManager1.SetFocus(btnAdd);

        }
        lblMsg.Visible = false;
    }
    protected void clearfields()
    {
        txtPassWord.Text = "";
        txtServerName.Text = "";
        txtUserName.Text = "";
        txtServer.Text = "";
    }
    protected void enablecontrol(Boolean action)
    {
        txtUserName.Enabled = action;
        txtServerName.Enabled = action;
        txtPassWord.Enabled = action;
        rblSSL.Enabled = action;
        txtServer.Enabled = action;
    }
    protected void btnADD_Click(object sender, EventArgs e)
    {
        try
        {





            //TextBox1.AutoPostBack = false;
            //TextBox1.Focus();
            enablecontrol(true);
            ModCommon.AddClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
            ScriptManager1.SetFocus(txtServer);
        }
        catch
        {
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            //TextBox1.AutoPostBack = false;
            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "BEM_Server_Proc";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = con;

            cmd.Parameters.Add("Server_Kid", SqlDbType.NVarChar, 10).Value = ModCommon.NewPrimaryKey(p);
            cmd.Parameters.Add("Server_Code", SqlDbType.NVarChar, 25).Value = CommonData.Generate_Code("Select Count(*) From BEM_Category Where Category_Code='", "BCC");
            cmd.Parameters.Add("Server_ServerName", SqlDbType.NVarChar, 50).Value = txtServer.Text;
            cmd.Parameters.Add("Server_Name", SqlDbType.NVarChar, 200).Value = txtServerName.Text;
            cmd.Parameters.Add("Server_UserName", SqlDbType.NVarChar, 200).Value = txtUserName.Text;
            cmd.Parameters.Add("Server_Password", SqlDbType.NVarChar, 200).Value = txtPassWord.Text;
            cmd.Parameters.Add("Server_SSL", SqlDbType.NVarChar, 10).Value = rblSSL.SelectedItem.Value;
            cmd.Parameters.Add("Server_CompanyId", SqlDbType.NVarChar, 10).Value = "";
            cmd.Parameters.Add("Server_UserId", SqlDbType.NVarChar, 10).Value = "";
            


            //cmd.Parameters.Add(New SqlParameter("FactoryDetails_TINNo", SqlDbType.NVarChar, 50)).Value = txttinno.Text;

            cmd.Parameters.Add("Mode", SqlDbType.NVarChar, 50).Value = "Insert";

            //cmd.Parameters.Add(new SqlParameter("Mode", SqlDbType.NVarChar, 50).Value = "Insert");
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            //TextBox1.Text = "";
            enablecontrol(false);
            clearfields();
            ModCommon.showmessage("Record is Saved Sucessfully.", lblMsg);
            ModCommon.Fill_Grid("Select * From BEM_Server", GridView1);
            ModCommon.SaveClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
        }
        catch
        {
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        try
        {
            //string str;
            //str = GridView1.SelectedDataKey.Value.ToString();
            //TextBox1.AutoPostBack = false;
            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "BEM_Server_Proc";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = con;

            cmd.Parameters.Add("Server_Kid", SqlDbType.NVarChar, 10).Value = GridView1.SelectedDataKey.Value;
            cmd.Parameters.Add("Server_Code", SqlDbType.NVarChar, 25).Value = CommonData.Generate_Code("Select Count(*) From BEM_Category Where Category_Code='", "BCC");
            cmd.Parameters.Add("Server_ServerName", SqlDbType.NVarChar, 50).Value = txtServer.Text;
            cmd.Parameters.Add("Server_Name", SqlDbType.NVarChar, 200).Value = txtServerName.Text;
            cmd.Parameters.Add("Server_UserName", SqlDbType.NVarChar, 200).Value = txtUserName.Text;
            cmd.Parameters.Add("Server_Password", SqlDbType.NVarChar, 200).Value = txtPassWord.Text;
            cmd.Parameters.Add("Server_SSL", SqlDbType.NVarChar, 10).Value = rblSSL.SelectedItem.Value;
            cmd.Parameters.Add("Server_CompanyId", SqlDbType.NVarChar, 10).Value = "";
            cmd.Parameters.Add("Server_UserId", SqlDbType.NVarChar, 10).Value = "";

            cmd.Parameters.Add("Mode", SqlDbType.NVarChar, 50).Value = "Update";

            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            ModCommon.Fill_Grid("Select * From BEM_Server", GridView1);
            //TextBox1.Text = "";
            clearfields();
            enablecontrol(false);
            ModCommon.showmessage("Record is Updated Sucessfully.", lblMsg);
            ModCommon.EditClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
        }
        catch
        {
        }
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        try
        {
           // TextBox1.AutoPostBack = false;
            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "BEM_Server_Proc";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = con;

            cmd.Parameters.Add("Server_Kid", SqlDbType.NVarChar, 10).Value = GridView1.SelectedDataKey.Value;
            cmd.Parameters.Add("Server_Code", SqlDbType.NVarChar, 25).Value = CommonData.Generate_Code("Select Count(*) From BEM_Category Where Category_Code='", "BCC");
            cmd.Parameters.Add("Server_ServerName", SqlDbType.NVarChar, 50).Value = txtServer.Text;
            cmd.Parameters.Add("Server_Name", SqlDbType.NVarChar, 200).Value = txtServerName.Text;
            cmd.Parameters.Add("Server_UserName", SqlDbType.NVarChar, 200).Value = txtUserName.Text;
            cmd.Parameters.Add("Server_Password", SqlDbType.NVarChar, 200).Value = txtPassWord.Text;
            cmd.Parameters.Add("Server_SSL", SqlDbType.NVarChar, 10).Value = rblSSL.SelectedItem.Value;
            cmd.Parameters.Add("Server_CompanyId", SqlDbType.NVarChar, 10).Value = "";
            cmd.Parameters.Add("Server_UserId", SqlDbType.NVarChar, 10).Value = "";

            
            cmd.Parameters.Add("Mode", SqlDbType.NVarChar, 50).Value = "Delete";

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

            enablecontrol(false);
            clearfields();
            ModCommon.Fill_Grid("Select * From BEM_Server", GridView1);
            ModCommon.showmessage("Record is Deleted Sucessfully.", lblMsg);
            ModCommon.DeleteClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
        }
        catch(Exception ex)
        {

        }
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        try
        {
            //TextBox1.AutoPostBack = false;
            //TextBox1.Text = "";
            enablecontrol(false);
            clearfields();
            ModCommon.Fill_Grid("Select * From BEM_Server", GridView1);
            ModCommon.CancelClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
        }
        catch
        {
        }
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        ModCommon.SearchClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            //string str;
            //str = GridView1.SelectedDataKey.Value.ToString ();
            //TextBox1.AutoPostBack = false;
            //TextBox1.Text = GridView1.SelectedRow.Cells[1].Text;
            txtServer.Text = GridView1.SelectedRow.Cells[1].Text;
            txtServerName.Text = GridView1.SelectedRow.Cells[2].Text;
            txtUserName .Text = GridView1.SelectedRow.Cells[3].Text;
            txtPassWord.Text = GridView1.SelectedRow.Cells[4].Text;
            rblSSL.ClearSelection();
            rblSSL.Items.FindByValue(GridView1.SelectedRow.Cells[5].Text).Selected = true;
            enablecontrol(true);
            ModCommon.GridClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
        }
        catch
        {
        }
    }
}