public int Insert(OrderStatu entity)
{
entity.CreateDate = DateTime.Now;
db.OrderStatus.Add(entity);
db.SaveChanges();
return(entity.OrderStatusID);
}
public ActionResult DeleteConfirmed(int id)
{
OrderStatu orderStatu = userAppManager.FindOrderStatus(id);
userAppManager.DeleteOrderStatus(orderStatu);
return(RedirectToAction("Index"));
}
public static void GenerateOrder()
{
using (EcommerceEntities entites = new EcommerceEntities())
{
HttpRequest httpRequest = HttpContext.Current.Request;
List <OrderItemViewModel> orderItems = JsonConvert.DeserializeObject <List <OrderItemViewModel> >(httpRequest["orderItems"]);
Order order = new Order();
order.CustomerID = Convert.ToInt16(httpRequest["custmerId"]);
order.GrandTotal = Convert.ToInt16(httpRequest["GrandTotal"]);
order.Date = DateTime.UtcNow;
OrderStatu orderStatus = entites.OrderStatus.FirstOrDefault();
order.OrderStatusID = orderStatus.ID;
foreach (var orderItem in orderItems)
{
order.OrderItems.Add(new OrderItem
{
ItemName = orderItem.itemName,
ItemDiscount = orderItem.itemDiscount,
ItemImage = orderItem.itemImage,
ItemPrice = Convert.ToInt16(orderItem.itemPrice),
ItemQuentity = Convert.ToInt16(orderItem.itemQuentity),
ProductID = orderItem.productId
});
}
entites.Orders.Add(order);
entites.SaveChanges();
}
}
public ActionResult OrderStatuCreate([DataSourceRequest] DataSourceRequest request, OrderStatu orderstatu)
{
BL.OrderStatus blOrderStatus = new BL.OrderStatus();
OrderStatu model = blOrderStatus.Insert(orderstatu);
return(Json(new[] { model }.ToDataSourceResult(request, ModelState), JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(long id)
{
OrderStatu orderStatu = db.OrderStatus.Find(id);
db.OrderStatus.Remove(orderStatu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Status")] OrderStatu orderStatu)
{
if (ModelState.IsValid)
{
userAppManager.EditOrderStatus(orderStatu);
return(RedirectToAction("Index"));
}
return(View(orderStatu));
}
public static void DeleteOrderStatus(int id)
{
using (EcommerceEntities entities = new EcommerceEntities())
{
OrderStatu orderStatus = entities.OrderStatus.Where(entry => entry.ID == id).FirstOrDefault();
entities.OrderStatus.Remove(orderStatus);
entities.SaveChanges();
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
OrderStatu orderStatu = await db.OrderStatus.FindAsync(id);
db.OrderStatus.Remove(orderStatu);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name")] OrderStatu orderStatu)
{
if (ModelState.IsValid)
{
db.Entry(orderStatu).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(orderStatu));
}
public ActionResult Create([Bind(Include = "Id,Name")] OrderStatu orderStatu)
{
if (ModelState.IsValid)
{
db.OrderStatus.Add(orderStatu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(orderStatu));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Status")] OrderStatu orderStatu)
{
if (ModelState.IsValid)
{
db.Entry(orderStatu).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(orderStatu));
}
public static ResponseViewModel <OrderStatu> GetOrderStatus(int id)
{
ResponseViewModel <OrderStatu> viewModel = new ResponseViewModel <OrderStatu>();
using (EcommerceEntities entities = new EcommerceEntities())
{
OrderStatu orderStatus = entities.OrderStatus.Where(entry => entry.ID == id).FirstOrDefault();
viewModel.Data = orderStatus;
}
return(viewModel);
}
public IHttpActionResult UpdateOrderStatus([FromBody] OrderStatu orderStatus)
{
try
{
return(Ok(OrderManager.UpdateOrderStatus(orderStatus)));
}
catch (Exception exception)
{
return(InternalServerError(exception));
}
}
public int UpdateOrderStatu(OrderStatu C)
{
try
{
db.Entry(C).State = EntityState.Modified;
return db.SaveChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public int CreateOrderStatu(OrderStatu C)
{
try
{
this.db.OrderStatus.Add(C);
return(db.SaveChanges());
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public async Task <ActionResult> Create([Bind(Include = "Id,Status")] OrderStatu orderStatu)
{
if (ModelState.IsValid)
{
db.OrderStatus.Add(orderStatu);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(orderStatu));
}
public int UpdateOrderStatu(OrderStatu C)
{
try
{
db.Entry(C).State = EntityState.Modified;
return(db.SaveChanges());
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public int CreateOrderStatu(OrderStatu C)
{
try
{
this.db.OrderStatus.Add(C);
return db.SaveChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static ResponseViewModel <OrderStatu> AddOrderStatus(OrderStatu orderStatus)
{
ResponseViewModel <OrderStatu> viewModel = new ResponseViewModel <OrderStatu>();
using (EcommerceEntities entities = new EcommerceEntities())
{
entities.OrderStatus.Add(orderStatus);
entities.SaveChanges();
viewModel.Data = orderStatus;
}
return(viewModel);
}
public static ResponseViewModel <OrderStatu> UpdateOrderStatus(OrderStatu ordersStatus)
{
ResponseViewModel <OrderStatu> viewModel = new ResponseViewModel <OrderStatu>();
using (EcommerceEntities entities = new EcommerceEntities())
{
OrderStatu orderStatusDb = entities.OrderStatus.Where(entry => entry.ID == ordersStatus.ID).FirstOrDefault();
orderStatusDb.Name = ordersStatus.Name;
viewModel.Data = orderStatusDb;
entities.SaveChanges();
}
return(viewModel);
}
public static OrderStatusDTO ToOrderStatusBusiness(this OrderStatu orderstatus)
{
if (orderstatus == null)
{
return(null);
}
return(new OrderStatusDTO
{
ID = orderstatus.ID,
Description = orderstatus.Description
});
}
// GET: OrderStatus/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderStatu orderStatu = await db.OrderStatus.FindAsync(id);
if (orderStatu == null)
{
return(HttpNotFound());
}
return(View(orderStatu));
}
// GET: AOrderStatus/Delete/5
public ActionResult Delete(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderStatu orderStatu = userAppManager.FindOrderStatus(id);
if (orderStatu == null)
{
return(HttpNotFound());
}
return(View(orderStatu));
}
// GET: OrderStatus/Delete/5
public ActionResult Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderStatu orderStatu = db.OrderStatus.Find(id);
if (orderStatu == null)
{
return(HttpNotFound());
}
return(View(orderStatu));
}
public bool Update(OrderStatu entity)
{
try
{
var _orderStatus = db.OrderStatus.Find(entity.OrderStatusID);
_orderStatus.OrderStatusName = entity.OrderStatusName;
_orderStatus.Description = entity.Description;
_orderStatus.DisplayOrder = entity.DisplayOrder;
_orderStatus.ModifiedDate = DateTime.Now;
_orderStatus.ModifiedUser = entity.ModifiedUser;
_orderStatus.CreateDate = entity.CreateDate;
_orderStatus.CreateUser = entity.CreateUser;
_orderStatus.IsActive = entity.IsActive;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit([Bind(Include = "OrderStatusID,OrderStatusName,Description,DisplayOrder,CreateDate,CreateUser,ModifiedDate,ModifiedUser,IsActive")] OrderStatu orderStatu)
{
var UserSession = (UserLogin)Session[TechDeviShopVs002.Common.CommonConstants.USER_SESSION];
if (ModelState.IsValid)
{
var _dal = new OrderStatusDAL();
orderStatu.ModifiedUser = UserSession.UserID;
var _result = _dal.Update(orderStatu);
if (_result)
{
return(RedirectToAction("Index", "OrderStatus"));
}
else
{
ModelState.AddModelError("", "Cập nhật trạng thái hóa đơn ko thành công");
}
}
return(View(orderStatu));
}
public void AddToOrderStatus(OrderStatu orderStatu)
{
base.AddObject("OrderStatus", orderStatu);
}
public int DeleteOrderStatu(int Id)
{
OrderStatu orderStatus = db.OrderStatus.Where(u => u.ID == Id).FirstOrDefault();
return(DeleteOrderStatu(orderStatus));
}
/// <summary>
/// Updates the OrderStatu record with applied changes
/// </summary>
/// <param name="OrderStatus">The OrderStatu record with the OrderStatuID populated that is to be updated.</param>
/// <returns>The OrderStatu record back, unaltered.</returns>
public OrderStatu Update(OrderStatu OrderStatus)
{
return(repository.Update <OrderStatu>(OrderStatus));
}
/// <summary>
/// Inserts the OrderStatu record into the database
/// </summary>
/// <param name="OrderStatus">The new OrderStatu record that is to be inserted into the database.</param>
/// <returns>The inserted OrderStatu record (complete with new OrderStatuID)</returns>
public OrderStatu Insert(OrderStatu OrderStatus)
{
return(repository.Insert <OrderStatu>(OrderStatus));
}
public Order PlaceOrder(string DeliveryType, bool UseWalletCash = false)
{
if (currentCart == null)
{
return(null);
}
List <CartItem> cartItems = GetCartItems();
if (cartItems == null || cartItems.Count == 0)
{
return(null);
}
using (FreshChoiceEntities db = new FreshChoiceEntities())
{
if (DeliveryType == DeliveryTypes.HOME_DELIVERY)
{
Address address = db.Addresses.Where(w => w.UserId == currentUserId).FirstOrDefault();
if (address == null)
{
return(null);
}
}
// Set order status and delivery status
OrderStatu orderStatus = db.OrderStatus.Where(w => w.OrderStatusOrder == OrderProcessingStatus.PLACED).FirstOrDefault();
Delivery delivery = new Delivery();
delivery.DeliveryType = DeliveryType;
db.Deliveries.Add(delivery);
db.SaveChanges();
// create new order
Order order = new Order();
order.OrderDescription = "New Order";
order.OrderBillNo = GenerateBillNo(DeliveryType);
order.OrderConfirmationNo = GenerateConfirmationNo(DeliveryType);
order.OrderUpdatedDate = DateTime.Now;
order.OrderNextDeadline = DateTime.Now.AddHours(ORDER_PLACED_DEADLINE);
order.DeliveryId = delivery.DeliveryId;
order.OrderStatusId = orderStatus.OrderStatusId;
order.CartId = currentCart.CartId;
// calculate cart amount
double total = 0;
foreach (var cartItem in cartItems)
{
total += cartItem.CartItemTotalPrice;
}
// calculate & Add delivery Fees
double deliveryFee = 0;
if (DeliveryType == DeliveryTypes.HOME_DELIVERY)
{
Address address = db.Addresses.Where(w => w.UserId == currentUserId).FirstOrDefault();
if (address != null)
{
var userCoordinate = new GeoCoordinate(address.AddressLatitude, address.AddressLongitude);
var shopCoordinate = new GeoCoordinate(StoreLocation.STORE_LATITUDE, StoreLocation.STORE_LONGITUDE);
var distanceInKM = userCoordinate.GetDistanceTo(shopCoordinate) / 1000;
deliveryFee = distanceInKM * 50;
delivery.DeliveryFee = deliveryFee;
db.SaveChanges();
}
}
order.OrderAmount = total + deliveryFee;
order.UserId = currentUserId;
// if using wallet cash
if (UseWalletCash)
{
// add amount to user wallet
Wallet wallet = db.Wallets.Where(w => w.UserId == currentUserId).FirstOrDefault();
if (wallet == null || wallet.WalletTotal < order.OrderAmount)
{
return(null);
}
// create transaction
Transaction transaction = new Transaction();
transaction.TransactionDate = DateTime.Now;
transaction.TransactionDescription = "cancel_order_" + order.OrderId;
transaction.TransactionAmount = 0 - order.OrderAmount;
transaction.WalletId = wallet.WalletId;
db.Transactions.Add(transaction);
wallet.WalletTotal -= order.OrderAmount;
db.SaveChanges();
}
db.Orders.Add(order);
db.SaveChanges();
DeleteCart();
return(order);
}
}
public void EditOrderStatus(OrderStatu OrderStatus)
{
orderStatusManager.Edit(OrderStatus);
orderStatusManager.Save();
}
public static OrderStatu CreateOrderStatu(short orderStatusID, string statusLabel)
{
OrderStatu orderStatu = new OrderStatu();
orderStatu.OrderStatusID = orderStatusID;
orderStatu.StatusLabel = statusLabel;
return orderStatu;
}
public void DeleteOrderStatus(OrderStatu OrderStatus)
{
orderStatusManager.Delete(OrderStatus);
orderStatusManager.Save();
}
