Ejemplo n.º 1
0
    /// <summary>
    /// Destroys objects
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Unload(object sender, EventArgs e)
    {
        // Destroy Customer object
        currentCustomer = null;

        Debug.WriteLine("Page has been unloaded");
    }
Ejemplo n.º 2
0
    /// <summary>
    /// Destroys objects
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Unload(object sender, EventArgs e)
    {
        // Destroy Customer object
        currentCustomer = null;

        Debug.WriteLine("Page has been unloaded");
    }
Ejemplo n.º 3
0
 /// <summary>
 /// Instantiates and populates the Customer member object
 /// </summary>
 private void instantiateCustomerObject()
 {
     // First time loading page?
     if (!this.IsPostBack)
         // Instantiate new Customer object
         currentCustomer = new CustomerManagementEntities.Customer();
     else
         // Instantiate new Customer object with user input
         currentCustomer = new CustomerManagementEntities.Customer(
             null, CustomerNameTextBox.Text, CustomerAddressTextBox.Text,
             CustomerPhoneTextBox.Text, CustomerZipCodeTextBox.Text,
             CustomerCityTextBox.Text, CustomerStateTextBox.Text,
             null, CustomerEmailAddressTextBox.Text, -1, DateTime.Now,
             "", null, "");
 }
Ejemplo n.º 4
0
 /// <summary>
 /// Instantiates and populates the Customer member object
 /// </summary>
 private void instantiateCustomerObject()
 {
     // First time loading page?
     if (!this.IsPostBack)
     {
         // Instantiate new Customer object
         currentCustomer = new CustomerManagementEntities.Customer(
             null, CustomerFirstNameTextBox.Text, CustomerLastNameTextBox.Text,
             CustomerAddressTextBox.Text, CustomerZipCodeTextBox.Text,
             CustomerCityTextBox.Text, CustomerStateTextBox.Text,
             null, CustomerPhoneTextBox.Text, CustomerEmailAddressTextBox.Text,
             CustomerWebAddressTextBox.Text, -1, CustomerNewsSubscriberCheckBox.Checked,
             DateTime.Now, "", null, "");
     }
 }
Ejemplo n.º 5
0
 /// <summary>
 /// Instantiates and populates the Customer member object
 /// </summary>
 private void instantiateCustomerObject()
 {
     // First time loading page?
     if (!this.IsPostBack)
     {
         // Instantiate new Customer object
         currentCustomer = new CustomerManagementEntities.Customer();
     }
     else
     {
         // Instantiate new Customer object with user input
         currentCustomer = new CustomerManagementEntities.Customer(
             null, CustomerNameTextBox.Text, CustomerAddressTextBox.Text,
             CustomerPhoneTextBox.Text, CustomerZipCodeTextBox.Text,
             CustomerCityTextBox.Text, CustomerStateTextBox.Text,
             null, CustomerEmailAddressTextBox.Text, -1, DateTime.Now,
             "", null, "");
     }
 }
Ejemplo n.º 6
0
 /// <summary>
 /// Instantiates and populates the Customer member object
 /// </summary>
 private void instantiateCustomerObject()
 {
     // First time loading page?
     if (!this.IsPostBack)
     {
         // Instantiate new Customer object
         currentCustomer = new CustomerManagementEntities.Customer();
     }
     else
     {
         // Instantiate new Customer object with user input
         currentCustomer = new CustomerManagementEntities.Customer(
             null, CustomerFirstNameTextBox.Text, CustomerLastNameTextBox.Text,
             CustomerAddressTextBox.Text, CustomerZipCodeTextBox.Text,
             CustomerCityTextBox.Text, CustomerStateTextBox.Text,
             new Guid(CustomerCountryDropDownList.SelectedValue), CustomerPhoneTextBox.Text,
             CustomerEmailAddressTextBox.Text, CustomerWebAddressTextBox.Text,
             int.Parse(CustomerCreditLimitTextBox.Text), CustomerNewsSubscriberCheckBox.Checked,
             DateTime.Now, "", null, "");
     }
 }
