public PartialViewResult HistoricPartialView(string day)
{
viewmodel = FillViewModel();
switch (day)
{
case "Thursday":
viewmodel.historicPerDay = GetHistoricPerDay(new DateTime(2018, 7, 26));
break;
case "Friday":
viewmodel.historicPerDay = GetHistoricPerDay(new DateTime(2018, 7, 27));
break;
case "Saturday":
viewmodel.historicPerDay = GetHistoricPerDay(new DateTime(2018, 7, 28));
break;
case "Sunday":
viewmodel.historicPerDay = GetHistoricPerDay(new DateTime(2018, 7, 29));
break;
default:
viewmodel.historicPerDay = GetHistoricPerDay(new DateTime(2018, 7, 26));
break;
}
return(PartialView("_HistoricPartialView", viewmodel));
}
public PartialViewResult DeleteTransaction(int _transactionNumber)
{
//Create the view model.
HistoricViewModel vm = new HistoricViewModel();
//Remove the transaction overview from the database
m_Context.TransactionOverviews.Remove(m_Context.TransactionOverviews.Where(to => to.TransactionNumber == _transactionNumber).First());
//for every transaction in the transaction overview remove it and increase the number in stock and decrease the nunber sold for that item.
foreach (Transaction t in m_Context.Transactions.Where(t => t.TransactionNumber == _transactionNumber))
{
m_Context.Transactions.Remove(t);
var item = m_Context.Items.Where(i => i.ItemId == t.ItemId).First();
item.Stock++;
item.Sold--;
}
//Save the database changes
m_Context.SaveChanges();
//Log the transaction has been deleted
Logger.LogAction("Transaction Deleted", "Deleted transaction number " + _transactionNumber);
//return the view
return(PartialView("Partials/HistoricView", vm));
}
public ActionResult Index(OrderRecord orderrecords)
{
if (Session["Orders"] == null)
{
Session["Orders"] = new Order();
}
Order order = (Order)Session["Orders"];
orderrecords = new OrderRecord();
// Het orderrecord vullen met de gegevens
orderrecords.Event_Id = int.Parse(Request.Form["eventid"]);
orderrecords.RecordAmount = int.Parse(Request.Form["amountOfTickets"]);
orderrecords.Event = historicrepository.GetHistoricById(orderrecords.Event_Id);
if (order.OrderRecords == null)
{
order.OrderRecords = new List <OrderRecord>();
}
order.OrderRecords.Add(orderrecords);
if (orderrecords.RecordAmount >= 4)
{
orderrecords.TicketType = TicketType.Family;
}
else
{
orderrecords.TicketType = TicketType.Single;
}
Session["Orders"] = order;
viewmodel = FillViewModel();
return(View(viewmodel));
}
public PartialViewResult HistoricView()
{
//Create the view model
HistoricViewModel vm = new HistoricViewModel();
//Return the view
return(PartialView("Partials/HistoricView", vm));
}
public PartialViewResult SerializeAdd(string prevVm)
{
//create view model from the vm passed from the view
AddViewModel addVM = JsonConvert.DeserializeObject <AddViewModel>(prevVm);
//Create a transaction overview to summerise the transaction been added
TransactionOverview to = new TransactionOverview();
to.CustomerId = addVM.transactionOverview.CustomerId;
to.Date = addVM.transactionOverview.Date;
to.TransactionNumber = addVM.transactionOverview.TransactionNumber;
to.TotalValue = addVM.transactionOverview.TotalValue;
//Add the transaction overview
m_Context.TransactionOverviews.Add(to);
//for every item added create a transaction and update the stock and sold
foreach (Item i in addVM.items)
{
Transaction t = new Transaction();
t.ItemId = i.ItemId;
t.TransactionNumber = addVM.transactionOverview.TransactionNumber;
t.Date = addVM.transactionOverview.Date;
t.CustomerId = addVM.transactionOverview.CustomerId;
m_Context.Transactions.Add(t);
var item = m_Context.Items.Where(it => it.ItemId == t.ItemId).First();
item.Stock--;
item.Sold++;
}
//Save the changes to the database
m_Context.SaveChanges();
//log that a transaction has been added
Logger.LogAction("Transaction Added", "Added transaction number " + to.TransactionNumber);
//create a new vm and return the view
HistoricViewModel vm = new HistoricViewModel();
return(PartialView("Partials/HistoricView", vm));
}
public ActionResult Index()
{
viewmodel = FillViewModel();
return(View(viewmodel));
}
public PartialViewResult SerializeEdit(string prevVM)
{
//create the view model and pass in the previous view model
EditViewModel editVM = JsonConvert.DeserializeObject <EditViewModel>(prevVM);
//create a new transaction over view and populate the variables to store in the data base
TransactionOverview to = new TransactionOverview();
to.CustomerId = editVM._transactionOverview.CustomerId;
to.Date = m_Context.TransactionOverviews.Where(i => i.TransactionNumber == editVM._transactionOverview.TransactionNumber).First().Date;
to.TransactionNumber = editVM._transactionOverview.TransactionNumber;
to.TotalValue = editVM._transactionOverview.TotalValue;
//retrive the current entry for that transaction id from the database
//then update the entry with the values populated from the the view model
var entry = m_Context.TransactionOverviews.Where(t => t.TransactionNumber == editVM._transactionOverview.TransactionNumber).First();
entry.TransactionNumber = to.TransactionNumber;
entry.TotalValue = to.TotalValue;
entry.CustomerId = to.CustomerId;
entry.Date = to.Date;
//if there are removed items then remove them from the transactions in the database and update the stock and sold variables
if (editVM._remItemsIndex.Count > 0)
{
List <Transaction> remList = new List <Transaction>();
var ts = m_Context.Transactions.Where(t => t.TransactionNumber == to.TransactionNumber).ToList();
foreach (int index in editVM._remItemsIndex)
{
if (index < ts.Count)
{
remList.Add(ts[index]);
}
}
foreach (Transaction rem in remList)
{
m_Context.Transactions.Remove(rem);
var item = m_Context.Items.Where(i => i.ItemId == rem.ItemId).First();
item.Stock++;
item.Sold--;
}
}
//for every new item in the updated transaction the data base with the item
foreach (Item i in editVM._newItems)
{
Transaction t = new Transaction();
t.ItemId = i.ItemId;
t.TransactionNumber = editVM._transactionOverview.TransactionNumber;
t.Date = editVM._transactionOverview.Date;
t.CustomerId = editVM._transactionOverview.CustomerId;
m_Context.Transactions.Add(t);
var item = m_Context.Items.Where(it => it.ItemId == t.ItemId).First();
item.Stock--;
item.Sold++;
}
//save the changes
m_Context.SaveChanges();
//Log that a transaction has been edited
Logger.LogAction("Transaction Edited", "Edited transaction number " + to.TransactionNumber);
//Create the historical view model and return a view.
HistoricViewModel vm = new HistoricViewModel();
return(PartialView("Partials/HistoricView", vm));
}
public HistoricPage()
{
InitializeComponent();
BindingContext = new HistoricViewModel();
}
