public void addOrder()
{
Orders order = new OrdersBuilder().CustomerID("FRANS").Build();
index = repo.addOrders(order);
Assert.IsTrue(index != 0);
}
public Orders getOrdersById(int orderID)
{
Orders order = null;
Connection conn = new Connection();
SqlConnection connection = conn.SqlConnection;
SqlCommand selectCommand = new SqlCommand();
selectCommand.Connection = connection;
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.CommandText = "GetOrderById";
selectCommand.Parameters.Add("@OrderID", SqlDbType.Int);
selectCommand.Parameters["@OrderID"].Value = orderID;
{
try
{
connection.Open();
SqlDataReader dataReader = selectCommand.ExecuteReader();
if (dataReader.HasRows)
{
dataReader.Read();
order = new OrdersBuilder(dataReader.GetInt32(0))
.CustomerID(dataReader.IsDBNull(1) ? (string)null : dataReader.GetString(1))
.EmployeeID(dataReader.IsDBNull(2) ? (int?)null : dataReader.GetInt32(2))
.OrderDate(dataReader.IsDBNull(3) ? (DateTime?)null : dataReader.GetDateTime(3))
.RequiredDate(dataReader.IsDBNull(4) ? (DateTime?)null : dataReader.GetDateTime(4))
.ShippedDate(dataReader.IsDBNull(5) ? (DateTime?)null : dataReader.GetDateTime(5))
.ShipperID(dataReader.IsDBNull(6) ? (int?)null : dataReader.GetInt32(6))
.Freight(dataReader.IsDBNull(7) ? (decimal?)null : dataReader.GetDecimal(7))
.ShipName(dataReader.IsDBNull(8) ? (string)null : dataReader.GetString(8))
.ShipAddress(dataReader.IsDBNull(9) ? (string)null : dataReader.GetString(9))
.ShipCity(dataReader.IsDBNull(10) ? (string)null : dataReader.GetString(10))
.ShipRegion(dataReader.IsDBNull(11) ? (string)null : dataReader.GetString(11))
.ShipPostalCode(dataReader.IsDBNull(12) ? (string)null : dataReader.GetString(12))
.ShipCountry(dataReader.IsDBNull(13) ? (string)null : dataReader.GetString(13))
.Build();
}
dataReader.Close();
}
catch (Exception exc)
{
logger.logError(DateTime.Now, "Error while trying to get Order with OrderID = " + orderID + ".");
MessageBox.Show(exc.Message);
}
finally
{
connection.Close();
}
logger.logInfo(DateTime.Now, "GetOrdersById method has sucessfully invoked.");
return(order);
}
}
protected void ButtonOrder_Click(object sender, EventArgs e)
{
OrderDetailsRepository repoDetails = new OrderDetailsRepository();
Customers customer = (Customers)Session["customer"];
Orders order = new OrdersBuilder().CustomerID(customer.CustomerID).Build();
Dictionary <int, OrderItem> cart = (Dictionary <int, OrderItem>)Session["Cart"];
repoDetails.addTransactionlOrderDetails(order, cart);
Session.Remove("Cart");
Response.Redirect("Cart.aspx");
}
public List <Orders> getAllOrders()
{
List <Orders> ordersList = new List <Orders>();
Connection conn = new Connection();
SqlConnection connection = conn.SqlConnection;
using (SqlCommand command = new SqlCommand("select * from Orders", connection))
{
try
{
connection.Open();
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
Orders order = new OrdersBuilder(dataReader.GetInt32(0))
.CustomerID(dataReader.IsDBNull(1) ? (string)null : dataReader.GetString(1))
.EmployeeID(dataReader.IsDBNull(2) ? (int?)null : dataReader.GetInt32(2))
.OrderDate(dataReader.IsDBNull(3) ? (DateTime?)null : dataReader.GetDateTime(3))
.RequiredDate(dataReader.IsDBNull(4) ? (DateTime?)null : dataReader.GetDateTime(4))
.ShippedDate(dataReader.IsDBNull(5) ? (DateTime?)null : dataReader.GetDateTime(5))
.ShipperID(dataReader.IsDBNull(6) ? (int?)null : dataReader.GetInt32(6))
.Freight(dataReader.IsDBNull(7) ? (decimal?)null : dataReader.GetDecimal(7))
.ShipName(dataReader.IsDBNull(8) ? (string)null : dataReader.GetString(8))
.ShipAddress(dataReader.IsDBNull(9) ? (string)null : dataReader.GetString(9))
.ShipCity(dataReader.IsDBNull(10) ? (string)null : dataReader.GetString(10))
.ShipRegion(dataReader.IsDBNull(11) ? (string)null : dataReader.GetString(11))
.ShipPostalCode(dataReader.IsDBNull(12) ? (string)null : dataReader.GetString(12))
.ShipCountry(dataReader.IsDBNull(13) ? (string)null : dataReader.GetString(13))
.Build();
ordersList.Add(order);
}
dataReader.Close();
}
catch (Exception exc)
{
logger.logError(DateTime.Now, "Error while trying to get all orders.");
MessageBox.Show(exc.Message);
}
logger.logInfo(DateTime.Now, "GetAllOrders method has sucessfully invoked.");
return(ordersList);
}
}
private Orders(OrdersBuilder builder)
{
this.orderID = builder.GetOrderID;
this.customerID = builder.GetCustomerID;
this.employeeID = builder.GetEmployeeID;
this.orderDate = builder.GetOrderDate;
this.requiredDate = builder.GetRequiredDate;
this.shippedDate = builder.GetShippedDate;
this.shipperID = builder.GetShipperID;
this.freight = builder.GetFreight;
this.shipName = builder.GetShipName;
this.shipAddress = builder.GetShipAddress;
this.shipCity = builder.GetShipCity;
this.shipRegion = builder.GetShipRegion;
this.shipPostalCode = builder.GetShipPostalCode;
this.shipCountry = builder.GetShipCountry;
}
