public ActionResult ActiveOrder(int id)
{
tblOrder tbldetail = db.tblOrders.Find(id);
tbldetail.Status = true;
db.SaveChanges();
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
tblOrder tblOrder = db.tblOrders.Find(id);
db.tblOrders.Remove(tblOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult OrderDeleteConfirmed(int id)
{
tblOrder orderModel = db.tblOrder.Find(id);
db.tblOrder.Remove(orderModel);
db.SaveChanges();
return(RedirectToAction("Orders"));
}
public GuestViewModel(GuestView guestViewOpen)
{
guestView = guestViewOpen;
service = new Service();
order = new tblOrder();
ProductList = service.GetAllProducts();
OrderProduct = new List <tblOrder>();
}
private void SendMail(string strOrderID)
{
try
{
tblOrder objOrder = new tblOrder();
objDataTable = objOrder.GetOrderInfo(strOrderID, Convert.ToInt32(Enums.Enums_OrderStatus.Confirmed).ToString(), Convert.ToInt32(Enums.PaymentMode.COD).ToString());
if (objDataTable.Rows.Count > 0)
{
objCommon = new clsCommon();
string Strbody = "";
string strSubject = "Order confirmation- Your COD Order #" + objDataTable.Rows[0][tblOrder.ColumnNames.AppOrderNo].ToString() + " with Fabymart has been successfully placed!";
Strbody = objCommon.readFile(Server.MapPath("~/Admin/EmailTemplates/CODOrderConfirmation.html"));
Strbody = Strbody.Replace("`link`", strServerURL);
Strbody = Strbody.Replace("`uname`", objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverName].ToString());
Strbody = Strbody.Replace("`orderno`", objDataTable.Rows[0][tblOrder.ColumnNames.AppOrderNo].ToString());
Strbody = Strbody.Replace("`name`", objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverName].ToString());
Strbody = Strbody.Replace("`address`", objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverAddress].ToString());
Strbody = Strbody.Replace("`city`", objDataTable.Rows[0][tblCity.ColumnNames.AppCity].ToString());
Strbody = Strbody.Replace("`pincode`", "-" + objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverPIN].ToString());
Strbody = Strbody.Replace("`state`", objDataTable.Rows[0][tblState.ColumnNames.AppState].ToString());
Strbody = Strbody.Replace("`country`", ", " + objDataTable.Rows[0][tblCountry.ColumnNames.AppCountry].ToString());
Strbody = Strbody.Replace("`mobile`", objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverContactNo1].ToString());
Strbody = Strbody.Replace("`email`", " " + objDataTable.Rows[0][tblOrder.ColumnNames.AppRecevierEmail].ToString());
string strTable = "";
foreach (DataRow row in objDataTable.Rows)
{
strTable += "<tr>";
strTable += "<td align=\"left\" style=\"text-transform: capitalize\" width=\"100\"><img src=\"" + strServerURL + "admin/" + row[tblProductImage.ColumnNames.AppSmallImage].ToString() + "\" width=\"100\" /></td>";
strTable += "<td align=\"left\" style=\"text-transform: capitalize\" ><a target=\"_blank\" href=\"" + GetAlias("ProductDetail.aspx") + generateUrl(row[tblProduct.ColumnNames.AppProductName].ToString()) + " \">" + row[tblProduct.ColumnNames.AppProductName].ToString() + "</a><br />Sku no :" + row[tblProductDetail.ColumnNames.AppSKUNo].ToString() + " </td>";
strTable += "<td align=\"right\" width=\"60\">Rs " + row["appRealPrice"].ToString() + " </td>";
strTable += "<td align=\"right\" width=\"80\">" + row["appQty"].ToString() + "</td>";
strTable += "<td align=\"right\" width=\"60\">Rs " + row["appDiscountPrice"].ToString() + " </td>";
strTable += "<td align=\"right\" width=\"60\">Rs " + row["appTotalPrice"].ToString() + " </td>";
strTable += "</tr>";
}
Strbody = Strbody.Replace("`table`", strTable);
Strbody = Strbody.Replace("`Shipping`", "Rs. " + "0");
Strbody = Strbody.Replace("`COD`", "Rs. " + "0");
Strbody = Strbody.Replace("`Discounts`", "Rs. " + objDataTable.Compute("sum(appDiscountPrice)", "").ToString());
Strbody = Strbody.Replace("`Total`", "Rs. " + objDataTable.Rows[0][tblOrder.ColumnNames.AppOrderAmount].ToString());
string strText = appFunctions.strOrderConfirmed;
strText = strText.Replace("`uname`", objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverName].ToString());
strText = strText.Replace("`orderno`", objDataTable.Rows[0][tblOrder.ColumnNames.AppOrderNo].ToString());
objCommon.SendOrderSMS(strText, objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverContactNo1].ToString());
//objCommon.SendMail(objDataTable.Rows[0][tblOrder.ColumnNames.AppRecevierEmail].ToString(), strSubject, Strbody);
objCommon.SendConfirmationMail(objDataTable.Rows[0][tblOrder.ColumnNames.AppRecevierEmail].ToString(), strSubject, Strbody, Enums.Enum_Confirmation_Mail_type.order);
objCommon = null;
}
objOrder = null;
}
catch (Exception ex)
{
Response.Write(ex.StackTrace.ToString());
}
}
public UserViewModel(User uvmOpen, string username)
{
uvm = uvmOpen;
tblorder = new tblOrder();
//taking JMBG that was forwarded from login form
tblorder.CustomerJMBG = username;
//filling list with data from database
OrderList = GetOrders();
}
public JsonResult UpdateTokenStatus(int id)
{
int branchid = Convert.ToInt32(Session["branchid"]);
tblOrder tb = _db.tblOrders.Where(k => k.OrderId == id && k.BranchId == branchid).FirstOrDefault();
tb.Status = "Inactive";
_db.SaveChanges();
return(Json(tb.TokenNo, JsonRequestBehavior.AllowGet));
}
public ActionResult Checkout()
{
if (Session["customerName"] == null && Session["customerID"] == null)
{
return(RedirectToAction("Login", "Customer"));
}
float totalPrice = 0;
int VendorID = 0;
List <Cart> cart_list = Session["my_cart"] != null ? (List <Cart>)Session["my_cart"] : new List <Cart>();
tblOrder order = new tblOrder();
List <tblOrderDetail> orderDetailList = new List <tblOrderDetail>();
foreach (var item in cart_list)
{
tblOrderDetail orderDetails = new tblOrderDetail();
orderDetails.productID = item.productID;
orderDetails.productTotalPrice = item.productTotalPrice;
orderDetails.productUnitPrice = item.productUnitPrice;
orderDetails.productQty = item.productQty;
VendorID = item.vendorID;
orderDetailList.Add(orderDetails);
totalPrice += item.productTotalPrice;
}
int custID = Convert.ToInt32(Session["customerID"]);
tblCustomer customer = db.tblCustomers.Where(x => x.customerID == custID).FirstOrDefault();
order.vendorID = VendorID;
order.orderStatus = 1;
order.customerID = Convert.ToInt32(Session["customerID"]);
order.totalOrderPrice = totalPrice;
order.orderDelieveryAddress = customer.customerAddress;
order.orderPlacedTime = DateTime.Now;
order.tblOrderDetails = orderDetailList;
db.tblOrders.Add(order);
db.SaveChanges();
int orderID = order.orderID;
foreach (tblOrderDetail order_det in order.tblOrderDetails)
{
order_det.orderID = orderID;
db.Entry(order_det).State = EntityState.Modified;
}
db.SaveChanges();
Session.Remove("my_cart");
return(RedirectToAction("DashBoard", "Customer"));
}
public OrderModel(tblOrder model)
{
Id = model.id;
StoreId = model.StoreId ?? 0;
SenderInfo = model.SenderShippingInfo.Map <ShippingInfoModel>();
SenderInfo.StoreId = this.StoreId;
RecipientInfo = model.RecipientShippingInfo.Map <ShippingInfoModel>();
RecipientInfo.StoreId = this.StoreId;
this.Packages = new List <PackageModel>();
DateTime createDateLocal = DateTime.Now;
foreach (var pa in model.tblPackageInfoes)
{
PackageModel pM = new PackageModel
{
Depth = pa.Depth ?? 0,
Weight = pa.Weight ?? 0,
Fee = pa.Fee ?? 0,
Height = pa.Height ?? 0,
Width = pa.Width ?? 0,
Expedite = pa.Expedite.HasValue ? (pa.Expedite.Value > 0 ? true : false) : false,
Ordinal = pa.Ordinal,
Id = pa.id,
Destination = pa.Destination ?? 0,
WarehouseId = pa.WarehouseId ?? 0,
Status = pa.Status,
CreateTime = model.CreateDate,
StoreId = pa.StoreId
};
pM.Items = new List <ItemPackageModel>();
foreach (var i in pa.tblItemInPackages)
{
ItemPackageModel iM = new ItemPackageModel
{
CategoryId = i.CategoryId ?? 0,
Code = i.Code,
Description = i.Description,
Id = i.id,
Quantity = i.Quantity ?? 0,
Unit = i.Unit,
Value = i.Value ?? 0,
NameCategory = i.tblCategory.CategoryName,
BarCode = i.BarCode
};
pM.Items.Add(iM);
}
this.Packages.Add(pM);
createDateLocal = pa.CreateDateLocal;
}
this.Code = model.Code;
this.CreateDate = (model.CreateDate).UnixTimeStampToDateTime();
this.CreateTime = model.CreateDate;
this.CreateDateLocalString = createDateLocal.ToString(FormatDateLocal);
this.CreateDateLocal = createDateLocal;
this.Expedite = model.Exedite.HasValue ? (model.Exedite.Value > 0 ? true : false) : false;
}
public ActionResult Delete(int id)
{
using (OnlineFoodDBEntities db = new OnlineFoodDBEntities())
{
tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault();
db.tblOrders.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
internal NewGuestViewModel(NewGuestView view, string ordererPersonalNo)
{
this.view = view;
Meals = LoadMeals();
selectedMeal = new tblMeal();
Meal = new tblMeal();
newOrder = new tblOrder();
orderedMeals = new List <tblMealOrder>();
this.ordererPersonalNo = ordererPersonalNo;
}
public ActionResult OrderEdit([Bind(Include = "Id,AdressId,Date,isShipped")] tblOrder orderModel)
{
if (ModelState.IsValid)
{
db.Entry(orderModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Orders"));
}
return(View(orderModel));
}
public ActionResult AddEmployee()
{
if (Session["UserID"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "Login"));
}
try
{
if (ModelState.IsValid)
{
int QID = Convert.ToInt32(Request.Form["QID"]);
int PGID = Convert.ToInt32(Request.Form["PGID"]);
int TypeID = Convert.ToInt32(Request.Form["TypeID"]);
if (IsEmployeeRecordExist(QID, PGID, TypeID))
{
return(Json(new { IsSelected = true, message = "Photographer is already selected for this type" }, JsonRequestBehavior.AllowGet));
}
tblOrder order = new tblOrder();
order.QuotationID = QID;
order.PhotographerID = PGID;
order.PhotographerTypeID = TypeID;
order.TotalPay = Convert.ToDecimal(Request.Form["Salary"]);
order.CreatedDate = DateTime.Now;
db.tblOrders.Add(order);
db.SaveChanges();
tblPayment payment = new tblPayment();
if (db.tblPayments.Where(P => P.PhotographerID == PGID).Count() > 0)
{
payment = db.tblPayments.SingleOrDefault(P => P.PhotographerID == PGID);
payment.RemainingPay += Convert.ToDecimal(Request.Form["Salary"]);
db.Entry(payment).State = EntityState.Modified;
db.SaveChanges();
}
else
{
payment.PhotographerID = PGID;
payment.TotalPay = 0;
payment.RemainingPay = Convert.ToDecimal(Request.Form["Salary"]);
db.tblPayments.Add(payment);
db.SaveChanges();
}
return(Json(new { success = true, message = "Record inserted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = "Record is not inserted!" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = "Error! " + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
var DC = new DataClassesDataContext();
if (Session["ClientID"] != null)
{
foreach (RepeaterItem item in repitem.Items)
{
CheckBox chk = (CheckBox)item.FindControl("chkItemSelect");
if (chk.Checked == true)
{
tblcart cartData = DC.tblcarts.Single(ob => ob.CartID == Convert.ToInt32(chk.Text));
tblitem itemData = DC.tblitems.Single(ob => ob.ItemID == cartData.ItemID);
tblOrder OrderData = new tblOrder();
OrderData.ClientID = Convert.ToInt32(Session["ClientID"]);
OrderData.Date = DateTime.Now;
OrderData.ItemID = cartData.ItemID;
OrderData.MACAddress = GetMACAddress();
OrderData.Qty = cartData.Quantity;
OrderData.TotalAmount = itemData.ItemPrice * cartData.Quantity;
OrderData.IsActive = false;
DC.tblOrders.InsertOnSubmit(OrderData);
DC.tblcarts.DeleteOnSubmit(cartData);
}
}
foreach (RepeaterItem item in repmeal.Items)
{
CheckBox chk = (CheckBox)item.FindControl("chkItemSelect");
if (chk.Checked)
{
tblcart cartData = DC.tblcarts.Single(ob => ob.CartID == Convert.ToInt32(chk.Text));
tblMealPlan MealData = DC.tblMealPlans.Single(ob => ob.MealID == cartData.MealID);
tblOrder OrderData = new tblOrder();
OrderData.ClientID = Convert.ToInt32(Session["ClientID"]);
OrderData.Date = DateTime.Now;
OrderData.MealID = cartData.MealID;
OrderData.MACAddress = GetMACAddress();
OrderData.Qty = cartData.Quantity;
OrderData.TotalAmount = Convert.ToDecimal(MealData.MealPrice) * cartData.Quantity;
OrderData.IsActive = false;
DC.tblOrders.InsertOnSubmit(OrderData);
DC.SubmitChanges();
DC.tblcarts.DeleteOnSubmit(cartData);
DC.SubmitChanges();
}
}
DC.SubmitChanges();
binddata();
binddata1();
}
else
{
Response.Redirect("ServiceLogin.aspx");
}
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool addToCart(Items item)
{
Guid OrderGuid = Guid.Empty;
int orderStatus = (int)OrderStatus.Incomplete;
tblOrder tblOrder = bringlyEntities.tblOrders
.Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid && x.FK_OrderStatusId != orderStatus)
.FirstOrDefault();
if (tblOrder != null && tblOrder.OrderGuid != Guid.Empty)
{
OrderGuid = tblOrder.OrderGuid;
tblOrder.FK_OrderStatusId = (int)(OrderStatus.Incomplete);
}
else
{
tblOrder = new tblOrder();
tblOrder.OrderGuid = Guid.NewGuid();
OrderGuid = tblOrder.OrderGuid;
tblOrder.FK_CreatedByGuid = UserVariables.LoggedInUserGuid;
tblOrder.FK_OrderStatusId = (int)OrderStatus.Incomplete;
tblOrder.OrderDiscount = 0;
//tblOrder.OrderSubTotal = 0;
tblOrder.OrderTotal = 0;
tblOrder.IsDeleted = false;
bringlyEntities.tblOrders.Add(tblOrder);
}
bringlyEntities.SaveChanges();
tblOrderItem OrderItem = bringlyEntities.tblOrderItems
.Where(x => x.FK_ItemGuid == item.ItemGuid && x.FK_OrderGuid == OrderGuid &&
x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid)
.FirstOrDefault();
if (OrderItem != null && OrderItem.OrderItemGuid != Guid.Empty)
{
OrderItem.Quantity = item.Quantity + OrderItem.Quantity;
}
else
{
OrderItem = new tblOrderItem();
OrderItem.OrderItemGuid = Guid.NewGuid();
OrderItem.FK_OrderGuid = OrderGuid;
OrderItem.FK_ItemGuid = item.ItemGuid;
OrderItem.Quantity = item.Quantity;
OrderItem.UnitPrice = 0;
OrderItem.FK_CreatedByGuid = UserVariables.LoggedInUserGuid;
OrderItem.DateCreated = DateTime.Now;
bringlyEntities.tblOrderItems.Add(OrderItem);
}
bringlyEntities.SaveChanges();
return(true);
}
public ActionResult ViewOrder_Post(int id)
{
using (VALLEYSTOREDBEntities db = new VALLEYSTOREDBEntities())
{
tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault();
sm.DeliveredStatus = "Confirmed";
db.SaveChanges();
return(RedirectToAction("ManageOrder", "Order"));
}
}
public void Delete()
{
using (DVDEntities dc = new DVDEntities())
{
tblOrder order = dc.tblOrders.FirstOrDefault(o => o.Id == -99);
dc.tblOrders.Remove(order);
int rowsEffected = dc.SaveChanges();
Assert.IsTrue(rowsEffected == 1);
}
}
public static void SetCShippingLabel(this tblOrder tblOrder, ShippingLabel shippingLabel)
{
tblOrder.CCompany = shippingLabel.Name;
tblOrder.CAddress1 = shippingLabel.Address.AddressLine1;
tblOrder.CAddress2 = shippingLabel.Address.AddressLine2;
tblOrder.CAddress3 = shippingLabel.Address.AddressLine3;
tblOrder.CCity = shippingLabel.Address.City;
tblOrder.CState = shippingLabel.Address.State;
tblOrder.CZip = shippingLabel.Address.PostalCode;
tblOrder.CCountry = shippingLabel.Address.Country;
}
public UserViewModel(User uvmOpen, string username)
{
uvm = uvmOpen;
tblorder = new tblOrder();
//taking JMBG that was forwarded from login form
tblorder.CustomerJMBG = username;
//filling list with data from database
OrderList = GetOrders();
//calling function that will show order status for 2 seconds and than that messagebox will be closed
Show();
}
public ActionResult Detail(int id)
{
tblOrder tbldetail = db.tblOrders.Find(id);
tbldetail.Status = true;
db.SaveChanges();
Updatehistoty.UpdateHistory("Đã check đơn hàng có mã là " + id + " vào lúc " + DateTime.Now + " ", Request.Cookies["Username"].Values["Username"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
string chuoi = "";
chuoi += "<table align=\"left\" cellpadding=\"2\">";
chuoi += "<tr class=\"top\">";
chuoi += "<td class=\"Name\">Tên sản phẩm</td>";
chuoi += "<td class=\"Price\">Đơn giá</td>";
chuoi += "<td class=\"Ord\">SL</td>";
chuoi += "<td class=\"PriceSale\">Thành tiền</td>";
chuoi += "</tr>";
var listOrrder = db.tblOrderDetails.Where(p => p.idOrder == id).ToList();
for (int i = 0; i < listOrrder.Count; i++)
{
chuoi += "<tr class=\"row" + listOrrder[i].id + "\" >";
chuoi += "<td class=\"Name\" >";
int idPro = int.Parse(listOrrder[i].idProduct.ToString());
var product = db.tblProducts.Find(idPro);
chuoi += "<a href=\"/San-pham/" + product.Tag + "\" title=\"" + product.Name + "\" target=\"_blank\" id=\"UpdateOrd" + product.id + "\"><img src=\"" + product.ImageLinkThumb + "\" alt=\"" + product.Name + "\" title=\"" + product.Name + "\" /></a>";
chuoi += "<a href=\"/San-pham/" + product.Tag + "\" title=\"" + product.Name + "\" target=\"_blank\" class=\"Namepd\">" + product.Name + "</a>";
chuoi += "</td>";
chuoi += "<td class=\"Price\"><span>" + string.Format("{0:#,#}", listOrrder[i].Price) + " vnđ</span></td>";
chuoi += "<td class=\"Ord\"><input type=\"number\" name=\"Ord\" class=\"txtOrd" + listOrrder[i].id + "\" value=\"" + listOrrder[i].Quantily + "\" /></td>";
chuoi += "<td class=\"PriceSale\"><span id=\"Gia" + listOrrder[i].id + "\">" + string.Format("{0:#,#}", listOrrder[i].SumPrice) + " vnđ</span></td>";
chuoi += "</tr>";
}
chuoi += "</table>";
chuoi += " <div class=\"Sum\">";
chuoi += " <div class=\"LeftSUM\">";
chuoi += " <span>Bạn có <span class=\"count\">" + listOrrder.Count + "</span> sản phẩm trong giỏ hàng</span>";
chuoi += " </div>";
chuoi += " <div class=\"RightSUM\">";
chuoi += " <span class=\"Sum1\">Tổng cộng : <span class=\"tt\">" + string.Format("{0:#,#}", db.tblOrders.Find(id).Tolar) + "</span> vnđ </span>";
chuoi += " <span class=\"Sum2\">Thành tiền: <span class=\"tt\">" + string.Format("{0:#,#}", db.tblOrders.Find(id).Tolar) + "</span> vnđ </span>";
chuoi += " </div>";
chuoi += "</div>";
chuoi += "<div class=\"OrderNows\">";
chuoi += " </div>";
ViewBag.chuoi = chuoi;
return(View(db.tblOrders.Find(id)));
}
public ActionResult Create(tblOrder tblOrder)
{
if (ModelState.IsValid)
{
db.tblOrders.Add(tblOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblOrder));
}
public IHttpActionResult GettblOrder(int id)
{
tblOrder tblOrder = db.tblOrders.Find(id);
if (tblOrder == null)
{
return(NotFound());
}
return(Ok(tblOrder));
}
public ActionResult Edit([Bind(Include = "OrderId,OrderDate,CustomerId,TotalQty,TotalAmount")] tblOrder tblOrder)
{
if (ModelState.IsValid)
{
db.Entry(tblOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", tblOrder.CustomerId);
return(View(tblOrder));
}
public ActionResult EditInvoice(int?id)
{
tblOrder t = null;
using (dbOrdersEntities ctx = new dbOrdersEntities())
{
FillProducts(ctx);
t = ctx.tblOrders.Include("tblUser").SingleOrDefault <tblOrder>(x => x.idAutoPK == id);
}
return(View(t));
}
public static void SetSShippingLabel(this tblOrder tblOrder, ShippingLabel shippingLabel)
{
tblOrder.SCompany = shippingLabel.Name;
tblOrder.SAddress1 = shippingLabel.Address.AddressLine1;
tblOrder.SAddress2 = shippingLabel.Address.AddressLine2;
tblOrder.SAddress3 = shippingLabel.Address.AddressLine3;
tblOrder.SCity = shippingLabel.Address.City;
tblOrder.SState = shippingLabel.Address.State;
tblOrder.SZip = shippingLabel.Address.PostalCode;
tblOrder.SCountry = shippingLabel.Address.Country;
tblOrder.SPhone = shippingLabel.Phone;
}
public void UpdateOrder(tblOrder updatedOrder)
{
using (var conn = new RestaurantEntities())
{
var order = conn.tblOrders.FirstOrDefault(o => o.OrderID == updatedOrder.OrderID);
if (order != null)
{
order.Price = updatedOrder.Price;
conn.SaveChanges();
}
}
}
public MakeOrderViewModel(MakeOrder openOrder, tblDish dish, User user)
{
thisOrder = openOrder;
pizza = dish;
newOrder = new tblOrder()
{
dishId = pizza.dishId,
dateAndTime = DateTime.Now,
status = "waiting",
username = user.username
};
}
public ActionResult Edit([Bind(Include = "Order_ID,Order_User,Order_TotalPrice,Order_Post,Order_DateAdd")] tblOrder tblOrder)
{
if (ModelState.IsValid)
{
db.Entry(tblOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Order_Post = new SelectList(db.tblPosts, "Post_ID", "Post_Title", tblOrder.Order_Post);
ViewBag.Order_User = new SelectList(db.tblUsers, "User_ID", "User_DisplayName", tblOrder.Order_User);
return(View(tblOrder));
}
private int isExistingOrder(List <tblOrder> orders, tblOrder order)
{
for (int i = 0; i < orders.Count; i++)
{
if (orders[i].Id == order.Id)
{
return(i);
}
}
return(-1);
}
public IHttpActionResult PosttblOrder(tblOrder tblOrder)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblOrders.Add(tblOrder);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tblOrder.orderid }, tblOrder));
}
partial void DeletetblOrder(tblOrder instance);
partial void UpdatetblOrder(tblOrder instance);
partial void InserttblOrder(tblOrder instance);
