public void updateCustomers()
{
Customers customer = new CustomersBuilder("MILBO", "MBM - Solutions").Build();
string res = repo.updateCustomers(customer);
Assert.IsNotNull(res);
}
public Customers findCustomerByNameAndPassword(string username, string password)
{
Customers customer = null;
Connection conn = new Connection();
SqlConnection connection = conn.SqlConnection;
SqlCommand selectCommand = new SqlCommand();
selectCommand.Connection = connection;
selectCommand.CommandType = CommandType.Text;
selectCommand.CommandText = "select * from Customers where ContactName = @ContactName and PostalCode = @Password";
selectCommand.Parameters.Add("@ContactName", SqlDbType.NChar);
selectCommand.Parameters["@ContactName"].Value = username;
selectCommand.Parameters.Add("@Password", SqlDbType.NChar);
selectCommand.Parameters["@Password"].Value = password;
try
{
connection.Open();
SqlDataReader dataReader = selectCommand.ExecuteReader();
if (dataReader.HasRows)
{
dataReader.Read();
customer = new CustomersBuilder(dataReader.GetString(0), dataReader.GetString(1))
.ContactName(dataReader.IsDBNull(2) ? (string)null : dataReader.GetString(2))
.ContactTitle(dataReader.IsDBNull(3) ? (string)null : dataReader.GetString(3))
.Address(dataReader.IsDBNull(4) ? (string)null : dataReader.GetString(4))
.City(dataReader.IsDBNull(5) ? (string)null : dataReader.GetString(5))
.Region(dataReader.IsDBNull(6) ? (string)null : dataReader.GetString(6))
.PostalCode(dataReader.IsDBNull(7) ? (string)null : dataReader.GetString(7))
.Country(dataReader.IsDBNull(8) ? (string)null : dataReader.GetString(8))
.Phone(dataReader.IsDBNull(9) ? (string)null : dataReader.GetString(9))
.Fax(dataReader.IsDBNull(10) ? (string)null : dataReader.GetString(10))
.Build();
}
dataReader.Close();
}
catch (Exception exc)
{
logger.logError(DateTime.Now, "Error while trying to get Customer with ContactName = " + username + " and PostalCode = " + password);
MessageBox.Show(exc.Message);
}
finally
{
connection.Close();
}
logger.logInfo(DateTime.Now, "GetCustomerById method has sucessfully invoked.");
return(customer);
}
public Customers getCustomerById(string customerID)
{
Customers customer = null;
Connection conn = new Connection();
SqlConnection connection = conn.SqlConnection;
SqlCommand selectCommand = new SqlCommand();
selectCommand.Connection = connection;
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.CommandText = "GetCustomerById";
selectCommand.Parameters.Add("@CustomerID", SqlDbType.NChar);
selectCommand.Parameters["@CustomerID"].Value = customerID;
{
try
{
connection.Open();
SqlDataReader dataReader = selectCommand.ExecuteReader();
if (dataReader.HasRows)
{
dataReader.Read();
customer = new CustomersBuilder(dataReader.GetString(0), dataReader.GetString(1))
.ContactName(dataReader.IsDBNull(2) ? (string)null : dataReader.GetString(2))
.ContactTitle(dataReader.IsDBNull(3) ? (string)null : dataReader.GetString(3))
.Address(dataReader.IsDBNull(4) ? (string)null : dataReader.GetString(4))
.City(dataReader.IsDBNull(5) ? (string)null : dataReader.GetString(5))
.Region(dataReader.IsDBNull(6) ? (string)null : dataReader.GetString(6))
.PostalCode(dataReader.IsDBNull(7) ? (string)null : dataReader.GetString(7))
.Country(dataReader.IsDBNull(8) ? (string)null : dataReader.GetString(8))
.Phone(dataReader.IsDBNull(9) ? (string)null : dataReader.GetString(9))
.Fax(dataReader.IsDBNull(10) ? (string)null : dataReader.GetString(10))
.Build();
}
dataReader.Close();
}
catch (Exception exc)
{
logger.logError(DateTime.Now, "Error while trying to get Customer with CustomerID = " + customerID + ".");
MessageBox.Show(exc.Message);
}
finally
{
connection.Close();
}
logger.logInfo(DateTime.Now, "GetCustomerById method has sucessfully invoked.");
return(customer);
}
}
private Customers(CustomersBuilder builder)
{
this.customerID = builder.GetCustomerID;
this.companyName = builder.GetCompanyName;
this.contactName = builder.GetContactName;
this.contactTitle = builder.GetContactTitle;
this.address = builder.GetAddress;
this.city = builder.GetCity;
this.region = builder.GetRegion;
this.postalCode = builder.GetPostalCode;
this.country = builder.GetCountry;
this.phone = builder.GetPhone;
this.fax = builder.GetFax;
}
public List <Customers> getAllCustomers()
{
List <Customers> customersList = new List <Customers>();
Connection conn = new Connection();
SqlConnection connection = conn.SqlConnection;
using (SqlCommand command = new SqlCommand("select * from Customers", connection))
{
try
{
connection.Open();
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
Customers customer = new CustomersBuilder(dataReader.GetString(0), dataReader.GetString(1))
.ContactName(dataReader.IsDBNull(2) ? (string)null : dataReader.GetString(2))
.ContactTitle(dataReader.IsDBNull(3) ? (string)null : dataReader.GetString(3))
.Address(dataReader.IsDBNull(4) ? (string)null : dataReader.GetString(4))
.City(dataReader.IsDBNull(5) ? (string)null : dataReader.GetString(5))
.Region(dataReader.IsDBNull(6) ? (string)null : dataReader.GetString(6))
.PostalCode(dataReader.IsDBNull(7) ? (string)null : dataReader.GetString(7))
.Country(dataReader.IsDBNull(8) ? (string)null : dataReader.GetString(8))
.Phone(dataReader.IsDBNull(9) ? (string)null : dataReader.GetString(9))
.Fax(dataReader.IsDBNull(10) ? (string)null : dataReader.GetString(10))
.Build();
customersList.Add(customer);
}
dataReader.Close();
}
catch (Exception exc)
{
logger.logError(DateTime.Now, "Error while trying to get all Customers.");
MessageBox.Show(exc.Message);
}
logger.logInfo(DateTime.Now, "GetAllCustomers method has sucessfully invoked.");
return(customersList);
}
}
