using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using nmsSetup;
using System.Data;
using System.Data.SqlClient;
using nmsDropDown;
public partial class Default2 : System.Web.UI.Page
{
    clsBLSetup b;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {

            bind_State();

        }
    }

    public void bind_State()
    {

        List<clsPRPdropdown> lst = new List<clsPRPdropdown>();
        clsPRPdropdown prp = new clsPRPdropdown();
        clsDLdropDown obj = new clsDLdropDown();
        b = new clsBLSetup();
        prp.id = 0;
        prp.spName = "selState";
        lst = obj.SelectDropDown(prp);

        ddlstate.DataSource = lst;
        ddlstate.DataTextField = "name";
        ddlstate.DataValueField = "id";
        ddlstate.DataBind();

    }
    public void bind_District(Int32 id)
    {
        List<clsPRPdropdown> lst = new List<clsPRPdropdown>();
        clsPRPdropdown prp = new clsPRPdropdown();
        clsDLdropDown obj = new clsDLdropDown();
        b = new clsBLSetup();
        prp.id = id;
        prp.spName = "Bind_District";
        lst = obj.SelectDropDown(prp);

        ddlDistrict.DataSource = lst;
        ddlDistrict.DataTextField = "name";
        ddlDistrict.DataValueField = "id";
        ddlDistrict.DataBind();

    }

    protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlstate.SelectedIndex > 0)
        {

            bind_District(Convert.ToInt32(ddlstate.SelectedValue));
        }
    }


    public void insEnquiry()
    {
        PRPSetup obj = new PRPSetup();
        b = new clsBLSetup();
        obj.enqname = txtname.Text;
         
        obj.Stid = ddlstate.SelectedValue;
        obj.Cityid = ddlDistrict.SelectedValue;
        obj.enqdepartment = ddlpuropose.SelectedValue;
        
        obj.enqmail = txtemail.Text;
        obj.enqmob = txtmobile.Text;
        obj.enqmsg = txtmsg.Text;
        obj.enqaddress = "";
        string m = b.ins_enquity(obj);
       
        if (m == "Successfully Submitted!")
        {


            Reset();

        }
        
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "showError",
              "alert('" + m + "');", true);
        

    }

    private void Reset()
    {
        txtname.Text = "";

        ddlstate.SelectedIndex = 0;
        ddlDistrict.SelectedIndex = 0;
        ddlpuropose.SelectedIndex = 0;

        txtemail.Text = "";
        txtmobile.Text = "";
        txtmsg.Text = "";

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        insEnquiry();
    }
}