public OrderBE Insert(OrderBE Order)
{
dataAccess.Open();
dataAccess.BeginTran();
try
{
QueryParameter[] list = new QueryParameter[4];
list[0] = new QueryParameter("OrderId", Order.OrderId, DbType.Int32);
list[1] = new QueryParameter("CreateTime", Order.CreateTime, DbType.DateTime);
list[2] = new QueryParameter("CustomerId", Order.CustomerId, DbType.Int32);
list[3] = new QueryParameter("OrderStatusId", Order.OrderStatusId, DbType.Int32);
string sql = "insert into dbo.[Order] values(@CreateTime,@CustomerId,@OrderStatusId)";
dataAccess.ExecuteNonQuery(sql, list);
dataAccess.CommitTran();
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataAccess.Close();
}
return(Order);
}
/// <summary>
/// Gets order by condition.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="date">The date.</param>
/// <param name="oper">The operator.</param>
/// <returns></returns>
public List <OrderBE> GetByCondition(TTAEntityContainer dBEntity, string name, string startDate, string endDate)
{
List <Order> list = new List <Order>();
DateTime startDateTime = DateTime.MinValue;
DateTime endDateTime = DateTime.MaxValue;
if (!startDate.Equals(string.Empty))
{
startDateTime = Convert.ToDateTime(startDate);
}
if (!endDate.Equals(string.Empty))
{
endDateTime = Convert.ToDateTime(endDate);
}
Status status = Status.Deleted;
list = (from Order o in dBEntity.Orders where o.StatusId != (int)status && o.Customer.CustomerName.Contains(name) && o.CreatedDate >= startDateTime && o.CreatedDate <= endDateTime select o).ToList();
List <OrderBE> orderList = new List <OrderBE>();
OrderTranslator translator = new OrderTranslator();
foreach (Order order in list)
{
OrderBE orderBE = translator.Translate(order);
orderList.Add(orderBE);
}
return(orderList);
}
/// <summary>
/// Updates the specified order.
/// </summary>
/// <param name="order">The order.</param>
/// <returns></returns>
public bool Update(SqlConnection connection, OrderBE order)
{
int result = initialData;
bool success = false;
if (order != null)
{
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = UpdateScript;
command.Parameters.AddWithValue(ColumnNameCreatedDate, order.CreateTime);
command.Parameters.AddWithValue(ColumnNameCustomerId, order.Customer.CustomerId);
command.Parameters.AddWithValue(ColumnNameStatusId, order.OrderStatus.OrderStatusId);
command.Parameters.AddWithValue(ColumnNameOrderId, order.OrderId);
result = Convert.ToInt32(command.ExecuteScalar());
if (result != initialData)
{
success = true;
}
}
}
return(success);
}
/// <summary>
/// Gets the by id.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public OrderBE GetById(int id, SqlConnection connection)
{
List <OrderBE> orderList = new List <OrderBE>();
OrderBE orderResult = new OrderBE();
if (id > 0)
{
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = SelectByIdScript;
command.Parameters.AddWithValue(ColumnNameOrderId, id);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
if (table != null)
{
orderList = ConvertToOrderDEList(table);
}
orderResult = orderList.First();
}
}
return(orderResult);
}
/// <summary>
/// Translates Order into OrderBE.
/// </summary>
/// <param name="order"> order data entity.</param>
/// <returns></returns>
public OrderBE Translate(Order order)
{
if (order != null)
{
OrderBE orderBE = new OrderBE()
{
OrderId = order.OrderId,
CreateTime = order.CreatedDate,
CustomerId = order.CustomerId,
OrderStatusId = order.StatusId,
Customer = new CustomerBE(),
OrderStatus = new OrderStatusBE()
};
if (order.Customer != null)
{
CustomerTranslator customerTranslator = new CustomerTranslator();
orderBE.Customer = customerTranslator.Translate(order.Customer);
}
if (order.OrderStatus != null)
{
orderBE.OrderStatus.OrderStatusId = order.OrderStatus.StatusId;
orderBE.OrderStatus.StatusName = order.OrderStatus.StatusName;
if (order.StatusId == 1)
{
orderBE.OrderCheckBoxFlag = true;
}
}
return(orderBE);
}
else
{
return(null);
}
}
public OrderBE GetById(int id)
{
SqlConnection connection = CreateConnection();
OrderBE orderResult = new OrderBE();
orderResult = this.GetById(id, connection);
connection.Close();
return(orderResult);
}
/// <summary>
/// Updates the specified order.
/// </summary>
/// <param name="order">The order.</param>
/// <returns></returns>
public bool Update(OrderBE order)
{
SqlConnection connection = CreateConnection();
bool result = false;
result = this.Update(connection, order);
connection.Close();
return(result);
}
/// <summary>
/// Saves the specified order.
/// </summary>
/// <param name="order">The order.</param>
/// <returns></returns>
public OrderBE Insert(OrderBE order)
{
if (order != null)
{
SqlConnection connection = CreateConnection();
order = this.Insert(connection, order);
connection.Close();
}
return(order);
}
/// <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();
}
}
}
/// <summary>
/// Inserts order.
/// </summary>
/// <param name="DBEntity">The TTAEntityContainer.</param>
/// <param name="order">The order.</param>
public OrderBE Insert(TTAEntityContainer DBEntity, OrderBE orderBE)
{
OrderTranslator translator = new OrderTranslator();
Order order = null;
if (orderBE != null)
{
order = translator.Translate(orderBE);
DBEntity.AddToOrders(order);
DBEntity.SaveChanges();
}
return(translator.Translate(order));
}
/// <summary>
/// Inserts the specified order.
/// </summary>
/// <param name="order">The order.</param>
/// <param name="connection">The connection.</param>
/// <returns></returns>
public OrderBE Insert(SqlConnection connection, OrderBE order)
{
if (order != null)
{
SqlCommand command = connection.CreateCommand();
command.CommandText = InsertScript;
command.Parameters.AddWithValue(ColumnNameCreatedDate, order.CreateTime);
command.Parameters.AddWithValue(ColumnNameCustomerId, order.Customer.CustomerId);
command.Parameters.AddWithValue(ColumnNameStatusId, order.OrderStatus.OrderStatusId);
order.OrderId = Convert.ToInt32(command.ExecuteScalar());
}
return(order);
}
/// <summary>
/// Insert a piece of order and return the orderid --by Eric
/// </summary>
/// <param name="order"></param>
/// <returns>Inserted order </returns>
public OrderBE InsertOrder(OrderBE order)
{
InsertOrderRequest request = new InsertOrderRequest();
request.OrderBE = order;
InsertOrderResponse response = MyChannelFactory.CreateChannel().InsertOrder(request);
if (response != null)
{
if (response.IsFailed == true)
{
throw (new Exception(response.Message));
}
}
return(response.OrderBE);
}
/// <summary>
/// Gets the by customer ID.
/// </summary>
/// <param name="dBEntity">The d B entity.</param>
/// <param name="customerId">The customer id.</param>
/// <returns></returns>
public List <OrderBE> GetByCustomerID(TTAEntityContainer dBEntity, int customerId)
{
List <Order> orderList = null;
List <OrderBE> resultList = null;
OrderTranslator translator = new OrderTranslator();
if (customerId >= 0)
{
orderList = (from Order o in dBEntity.Orders where o.CustomerId == customerId select o).ToList <Order>();
}
foreach (Order order in orderList)
{
OrderBE orderBE = translator.Translate(order);
resultList.Add(orderBE);
}
return(resultList);
}
/// <summary>
/// Translates orderBE into order.
/// </summary>
/// <param name="orderBE">The order BE.</param>
/// <returns></returns>
public Order Translate(OrderBE orderBE)
{
if (orderBE != null)
{
Order order = new Order()
{
OrderId = orderBE.OrderId,
CreatedDate = orderBE.CreateTime,
StatusId = orderBE.OrderStatus.OrderStatusId,
CustomerId = orderBE.Customer.CustomerId,
};
return(order);
}
else
{
return(null);
}
}
/// <summary>
/// Insert a piece of order and return the orderid --by Eric
/// </summary>
/// <param name="order"></param>
/// <returns>Inserted order </returns>
public OrderBE InsertOrder(OrderBE order)
{
InsertOrderRequest request = new InsertOrderRequest();
request.OrderBE = order;
InsertOrderResponse response = MyChannelFactory.CreateChannel().InsertOrder(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.OrderBE);
}
/// <summary>
/// Converts dataTable into OrderDE list.
/// </summary>
/// <param name="table">The table.</param>
/// <returns></returns>
private List <OrderBE> ConvertToOrderDEList(DataTable table)
{
List <OrderBE> orderList = new List <OrderBE>();
foreach (DataRow row in table.Rows)
{
OrderBE order = new OrderBE()
{
OrderId = Convert.ToInt32(row[ColumnNameOrderId]),
CreateTime = Convert.ToDateTime(row[ColumnNameCreatedDate]),
};
CustomerDA customerDA = new CustomerDA();
order.Customer = customerDA.GetById(Convert.ToInt32(row[ColumnNameCustomerId])); //
OrderStatusDA orderStatusDA = new OrderStatusDA();
order.OrderStatus = orderStatusDA.GetById(Convert.ToInt32(row[ColumnNameStatusId]));
orderList.Add(order);
}
return(orderList);
}
/// <summary>
/// Updates order.
/// </summary>
/// <param name="dBEntity">The entity frame work data entity.</param>
/// <param name="orderBE">The order.</param>
public bool Update(TTAEntityContainer dBEntity, OrderBE orderBE)
{
int result = initialData;
if (orderBE != null)
{
Order temp = this.GetDEById(dBEntity, orderBE.OrderId);
temp.StatusId = orderBE.OrderStatusId;
temp.OrderStatus.StatusId = orderBE.OrderStatus.OrderStatusId;
temp.OrderStatus.StatusName = orderBE.OrderStatus.StatusName;
result = dBEntity.SaveChanges();
}
if (result != initialData)
{
return(true);
}
else
{
return(false);
}
}
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>
/// Insert a piece of order and return the orderid --by Eric
/// </summary>
/// <param name="order"></param>
/// <returns>Inserted order </returns>
public OrderBE InsertOrder()
{
OrderBE order = new OrderBE()
{
CreateTime = DateTime.Now,
CustomerId = int.Parse(View.CustomerName),
OrderStatusId = 1,
Customer = new CustomerBE()
{
CustomerId = int.Parse(View.CustomerName),
Address = new AddressBE()
{
AddressId = 1
}
},
OrderStatus = new OrderStatusBE()
{
OrderStatusId = 1
}
};
return(_controller.InsertOrder(order));
}
/// <summary>
/// Insert a piece of order and return the orderid --by Eric
/// </summary>
/// <param name="order"></param>
/// <returns>Inserted order </returns>
public virtual OrderBE InsertOrder(OrderBE order)
{
return(_orderdetailsService.InsertOrder(order));
}
/// <summary>
/// update orderBE by orderid
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Update(OrderBE order)
{
return(new OrderManager().Update(order));
}
/// <summary>
/// Insert order.
/// </summary>
/// <param name="orderBE">The order.</param>
public OrderBE Insert(OrderBE orderBE)
{
TTAEntityContainer DBEntity = new TTAEntityContainer();
return(this.Insert(DBEntity, orderBE));
}
/// <summary>
/// Updates order. -By Eric
/// </summary>
/// <param name="order">The order.</param>
public bool Update(OrderBE orderBE)
{
TTAEntityContainer DBEntity = new TTAEntityContainer();
return(this.Update(DBEntity, orderBE));
}
/// <summary>
/// Insert a piece of order record according to customername and return its corresponding orderid
/// </summary>
/// <param name="odBE">A object generate when create order </param>
/// <returns></returns>
public OrderBE InsertOrder(OrderBE oBE)
{
return(new OrderManager().Insert(oBE));
//return new OrderDetailsManager().InsertOrder(oBE);
}
/// <summary>
/// Insert a piece of order and return the orderid --by Eric
/// </summary>
/// <param name="order"></param>
/// <returns>Inserted order </returns>
public OrderBE InsertOrder(OrderBE order)
{
return(new Proxy().InsertOrder(order));
}
