/// <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");
}
/// <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");
}
/// <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, "");
}
/// <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, "");
}
}
/// <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, "");
}
}
/// <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, "");
}
}
/// <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");
}
}
}
/// <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;
}
/// <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;
}
/// <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");
}
}
}
/// <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, "");
}
