public static List<Customer> GetCustomers()
{
// if the directory doesn't exist, create it
if (!Directory.Exists(dir))
Directory.CreateDirectory(dir);
// create the array list for customers
List<Customer> customers = new List<Customer>();
// create the object for the input stream for a binary file
BinaryReader binaryIn =
new BinaryReader(
new FileStream(path, FileMode.OpenOrCreate, FileAccess.Read));
// read the data from the file and store it in the List<>
while (binaryIn.PeekChar() != -1)
{
Customer c = new Customer();
c.FirstName = binaryIn.ReadString();
c.LastName = binaryIn.ReadString();
c.Email = binaryIn.ReadString();
customers.Add(c);
}
binaryIn.Close();
return customers;
}
public static List<Customer> GetCustomers()
{
// if the directory doesn't exist, create it
if (!Directory.Exists(dir))
Directory.CreateDirectory(dir);
// create the object for the input stream for a text file
StreamReader textIn =
new StreamReader(
new FileStream(path, FileMode.OpenOrCreate, FileAccess.Read));
// create the array list for customers
List<Customer> customers = new List<Customer>();
// read the data from the file and store it in the ArrayList
while (textIn.Peek() != -1)
{
string row = textIn.ReadLine();
string[] columns = row.Split('|');
Customer customer = new Customer();
customer.FirstName = columns[0];
customer.LastName = columns[1];
customer.Email = columns[2];
customers.Add(customer);
}
textIn.Close();
return customers;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsValidData())
{
customer = new Customer(txtFirstName.Text, txtLastName.Text,
txtEmail.Text);
this.Close();
}
}
private void btnSave_Click(object sender, System.EventArgs e)
{
if (IsValidData())
{
customer = new WholesaleCustomer(txtFirstName.Text, txtLastName.Text,
txtEmail.Text, txtCompany.Text);
this.Close();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
frmAddModifyCustomer addCustomerForm = new frmAddModifyCustomer();
addCustomerForm.addCustomer = true;
DialogResult result = addCustomerForm.ShowDialog();
if (result == DialogResult.OK)
{
customer = addCustomerForm.customer;
txtCustomerID.Text = customer.CustomerID.ToString();
this.DisplayCustomer();
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
if (IsValidData())
{
if (addCustomer)
{
customer = new Customer();
this.PutCustomerData(customer);
try
{
//customer.CustomerID = CustomerDB.AddCustomer(customer);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else
{
Customer newCustomer = new Customer();
newCustomer.CustomerID = customer.CustomerID;
this.PutCustomerData(newCustomer);
try
{
//if (! CustomerDB.UpdateCustomer(customer, newCustomer))
//{
// MessageBox.Show("Another user has updated or " +
// "deleted that customer.", "Database Error");
// this.DialogResult = DialogResult.Retry;
//}
//else
//{
// customer = newCustomer;
// this.DialogResult = DialogResult.OK;
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
public static bool DeleteCustomer(Customer customer)
{
SqlConnection connection = MMABooksDB.GetConnection();
string strDeleteStatement =
"DELETE FROM Customers WHERE " +
"Name = @Name " +
"AND Address = @Address " +
"AND City = @City " +
"AND State = @State " +
"and ZipCode = @ZipCode ";
SqlCommand deleteCommand = new SqlCommand(strDeleteStatement, connection);
deleteCommand.Parameters.AddWithValue("@Name", customer.Name);
deleteCommand.Parameters.AddWithValue("@Address", customer.Address);
deleteCommand.Parameters.AddWithValue("@City", customer.City);
deleteCommand.Parameters.AddWithValue("@State", customer.State);
deleteCommand.Parameters.AddWithValue("@ZipCode", customer.ZipCode);
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return true;
}
else
{
return false;
}
}
catch (SqlException e)
{
throw e;
}
finally
{
connection.Close();
}
}
public static int AddCustomer(Customer customer)
{
SqlConnection connection = MMABooksDB.GetConnection();
string insertStatement =
"INSERT Customers " +
"(Name, Address, City, State, ZipCode) " +
"VALUES (@Name, @Address, @City, @State, @ZipCode)";
SqlCommand insertCommand =
new SqlCommand(insertStatement, connection);
insertCommand.Parameters.AddWithValue(
"@Name", customer.Name);
insertCommand.Parameters.AddWithValue(
"@Address", customer.Address);
insertCommand.Parameters.AddWithValue(
"@City", customer.City);
insertCommand.Parameters.AddWithValue(
"@State", customer.State);
insertCommand.Parameters.AddWithValue(
"@ZipCode", customer.ZipCode);
try
{
connection.Open();
insertCommand.ExecuteNonQuery();
string selectStatement =
"SELECT IDENT_CURRENT('Customers') FROM Customers";
SqlCommand selectCommand =
new SqlCommand(selectStatement, connection);
int customerID = Convert.ToInt32(selectCommand.ExecuteScalar());
return customerID;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public static List<Customer> GetCustomers()
{
// create the list
List<Customer> customers = new List<Customer>();
// create the XmlReaderSettings object
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreWhitespace = true;
settings.IgnoreComments = true;
// create the XmlReader object
XmlReader xmlIn = XmlReader.Create(path, settings);
// read past all nodes to the first Customer node
xmlIn.ReadToDescendant("Customer");
// create one Customer object for each Customer node
do
{
Customer c = new Customer();
xmlIn.ReadStartElement("Customer");
c.FirstName =
xmlIn.ReadElementContentAsString();
c.LastName =
xmlIn.ReadElementContentAsString();
c.Email =
xmlIn.ReadElementContentAsString();
customers.Add(c);
}
while (xmlIn.ReadToNextSibling("Customer"));
// close the XmlReader object
xmlIn.Close();
return customers;
}
private void btnModify_Click(object sender, EventArgs e)
{
frmAddModifyCustomer modifyCustomerForm = new frmAddModifyCustomer();
modifyCustomerForm.addCustomer = false;
modifyCustomerForm.customer = customer;
DialogResult result = modifyCustomerForm.ShowDialog();
if (result == DialogResult.OK)
{
customer = modifyCustomerForm.customer;
this.DisplayCustomer();
}
else if (result == DialogResult.Retry)
{
this.GetCustomer(customer.CustomerID);
if (customer != null)
this.DisplayCustomer();
else
this.ClearControls();
}
}
private void GetCustomer(int customerID)
{
try
{
customer = CustomerDB.GetCustomer(customerID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
public static Customer GetCustomer(int customerID)
{
SqlConnection connection = MMABooksDB.GetConnection();
string selectStatement
= "SELECT CustomerID, Name, Address, City, State, ZipCode "
+ "FROM Customers "
+ "WHERE CustomerID = @CustomerID";
SqlCommand selectCommand =
new SqlCommand(selectStatement, connection);
selectCommand.Parameters.AddWithValue("@CustomerID", customerID);
try
{
connection.Open();
SqlDataReader custReader =
selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (custReader.Read())
{
Customer customer = new Customer();
customer.CustomerID = (int)custReader["CustomerID"];
customer.Name = custReader["Name"].ToString();
customer.Address = custReader["Address"].ToString();
customer.City = custReader["City"].ToString();
customer.State = custReader["State"].ToString();
customer.ZipCode = custReader["ZipCode"].ToString();
return customer;
}
else
{
return null;
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public static bool UpdateCustomer(Customer oldCustomer,
Customer newCustomer)
{
SqlConnection connection = MMABooksDB.GetConnection();
string updateStatement =
"UPDATE Customers SET " +
"Name = @NewName, " +
"Address = @NewAddress, " +
"City = @NewCity, " +
"State = @NewState, " +
"ZipCode = @NewZipCode " +
"WHERE Name = @OldName " +
"AND Address = @OldAddress " +
"AND City = @OldCity " +
"AND State = @OldState " +
"AND ZipCode = @OldZipCode";
SqlCommand updateCommand =
new SqlCommand(updateStatement, connection);
updateCommand.Parameters.AddWithValue(
"@NewName", newCustomer.Name);
updateCommand.Parameters.AddWithValue(
"@NewAddress", newCustomer.Address);
updateCommand.Parameters.AddWithValue(
"@NewCity", newCustomer.City);
updateCommand.Parameters.AddWithValue(
"@NewState", newCustomer.State);
updateCommand.Parameters.AddWithValue(
"@NewZipCode", newCustomer.ZipCode);
updateCommand.Parameters.AddWithValue(
"@OldName", oldCustomer.Name);
updateCommand.Parameters.AddWithValue(
"@OldAddress", oldCustomer.Address);
updateCommand.Parameters.AddWithValue(
"@OldCity", oldCustomer.City);
updateCommand.Parameters.AddWithValue(
"@OldState", oldCustomer.State);
updateCommand.Parameters.AddWithValue(
"@OldZipCode", oldCustomer.ZipCode);
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
return true;
else
return false;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
private void PutCustomerData(Customer customer)
{
customer.Name = txtName.Text;
customer.Address = txtAddress.Text;
customer.City = txtCity.Text;
customer.State = cboStates.SelectedValue.ToString();
customer.ZipCode = txtZipCode.Text;
}
public void Remove(Customer customer)
{
customers.Remove(customer);
Changed(this);
}
public void Add(Customer customer)
{
customers.Add(customer);
Changed(this);
}