public static string CreateOrder(Order ord)
{
string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
String sql = "INSERT INTO [Order] VALUES(@OrderID ,@CustomerID, @ProductID, @Address, @Amount, @OrderDate, @SupplierID)";
//if there is an error with the data it will catch the exception and display an error
try
{
if (ord.Product.ProductID > 0)
{
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.Add("@OrderID", SqlDbType.Int);
command.Parameters["@OrderID"].Value = ord.OrderID;
command.Parameters.Add("@CustomerID", SqlDbType.Int);
command.Parameters["@CustomerID"].Value = ord.CustomerID;
command.Parameters.Add("@ProductID", SqlDbType.Int);
command.Parameters["@ProductID"].Value = ord.Product.ProductID;
command.Parameters.Add("@Address", SqlDbType.NVarChar);
command.Parameters["@Address"].Value = ord.Address;
command.Parameters.Add("@Amount", SqlDbType.Float);
command.Parameters["@Amount"].Value = ord.Amount;
command.Parameters.Add("@OrderDate", SqlDbType.DateTime);
command.Parameters["@OrderDate"].Value = ord.Date;
command.Parameters.Add("@SupplierID", SqlDbType.Int);
command.Parameters["@SupplierID"].Value = ord.SupplierID;
command.ExecuteNonQuery();
connection.Close();
return "complete";
}
else
return "ProductID <= 0 for some reason - OrderMapper";
}
catch (SqlException sqlEx)
{
return (sqlEx.Message);
}
}
public static string GetOrderID(Order ord)
{
int oID = 0;
string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
SqlDataReader reader;
SqlCommand cmd = new SqlCommand("SELECT OrderID FROM [Order] WHERE OrderID = (SELECT MAX(OrderID) FROM [Order])", con);
try
{
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
oID = Convert.ToInt32(reader["OrderID"]);
oID++;
}
reader.Close();
ord.OrderID = oID;
}
catch (SqlException sqlEx)
{
return (sqlEx.Message);
}
finally
{
con.Close();
}
return "complete";
}
public static string RemoveProduct(Order ord, int pID)
{
string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
String sql = "DELETE FROM [Order] WHERE [OrderID] = @OrderID AND [ProductID] = @ProductID";
//if there is an error with the data it will catch the exception and display an error
try
{
if (ord.Product.ProductID > 0)
{
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.Add("@OrderID", SqlDbType.Int);
command.Parameters["@OrderID"].Value = ord.OrderID;
command.Parameters.Add("@ProductID", SqlDbType.Int);
command.Parameters["@ProductID"].Value = pID;
command.ExecuteNonQuery();
connection.Close();
return "remove product completed";
}
else
return "ProductID < 1 - remove product";
}
catch (SqlException sqlEx)
{
return (sqlEx.Message);
}
}
public static string EditOrder(Order ord)
{
string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
String sql = "UPDATE [Order] SET CustomerID = @CustomerID, ProductID = @ProductID," +
"Address = @Address, Amount = @Amount, OrderDate = @OrderDate, SupplierID = @SupplierID WHERE OrderID = @OrderID)";
//if there is an error with the data it will catch the exception and display an error
try
{
if (ord.Product.ProductID > 0)
{
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.Add("@CustomerID", SqlDbType.Int);
command.Parameters["@CustomerID"].Value = ord.CustomerID;
command.Parameters.Add("@ProductID", SqlDbType.Int);
command.Parameters["@ProductID"].Value = ord.Product.ProductID;
command.Parameters.Add("@Address", SqlDbType.NVarChar);
command.Parameters["@Address"].Value = ord.Address;
command.Parameters.Add("@Amount", SqlDbType.Float);
command.Parameters["@Amount"].Value = ord.Amount;
command.Parameters.Add("@OrderDate", SqlDbType.DateTime);
command.Parameters["@OrderDate"].Value = ord.Date;
command.Parameters.Add("@SupplierID", SqlDbType.Int);
command.Parameters["@SupplierID"].Value = ord.SupplierID;
command.ExecuteNonQuery();
connection.Close();
}
}
catch (SqlException sqlEx)
{
return (sqlEx.Message);
}
return "Edit Order COmpleted";
}
public override void applyDiscount(Order ord)
{
ord.Amount = ord.Amount * disc;
}
protected void btnOrder_Click(object sender, EventArgs e)
{
if (IsValid)
{//Convert.ToInt32(lstProducts.SelectedValue), Convert.ToInt32(txtPrice.Text), 1)
sessionCust = (Customer)Session["CustObj"];
newProduct = new StandardProduct(Convert.ToInt32(lstProducts.SelectedValue), Convert.ToDouble(txtPrice.Text), lstProducts.SelectedItem.Text, 1);
ProductDiscount pd = new ProductDiscount(newProduct);
if (sessionCust != null)
{
Response.Write("Calculating Individual Product DIscount - " + pd.applyDiscount() + "/" + newProduct.Price + " Pid = " + newProduct.ProductID + "\n");
newOrder = new Order(
sessionCust.CustomerID,
newProduct,
1,
txtAddress.Text,
pd.applyDiscount() * Convert.ToInt32(txtQuantity.Text),
DateTime.Now);
newOrder.CreateOrder();
Response.Write("Order processed!!\n\n\n\n");
btnOrder.Enabled = false;
btnAddOrder.Enabled = true;
btnViewOrder.Enabled = true;
Response.Write("Calculating Customer Discount - " + newOrder.Amount +
"/" + (Convert.ToDouble(txtPrice.Text) * Convert.ToInt32(txtQuantity.Text)) + "\n");
Session["OrderObj"] = newOrder;
}
else
Response.Write("No customer is in session, please log in");
}
}
override public void applyDiscount(Order ord)
{
ord.Amount = ord.Amount * disc;
}
public abstract void applyDiscount(Order ord);