public IActionResult Create(CateringOrder cateringOrder)
{
cateringOrder.User = db.Users.FirstOrDefault(i => i.UserName == User.Identity.Name);
db.CateringOrders.Add(cateringOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public CateringOrder Create(CateringOrder model)
{
_ctx.CateringOrders.Add(model);
_ctx.SaveChanges();
return(model);
}
public static CateringOrder ToModel(this BackendCateringViewModelItem viewmodel)
{
CateringOrder model = new CateringOrder();
model.ID = viewmodel.ID;
model.OrderState = viewmodel.Status.Key;
return(model);
}
public CateringOrder Update(CateringOrder model)
{
var entity = _ctx.CateringOrders.FirstOrDefault(x => x.Id == model.Id);
entity.NumberOfPeople = model.NumberOfPeople;
entity.Outdoors = model.Outdoors;
entity.ChefTypeId = model.ChefTypeId;
entity.Address = model.Address;
_ctx.SaveChanges();
return(model);
}
public static CateringOrder ToModel(this OrderRequest viewmodel, Int32 EventID)
{
CateringOrder model = new CateringOrder();
model.UserID = UserHelper.CurrentUserID;
model.SeatID = viewmodel.SeatID;
model.EventID = EventID;
model.Registered = DateTime.Now;
model.CateringOrderDetail = viewmodel.Items.ConvertAll(x =>
{
return(x.ToModel());
});
return(model);
}
//CateringTotals
//Parameters: CateringOrder – object that contains the values for the catering order
public IActionResult CateringTotals(CateringOrder cateringOrder)
{
TryValidateModel(cateringOrder);
if (ModelState.IsValid == false)
{
return(View("CheckoutCatering", cateringOrder));
}
else
{
cateringOrder.customerType = CustomerType.Catering;
cateringOrder.CalcTotals(cateringOrder.DeliveryFee);
return(View("CateringTotals", cateringOrder));
}
}
private void MigrateOrdersAndDetails(DataContext db, MySqlConnection conn, DataSet set, MySqlDataAdapter adapter)
{
adapter.SelectCommand = new MySqlCommand("Select * from catering_orders", conn);
adapter.Fill(set, "catering_orders");
foreach (DataRow entry in set.Tables["catering_orders"].Rows)
{
int seatID = Convert.ToInt32(entry["seat_id"]);
if (db.Seat.FirstOrDefault(x => x.SeatNumber == seatID) == null)
{
Console.WriteLine("Skipping OrderDetail SeatID : {0} does not exist", Convert.ToInt32(entry["seat_id"]));
continue;
}
var offsetID = TupleToId(db, Convert.ToInt32(entry["user_id"]));
int lanID = Convert.ToInt32(entry["lan_id"]);
var seat = db.Seat.FirstOrDefault(x => x.SeatNumber == seatID);
var order = new CateringOrder()
{
Event = (from eve in db.Event where eve.EventTypeID == 1 && eve.Volume == lanID select eve).First(),
UserID = offsetID,
Seat = seat,
OrderState = Convert.ToInt32(entry["complete_status"]),
Registered = DateTime.Now
};
Detail test = null;
string json = @entry["details"].ToString();
var obj = JsonConvert.DeserializeObject <List <Detail> >(json);
foreach (Detail det in obj)
{
test = det;
var details = new CateringOrderDetail()
{
CateringOrder = order,
CateringProductID = det.ID.Value,
Amount = 1,
Attributes = JsonConvert.SerializeObject(det.attributes),
};
db.CateringOrderDetail.Add(details);
}
}
db.SaveChanges();
}
public static CateringOrder ToModel(this BackendNewOrderRequest viewmodel)
{
UserDataController userDataCtrl = new UserDataController();
CateringOrder model = new CateringOrder();
model.EventID = viewmodel.Event.ID;
model.OrderState = 0;
model.Registered = DateTime.Now;
model.UserID = userDataCtrl.GetItems().Single(x => x.Email == "*****@*****.**").ID;
model.SeatID = 1; // TODO
model.Note = viewmodel.Note;
model.CateringOrderDetail = viewmodel.Data.ConvertAll(x =>
{
return(x.ToModel());
});
return(model);
}
//Checks validation for catering and returns catering total values and view
public IActionResult CateringTotals(CateringOrder Cateringorder)
{
TryValidateModel(Cateringorder);
if (ModelState.IsValid == false) //something is wrong
{
return(View("CheckoutCatering", Cateringorder));
}
//sets the given customer type
Cateringorder.Customertype = CustomerType.Catering;
if (Cateringorder.PreferredCustomer)
{
Cateringorder._decDeliveryFee = 0m;
}
//calculates all preliminary prices and total
Cateringorder.CalcTotals(Cateringorder._decDeliveryFee);
//Move to catering totals
return(View("CateringTotals", Cateringorder));
}
public static BackendCateringViewModelItem FromModel(this BackendCateringViewModelItem viewmodel, CateringOrder model)
{
viewmodel.ID = model.ID;
viewmodel.Event.FromModel(model.Event);
viewmodel.User.FromModel(model.User);
viewmodel.SeatNumber = model.Seat.SeatNumber;
viewmodel.Order = model.CateringOrderDetail.ToList().ConvertAll(x =>
{
return(new BackendCateringOrderItem().FromModel(x));
});
viewmodel.Status = new BackendCateringStatusOption(model.OrderState);
viewmodel.Note = model.Note;
viewmodel.Registered = model.Registered;
return(viewmodel);
}
