public ObservableCollection <NinjaEquipmentViewModel> GetAll()
{
var ninjaEquipment = new ObservableCollection <NinjaEquipmentViewModel>();
using (var ctx = new DatabaseModelContainer())
{
foreach (var equipment in ctx.NinjaEquipmentSet.ToList())
{
ninjaEquipment.Add(new NinjaEquipmentViewModel {
Id = equipment.Id,
Equipment = new EquipmentViewModel {
Id = equipment.Equipment.Id,
Agi = equipment.Equipment.Agi,
Gold = equipment.Equipment.Gold,
Int = equipment.Equipment.Int,
Name = equipment.Equipment.Name
},
Ninja = new NinjaViewModel {
Id = equipment.Ninja.Id,
Gold = equipment.Ninja.Gold,
Name = equipment.Ninja.Name
}
});
}
}
return(ninjaEquipment);
}
public ObservableCollection <EquipmentViewModel> GetAllFromType(EquipmentTypeViewModel type)
{
var equipment = new ObservableCollection <EquipmentViewModel>();
using (var ctx = new DatabaseModelContainer()) {
var results = ctx.EquipmentSet.ToList();
foreach (var item in results)
{
if (item.EquipmentType.Id != type.Id)
{
continue;
}
equipment.Add(new EquipmentViewModel()
{
Id = item.Id,
Agi = item.Agi,
Str = item.Str,
Int = item.Int,
Gold = item.Gold,
Name = item.Name,
EquipmentTypeViewModel = new EquipmentTypeViewModel {
Id = item.EquipmentType.Id,
Name = item.EquipmentType.Name,
},
});
}
}
return(equipment);
}
public ObservableCollection <EquipmentViewModel> GetAll()
{
var equipment = new ObservableCollection <EquipmentViewModel>();
using (var ctx = new DatabaseModelContainer()) {
foreach (var item in ctx.EquipmentSet.ToList())
{
equipment.Add(new EquipmentViewModel()
{
Id = item.Id,
Agi = item.Agi,
Str = item.Str,
Int = item.Int,
Gold = item.Gold,
Name = item.Name,
EquipmentTypeViewModel = new EquipmentTypeViewModel()
{
Id = item.EquipmentType.Id,
Name = item.EquipmentType.Name
}
});
}
}
return(equipment);
}
public bool Delete(EquipmentTypeViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
ctx.EquipmentTypeSet.Remove(ctx.EquipmentTypeSet.First(o => o.Id == item.Id));
ctx.SaveChanges();
return(true);
}
}
public bool Delete(NinjaViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
ctx.NinjaSet.Remove(ctx.NinjaSet.Find(item.Id) ?? new Ninja());
ctx.SaveChanges();
return(true);
}
}
public TransactionsUpsert(DatabaseModelContainer db, TransactionSet updatingTransaction)
{
this.db = db;
currentEditingTransaction = updatingTransaction;
InitializeComponent();
LoadInitialData();
}
public bool Delete(NinjaEquipmentViewModel item)
{
using (var ctx = new DatabaseModelContainer())
{
ctx.NinjaEquipmentSet.Remove(ctx.NinjaEquipmentSet.First(o => o.Ninja.Id == item.Ninja.Id && o.Equipment.Id == item.Equipment.Id));
ctx.SaveChanges();
return(true);
}
}
public bool Update(NinjaViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
var ninja = ctx.NinjaSet.First(o => o.Id == item.Id);
ninja.Gold = item.Gold;
ninja.Name = item.Name;
ctx.SaveChanges();
return(true);
}
}
public bool Add(EquipmentTypeViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
var type = ctx.EquipmentTypeSet.Add(new EquipmentType()
{
Name = item.Name
});
ctx.SaveChanges();
return(type != null);
}
}
public bool Add(NinjaViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
ctx.NinjaSet.Add(new Ninja()
{
Gold = item.Gold,
Name = item.Name
});
ctx.SaveChanges();
return(true);
}
}
public bool Add(NinjaEquipmentViewModel item)
{
using (var ctx = new DatabaseModelContainer())
{
ctx.NinjaEquipmentSet.Add(new NinjaEquipment {
Ninja = ctx.NinjaSet.FirstOrDefault(o => o.Id == item.Ninja.Id),
Equipment = ctx.EquipmentSet.FirstOrDefault(o => o.Id == item.Equipment.Id)
});
ctx.SaveChanges();
return(true);
}
}
public AddNewContact(TransactionsUpsert transactionUpsert, DatabaseModelContainer db, ContactManagement contactManagement,
Contact editingContact)
{
this.transactionUpsert = transactionUpsert;
this.db = db;
this.contactManagement = contactManagement;
this.editingContact = editingContact;
InitializeComponent();
if (editingContact != null)
{
LoadCurrentData();
}
}
public bool Update(EquipmentViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
var equipment = ctx.EquipmentSet.First(o => o.Id == item.Id);
equipment.Agi = item.Agi;
equipment.Int = item.Int;
equipment.Str = item.Str;
equipment.Gold = item.Gold;
equipment.Name = item.Name;
equipment.EquipmentType = ctx.EquipmentTypeSet.First(o => o.Id == item.EquipmentTypeViewModel.Id);
ctx.SaveChanges();
}
return(true);
}
public AddNewCategory(TransactionsUpsert transactionUpsert, DatabaseModelContainer db, CategoryManagement categoryManagement,
Category editingCategory)
{
this.transactionUpsert = transactionUpsert;
this.db = db;
this.categoryManagement = categoryManagement;
this.editingCategory = editingCategory;
InitializeComponent();
if (editingCategory != null)
{
LoadCurrentCategory();
}
}
public ObservableCollection <EquipmentTypeViewModel> GetAll()
{
var types = new ObservableCollection <EquipmentTypeViewModel>();
using (var ctx = new DatabaseModelContainer()) {
foreach (var item in ctx.EquipmentTypeSet)
{
types.Add(new EquipmentTypeViewModel()
{
Id = item.Id,
Name = item.Name
});
}
}
return(types);
}
public bool Add(EquipmentViewModel item)
{
using (var ctx = new DatabaseModelContainer()) {
ctx.EquipmentSet.Add(new Equipment()
{
Agi = item.Agi,
Str = item.Str,
Int = item.Int,
Name = item.Name,
Gold = item.Gold,
EquipmentType = ctx.EquipmentTypeSet.First(o => o.Id == item.EquipmentTypeViewModel.Id)
});
ctx.SaveChanges();
}
return(true);
}
public ObservableCollection <NinjaViewModel> GetAll()
{
var ninjas = new ObservableCollection <NinjaViewModel>();
using (var ctx = new DatabaseModelContainer()) {
foreach (var ninja in ctx.NinjaSet.ToList())
{
ninjas.Add(new NinjaViewModel()
{
Id = ninja.Id,
Gold = ninja.Gold,
Name = ninja.Name
});
}
}
return(ninjas);
}
public AddNewEvent(DatabaseModelContainer db, EventsAndAppointments eventAndAppointment, EventDto editingEventAndAppointment)
{
this.db = db;
InitializeComponent();
this.eventAndAppointment = eventAndAppointment;
this.editingEventAndAppointment = editingEventAndAppointment;
repeatToggle = new ToggleButton();
repeatToggle.Location = new Point(54, 29);
repeatToggle.Size = new System.Drawing.Size(47, 21);
groupBox1.Controls.Add(repeatToggle);
dtpEvent.CustomFormat = "dd/MM/yyyy hh:mm:ss";
LoadInitialData();
if (editingEventAndAppointment != null)
{
LoadEditingItemData();
}
}
public PredictFinancialState(DatabaseModelContainer db)
{
this.db = db;
InitializeComponent();
DateTime now = DateTime.Now;
var startDate = new DateTime(now.Year, now.Month, 1);
// var endDate = startDate.AddMonths(1).AddSeconds(-1);
var endDate = now;
dtpFrom.MinDate = startDate.AddMonths(-2);
dtpFrom.Value = startDate;
dtpFrom.MaxDate = now;
dtpTo.MinDate = dtpFrom.Value;
dtpTo.MaxDate = now;
dtpTo.Value = endDate;
txtGrowth1.Text = defaultGrowth1.ToString();
txtGrowth2.Text = defaultGrowth2.ToString();
txtGrowth3.Text = defaultGrowth3.ToString();
LoadFinancialStatus(startDate, endDate);
}
public TransactionModel(DatabaseModelContainer db)
{
this.db = db;
}
public ContactModel(DatabaseModelContainer db)
{
this.db = db;
}
public DeleteHandler(DatabaseModelContainer container) : base(container)
{
}
public EventsAndAppointments(DatabaseModelContainer db)
{
this.db = db;
InitializeComponent();
GetEventsAndAppointments();
}
public ContactManagement(DatabaseModelContainer db)
{
this.db = db;
InitializeComponent();
GetContacts();
}
public UpdateHandler(DatabaseModelContainer container) : base(container)
{
}
public DatabaseContextAccessor()
{
dbContext = DatabaseModelContainer.Current;
}
public EventAndAppointmentModel(DatabaseModelContainer db)
{
this.db = db;
}
public RecursiveItemModel(DatabaseModelContainer db)
{
this.db = db;
}
public MockDataModel(DatabaseModelContainer db)
{
this.db = db;
}
public CategoryManagement(DatabaseModelContainer db)
{
this.db = db;
InitializeComponent();
GetCategories();
}
