/// <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));
}