Ejemplo n.º 7
0
    /// <summary>
    /// Saves the current customer information and adds default values
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void CustomerInsertButton_Click(object sender, EventArgs e)
    {
        // Did page validation succeed?
        if (!Page.IsValid)
        {
            return;
        }

        // Add the current user name
        currentCustomer.CreatedBy = Context.User.Identity.Name;

        // Create and instantiate connection
        using (SqlConnection customerManagementConnection = new SqlConnection())
        {
            // Initialize connection string from web.config
            customerManagementConnection.ConnectionString =
                ConfigurationManager.ConnectionStrings["CustomerManagementConnectionString"].ConnectionString;

            // Open connection
            customerManagementConnection.Open();
            // Declare and instantiate data adapter
            SqlDataAdapter customerManagementDataAdapter = new SqlDataAdapter();

            // Declare and instantiate command objects
            SqlCommand selectCommand = new SqlCommand("SELECT * FROM Customers",
                                                      customerManagementConnection);
            SqlCommand insertCommand = new SqlCommand(
                "INSERT INTO Customers (FirstName, LastName, Address, ZipCode, City, State, CountryID, Phone, EmailAddress, " +
                "Url, CreditLimit, NewsSubscriber, CreatedDate, CreatedBy) VALUES(@FirstName, @LastName, @Address, @ZipCode, @City, @State, " +
                "@CountryID, @Phone, @EmailAddress, @EmailAddress, @CreditLimit, @NewsSubscriber, @CreatedDate, @CreatedBy)",
                customerManagementConnection);

            // Assign command objects
            customerManagementDataAdapter.SelectCommand = selectCommand;
            customerManagementDataAdapter.InsertCommand = insertCommand;

            // Declare and instantiate parameter objects
            SqlParameter insertFirstNameParameter      = new SqlParameter("@FirstName", SqlDbType.NVarChar, 50, "FirstName");
            SqlParameter insertLastNameParameter       = new SqlParameter("@LastName", SqlDbType.NVarChar, 30, "LastName");
            SqlParameter insertAddressParameter        = new SqlParameter("@Address", SqlDbType.NVarChar, 50, "Address");
            SqlParameter insertZipCodeParameter        = new SqlParameter("@ZipCode", SqlDbType.NVarChar, 10, "ZipCode");
            SqlParameter insertCityParameter           = new SqlParameter("@City", SqlDbType.NVarChar, 30, "City");
            SqlParameter insertStateParameter          = new SqlParameter("@State", SqlDbType.NVarChar, 30, "State");
            SqlParameter insertCountryIDParameter      = new SqlParameter("@CountryID", SqlDbType.UniqueIdentifier, 0, "CountryID");
            SqlParameter insertPhoneParameter          = new SqlParameter("@Phone", SqlDbType.VarChar, 30, "Phone");
            SqlParameter insertEmailAddressParameter   = new SqlParameter("@EmailAddress", SqlDbType.NVarChar, 50, "EmailAddress");
            SqlParameter insertWebAddressParameter     = new SqlParameter("@WebAddress", SqlDbType.NVarChar, 80, "Url");
            SqlParameter insertCreditLimitParameter    = new SqlParameter("@CreditLimit", SqlDbType.Int, 0, "CreditLimit");
            SqlParameter insertNewsSubscriberParameter = new SqlParameter("@NewsSubscriber", SqlDbType.Bit, 0, "NewsSubscriber");
            SqlParameter insertCreatedDateParameter    = new SqlParameter("@CreatedDate", SqlDbType.SmallDateTime, 0, "CreatedDate");
            SqlParameter insertCreatedByParameter      = new SqlParameter("@CreatedBy", SqlDbType.VarChar, 15, "CreatedBy");


            // Assign parameters to command object
            insertCommand.Parameters.Add(insertFirstNameParameter);
            insertCommand.Parameters.Add(insertLastNameParameter);
            insertCommand.Parameters.Add(insertAddressParameter);
            insertCommand.Parameters.Add(insertZipCodeParameter);
            insertCommand.Parameters.Add(insertCityParameter);
            insertCommand.Parameters.Add(insertStateParameter);
            insertCommand.Parameters.Add(insertCountryIDParameter);
            insertCommand.Parameters.Add(insertPhoneParameter);
            insertCommand.Parameters.Add(insertEmailAddressParameter);
            insertCommand.Parameters.Add(insertWebAddressParameter);
            insertCommand.Parameters.Add(insertCreditLimitParameter);
            insertCommand.Parameters.Add(insertNewsSubscriberParameter);
            insertCommand.Parameters.Add(insertCreatedDateParameter);
            insertCommand.Parameters.Add(insertCreatedByParameter);

            // Declare and instantiate dataset
            DataSet customerManagementDataSet = new DataSet("CustomerManagementDataSet");
            // Apply the full schema from the data source
            customerManagementDataAdapter.FillSchema(customerManagementDataSet, SchemaType.Source, "Customers");
            customerManagementDataAdapter.MissingSchemaAction  = MissingSchemaAction.AddWithKey;
            customerManagementDataAdapter.MissingMappingAction = MissingMappingAction.Passthrough;
            // Populate Customers DataTable
            customerManagementDataAdapter.Fill(customerManagementDataSet, "Customers");

            // Create new row locally
            DataRow newCustomerDataRow = customerManagementDataSet.Tables["Customers"].NewRow();
            newCustomerDataRow["ID"]             = Guid.NewGuid();
            newCustomerDataRow["FirstName"]      = currentCustomer.FirstName;
            newCustomerDataRow["LastName"]       = currentCustomer.LastName;
            newCustomerDataRow["Address"]        = currentCustomer.Address;
            newCustomerDataRow["ZipCode"]        = currentCustomer.ZipCode;
            newCustomerDataRow["City"]           = currentCustomer.City;
            newCustomerDataRow["State"]          = currentCustomer.State;
            newCustomerDataRow["CountryID"]      = currentCustomer.CountryID;
            newCustomerDataRow["Phone"]          = currentCustomer.Phone;
            newCustomerDataRow["EmailAddress"]   = currentCustomer.EmailAddress;
            newCustomerDataRow["Url"]            = currentCustomer.EmailAddress;
            newCustomerDataRow["CreditLimit"]    = currentCustomer.CreditLimit;
            newCustomerDataRow["NewsSubscriber"] = currentCustomer.NewsSubscriber;
            newCustomerDataRow["CreatedDate"]    = currentCustomer.CreatedDate;
            newCustomerDataRow["CreatedBy"]      = currentCustomer.CreatedBy;

            // Insert new row locally
            customerManagementDataSet.Tables["Customers"].Rows.Add(newCustomerDataRow);

            // Update data source
            if (customerManagementDataAdapter.Update(customerManagementDataSet, "Customers") == 1)
            {
                // Instantiate new Customer object
                currentCustomer = new CustomerManagementEntities.Customer();
                // Reload page to refresh with "blank" input controls
                Response.Redirect("~/InsertCustomer.aspx");
            }
        }
    }
