public Order_Artwork Get(string Field, string Value) { using (SqlConnection con = DBUtil.BuildConnection()) { con.Open(); SqlCommand Cmd; Cmd = new SqlCommand("SELECT * FROM Order_Artwork WHERE ([" + Field + "] = @Value)", con); Cmd.Parameters.AddWithValue("@Value", Value); using (SqlDataReader Dr = Cmd.ExecuteReader()) { if (Dr.Read()) { /* method thanks to Ron C - https://stackoverflow.com/a/41041029 */ // int i = 0; //return new Customer(Dr.GetString(i++), Dr.GetString(i++), Dr.GetString(i++), Dr.GetString(i++), Dr.GetString(i++), (byte[]) Dr["PasswordSalt"], Dr.GetString(i++)); // method thanks to Andy Edinborough & Cosmin - https://stackoverflow.com/a/5371281 Order_Artwork orderArtwork = new Order_Artwork( (int)Dr["Index"], (string)Dr["OrderId"], (string)Dr["ArtpieceId"], (int)Dr["Quantity"] ); Dr.Close(); con.Close(); return(orderArtwork); } } con.Close(); return(null); } }
public void Delete(Order_Artwork Order_Artwork) { using (SqlConnection con = DBUtil.BuildConnection()) { con.Open(); SqlCommand Cmd = new SqlCommand("DELETE FROM Order_Artwork WHERE Index = @Index", con); Cmd.Parameters.AddWithValue("@CustomerId", Order_Artwork.Index); Cmd.ExecuteNonQuery(); con.Close(); } }
protected void btnAddToCart_Click(object sender, EventArgs e) // TESTING! { /* ---------------------------------------------------------------------------------------------------- * Get session attributes to manipulate * ---------------------------------------------------------------------------------------------------- */ Customer customer = (Customer)Net.GetSession("customer"); Order order = (Order)Net.GetSession("order"); List <Order_Artwork> oaList = (List <Order_Artwork>)Net.GetSession("oaList"); /* ---------------------------------------------------------------------------------------------------- * Initialise daos to use * ---------------------------------------------------------------------------------------------------- */ ArtpieceDao artpieceDao = new ArtpieceDao(); /* ---------------------------------------------------------------------------------------------------- * Add/remove artpiece from oaList * ---------------------------------------------------------------------------------------------------- */ string buttonStr = (sender as Button).Text; // Adding artpiece to oaList if (buttonStr.ToLower().Equals("add to cart")) { Order_Artwork orderArtwork = new Order_Artwork(order.OrderId, artpiece.ArtpieceId, 1, oaList); // Set default quantity to 1 oaList.Add(orderArtwork); // Add order total price order.TotalPrice += artpiece.Price; // Update session Net.SetSession("oaList", oaList); Net.SetSession("order", order); (sender as Button).Text = "ADDED TO CART"; } // Removing artpiece from oaList else if (buttonStr.ToLower().Equals("added to cart")) { oaList.RemoveAll(orderArtwork => orderArtwork.ArtpieceId == artpiece.ArtpieceId); // Thanks to Jon Skeet - https://stackoverflow.com/a/853551 // Refund order total price order.TotalPrice = order.TotalPrice - artpiece.Price; // Update session Net.SetSession("oaList", oaList); Net.SetSession("order", order); (sender as Button).Text = "ADD TO CART"; } }
// crud functions public void Add(Order_Artwork Order_Artwork) { using (SqlConnection con = DBUtil.BuildConnection()) { con.Open(); SqlCommand Cmd = new SqlCommand("INSERT INTO Order_Artwork(OrderId, ArtpieceId, Quantity)" + "VALUES(@OrderId, @ArtpieceId, @Quantity)", con); // Cmd.Parameters.AddWithValue("@Index", Order_Artwork.Index); Auto generated hence no need to insert Cmd.Parameters.AddWithValue("@OrderId", Order_Artwork.OrderId); Cmd.Parameters.AddWithValue("@ArtpieceId", Order_Artwork.ArtpieceId); Cmd.Parameters.AddWithValue("@Quantity", Order_Artwork.Quantity); Cmd.ExecuteNonQuery(); con.Close(); } }
public void Update(Order_Artwork Order_Artwork) { using (SqlConnection con = DBUtil.BuildConnection()) { // SqlCommand Cmd = DBUtil.GenerateSql("UPDATE Order_Artwork SET ... WHERE ([Index] = @Index)"); SqlCommand Cmd = new SqlCommand("UPDATE Order_Artwork " + "SET OrderId = @OrderId" + ", ArtpeiceId = @ArtpeiceId" + ", Quantity = @Quantity" + " WHERE Index = @Index", con ); con.Open(); Cmd.Parameters.AddWithValue("@Index", Order_Artwork.Index); Cmd.Parameters.AddWithValue("@OrderId", Order_Artwork.OrderId); Cmd.Parameters.AddWithValue("@ArtpeiceId", Order_Artwork.ArtpieceId); Cmd.Parameters.AddWithValue("@Quantity", Order_Artwork.Quantity); Cmd.ExecuteNonQuery(); con.Close(); } }