/// <summary> /// translate OrderDetails type to OrderDetailsBE type /// </summary> /// <param name="orderdetails"></param> /// <returns></returns> public OrderDetailsBE Translate(OrderDetails orderdetails) { if (orderdetails != null) { OrderDetailsBE orderdetailsBE = new OrderDetailsBE() { OrderDetailId = orderdetails.OrderDetailId, OrderId = orderdetails.OrderId, ProductId = orderdetails.ProductId, Quantity = orderdetails.Quantity, TotalPrice = orderdetails.TotalPrice, IsDeleted = orderdetails.IsDeleted, Order = new OrderTranslator().Translate(orderdetails.Order), Product = new ProductTranslator().Translate(orderdetails.Product) }; if (orderdetails.Order != null) { OrderTranslator orderTranslator = new OrderTranslator(); orderdetailsBE.Order = orderTranslator.Translate(orderdetails.Order); } if (orderdetails.Product != null) { ProductTranslator productTranslator = new ProductTranslator(); orderdetailsBE.Product = productTranslator.Translate(orderdetails.Product); } return(orderdetailsBE); } else { return(null); } }
/// <summary> /// insert a piece of orderdetails by orderid --by Eric /// </summary> /// <param name="orderdetails"></param> /// <returns></returns> public bool InsertOrderDetails() { OrderDetailsBE orderdetails = new OrderDetailsBE() { OrderId = View.OrderId, ProductId = 1, Quantity = 0, TotalPrice = 0 }; return(_controller.InsertOrderDetails(orderdetails)); }
/// <summary> /// insert a order record and use this orderid to insert a new orderdetails /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void CreateNewRow_Click(object sender, EventArgs e) { if (CustomerList.Text != "Please Select!") { if (ViewState["firstNewRow"] == null) { OrderBE order = new OrderBE() { CreateTime = DateTime.Now, CustomerId = int.Parse(CustomerList.SelectedValue.ToString()), OrderStatusId = 1, Customer = new CustomerBE() { CustomerId = int.Parse(CustomerList.SelectedValue.ToString()), Address = new AddressBE() { AddressId = 1 } }, OrderStatus = new OrderStatusBE() { OrderStatusId = 1 } }; ViewState["orderId"] = new Proxy().InsertOrder(order).OrderId; OrderDetailsBE OrderDetails = new OrderDetailsBE() { OrderId = Convert.ToInt32(ViewState["orderId"]), ProductId = 1, Quantity = 0, TotalPrice = 0 }; new Proxy().InsertOrderDetails(OrderDetails); GridViewOrderdetails.DataSource = new Proxy().GetOrderDetailsByOrderId(Convert.ToInt32(ViewState["orderId"])); GridViewOrderdetails.DataBind(); ViewState["firstNewRow"] = false; CustomerList.Enabled = false; } else { OrderDetailsBE OrderDetails = new OrderDetailsBE() { OrderId = Convert.ToInt32(ViewState["orderId"]), ProductId = 1, Quantity = 0, TotalPrice = 0 }; new Proxy().InsertOrderDetails(OrderDetails); GridViewOrderdetails.DataSource = new Proxy().GetOrderDetailsByOrderId(Convert.ToInt32(ViewState["orderId"])); GridViewOrderdetails.DataBind(); } } }
public void CloseTest() { OrderDetailsManager target = new OrderDetailsManager(); // TODO: Initialize to an appropriate value OrderDetailsBE odBE = new OrderDetailsBE(); // TODO: Initialize to an appropriate value odBE.OrderDetailId = 204; bool expected = false; // TODO: Initialize to an appropriate value bool actual; actual = !(target.Close(odBE)); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
/// <summary> /// Delete a piece of orderdetails through orderdetailsid --by Eric /// </summary> /// <param name="orderdetailId"></param> /// <returns>IsDelete </returns> public bool DeleteOrderDetails() { OrderDetailsBE orderdetails = new OrderDetailsBE() { OrderDetailId = View.OrderDetailsId, OrderId = View.OrderId, ProductId = View.ProductId, Quantity = View.Quantity, TotalPrice = View.TotalPrice }; return(_controller.DeleteOrderDetails(orderdetails)); }
/// <summary> /// insert a piece of orderdetails by orderid --by Eric /// </summary> /// <param name="orderdetails"></param> /// <returns></returns> public bool InsertOrderDetails(OrderDetailsBE orderdetails) { InsertOrderDetailsRequest request = new InsertOrderDetailsRequest(); request.OrderDetailsBE = orderdetails; InsertOrderDetailsResponse response = MyChannelFactory.CreateChannel().InsertOrderDetails(request); if (response != null) { if (response.IsFailed == true) { throw (new Exception(response.Message)); } } return(response.IsFailed); }
/// <summary> /// insert a piece of orderdetails record by new inserted orderid linked by its corresponding createdtime /// </summary> /// <param name="orderdetails"></param> public bool Insert(OrderDetailsBE orderdetailsBE) { TTAEntityContainer dbEntity = new TTAEntityContainer(); OrderDetails orderdetails = new OrderDetailsTranslator().Translate(orderdetailsBE); dbEntity.AddToOrderDetails(orderdetails); int result = dbEntity.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
/// <summary> /// delete a piece of orderdetails record by its corresponding orderdetailsid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewOrderdetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { HiddenField hf = (HiddenField)GridViewOrderdetails.Rows[e.RowIndex].FindControl("OrderDetailId"); DropDownList pn = (DropDownList)GridViewOrderdetails.Rows[e.RowIndex].FindControl("ProductNameList"); TextBox q = (TextBox)GridViewOrderdetails.Rows[e.RowIndex].FindControl("Quantity"); TextBox tp = (TextBox)GridViewOrderdetails.Rows[e.RowIndex].FindControl("TotalPrice"); OrderDetailsBE OrderDetails = new OrderDetailsBE() { OrderDetailId = Convert.ToInt32(hf.Value.ToString()), OrderId = Convert.ToInt32(ViewState["orderId"]), ProductId = Convert.ToInt32(pn.SelectedValue), Quantity = Convert.ToInt32(q.Text), TotalPrice = Convert.ToDecimal(tp.Text) }; new Proxy().DeleteOrderDetails(OrderDetails); GridViewOrderdetails.DataSource = new Proxy().GetOrderDetailsByOrderId(Convert.ToInt32(ViewState["orderId"])); GridViewOrderdetails.DataBind(); }
public void UpdateTest() { OrderDetailsManager target = new OrderDetailsManager(); // TODO: Initialize to an appropriate value OrderDetailsBE orderdetailsBE = new OrderDetailsBE() { OrderDetailId = 204, OrderId = 110, ProductId = 1, Quantity = 1, TotalPrice = 5, IsDeleted = false }; // TODO: Initialize to an appropriate value bool expected = false; // TODO: Initialize to an appropriate value bool actual; actual = !(target.Update(orderdetailsBE)); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
/// <summary> /// insert a piece of orderdetails by orderid --by Eric /// </summary> /// <param name="orderdetails"></param> /// <returns></returns> public bool InsertOrderDetails(OrderDetailsBE orderdetails) { InsertOrderDetailsRequest request = new InsertOrderDetailsRequest(); request.OrderDetailsBE = orderdetails; InsertOrderDetailsResponse response = MyChannelFactory.CreateChannel().InsertOrderDetails(request); if (response != null) { if (response.IsFailed == true) { ILog log = log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); log.Error("error", new Exception(response.Message)); log.Fatal("fatal", new Exception(response.Message)); throw (new Exception(response.Message)); } } return(response.IsFailed); }
/// <summary> /// update a piece of orderdetails record by its corresponding orderdetailsid /// </summary> /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridViewOrderDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox orderdetailsId = (TextBox)GridViewOrderDetails.Rows[e.RowIndex].FindControl("OrderDetailId"); TextBox orderId = (TextBox)GridViewOrderDetails.Rows[e.RowIndex].FindControl("OrderId"); DropDownList productName = (DropDownList)GridViewOrderDetails.Rows[e.RowIndex].FindControl("ProductName"); TextBox quantity = (TextBox)GridViewOrderDetails.Rows[e.RowIndex].FindControl("Quantity"); TextBox totalPrice = (TextBox)GridViewOrderDetails.Rows[e.RowIndex].FindControl("TotalPrice"); OrderDetailsBE OrderDetails = new OrderDetailsBE() { OrderDetailId = Convert.ToInt32(orderdetailsId.Text), OrderId = Convert.ToInt32(orderId.Text), ProductId = Convert.ToInt32(productName.SelectedValue), Quantity = Convert.ToInt32(quantity.Text), TotalPrice = Convert.ToDecimal(totalPrice.Text) }; new Proxy().UpdateOrderDetails(OrderDetails); GridViewOrderDetails.EditIndex = -1; GridViewOrderDetailsDataSource(); }
/// <summary> /// update a piece of orderdetail by its corresponding orderdetailid /// </summary> /// <param name="id"></param> public bool Close(OrderDetailsBE odBE) { TTAEntityContainer dbEntity = new TTAEntityContainer(); OrderDetails orderdetails = (from OrderDetails o in dbEntity.OrderDetails where o.OrderDetailId == odBE.OrderDetailId select o).SingleOrDefault <OrderDetails>(); orderdetails.IsDeleted = true; //dbEntity.OrderDetails.DeleteObject(orderdetails); int result = dbEntity.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
/// <summary> /// update a piece of orderdetail by its corresponding orderdetailid /// </summary> /// <param name="od"></param> public bool Update(OrderDetailsBE odBE) { TTAEntityContainer dbEntity = new TTAEntityContainer(); OrderDetails orderdetails = (from OrderDetails o in dbEntity.OrderDetails where o.OrderDetailId == odBE.OrderDetailId select o).SingleOrDefault <OrderDetails>(); orderdetails.ProductId = odBE.ProductId; orderdetails.Quantity = odBE.Quantity; orderdetails.TotalPrice = odBE.TotalPrice; int result = dbEntity.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
/// <summary> /// translate OrderDetailsBE type to OrderDetails type /// </summary> /// <param name="orderdetailsBE"></param> /// <returns></returns> public OrderDetails Translate(OrderDetailsBE orderdetailsBE) { if (orderdetailsBE != null) { OrderDetails orderdetails = new OrderDetails() { OrderDetailId = orderdetailsBE.OrderDetailId, OrderId = orderdetailsBE.OrderId, ProductId = orderdetailsBE.ProductId, Quantity = orderdetailsBE.Quantity, TotalPrice = orderdetailsBE.TotalPrice, IsDeleted = orderdetailsBE.IsDeleted }; return(orderdetails); } else { return(null); } }
public void InsertTest() { OrderManager orderManager = new OrderManager(); // TODO: Initialize to an appropriate value OrderBE orderBE = new OrderBE() { CreateTime = DateTime.Now, CustomerId = 1, OrderStatusId = 1, Customer = new CustomerBE() { CustomerId = 1, Address = new AddressBE() { AddressId = 1 } }, OrderStatus = new OrderStatusBE() { OrderStatusId = 1 } }; // TODO: Initialize to an appropriate value OrderBE order; order = orderManager.Insert(orderBE); OrderDetailsManager target = new OrderDetailsManager(); // TODO: Initialize to an appropriate value OrderDetailsBE orderdetailsBE = new OrderDetailsBE() { OrderId = order.OrderId, ProductId = 1, Quantity = 0, TotalPrice = 0, IsDeleted = false }; // TODO: Initialize to an appropriate value bool expected = false; // TODO: Initialize to an appropriate value bool actual; actual = !(target.Insert(orderdetailsBE)); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
/// <summary> /// update a piece of orderdetails record by its corresponding orderdetailsid when textbox textchanged /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Quantity_TextChanged(object sender, EventArgs e) { GridViewRow gridRow = ((sender as TextBox).Parent.Parent) as GridViewRow; HiddenField hf = (HiddenField)gridRow.FindControl("OrderDetailId"); DropDownList pn = (DropDownList)gridRow.FindControl("ProductNameList"); TextBox q = (TextBox)gridRow.FindControl("Quantity"); TextBox tp = (TextBox)gridRow.FindControl("TotalPrice"); tp.Text = (new Proxy().GetProductById(Convert.ToInt32(pn.SelectedValue)).ProductPrice *Convert.ToInt32(q.Text)).ToString(); OrderDetailsBE OrderDetails = new OrderDetailsBE() { OrderDetailId = Convert.ToInt32(hf.Value.ToString()), OrderId = Convert.ToInt32(ViewState["orderId"]), ProductId = Convert.ToInt32(pn.SelectedValue), Quantity = Convert.ToInt32(q.Text), TotalPrice = Convert.ToDecimal(tp.Text) }; new Proxy().UpdateOrderDetails(OrderDetails); GridViewOrderdetails.DataSource = new Proxy().GetOrderDetailsByOrderId(Convert.ToInt32(ViewState["orderId"])); GridViewOrderdetails.DataBind(); }
public List <OrderDetailsBE> GetOrderDetails(int orderId) { List <OrderDetailsBE> orders = new List <OrderDetailsBE>(); using (_connection = new SqlConnection(_connectionString)) { //var query = "SELECT [Order].OrderId, Product.ProductId , Product.ProductName , Product.UnitPrice, OrderDetail.Quantity,(OrderDetail.UnitPrice * OrderDetail.Quantity) AS Total " + // "FROM((( [Order] INNER JOIN OrderDetail ON [Order].OrderId = OrderDetail.OrderId) " + // "INNER JOIN Product ON OrderDetail.ProductId = Product.ProductId )) " + // "WHERE[Order].OrderId = orderId"; var query = "SELECT [Order].OrderId, Product.ProductId , Product.ProductName , Product.UnitPrice, OrderDetail.Quantity,(OrderDetail.UnitPrice * OrderDetail.Quantity) AS Total FROM((( [Order] INNER JOIN OrderDetail ON[Order].OrderId = OrderDetail.OrderId) INNER JOIN Product ON OrderDetail.ProductId = Product.ProductId )) WHERE[Order].OrderId = @orderId"; SqlCommand command = new SqlCommand(query, _connection); command.Parameters.AddWithValue("@orderId", orderId); try { _connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { OrderDetailsBE order = new OrderDetailsBE(); order.OrderId = Convert.ToInt32(reader["OrderId"]); order.ProductId = Convert.ToInt32(reader["ProductId"]); order.ProductName = Convert.ToString(reader["ProductName"]); order.UnitPrice = Convert.ToDouble(reader["UnitPrice"]); order.Quantity = Convert.ToInt32(reader["Quantity"]); order.Total = Convert.ToDouble(reader["Total"]); //Adding object to the list orders.Add(order); } reader.Close(); return(orders); } catch (Exception ex) { throw ex; } } }
/// <summary> /// Update a piece of orderdetails record according to its corresponding orderdetailsid /// </summary> /// <param name="orderdetailsBE">A object edit template </param> public bool UpdateOrderDetails(OrderDetailsBE orderdetailsBE) { return(new OrderDetailsManager().Update(orderdetailsBE)); }
/// <summary> /// Insert a piece of orderdetails record according to user's ordering time and orderid /// </summary> /// <param name="orderDetailsBE"></param> public bool InsertOrderDetails(OrderDetailsBE orderDetailsBE) { return(new OrderDetailsManager().Insert(orderDetailsBE)); }
/// <summary> /// Update a piece of orderdetails by orderdetailsid --by Eric /// </summary> /// <param name="orderdetailsBE"></param> /// <returns>IsUpdate </returns> public bool UpdateOrderDetails(OrderDetailsBE orderdetails) { return(new Proxy().UpdateOrderDetails(orderdetails)); }
/// <summary> /// insert a piece of orderdetails by orderid --by Eric /// </summary> /// <param name="orderdetails"></param> /// <returns></returns> public bool InsertOrderDetails(OrderDetailsBE orderdetails) { return(new Proxy().InsertOrderDetails(orderdetails)); }
/// <summary> /// Delete a piece of orderdetails through orderdetailsid --by Eric /// </summary> /// <param name="orderdetailId"></param> /// <returns>IsDelete </returns> public virtual bool CloseOrderDetails(OrderDetailsBE orderdetails) { return(_orderdetailsService.CloseOrderDetails(orderdetails)); }
/// <summary> /// insert a piece of orderdetails by orderid --by Eric /// </summary> /// <param name="orderdetails"></param> /// <returns></returns> public virtual bool InsertOrderDetails(OrderDetailsBE orderdetails) { return(_orderdetailsService.InsertOrderDetails(orderdetails)); }
/// <summary> /// Delete a piece of orderdetails through orderdetailsid --by Eric /// </summary> /// <param name="orderdetailId"></param> /// <returns>IsDelete </returns> public bool DeleteOrderDetails(OrderDetailsBE orderdetails) { return(new Proxy().DeleteOrderDetails(orderdetails)); }
/// <summary> /// Update a piece of orderdetails by orderdetailsid --by Eric /// </summary> /// <param name="orderdetailsBE"></param> /// <returns>IsUpdate </returns> public virtual bool UpdateOrderDetails(OrderDetailsBE orderdetails) { return(_orderdetailsService.UpdateOrderDetails(orderdetails)); }
/// <summary> /// update orderdetails status /// </summary> /// <param name="id">orderdetailsid</param> public bool CloseOrderDetails(OrderDetailsBE orderdetailsBE) { return(new OrderDetailsManager().Close(orderdetailsBE)); }
/// <summary> /// Delete a piece of orderdetails through orderdetailsid --by Eric /// </summary> /// <param name="orderdetailId"></param> /// <returns>IsDelete </returns> public bool CloseOrderDetails(OrderDetailsBE orderdetails) { return(new Proxy().CloseOrderDetails(orderdetails)); }
/// <summary> /// Delete a piece of orderdetails through orderdetailsid --by Eric /// </summary> /// <param name="orderdetailId"></param> /// <returns>IsDelete </returns> public virtual bool DeleteOrderDetails(OrderDetailsBE orderdetails) { return(_orderdetailsService.DeleteOrderDetails(orderdetails)); }