Ejemplo n.º 8
0
 /// <summary>
 /// Destroys objects
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void Page_Unload(object sender, EventArgs e)
 {
     // Destroy Customer object
     currentCustomer = null;
 }
Ejemplo n.º 9
0
 /// <summary>
 /// Destroys objects
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void Page_Unload(object sender, EventArgs e)
 {
     // Destroy Customer object
     currentCustomer = null;
 }
Ejemplo n.º 10
0
    /// <summary>
    /// Saves the current customer information and adds default values
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void CustomerInsertButton_Click(object sender, EventArgs e)
    {
        // Did page validation succeed?
        if (!Page.IsValid)
            return;

        // Add the current user name
        currentCustomer.CreatedBy = Context.User.Identity.Name;

        // Create and instantiate connection
        using (SqlConnection customerManagementConnection = new SqlConnection())
        {
            // Initialize connection string from web.config
            customerManagementConnection.ConnectionString =
                ConfigurationManager.ConnectionStrings["CustomerManagementConnectionString"].ConnectionString;

            // Open connection
            customerManagementConnection.Open();
            // Declare and instantiate data adapter
            SqlDataAdapter customerManagementDataAdapter = new SqlDataAdapter();

            // Declare and instantiate command objects
            SqlCommand selectCommand = new SqlCommand("SELECT * FROM Customers",
                customerManagementConnection);
            SqlCommand insertCommand = new SqlCommand(
                "INSERT INTO Customers (FirstName, LastName, Address, ZipCode, City, State, CountryID, Phone, EmailAddress, " +
                "Url, CreditLimit, NewsSubscriber, CreatedDate, CreatedBy) VALUES(@FirstName, @LastName, @Address, @ZipCode, @City, @State, " +
                "@CountryID, @Phone, @EmailAddress, @EmailAddress, @CreditLimit, @NewsSubscriber, @CreatedDate, @CreatedBy)",
                customerManagementConnection);

            // Assign command objects
            customerManagementDataAdapter.SelectCommand = selectCommand;
            customerManagementDataAdapter.InsertCommand = insertCommand;

            // Declare and instantiate parameter objects
            SqlParameter insertFirstNameParameter = new SqlParameter("@FirstName", SqlDbType.NVarChar, 50, "FirstName");
            SqlParameter insertLastNameParameter = new SqlParameter("@LastName", SqlDbType.NVarChar, 30, "LastName");
            SqlParameter insertAddressParameter = new SqlParameter("@Address", SqlDbType.NVarChar, 50, "Address");
            SqlParameter insertZipCodeParameter = new SqlParameter("@ZipCode", SqlDbType.NVarChar, 10, "ZipCode");
            SqlParameter insertCityParameter = new SqlParameter("@City", SqlDbType.NVarChar, 30, "City");
            SqlParameter insertStateParameter = new SqlParameter("@State", SqlDbType.NVarChar, 30, "State");
            SqlParameter insertCountryIDParameter = new SqlParameter("@CountryID", SqlDbType.UniqueIdentifier, 0, "CountryID");
            SqlParameter insertPhoneParameter = new SqlParameter("@Phone", SqlDbType.VarChar, 30, "Phone");
            SqlParameter insertEmailAddressParameter = new SqlParameter("@EmailAddress", SqlDbType.NVarChar, 50, "EmailAddress");
            SqlParameter insertWebAddressParameter = new SqlParameter("@WebAddress", SqlDbType.NVarChar, 80, "Url");
            SqlParameter insertCreditLimitParameter = new SqlParameter("@CreditLimit", SqlDbType.Int, 0, "CreditLimit");
            SqlParameter insertNewsSubscriberParameter = new SqlParameter("@NewsSubscriber", SqlDbType.Bit, 0, "NewsSubscriber");
            SqlParameter insertCreatedDateParameter = new SqlParameter("@CreatedDate", SqlDbType.SmallDateTime, 0, "CreatedDate");
            SqlParameter insertCreatedByParameter = new SqlParameter("@CreatedBy", SqlDbType.VarChar, 15, "CreatedBy");

            // Assign parameters to command object
            insertCommand.Parameters.Add(insertFirstNameParameter);
            insertCommand.Parameters.Add(insertLastNameParameter);
            insertCommand.Parameters.Add(insertAddressParameter);
            insertCommand.Parameters.Add(insertZipCodeParameter);
            insertCommand.Parameters.Add(insertCityParameter);
            insertCommand.Parameters.Add(insertStateParameter);
            insertCommand.Parameters.Add(insertCountryIDParameter);
            insertCommand.Parameters.Add(insertPhoneParameter);
            insertCommand.Parameters.Add(insertEmailAddressParameter);
            insertCommand.Parameters.Add(insertWebAddressParameter);
            insertCommand.Parameters.Add(insertCreditLimitParameter);
            insertCommand.Parameters.Add(insertNewsSubscriberParameter);
            insertCommand.Parameters.Add(insertCreatedDateParameter);
            insertCommand.Parameters.Add(insertCreatedByParameter);

            // Declare and instantiate dataset
            DataSet customerManagementDataSet = new DataSet("CustomerManagementDataSet");
            // Apply the full schema from the data source
            customerManagementDataAdapter.FillSchema(customerManagementDataSet, SchemaType.Source, "Customers");
            customerManagementDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
            customerManagementDataAdapter.MissingMappingAction = MissingMappingAction.Passthrough;
            // Populate Customers DataTable
            customerManagementDataAdapter.Fill(customerManagementDataSet, "Customers");

            // Create new row locally
            DataRow newCustomerDataRow = customerManagementDataSet.Tables["Customers"].NewRow();
            newCustomerDataRow["ID"] = Guid.NewGuid();
            newCustomerDataRow["FirstName"] = currentCustomer.FirstName;
            newCustomerDataRow["LastName"] = currentCustomer.LastName;
            newCustomerDataRow["Address"] = currentCustomer.Address;
            newCustomerDataRow["ZipCode"] = currentCustomer.ZipCode;
            newCustomerDataRow["City"] = currentCustomer.City;
            newCustomerDataRow["State"] = currentCustomer.State;
            newCustomerDataRow["CountryID"] = currentCustomer.CountryID;
            newCustomerDataRow["Phone"] = currentCustomer.Phone;
            newCustomerDataRow["EmailAddress"] = currentCustomer.EmailAddress;
            newCustomerDataRow["Url"] = currentCustomer.EmailAddress;
            newCustomerDataRow["CreditLimit"] = currentCustomer.CreditLimit;
            newCustomerDataRow["NewsSubscriber"] = currentCustomer.NewsSubscriber;
            newCustomerDataRow["CreatedDate"] = currentCustomer.CreatedDate;
            newCustomerDataRow["CreatedBy"] = currentCustomer.CreatedBy;

            // Insert new row locally
            customerManagementDataSet.Tables["Customers"].Rows.Add(newCustomerDataRow);

            // Update data source
            if (customerManagementDataAdapter.Update(customerManagementDataSet, "Customers") == 1)
            {
                // Instantiate new Customer object
                currentCustomer = new CustomerManagementEntities.Customer();
                // Reload page to refresh with "blank" input controls
                Response.Redirect("~/InsertCustomer.aspx");
            }
        }
    }
Ejemplo n.º 11
0
 /// <summary>
 /// Instantiates and populates the Customer member object
 /// </summary>
 private void instantiateCustomerObject()
 {
     // First time loading page?
     if (!this.IsPostBack)
         // Instantiate new Customer object
         currentCustomer = new CustomerManagementEntities.Customer();
     else
         // Instantiate new Customer object with user input
         currentCustomer = new CustomerManagementEntities.Customer(
             null, CustomerFirstNameTextBox.Text, CustomerLastNameTextBox.Text,
             CustomerAddressTextBox.Text, CustomerZipCodeTextBox.Text,
             CustomerCityTextBox.Text, CustomerStateTextBox.Text,
             new Guid(CustomerCountryDropDownList.SelectedValue), CustomerPhoneTextBox.Text,
             CustomerEmailAddressTextBox.Text, CustomerWebAddressTextBox.Text,
             int.Parse(CustomerCreditLimitTextBox.Text), CustomerNewsSubscriberCheckBox.Checked,
             DateTime.Now, "", null, "");
 }