private void btn_ViewOrder7_Click(object sender, EventArgs e)
{
pnl_OrderItems.Show();
pnl_homekeuken.Hide();
lbl_OrderItems.Text = "Tafel 7";
Order_Items_Service order_Item_Service = new Order_Items_Service();
List <Order_Item> order_Item_List = order_Item_Service.Get_Order_Items();
Order_Item order_Items = new Order_Item();
Order_Service order_Service = new Order_Service();
List <Order> order_List = order_Service.Get_Orders();
foreach (Order items in order_List)
{
foreach (Order_Item orderitems in order_Item_List)
{
if (items.Tafel_ID == 7)
{
listView_OrderItems.View = View.Details;
ListViewItem li = new ListViewItem(orderitems.Tijd.ToString());
li.SubItems.Add(orderitems.Menu_Item_ID.ToString());
li.SubItems.Add(orderitems.status.ToString());
listView_OrderItems.Items.Add(li);
}
}
}
}
public IActionResult PlaceOrder(int id)
{
List <Cart_Item> CartItems = _context.cart_items.Where(c => c.customer_id == id).ToList();
if (CartItems.Count() == 0)
{
return(RedirectToAction("CustomerDetail", "Customers", new { id = id }));
}
Order currentorder = new Order();
currentorder.customer_id = id;
_context.orders.Add(currentorder);
_context.SaveChanges();
foreach (Cart_Item cartitem in CartItems)
{
Order_Item orderitem = new Order_Item();
orderitem.order_id = currentorder.id;
orderitem.product_id = cartitem.product_id;
orderitem.product_quantity = cartitem.product_quantity;
_context.order_items.Add(orderitem);
_context.Remove(cartitem);
_context.SaveChanges();
}
return(RedirectToAction("CustomerDetail", "Customers", new { id = id }));
}
public ActionResult PlaceOrder(string id)
{
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db));
ApplicationUser customer = UserManager.FindById(User.Identity.GetUserId());
db.Orders.Add(new Order
{
Email = customer.Email,
date_created = DateTime.Now,
shipped = false,
status = "Payment Complete"
});
db.SaveChanges();
var order = db.Orders.ToList()
.FindAll(x => x.Email == customer.Email)
.LastOrDefault();
if (id == "deliver")
{
db.Order_Addresses.Add(new Order_Address()
{
Order_ID = order.Order_ID,
street = Session["Street"].ToString(),
city = Session["City"].ToString(),
zipcode = Session["PostalCode"].ToString()
});
db.SaveChanges();
}
var items = get_Cart_Items();
foreach (var item in items)
{
var x = new Order_Item()
{
Order_id = order.Order_ID,
item_id = item.item_id,
quantity = item.quantity,
price = item.price
};
db.Order_Items.Add(x);
db.SaveChanges();
}
empty_Cart();
//order tracking
//db.Order_Trackings.Add(new Order_Tracking()
//{
// order_ID = order.Order_ID,
// date = DateTime.Now,
// status = "Awaiting Payment",
// Recipient = ""
//});
db.SaveChanges();
//Redirect to payment
return(RedirectToAction("Payment", new { id = order.Order_ID }));
}
private void btn_VoegToe_DEF_Click(object sender, EventArgs e)
{
lbl_Productnaam.Text = listView_MenuItems.SelectedItems[0].SubItems[1].Text;
//Order
Order_Service order_Service = new Order_Service();
List <Order> orders = new List <Order>();
//Order items
Order_Items_Service order_Items_Service = new Order_Items_Service();
List <Order_Item> order_items = new List <Order_Item>();
//Werknemer
Werknemer werknemer = new Werknemer();
werknemer.Werknemer_ID = 2;
//Tafel info
tafel_Service tafel_Service = new tafel_Service();
List <Tafel> tafels = tafel_Service.Get_Tafels();
//Order Items info
Order_Item order_Item = new Order_Item();
foreach (Tafel tafel in tafels)
{
if (tafel.Tafel_Status == Tafel_Status.Open || tafel.Tafel_Status == Tafel_Status.Gereserveerd)
{
orders = order_Service.New_Order(tafel, werknemer);
foreach (Order order in orders)
{
order_Item.Order_ID = order.Order_ID;
}
order_Item.Menu_Item_ID = int.Parse(listView_MenuItems.SelectedItems[0].SubItems[1].Text);
order_Item.status = Order_Status.Besteld;
order_Item.Hoeveelheid = int.Parse(txt_Hoeveelheid.Text);
order_Item.Tijd = DateTime.Now;
order_Item.Opmerking = txt_Opmerking.Text;
}
//else if (tafel.Tafel_Status == Tafel_Status.Bezet)
//{
// orders = order_Service.Get_Orders();
// order_Item.Menu_Item_ID = int.Parse(listView_MenuItems.SelectedItems[0].SubItems[1].Text);
// order_Item.status = Order_Status.Besteld;
// order_Item.Hoeveelheid = int.Parse(txt_Hoeveelheid.Text);
// order_Item.Tijd = DateTime.Now;
// order_Item.Opmerking = txt_Opmerking.Text;
// foreach (Order order in orders)
// {
// }
// orders = order_Items_Service.Add_To_Order();
//}
}
}
//<-----Moving from cart to Order----->
public bool placeOrder(int userId, int shipping, int paymentId)
{
Cart[] items = GetAllCartItemsForClient(userId).ToArray();
decimal perc = 0;
if (CalculateTotalQuantity(userId) >= 5000)
{
perc = 5;
}
Order_Table order = new Order_Table
{
Order_date = DateTime.Now,
Order_Total = CalculateTotalPrice(userId),
Order_Quantity = CalculateTotalQuantity(userId),
Order_Tax = CalculateTotalPrice(userId) * (decimal)0.15,
Order_Status = "Ordered",
Order_Discount = perc > 0 ? 0 : (perc / 100) * CalculateTotalPrice(userId),
Order_Shipping = CalculateTotalQuantity(userId) > 10000 ? 0 : CalculateTotalQuantity(userId) * (decimal)0.02,
Delivery_Id = shipping
};
db.Order_Tables.InsertOnSubmit(order);
db.SubmitChanges();
int orderId = (from o in db.Order_Tables where o.Order_date.Equals(order.Order_date) select o).FirstOrDefault().Order_Id;
order.Order_Total = order.Order_Total + order.Order_Tax + order.Order_Shipping - order.Order_Discount;
foreach (Cart c in items)
{
Order_Item oi = new Order_Item
{
Quantity = c.Quantity,
Product_Id = c.Product_Id,
Order_Id = order.Order_Id,
};
db.Order_Items.InsertOnSubmit(oi);
}
ClearTheCart(userId);
PayClient pc = new PayClient
{
User_Id = userId,
Payment_Id = paymentId,
Order_Id = orderId,
};
db.PayClients.InsertOnSubmit(pc);
db.SubmitChanges();
return(ClearTheCart(userId));
}
public void AddOrderItems(Order order, List <Cart_Item> items)
{
foreach (var item in items)
{
var x = new Order_Item()
{
Order_id = order.Order_ID,
item_id = item.item_id,
quantity = item.quantity,
price = item.price
};
ModelsContext.Order_Items.Add(x);
ModelsContext.SaveChanges();
}
}
public void addOrderItems(Order order, List <Cart_Item> items)
{
foreach (var item in items)
{
var x = new Order_Item()
{
Order_id = order.Order_ID,
item_id = item.item_id,
quantity = item.quantity,
Picture = item.Picture,
price = item.price
};
db.Order_Items.Add(x);
db.SaveChanges();
}
}
static void Main(string[] args)
{
Console.WriteLine("Enter cliente data :");
Console.Write("Name: ");
string name = Console.ReadLine();
Console.Write("Email: ");
string email = Console.ReadLine();
Console.Write("Birth Date (MM/DD/YYYY): ");
DateTime birthday = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Enter order data: ");
Console.Write("Status: ");
OrderStatus status = Enum.Parse <OrderStatus>(Console.ReadLine());
Client client1 = new Client(name, email, birthday);
Order order = new Order(DateTime.Now, status, client1);
Console.WriteLine("How many items to this order? ");
int norder = int.Parse(Console.ReadLine());
for (int i = 1; i <= norder; i++)
{
Console.WriteLine("Enter #{0} item data: ", i);
Console.Write("Product name: ");
string pname = Console.ReadLine();
Console.Write("Product price: ");
double price = double.Parse(Console.ReadLine());
Product product = new Product(pname, price);
Console.Write("Quantity: ");
int quantity = int.Parse(Console.ReadLine());
Order_Item orderI = new Order_Item(quantity, price, product);
order.addItem(orderI);
}
Console.WriteLine("Order Summary: ");
Console.WriteLine(order);
}
public ActionResult UpdateOrderItem([FromRoute] int id, [FromBody] Order_Item order_item)
{
try
{
order_itemRepository.UpdateOrderItem(id, order_item);
return(Ok());
}
catch (DbUpdateConcurrencyException)
{
if (!OrderItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
public ActionResult PlaceOrder(string id)
{
var customer = db.Customers.ToList().Find(x => x.Email == HttpContext.User.Identity.Name);
db.Orders.Add(new Order()
{
Email = customer.Email,
date_created = DateTime.Now,
shipped = false,
status = "Awaiting Payment"
});
db.SaveChanges();
var order = db.Orders.ToList()
.FindAll(x => x.Email == HttpContext.User.Identity.Name)
.LastOrDefault();
if (id == "deliver")
{
db.Order_Addresses.Add(new Order_Address()
{
Order_ID = order.Order_ID,
street = Session["Street"].ToString(),
city = Session["City"].ToString(),
zipcode = Session["PostalCode"].ToString()
});
db.SaveChanges();
}
else if (id == "Same")
{
var cus = db.Customers.ToList().Find(x => x.Email == HttpContext.User.Identity.Name);
db.Order_Addresses.Add(new Order_Address()
{
Order_ID = order.Order_ID,
street = cus.address,
city = cus.City,
zipcode = cus.PostalCode
});
db.SaveChanges();
}
var items = get_Cart_Items();
foreach (var item in items)
{
var x = new Order_Item()
{
Order_id = order.Order_ID,
LivestockID = item.item_id,
quantity = item.quantity,
price = item.price
};
LivesStock itemAlia = (from i in db.LivesStocks
where i.LivestockID == x.LivestockID
select i).Single();
// itemAlia.QuantityInStock -= x.quantity;
db.Entry(itemAlia).State = EntityState.Modified;
db.Order_Items.Add(x);
db.SaveChanges();
}
empty_Cart();
//order tracking
db.Order_Trackings.Add(new Order_Tracking()
{
order_ID = order.Order_ID,
date = DateTime.Now,
status = "Awaiting Payment",
Recipient = ""
});
db.SaveChanges();
//Redirect to payment
return(RedirectToAction("Payment", new { id = order.Order_ID }));
}
public void Update([FromRoute] int id, [FromBody] Order_Item order_item)
{
order_itemRepository.Update(id, order_item);
}
public void Create([FromBody] Order_Item order_item)
{
order_itemRepository.Create(order_item);
}
/// <summary>
/// Updates
/// </summary>
/// <param name="customerId"></param>
/// <param name="foodItemId"></param>
/// <param name="foodItemQuantity"></param>
/// <returns></returns>
public bool UpdateCart(int customerId, ICollection <Order_Item> orderItems)
{
using (Online_Food_Ordering_SystemEntities1 db = new Online_Food_Ordering_SystemEntities1())
{
bool isUpdated = false;
try
{
//find if customer exists, if not then:
if (db.Customers.Where(c => c.Customer_Id == customerId).Count() == 0)
{
throw new FoodOrderException("Customer Doesn't Exist");
}
//find cart for given customer
Order cart = db.Orders.FirstOrDefault(o => (o.isActive && o.Customer_Id == customerId && o.Submit_Status == false));
//if cart doesn't exist for customer
int finalTotalPrice = 0;
int finalTotalQuantity = 0;
if (cart == null)
{
foreach (Order_Item o in orderItems)
{
//setting the latest price of the product in the cart
decimal foodItemPrice = db.Food_Items.FirstOrDefault(item => item.IsActive && item.Food_Item_Id == o.Food_Item_Id).Price;
o.Price = foodItemPrice;
if (o.Quantity < 1)
{
orderItems.Remove(o);
}
}
Order newCart = new Order()
{
Customer_Id = customerId,
Order_date = DateTime.Now,
Employee = null,
Order_Items = orderItems,
Food_Store_Id = null,
Submit_Status = false,
Creation_Date = DateTime.Now,
isActive = true
};
cart = newCart;
db.Orders.Add(newCart);
}
//else if cart exists for customer
else
{
foreach (Order_Item orderItem in orderItems)
{
//find latest price of given orderItem
Food_Item foodItemForPrice = db.Food_Items.FirstOrDefault(item => item.IsActive && item.Food_Item_Id == orderItem.Food_Item_Id);
if (foodItemForPrice == null)
{
continue;
}
decimal foodItemPrice = foodItemForPrice.Price;
//find if item already exist in cart
Order_Item existingOrderItem = db.Order_Items.FirstOrDefault(i => i.Order_Id == cart.Order_Id && i.Food_Item_Id == orderItem.Food_Item_Id);
//if item doesn't already exist in the cart add new item
if (existingOrderItem == null)
{
if (orderItem.Quantity > 0)
{
db.Order_Items.Add(new Order_Item()
{
Order_Id = cart.Order_Id, Food_Item_Id = orderItem.Food_Item_Id, Quantity = orderItem.Quantity, Price = foodItemPrice
});
}
}
//else if item exists in the cart update quantity and latest price
else
{
existingOrderItem.Quantity = orderItem.Quantity;
existingOrderItem.Price = foodItemPrice;
}
}
}
db.SaveChanges();
//Updating Total_Quantity and Total_Price in the db
IQueryable <Order_Item> orderItemList = db.Order_Items.Where(item => item.Order_Id == cart.Order_Id);
foreach (Order_Item orderItem in orderItemList)
{
finalTotalQuantity += (int)orderItem.Quantity;
finalTotalPrice += (int)orderItem.Price * (int)orderItem.Quantity;
if (orderItem.Quantity < 1)
{
db.Order_Items.Remove(orderItem);
}
}
cart.Total_Quantity = finalTotalQuantity;
cart.Total_Price = finalTotalPrice;
db.SaveChanges();
isUpdated = true;
}
catch
{
throw new FoodOrderException();
}
return(isUpdated);
}
}
public ActionResult <Order_Item> CreateOrderItem(Order_Item order_item)
{
order_itemRepository.CreateOrderItem(order_item);
return(CreatedAtAction("GetOrderItem", new { id = order_item.Id }, order_item));
}
//Placing an order method
public ActionResult PlaceOrder(string id)
{
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(db));
ApplicationUser customer = UserManager.FindById(User.Identity.GetUserId());
db.Orders.Add(new Order
{
Email = customer.Email,
date_created = DateTime.Now,
shipped = false,
status = "Payment Complete",
packed = false
});
db.SaveChanges();
//
//Send email after order has been placed
System.Net.ServicePointManager.ServerCertificateValidationCallback = new System.Net.Security.RemoteCertificateValidationCallback(RemoteServerCertificateValidationCallback);
var body = "<p>Email From: {0} ({1})</p><p>Message:</p><p>{2}</p>";
string Message = "<p>You have successfuly placed an order</p>,<p>Send us Feedback:</p>,<link><a href=https://abiytshirt3.azurewebsites.net/Feedback/Create > Click here! </a></link>";
string FromEmail = "ABIY Ltd";
string FromName = "*****@*****.**";
var message = new MailMessage();
message.To.Add(new MailAddress(customer.Email));
message.From = new MailAddress("*****@*****.**");
message.Subject = "Order";
message.Body = string.Format(body, FromName, FromEmail, Message);
message.IsBodyHtml = true;
using (var smtp = new SmtpClient())
{
var credential = new NetworkCredential
{
UserName = "******",
Password = "******" //valid value
};
smtp.Credentials = credential;
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
//smtp.Send(message);
}
var order = db.Orders.ToList()
.FindAll(x => x.Email == customer.Email)
.LastOrDefault();
if (id == "deliver")
{
db.Order_Addresses.Add(new Order_Address()
{
Order_ID = order.Order_ID,
// distance = (int)Session["Distance"],
street = Session["Street"].ToString(),
city = Session["City"].ToString(),
zipcode = Session["PostalCode"].ToString()
});
db.SaveChanges();
}
var items = get_Cart_Items();
foreach (var item in items)
{
var x = new Order_Item()
{
Order_id = order.Order_ID,
item_id = item.item_id,
quantity = item.quantity,
price = item.price
};
db.Order_Items.Add(x);
db.SaveChanges();
}
empty_Cart();
//order tracking
db.Order_Trackings.Add(new Order_Tracking()
{
order_ID = order.Order_ID,
date = DateTime.Now,
status = "Awaiting Payment",
Recipient = ""
});
db.SaveChanges();
//Redirect to payment
return(RedirectToAction("Payment", new { id = order.Order_ID }));
}
public static OrderItemModel ToModel(this Order_Item entity)
{
return(entity.MapTo <Order_Item, OrderItemModel>());
}
