public ActionResult DeleteConfirmed(int id)
{
ViewBag.Exception = null;
string msg = null;
OrderDetailsView odv = db.OrderDetailsView.SingleOrDefault(m => m.id == id);
var entity = (from x in db.OrderDetails where x.id == odv.id select x).First();
var orderid = entity.order_id;
db.OrderDetails.Remove(entity);
try
{
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.order_id = odv.order_id;
ViewBag.Exception = msg;
return(View(odv));
}
return(RedirectToAction("Details", "OrdersViews", new { id = orderid }));
}
private void ViewOrderCommandExecute()
{
Debug.WriteLine("View Order Command executed.");
IRegionManager regionManager = ServiceLocator.Current.GetInstance <IRegionManager>();
if (regionManager != null)
{
IRegion region = regionManager.Regions["MainWindow"];
if (region != null)
{
OrderDetailsView odv = region.GetView("OrderDetailsView") as OrderDetailsView;
OrderDetailsViewModel odvm = odv.DataContext as OrderDetailsViewModel;
odvm.CustomerName = CurrentCustomer.CompanyName;
odvm.Address = CurrentCustomer.Address;
odvm.City = CurrentCustomer.City;
odvm.PostalCode = CurrentCustomer.PostalCode;
odvm.Phone = CurrentCustomer.Phone;
odvm.CurrentOrder = SelectedOrder;
odvm.OrderDate = SelectedOrder.OrderDate;
odvm.RequiredDate = SelectedOrder.RequiredDate;
odvm.ShippedDate = SelectedOrder.ShippedDate;
region.Deactivate(region.GetView("CustomerSummaryView"));
region.Activate(odv);
}
}
}
// public void CreateOrder()
public HttpResponseMessage CreateOrder([FromBody] OrderDetailsView orderDetailsView)
{
string message = "";
int orderNum = 0;
try
{
//אם מחזיר -1 חסרים פרטים על המשתמש בטבלת משתמשים
//Userservice userservice = new Userservice();
//bool ok = userservice.CheckUserDetails(orderDetailsView.User.UserID);
OrderService orderService = new OrderService();
orderNum = orderService.createOrder(orderDetailsView);
//if (!ok) return -1;
if (orderNum == -997)
{
message = string.Format(" כפילות בהזמנות - יש כלב משותף בהזמנה הנוכחית ןבהזמנות קודמות באותם תאריכים ");
HttpError httpError = new HttpError(message);
return(Request.CreateErrorResponse(HttpStatusCode.Conflict, httpError));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, orderNum));
}
}
catch (HttpRequestException ex)
{
throw ex;
// throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.BadRequest,
// badInputValidationException.Result));
//Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
}
private void ShowOrderDetailsView(object sender, EventArgs e)
{
using (var db = new FleaMarketContext())
{
item_order foundOrder = db.item_order.Find(_View.ItemOrderId);
OrderDetailsView details = new OrderDetailsView
{
ItemName = foundOrder.item.item_name,
ItemPrice = foundOrder.item.GetFormattedPrice(),
OrderedAt = foundOrder.ordered_at,
OrdererAddress = foundOrder.orderer_address,
OrdererEmail = foundOrder.orderer_email,
OrdererName = foundOrder.orderer_name,
OrdererPhone = foundOrder.orderer_phone,
StatusId = foundOrder.item.status_id,
StatusName = foundOrder.item.status.status_name,
OrderItemId = foundOrder.item_id,
OrderId = foundOrder.order_id,
Owner = _View.Form,
};
_View.Form.Enabled = false;
details.Show();
}
}
public ActionResult SzczegolyZamowieniaHistoria(int orderID)
{
OrderDetailsView orderDetails = OrderManager.GetOrderDetails(User.Identity.Name, orderID);
if (orderDetails == null) // gdy brak dostepu do zamowienia
{
return(RedirectToAction("Index"));
}
ViewBag.orderID = orderDetails.OrderID;
return(View(orderDetails));
}
public ActionResult Details(int orderId)
{
var order = Context.Orders.Where(ord => ord.Id == orderId).Single();
var orderBooks = Context.Orders_Books.Where(ob => ob.Order_Id == order.Id).Join(Context.Books, ob => ob.Book_Id, b => b.ISBN, (ob, b) => b);
var viewModel = new OrderDetailsView
{
Books = orderBooks.ToList(),
Order = order
};
return(View(viewModel));
}
// GET: OrdersViews/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderDetailsView ordersView = db.OrderDetailsView.SingleOrDefault(m => m.id == id);
if (ordersView == null)
{
return(HttpNotFound());
}
return(View(ordersView));
}
public static PayUForm GetPayUFrom(OrderDetailsView orderDetails)
{
PayUForm payUForm = new PayUForm();
payUForm.listProduct = new List <OrderProductView>(orderDetails.orderProductList);
OrderProductView ord = new OrderProductView();
ord.ProductName = orderDetails.NameDelivery;
ord.ProductPriceB = orderDetails.DeliveryPriceB;
ord.QuantityChoose = 1;
payUForm.listProduct.Add(ord);
Dictionary <string, string> dictionaryPayU = new Dictionary <string, string>();
dictionaryPayU.Add("customerIp", "127.0.0.1");
dictionaryPayU.Add("merchantPosId", "145227");
dictionaryPayU.Add("description", "Sklep internetowy");
String totalPrice = orderDetails.TotalOrderPriceB.Replace(" ", "").Replace("zł", "");
Decimal tPrice = decimal.Parse(totalPrice);
tPrice = tPrice * 100;
dictionaryPayU.Add("totalAmount", ((int)tPrice).ToString());
dictionaryPayU.Add("currencyCode", "PLN");
dictionaryPayU.Add("notifyUrl", "http://localhost:44300/Home/testPay");
dictionaryPayU.Add("continueUrl", "http://localhost:44300/Zamowienia/PayUSuccess"); // po udanej transakcji
for (int i = 0; i < payUForm.listProduct.Count; i++)
{
dictionaryPayU.Add("products[" + i + "].name", payUForm.listProduct[i].ProductName);
String itemPrice = (payUForm.listProduct[i].ProductPriceB).Replace(" ", "").Replace("zł", "");
Decimal itPrice = decimal.Parse(itemPrice);
itPrice = itPrice * 100;
dictionaryPayU.Add("products[" + i + "].unitPrice", ((int)itPrice).ToString());
dictionaryPayU.Add("products[" + i + "].quantity", payUForm.listProduct[i].QuantityChoose.ToString());
}
dictionaryPayU = dictionaryPayU.OrderBy(x => x.Key).ToDictionary(x => x.Key, x => x.Value);
string content = "";
foreach (var item in dictionaryPayU)
{
content = content + item.Key + "=" + Uri.EscapeDataString(item.Value).Replace("%20", "+") + "&";
}
content = content + "13a980d4f851f3d9a1cfc792fb1f5e50";
string hash = sha256(content);
dictionaryPayU.Add("Signature", "sender=145227;algorithm=SHA-256;signature=" + hash);
payUForm.PayUConfiguration = dictionaryPayU;
return(payUForm);
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load"/> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs"/> object that contains the event data.</param>
protected override void OnLoad(EventArgs e)
{
Debug.ArgumentNotNull(e, "e");
base.OnLoad(e);
this.GetOrder(); // INFO: do not remove this "magic" call, otherwise the following line will not work.
OrderDetailsView view = new OrderDetailsView { Order = this.GetOrder() };
this.presenter = new OrderDetailsPresenter(view)
{
OrderSecurity = Ecommerce.Context.Entity.Resolve<MerchantOrderSecurity>(),
OrderStateListValidator = Ecommerce.Context.Entity.Resolve<OrderStateListValidator>()
};
this.presenter.Initialize();
this.Page.Items["OrderDetailsView"] = view;
}
public static OrderDetailsView GetOrderDetails(string login, int orderID)
{
OrderDetailsView orderDetails = new OrderDetailsView();
orderDetails.orderProductList = GetOrderProducts(orderID);
using (sklepEntities db = new sklepEntities())
{
Users user = db.Users.Where(x => x.UserName == login).Single();
orderDetails.OrderID = orderID;
Orders order = db.Orders.Where(x => x.OrderID == orderID).Single();
if (order.UserID != user.UserID) // gdy uzytkonik chce wyswietlic czyjes zamowienie
{
return(null);
}
orderDetails.TotalOrderPriceN = ((decimal)order.PriceN).ToString("C2");
orderDetails.TotalOrderPriceB = ((decimal)order.PriceB).ToString("C2");
orderDetails.Status = order.Status;
orderDetails.NameDelivery = order.NameDelivery;
orderDetails.DeliveryPriceB = ((decimal)((1M + order.VATDelivery) * order.PriceNDelivery)).ToString("C2");
if (order.LastTimeModified == null)
{
orderDetails.lastTimeModified = "Brak";
}
else
{
orderDetails.lastTimeModified = "Ostatnia aktualizacja: " + ((DateTime)order.LastTimeModified).ToString();
}
orderDetails.OrderPath = order.OrderPath;
if (order.InvoicePath == null)
{
orderDetails.InvoicePath = "0"; // gdy brak faktury
}
else
{
orderDetails.InvoicePath = order.InvoicePath;
}
orderDetails.Street = order.DeliverStreet;
orderDetails.NumOfHouse = order.DeliverNumOfHouse;
orderDetails.PostCode = order.DeliverPostCode;
orderDetails.City = order.DeliverCity;
}
return(orderDetails);
}
public ActionResult SzczegolyZamowienia(int orderID)
{
OrderDetailsView orderDetails = OrderManager.GetOrderDetails(User.Identity.Name, orderID);
if (orderDetails == null) // gdy brak dostepu do zamowienia
{
return(RedirectToAction("Index"));
}
ViewBag.orderID = orderDetails.OrderID;
if (orderDetails.Status == "Oczekiwanie na wpłatę")
{
ViewBag.Niezaplacono = 1;
ViewData["payUData"] = OrderManager.GetPayUFrom(orderDetails);
}
return(View(orderDetails));
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load"/> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs"/> object that contains the event data.</param>
protected override void OnLoad(EventArgs e)
{
Debug.ArgumentNotNull(e, "e");
base.OnLoad(e);
this.GetOrder(); // INFO: do not remove this "magic" call, otherwise the following line will not work.
OrderDetailsView view = new OrderDetailsView {
Order = this.GetOrder()
};
this.presenter = new OrderDetailsPresenter(view)
{
OrderSecurity = Ecommerce.Context.Entity.Resolve <MerchantOrderSecurity>(),
OrderStateListValidator = Ecommerce.Context.Entity.Resolve <OrderStateListValidator>()
};
this.presenter.Initialize();
this.Page.Items["OrderDetailsView"] = view;
}
public ActionResult Podsumowanie(DeliveryAddressViewModel deliveryAddressViewModel)
{
if (ModelState.IsValid)
{
int deliveryID = Int32.Parse(Request["deliveriesList"]);
int status;
SummaryOrderViewModel summaryOrderViewModel = OrderManager.GetOrderToSummary(deliveryAddressViewModel, deliveryID, User.Identity.Name, out status);
ViewBag.Status = status;
OrderDetailsView orderDetails = new OrderDetailsView();
orderDetails.orderProductList = summaryOrderViewModel.orderProductList;
orderDetails.TotalOrderPriceB = summaryOrderViewModel.TotalOrderPriceB;
orderDetails.DeliveryPriceB = summaryOrderViewModel.DeliveryPriceB;
orderDetails.NameDelivery = summaryOrderViewModel.NameDelivery;
ViewData["payUData"] = OrderManager.GetPayUFrom(orderDetails);
return(View(summaryOrderViewModel));
}
else
{
// TODO: usuniecie zamowienia z BD
return(RedirectToAction("Index", "Koszyk"));
}
}
private void SearchOrder(object sender, EventArgs e)
{
if (_View.ItemOrderId != -1)
{
// Megnézzük, hogy létezik-e a megrendelés az azonosító alapján
using (var db = new FleaMarketContext())
{
item_order foundOrder = db.item_order.Find(_View.ItemOrderId);
if (foundOrder == null)
{
MessageBox.Show("Nem található az adatbázisban megrendelés ezzel az azonosítóval!", "Keresési hiba", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
// Hozzuk létre a részletes nézetet a megrendeléshez
OrderDetailsView newView = new OrderDetailsView()
{
OrderedAt = foundOrder.ordered_at,
ItemName = foundOrder.item.item_name,
ItemPrice = foundOrder.item.GetFormattedPrice(),
OrdererAddress = foundOrder.orderer_address,
OrdererEmail = foundOrder.orderer_email,
OrdererName = foundOrder.orderer_name,
OrdererPhone = foundOrder.orderer_phone,
StatusId = foundOrder.item.status_id,
StatusName = foundOrder.item.status.status_name,
OrderItemId = foundOrder.item_id,
OrderId = foundOrder.order_id,
Owner = _View.Form
};
_View.Form.Enabled = false;
newView.Show();
}
}
}
}
protected void NextStateButton_Command(object sender, CommandEventArgs e)
{
if (!Page.IsValid)
{
return;
}
Pharmacy.BusinessLayer.Data.ReplenishmentOrder order = OrderService.GetOrder(GetOrderId());
if (order.State == OrderState.Posting)
{
string expectedDelivery = ((TextBox)OrderDetailsView.FindControl("ExpectedDeliveryBox")).Text;
OrderService.UpdateExpectedDeliveryDate(order.Id, parseDateTime(expectedDelivery));
}
if (order.State == OrderState.Ordered)
{
string actualDelivery = ((TextBox)OrderDetailsView.FindControl("ActualDeliveryBox")).Text;
OrderService.UpdateActualDeliveryDate(order.Id, parseDateTime(actualDelivery));
}
OrderService.ProceedToNextState(order.Id);
// display updated data
OrderDetailsView.DataBind();
}
//public void UpdateOrdersByManager(HttpRequestMessage Orders)
public HttpResponseMessage UpdateOrder([FromBody] OrderDetailsView order)
{
//if (ModelState.IsValid)
//{
//var jsonString = Orders.Content.ReadAsStringAsync().Result;
//OrdersForManagetView list = JsonConvert.DeserializeObject<OrdersForManagetView>(jsonString);
// UserDetailsView user = JsonConvert.DeserializeObject<UserDetailsView>(jsonString);
try
{
OrderService orderService = new OrderService();
orderService.UpdateOrderDetails(order);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
// ThrowResponseException(HttpStatusCode.NotModified, ex.Message);
return(Request.CreateResponse(HttpStatusCode.NotModified));
}
//}
}
protected void Cancel_Command(object sender, CommandEventArgs e)
{
OrderService.Cancel(GetOrderId());
// display updated data
OrderDetailsView.DataBind();
}
public ActionResult CreateForProduct([Bind(Include = "id,order_id,quantity,product_name")] OrderDetailsView orderDetailsView)
{
ViewBag.Exception = null;
string msg = "";
var In_Out = (from o in db.Orders where o.id == orderDetailsView.order_id select o.Incoming_Outcoming).First();
ViewBag.In_Out = In_Out;
if (ModelState.IsValid)
{
var order_id = orderDetailsView.order_id;
var p_name = orderDetailsView.product_name;
OrderDetails od = new OrderDetails
{
order_id = orderDetailsView.order_id,
quantity = orderDetailsView.quantity,
product_id = (from p in db.Products where p.name == p_name select p).First().id
};
db.OrderDetails.Add(od);
try
{
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.Exception = msg;
ViewBag.order_id = RouteData.Values["id"];
if (In_Out.Equals("Incoming"))
{
ViewBag.product_name = new SelectList((from p in db.Products
join s in db.WarehousesStock on p.id equals s.product_id
join w in db.Warehouses on s.warehouse_id equals w.id
join o in db.Orders on w.id equals o.warehouse_id
where o.id == orderDetailsView.order_id
select p.name).ToList());
}
else
{
ViewBag.product_name = new SelectList((from p in db.Products
join pr in db.Producers on p.producer_id equals pr.id
join o in db.Orders on pr.id equals o.producer_id
where o.id == orderDetailsView.order_id
select p.name).ToList());
}
ViewBag.In_Out = In_Out;
ViewBag.product_name = new SelectList(db.Products, "name", "name");
return(View(orderDetailsView));
}
return(RedirectToAction("Details", "OrdersViews", new { id = order_id }));
}
ViewBag.order_id = RouteData.Values["id"];
if (In_Out.Equals("Incoming"))
{
ViewBag.product_name = new SelectList((from p in db.Products
join s in db.WarehousesStock on p.id equals s.product_id
join w in db.Warehouses on s.warehouse_id equals w.id
join o in db.Orders on w.id equals o.warehouse_id
where o.id == orderDetailsView.order_id
select p.name).ToList());
}
else
{
// ViewBag.product_name = new SelectList(db.Products, "name", "name");
ViewBag.product_name = new SelectList((from p in db.Products
join pr in db.Producers on p.producer_id equals pr.id
join o in db.Orders on pr.id equals o.producer_id
where o.id == orderDetailsView.order_id
select p.name).ToList());
}
return(View(orderDetailsView));
}
protected override Control CreateContentView()
{
return(_orderDetailsView ?? (_orderDetailsView = new OrderDetailsView(ViewModel)));
}
