public decimal GetOrderPrice(Common.Order order)
{
SqlParameter orderPrice = new SqlParameter {
Value = 0
};
Order o = mapper.Map <Order>(order);
using (var ctx = new OrderContext())
{
orderPrice = new SqlParameter();
orderPrice.ParameterName = "@totalcost";
orderPrice.Direction = ParameterDirection.Output;
orderPrice.SqlDbType = SqlDbType.Money;
var res = ctx.Database.ExecuteSqlCommand("usp_GetOrderPrice @distance, @floor, @totalcost OUT",
new SqlParameter("@distance", o.Distance),
new SqlParameter("@floor", o.FloorNum),
orderPrice);
}
return(Convert.ToDecimal(orderPrice.Value));
}
public JsonResult UpdateOrder(Common.Order obj)
{
try
{
OrdersBusiness orderBusiness = new OrdersBusiness();
var objentity = orderBusiness.GetById(obj.Id);
//objentity.Id = obj.Id;
objentity.CreateDate = obj.CreateDate;
objentity.CreateBy = obj.CreateBy;
objentity.ModifyDate = DateTime.Now;
objentity.ModifyBy = obj.ModifyBy;
objentity.DateDeliver = obj.DateDeliver;
objentity.Status = obj.Status;
objentity.KmRoad = obj.KmRoad;
objentity.NoteAboutOrder = obj.NoteAboutOrder;
objentity.GramGood = obj.GramGood;
objentity.IdPayForm = obj.IdPayForm;
objentity.IdShop = obj.IdShop;
objentity.TotalMoney = obj.TotalMoney;
objentity.FeeOfTranspot = obj.FeeOfTranspot;
objentity.UrlBtnPayNL = obj.UrlBtnPayNL;
orderBusiness.Edit(objentity);
return(Json(1));//Cập nhật thành công
}
catch (Exception)
{
throw;
}
}
public bool SaveOrder(Common.Order order)
{
Order o = mapper.Map <Order>(order);
using (var ctx = new OrderContext())
{
Order od = ctx.Orders.Add(o);
ctx.SaveChanges();
}
return(true);
}
static void Main(string[] args)
{
RemotingConfiguration.Configure("TestClient.exe.config", false);
Console.WriteLine("Press <Enter> to terminate.");
Common.OrderList list = new Common.OrderList();
Common.OrderItem[] cenas = new Common.OrderItem[2];
cenas[0] = new Common.OrderItem("sushi", 1);
cenas[1] = new Common.OrderItem("abc", 2);
Common.Order o = new Common.Order(list.GetCurrentId(), new Common.Client("hudur", "morada", "c"), cenas, 10);
//list.OnNew += list.HandleOnNew;
Common.OrderEventHandler hand = new Common.OrderEventHandler(list, Common.status.encomendada);
list.OnNew += hand.HandleAddToOrders;
//list.OnPreparing += new Common.OrderEventHandler().HandleOnPreparing;
list.AddOrder(o);
Console.Write(hand.relevant_orders.Count);
Console.ReadLine();
list.OnNew -= hand.HandleAddToOrders;
}
public JsonResult GetOrderById(long id)
{
try
{
var obj = _ordersBusiness.GetById(id);
if (obj != null)
{
Common.Order objentity = new Common.Order();
objentity.Id = obj.Id;
objentity.CreateDate = obj.CreateDate;
objentity.CreateBy = obj.CreateBy;
objentity.ModifyDate = obj.ModifyDate;
objentity.ModifyBy = obj.ModifyBy;
objentity.DateDeliver = obj.DateDeliver;
objentity.Status = obj.Status;
objentity.KmRoad = obj.KmRoad;
objentity.NoteAboutOrder = obj.NoteAboutOrder;
objentity.GramGood = obj.GramGood;
objentity.IdPayForm = obj.IdPayForm;
objentity.IdShop = obj.IdShop;
objentity.TotalMoney = obj.TotalMoney;
objentity.FeeOfTranspot = obj.FeeOfTranspot;
objentity.UrlBtnPayNL = obj.UrlBtnPayNL;
return(Json(objentity, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(0));
}
}
catch (Exception)
{
//Write log
throw;
}
}
/// <summary>
/// This method is used to create a new record of type Order
/// </summary>
/// <param name="order">This parameter is of type Order and holds all the details that need
/// to be stored into the database relating to the Order</param>
public void addOrder(Common.Order order)
{
new DAOrder().addOrder(order);
}
//update order status
/// <summary>
/// This method is used to Update an Order
/// </summary>
/// <param name="o">This parameter is of type ORder and holds all the details for
/// the record to be updated</param>
public void UpdateOrder(Common.Order o)
{
new DAOrder().UpdateOrder(o);
}
public void addOrder(Common.Order order)
{
base.Channel.addOrder(order);
}
public void UpdateOrder(Common.Order o)
{
base.Channel.UpdateOrder(o);
}
