private void SaveExecute()
{
Lanse lanse = new Lanse();
lanse.Id = Fitness.Logic.Data.FitnessC.GetLanses().ToList().Count();
lanse.Type = SelectedType;
lanse.TypeId = SelectedType.Id;
lanse.User = SelectedUser;
lanse.UserId = SelectedUser.Id;
lanse.StartDate = StartDate;
lanse.EndDate = EndDate;
lanse.RemainingTimes = SelectedType.ActiveTimes;
lanse.Price = SelectedType.Price;
lanse.Active = true;
// Update in DB
Fitness.Logic.Data.FitnessC.InsertLanse(lanse);
}
public AddLanseViewModel()
{
// Get Lanse:
CurrentLanse = new Lanse();
CloseTabItemCommand = new RelayCommand(CloseTabItemExecute);
CancelCommand = new RelayCommand(CancelExecute);
SaveCommand = new RelayCommand(SaveCanExecute);
StartDate = DateTime.Now;
EndDate = DateTime.Now;
Types = new List <LanseType>();
Types.Add(new LanseType {
Name = "SELECT TYPE"
});
List <LanseType> ltTemp = Fitness.Logic.Data.FitnessC.GetLanseTypes().Where(lt => lt.Active == true).ToList();
foreach (LanseType lt in ltTemp)
{
Types.Add(lt);
}
SelectedType = Types.First();
Users = new List <User>();
Users.Add(new User {
FirstName = "SELECT USER"
});
List <User> uTemp = Fitness.Logic.Data.FitnessC.GetUsers().Where(u => u.Active == true).ToList();
foreach (User u in uTemp)
{
Users.Add(u);
}
SelectedUser = Users.First();
}
private void EnterExecute()
{
// Update times left in selected lanse:
Lanse lanse = new Lanse();
lanse.Id = SelectedLanse.Id;
lanse.Type = SelectedLanse.Type;
lanse.TypeId = SelectedLanse.TypeId;
lanse.User = SelectedLanse.User;
lanse.UserId = SelectedLanse.UserId;
lanse.StartDate = SelectedLanse.StartDate;
lanse.EndDate = SelectedLanse.EndDate;
lanse.RemainingTimes = SelectedLanse.RemainingTimes - 1;
lanse.Active = SelectedLanse.Active;
lanse.Price = SelectedLanse.Price;
Fitness.Logic.Data.FitnessC.UpdateLanse(SelectedLanse.Id, lanse);
// Add new Entry to DB:
Entry entry = new Entry();
int entryCount = Fitness.Logic.Data.FitnessC.GetEntryes().ToList().Count();
Lanse lanse2 = Fitness.Logic.Data.FitnessC.GetLanses().Where(l => l.Id == SelectedLanse.Id).FirstOrDefault();
entry.Id = entryCount + 1;
entry.Lanse = lanse2;
entry.LanseId = lanse2.Id;
entry.Date = DateTime.Now;
entry.ReceptionistId = MainWindowViewModel.Instance.LoggedInUser.Id;
Fitness.Logic.Data.FitnessC.InsertEntry(entry);
GenerateEnterButtonAndLocation();
MessageBox.Show("Entered.");
}
public void UpdateLanse(int lanse_id, Lanse lanse)
{
try
{
Lanse result = (from u in fitnessDatabase.Lanse
where u.Id == lanse_id
select u).SingleOrDefault();
result.Id = lanse.Id;
result.Type = lanse.Type;
result.TypeId = lanse.TypeId;
result.User = lanse.User;
result.UserId = lanse.UserId;
result.StartDate = lanse.StartDate;
result.EndDate = lanse.EndDate;
result.RemainingTimes = lanse.RemainingTimes;
result.Active = lanse.Active;
result.Price = lanse.Price;
fitnessDatabase.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public void InsertLanse(Lanse lanse)
{
fitnessDatabase.Lanse.Add(lanse);
fitnessDatabase.SaveChanges();
}
public void ItemClickExecute()
{
LastSelectedLanse = _selectedLanse;
MainWindowViewModel.Instance.SetNewTab(new UserInfoViewModel());
}
