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;
    Registration obj;
     
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
          
            bind_State();
            Bind_checkboxList();


        }
    }

    public void bind_about_list()
    {
        obj = new Registration();
        b = new clsBLSetup();
        obj.Name = txtname.Text;
        obj.GeoLocation = rdGeolocation.SelectedValue;
        obj.OwnerShip = ddlOwnership.SelectedValue;
        obj.Type = ddltype.SelectedValue;
        obj.Faculty_Type = ddlfacultytype.SelectedValue;
        obj.CreateDate = txttccDate.Text;
        obj.Area = txtarea.Text;
        obj.TrainingRoom =Convert.ToInt32(ddltrainingroom.SelectedValue);
        obj.Labs =Convert.ToInt32(ddlLabs.SelectedValue);
        obj.Male_WashRoom =Convert.ToInt32(ddlMalewashroom.SelectedValue);
        obj.Female_WashRoom =Convert.ToInt32(ddlFemaleWashroom.SelectedValue);
         
        obj.Unisex_WashRoom = Convert.ToInt32(ddlunisexwashroom.SelectedValue);
        //obj.Total_WashRoom = Convert.ToInt32(txttotalwashroom.Text);
        obj.Address = txtaddress.Text;
        obj.LandMarks = txtlandmark.Text;
        obj.PinCode = txtpincode.Text;
        obj.City = txtcity.Text;
        obj.Costituencey = txtconstituency.Text;
        obj.Address_Prooftype = ddlprooftype.SelectedValue;
        obj.State = Convert.ToInt32(ddlstate.SelectedValue);
        obj.District =Convert.ToInt32(ddlDistrict.SelectedValue);
        obj.SPName = txtspName.Text;
        obj.SPMail = txtSPEmail.Text;
        obj.SPMobile = txtSPMobile.Text;
        obj.SPDesignation = txtSPDesignation.Text;
        obj.SPLandLine = txtSPLandline.Text;
        obj.Tehsil = txttehsil.Text;
        obj.Document = upload(1);
        obj.SPPhoto = upload(2);
        obj.SPExternal_Photo = upload(3);
        obj.SPClassRoom_Photo = upload(4);
        obj.SPLab_Photo = upload(5);
        obj.SPFacility_Photo = upload(6);
        obj.Address_Proof = upload(7);
        string m = b.insertForm(obj);
        string[] a;
        a = m.Split('/');
        if (a[0].ToString() == "Submit Successfully ")
        {
            checklist(a[1].ToString());


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

    }


    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();

    }

    public string upload(Int32 type)
    {
        string imgname = "", UID="";
        string imgpath = "";
        if (type == 1)
        {
            if (FUFranchiseDocument.HasFile)
            {
                
                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FUFranchiseDocument.FileName;
                int exnt = FUFranchiseDocument.FileName.IndexOf(".");
                string str = FUFranchiseDocument.FileName.Substring(exnt);
                if (str==".pdf" || str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FUFranchiseDocument.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FUFranchiseDocument.FileName);
                    FUFranchiseDocument.SaveAs(imgpath);
                }
                else
                {
                    
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

        }

        else if (type == 2)
        {
            if (FUCSP.HasFile)
            {

                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FUCSP.FileName;
                int exnt = FUCSP.FileName.IndexOf(".");
                string str = FUCSP.FileName.Substring(exnt);
                if (str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FUCSP.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FUCSP.FileName);
                    FUCSP.SaveAs(imgpath);
                }
                else
                {
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

        }

        else if (type == 3)
        {
            if (FUCEP.HasFile)
            {

                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FUCEP.FileName;
                int exnt = FUCEP.FileName.IndexOf(".");
                string str = FUCEP.FileName.Substring(exnt);
                if (str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FUCEP.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FUCEP.FileName);
                    FUCEP.SaveAs(imgpath);
                }
                else
                {
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

        }

        else if (type == 4)
        {
            if (FUCP.HasFile)
            {

                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FUCP.FileName;
                int exnt = FUCP.FileName.IndexOf(".");
                string str = FUCP.FileName.Substring(exnt);
                if (str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FUCP.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FUCP.FileName);
                    FUCEP.SaveAs(imgpath);
                }
                else
                {
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

        }

        else if (type == 5)
        {
            if (FULP.HasFile)
            {

                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FULP.FileName;
                int exnt = FULP.FileName.IndexOf(".");
                string str = FULP.FileName.Substring(exnt);
                if (str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FULP.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FULP.FileName);
                    FUCEP.SaveAs(imgpath);
                }
                else
                {
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

        }

        else if (type == 6)
        {
            if (FUFAP.HasFile)
            {

                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FUFAP.FileName;
                int exnt = FUFAP.FileName.IndexOf(".");
                string str = FUFAP.FileName.Substring(exnt);
                if (str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FUFAP.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FUFAP.FileName);
                    FUFAP.SaveAs(imgpath);
                }
                else
                {
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

        }

        else if (type == 7)
        {
            if (FUAP.HasFile)
            {

                Random rnd = new Random();
                UID = rnd.Next(99, 99999999).ToString();
                imgname = FUAP.FileName;
                int exnt = FUAP.FileName.IndexOf(".");
                string str = FUAP.FileName.Substring(exnt);
                if (str == ".pdf" || str == ".png" || str == ".jpg" || str == ".gif" || str == ".PNG" || str == ".JPEG" || str == ".JPG")
                {
                    imgname = "SPFile/" + UID + FUAP.FileName;
                    imgpath = Server.MapPath("SPFile/" + UID + FUAP.FileName);
                    FUAP.SaveAs(imgpath);
                }
                else
                {
                    Response.Write(@"<script language='javascript'>alert('Please Insert Png,JPG or GIF image !')</script>");
                    imgname = "";
                }

            }

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

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

    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Page.IsValid == true)
        {
            bind_about_list();
        }

        //checklist("1");
    }

     public void Bind_checkboxList()
    {
         
        b = new clsBLSetup();
        DataTable dt= new DataTable();
            
         dt= b.View_facility();
        CheckBoxList1.DataSource = dt;
        CheckBoxList1.DataValueField = "id";
        CheckBoxList1.DataTextField = "name";
        CheckBoxList1.DataBind();
    }

    public void checklist(string id)
    {
        string st = "";
        foreach(ListItem item in CheckBoxList1.Items)
        {
            
           if(item.Selected==true)
                {

                st += "exec insFacility " + item.Value + ","+ id +";";
            }
        }

        string msg = "";
        if (st !="")
        {
            b = new clsBLSetup();
      msg=  b.insertquery(st);
            if(msg== "Submit Successfully")
            {
                Int32 Amount = 3540;
                
                    Response.Redirect("Pay.aspx?v=" + Amount + "&Name=" + txtname.Text + "&mobile=" + txtSPMobile.Text + "&Address=" + txtaddress.Text + "&email=" + txtSPEmail.Text + "&reg=Registration" + "&reId=" + id);
                
                Reset();
            }
        }

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

    public void Reset()
    {

        txtname.Text = "";
         rdGeolocation.SelectedValue=null;
        ddlOwnership.SelectedIndex=0;
        ddltype.SelectedIndex=0;
        ddlfacultytype.SelectedIndex=0;
          txttccDate.Text="";
       txtarea.Text="";
      ddltrainingroom.SelectedIndex=0;
      ddlLabs.SelectedIndex=0;
         ddlMalewashroom.SelectedIndex=0;
   ddlFemaleWashroom.SelectedIndex=0;
        ddlunisexwashroom.SelectedIndex=0;
        
           // txttotalwashroom.Text = ""; 
    txtaddress.Text="";
          txtlandmark.Text="";
       txtpincode.Text="";
          txtcity.Text="";
        txtconstituency.Text="";
         ddlprooftype.SelectedIndex=0;
        ddlstate.SelectedIndex=0;
         ddlDistrict.SelectedIndex=0;
         txtspName.Text="";
       txtSPEmail.Text="";
         txtSPMobile.Text="";
         txtSPDesignation.Text="";
          txtSPLandline.Text="";
       txttehsil.Text="";
        CheckBoxList1.ClearSelection();

    }

     
}