using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Emp_cust : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
        

    }


    protected void Button1_Click1(object sender, EventArgs e)
    {
        
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            con.Open();
            cmd.CommandText = "insert into CustInfo(PFName,PMName,PLName,PSSNO,PEmail,PCellNo,PCellNo1,BFName,BMName,BLName,BAddress1,BAddress2,BCity,BState,BZipCode,BCountry,SFName,SMName,SLName,SAddress1,SAddress2,SCity,SState,SZipCode,SCountry,CCBankName,CCAcNumber,CCACHName,CCCardType,CCSubCard,CCCardName,CCExpiryDate,CCCardNumber,CCCVV,CCChecker,CBankName,CACNumber,CACHName,CChequeNo,CRoutingNo,CBankLocation,CenterID,OrderID,Amount,Status) values('" + txtpfname.Text + "','" + txtpmname.Text + "','" + txtplname.Text + "','" + txtpssno.Text + "','" + txtpemail.Text + "','" + txtpcell.Text + "','" + txtpcell1.Text + "','" + txtbfname.Text + "','" + txtbmname.Text + "','" + txtblname.Text + "','" + txtbadd1.Text + "','" + txtbadd2.Text + "','" + txtbcity.Text + "','" + txtbcity.Text + "','" + txtbstate.Text + "','" + txtbzip.Text + "','" + txtbcountry.Text + "','" + txtsfname.Text + "','" + txtsmname.Text + "','" + txtslname.Text + "','" + txtsadd1.Text + "','" + txtsadd2.Text + "','" + txtscity.Text + "','" + txtsstate.Text + "','" + txtszip.Text + "','" + txtscountry.Text + "','" + txtccbname.Text + "','" + txtccacnumber.Text + "','" + txtccachname.Text + "','" + ddlctype.SelectedItem.Text + "','" + ddlcsubtype.SelectedItem.Text + "','" + txtccexpdate.Text + "','" + txtcccardno.Text + "','" + txtcvv.Text + "','" + txtccchecker.Text + "','" + txtchbname.Text + "','" + txtchanumber.Text + "','" + txtchchname.Text + "','" + txtchnumber.Text + "','" + txtchroutingumber.Text + "','" + txtchbankloc.Text + "','" + txtcenterid.Text + "','" + txtorderid.Text + "','" + txtamount.Text + "','" + TextBox1.Text + "')";
            //int i = cmd.ExecuteNonQuery();
            //if (i > 0)
            //{
            //    Page.RegisterStartupScript("kk", "<script>alert('Customer Details  Added  Successfully')</script>");


            //}


            //else
            //{
            //    Page.RegisterStartupScript("ku", "<script>alert('Customer Details is Already Exists')</script>");

            //}
            con.Close();
       
    }
  
    
    protected void rbcard_CheckedChanged(object sender, EventArgs e)
    {
        Panel1.Visible = true;
        Panel2.Visible = false;
    }
    protected void rbcheque_CheckedChanged(object sender, EventArgs e)
    {
        Panel2.Visible = true;
        Panel1.Visible = false;
    }
    protected void rbcod_CheckedChanged(object sender, EventArgs e)
    {
        Panel1.Visible = false;
        Panel2.Visible = false;
       
    }

    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox1.Checked)
        {
            txtbfname.Text = txtpfname.Text;
            txtbmname.Text = txtpmname.Text;
            txtblname.Text = txtplname.Text;
        }
        else
        {
            txtbfname.Text = "";
            txtbmname.Text = "";
            txtblname.Text = "";
            txtbfname.Focus();
        }
    }
  


    protected void txtbzip_TextChanged(object sender, EventArgs e)
    {
        getZipCode();
    }

    private void getZipCode()
    {
        try
        {
            empBal obj = new empBal();
            DataSet ds = new DataSet();
            obj.ZipCode = txtbzip.Text;
            ds = obj.getZipdata(obj.ZipCode);
            txtbcity.Text = ds.Tables[0].Rows[0]["City"].ToString();
            txtbstate.Text = ds.Tables[0].Rows[0]["StateName"].ToString();
            txtbcountry.Text = "US";
        }
        catch(Exception e)
        {
            Console.WriteLine("", e);
            //alert ("Custome Details  Added  Successfully");
            
        }
    }

   
    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox2.Checked)
        {
            txtsfname.Text = txtbfname.Text;
            txtsmname.Text = txtbmname.Text;
            txtslname.Text = txtblname.Text;
            txtsadd1.Text = txtbadd1.Text;
            txtsadd2.Text = txtbadd2.Text;
            txtszip.Text = txtbzip.Text;
            txtscity.Text = txtbcity.Text;
            txtsstate.Text = txtbstate.Text;
            txtscountry.Text = txtbcountry.Text;

        }
        else
        {
            txtsfname.Text = "";
            txtsmname.Text = "";
            txtslname.Text = "";
            txtsadd1.Text = "";
            txtsadd2.Text = "";
            txtszip.Text = "";
            txtscity.Text = "";
            txtsstate.Text = "";
            txtscountry.Text = "";
            txtsfname.Focus();
        }
    }
    

    private void getsZipCode()
    {
       
        empBal obj = new empBal();
        DataSet ds = new DataSet();
        obj.ZipCode = txtszip.Text;
        ds = obj.getsZipdata(obj.ZipCode);
        txtscity.Text = ds.Tables[0].Rows[0]["City"].ToString();
        txtsstate.Text = ds.Tables[0].Rows[0]["StateName"].ToString();
        txtscountry.Text = "US";
    }
    protected void txtszip_TextChanged(object sender, EventArgs e)
    {
        getsZipCode();
    }
}