using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient; // sadf

namespace PracticeProject
{
    public partial class AccountInfo : System.Web.UI.Page
    {
        private SqlConnection myConn;
        private SqlDataReader myReader;
        private SqlCommand myCommand;
        private DataTable dt;

        protected void Page_Load(object sender, EventArgs e)
        {
            myConn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Users\Holly\Documents\Visual Studio Projects\PracticeProject\PracticeProject\App_Data\NORTHWND2.MDF';Integrated Security=True;User Instance=True");
            loadForm(); // hard way
            if (!IsPostBack)
            {
                selCust.DataSource = dt;
                selCust.DataBind();
                fillForm(null, null);
                
                //loadForm2();
            }
            
            
        }

        protected void fillForm(object sender, EventArgs e)
        {
            
             // selCust.SelectedIndex = (sender as DropDownList).SelectedIndex;
            int i = selCust.SelectedIndex; // (sender as DropDownList).SelectedIndex;
            DataRow dr = dt.Rows[i];
            txtCustID.Text = Convert.ToString(dr[0]);
            txtCustCompany.Text = Convert.ToString(dr[1]);
            txtCustContact.Text = Convert.ToString(dr[2]);
            txtCustTitle.Text = Convert.ToString(dr[3]);
            txtCustAddr.Text = Convert.ToString(dr[4]);
            txtCustCity.Text = Convert.ToString(dr[5]);
            txtCustRegion.Text = Convert.ToString(dr[6]);
            txtCustPC.Text = Convert.ToString(dr[7]);
            txtCustCountry.Text = Convert.ToString(dr[8]);
            txtCustPhone.Text = Convert.ToString(dr[9]);
            txtCustFax.Text = Convert.ToString(dr[10]); 
        }

        protected void loadForm2()
        {
            myReader = getCustData();
            myReader.Read();
            txtCustID.Text = Convert.ToString(myReader[0]);
            txtCustCompany.Text = Convert.ToString(myReader[1]);
            txtCustContact.Text = Convert.ToString(myReader[2]);
            txtCustTitle.Text = Convert.ToString(myReader[3]);
            txtCustAddr.Text = Convert.ToString(myReader[4]);
            txtCustCity.Text = Convert.ToString(myReader[5]);
            txtCustRegion.Text = Convert.ToString(myReader[6]);
            txtCustPC.Text = Convert.ToString(myReader[7]) ;
            txtCustCountry.Text = Convert.ToString(myReader[8]);
            txtCustPhone.Text = Convert.ToString(myReader[9]) ;
            txtCustFax.Text = Convert.ToString(myReader[10]);
        }

        protected void loadForm()
        {
            myReader = getCustData();
            dt = new DataTable();
            dt.Load(myReader);

        }

        protected SqlDataReader getCustData()
        {
            myConn.Open();
            myCommand = new SqlCommand("GetCustomers", myConn);
            myCommand.CommandType = CommandType.StoredProcedure;
            SqlDataReader rd = myCommand.ExecuteReader();
            return rd;
        }

        protected void cmdUpdate_Click(object sender, EventArgs e)
        {
            updateCust();
        }

        private void updateCust()
        {
            SqlCommand updtCust = new SqlCommand("UpdateCustomer", myConn);
            updtCust.CommandType = CommandType.StoredProcedure;
            updtCust.Parameters.AddWithValue("@custCompany", txtCustCompany.Text);
            updtCust.Parameters.AddWithValue("@custContact", txtCustContact.Text);
            updtCust.Parameters.AddWithValue("@custTitle", txtCustTitle.Text);
            updtCust.Parameters.AddWithValue("@custAddr", txtCustAddr.Text);
            updtCust.Parameters.AddWithValue("@custCity", txtCustCity.Text);
            updtCust.Parameters.AddWithValue("@custRegion", txtCustRegion.Text);
            updtCust.Parameters.AddWithValue("@custPC", txtCustPC.Text);
            updtCust.Parameters.AddWithValue("@custCountry", txtCustCountry.Text);
            updtCust.Parameters.AddWithValue("@custPhone", txtCustPhone.Text);
            updtCust.Parameters.AddWithValue("@custFax", txtCustFax.Text);
            updtCust.Parameters.AddWithValue("@custID", txtCustID.Text);
            int numAffected = updtCust.ExecuteNonQuery();
            if (numAffected == 1)
            {
                lblMsg.Text = "Customer updated!";
            }
        }

    }
}