private void DeleteEntry(object sender, RoutedEventArgs e) { if (ORM.SelectedItem is Part) { Part selected = (Part)ORM.SelectedItem; context.Parts.Remove(selected); //Manufacturer man = selected.Manufacturer; //man.Parts.Remove(selected); } else if (ORM.SelectedItem is Manufacturer) { // TODO: Make sure the user wants to delete all entries for this manufacturer Manufacturer selected = (Manufacturer)ORM.SelectedItem; if (selected.Parts.Count > 0) { MessageBoxResult mr = MessageBox.Show("Are you sure you want to delete this manufacturer and ALL of this manufacturer's parts?", "Delete manufacturer", MessageBoxButton.YesNo, MessageBoxImage.Exclamation, MessageBoxResult.No); if (mr == MessageBoxResult.Yes) { context.Manufacturers.Remove(selected); } } else { context.Manufacturers.Remove(selected); } } context.SaveChanges(); }
public int UpdateCardCompany(CardCompany cardCompany) { using (var ctx = new OrganizerContext()) { ctx.Entry(cardCompany).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int AddCurrency(Currency currency) { using (var ctx = new OrganizerContext()) { ctx.Currencies.Add(currency); return(ctx.SaveChanges()); } }
public int AddCard(Card card) { using (var ctx = new OrganizerContext()) { ctx.Cards.Add(card); return(ctx.SaveChanges()); } }
public int UpdateCurrency(Currency currency) { using (var ctx = new OrganizerContext()) { ctx.Entry(currency).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int UpdateMovement(Movement movement) { using (var ctx = new OrganizerContext()) { ctx.Entry(movement).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int AddMovement(Movement movement) { using (var ctx = new OrganizerContext()) { ctx.Movements.Add(movement); return(ctx.SaveChanges()); } }
public int AddAccount(Account account) { using (var ctx = new OrganizerContext()) { ctx.Accounts.Add(account); return(ctx.SaveChanges()); } }
public int UpdateAccount(Account account) { using (var ctx = new OrganizerContext()) { ctx.Entry(account).State = EntityState.Modified; return(ctx.SaveChanges()); } }
public int AddCardCompany(CardCompany cardCompany) { using (var ctx = new OrganizerContext()) { ctx.CardCompanies.Add(cardCompany); return(ctx.SaveChanges()); } }
public static List <User> AddExampleUsersToDatabase(DbContextOptions <OrganizerContext> dbContextOptions, MiniAutoFixture miniAutoFixture) { using (OrganizerContext organizerContext = new OrganizerContext(dbContextOptions)) { List <User> userList = Enumerable.Range(1, 10).Select(a => CreateUser(0, miniAutoFixture)).ToList(); userList.ForEach(user => organizerContext.Add(user)); organizerContext.SaveChanges(); return(userList); } }
private void Button_Click(object sender, RoutedEventArgs e) { Day currentDay = Week.WeekDays[0]; controller.AddTask(currentDay, title.Text, key_words.Text, description.Text); context.SaveChanges(); title.Clear(); key_words.Clear(); description.Clear(); }
public int RemoveMovement(long entryId) { using (var ctx = new OrganizerContext()) { var entry = ctx.Movements.Find(entryId); if (entry == null) { return(0); } ctx.Movements.Remove(entry); return(ctx.SaveChanges()); } }
public int RemoveCardCompany(long cardCompanyId) { using (var ctx = new OrganizerContext()) { var cardCompany = ctx.CardCompanies.Find(cardCompanyId); if (cardCompany == null) { return(0); } ctx.CardCompanies.Remove(cardCompany); return(ctx.SaveChanges()); } }
public UserView InsertUser(UserModify userModify) { User user = new User { Deleted = false }; user.SaveUserModify(userModify); _organizerContext.User.Add(user); _organizerContext.SaveChanges(); return(_organizerContext.User.Where(a => a.Id == user.Id).Select(a => a.MapUserToView()).Single()); }
public int RemoveAccount(long accountId) { using (var ctx = new OrganizerContext()) { var account = ctx.Accounts.Find(accountId); if (account == null) { return(0); } ctx.Accounts.Remove(account); return(ctx.SaveChanges()); } }
public int RemoveCurrency(long currencyId) { using (var ctx = new OrganizerContext()) { var currency = ctx.Currencies.Find(currencyId); if (currency == null) { return(0); } ctx.Currencies.Remove(currency); return(ctx.SaveChanges()); } }
static void Main(string[] args) { Database.SetInitializer(new MigrateDatabaseToLatestVersion <OrganizerContext, Configuration>()); using (var context = new OrganizerContext()) { var user = context.Users.FirstOrDefault(u => u.Username == "bayIvan5"); if (user == null) { user = new User(); user.AuthCode = "0123456789012345678901234567890123456789"; user.DisplayName = "Ivan Ivanov2"; user.Username = "******"; context.Users.Add(user); context.SaveChanges(); } Item rootUserItem = new Item(); rootUserItem.ItemType = ItemType.Type; rootUserItem.Title = "Root"; rootUserItem.User = user; context.Items.Add(rootUserItem); Location loc = new Location(); loc.Latitude = 40; loc.Longitude = 20; loc.ItemId = 4; context.Locations.Add(loc); context.SaveChanges(); } }
//opens the current week , that's going public List <Day> OpenWeek() { Day today = CheckCurrentDay(); Week.WeekDays = new List <Day>(); if (Week.WeekDays.Count > 0) { Week.WeekDays.Clear(); } Week.WeekDays.AddRange(context.Days.Where(x => x.weekID == today.weekID)); Week.WeekDays.OrderBy(x => x.date).ToList(); context.SaveChanges(); return(Week.WeekDays); }
public async Task <IActionResult> PostList(int id, [FromBody] ApplicationUser applicationuser) { var userId = _userManager.GetUserId(User); var list = _context.Lists.Include(q => q.Todos) .Where(q => _context.Permissions.Any(r => r.List.Id == id && r.User.Id == userId)) .FirstOrDefault(p => p.Id == id); var user = await _userManager.FindByEmailAsync(applicationuser.Email); var permission = new Permission(); permission.List = list; permission.User = user; _context.Permissions.Add(permission); _context.SaveChanges(); return(Ok(permission)); }
public static List <Task> AddExampleTasksToDatabase(DbContextOptions <OrganizerContext> dbContextOptions, MiniAutoFixture miniAutoFixture, out List <User> userList) { using (OrganizerContext organizerContext = new OrganizerContext(dbContextOptions)) { userList = new List <User>(); User user1 = DbSetTools.CreateUser(0, miniAutoFixture); organizerContext.Add(user1); userList.Add(user1); User user2 = DbSetTools.CreateUser(0, miniAutoFixture); organizerContext.Add(user2); userList.Add(user2); User user3 = DbSetTools.CreateUser(0, miniAutoFixture); organizerContext.Add(user3); userList.Add(user3); List <Task> taskList = Enumerable .Range(1, 10) .Select(a => CreateTask(0, user1, miniAutoFixture)) .ToList() .Concat( Enumerable.Range(11, 10) .Select(a => CreateTask(0, user2, miniAutoFixture)) .ToList() ) .Concat( Enumerable.Range(21, 10) .Select(a => CreateTask(0, user3, miniAutoFixture)) .ToList() ) .ToList(); taskList.ForEach(task => organizerContext.Add(task)); organizerContext.SaveChanges(); return(taskList); } }
// Opslaan public bool Opslaan() { return(_context.SaveChanges() >= 0); }
private void DiaryDone(Diaryes diary) { db.Entry(diary).State = EntityState.Modified; diary.DoneStatus = 1; db.SaveChanges(); }
// Fabrieksinstellingen terugzetten public void FabrieksInstellingenVerwijderAlles() { _context.Logins.RemoveRange(_context.Logins.ToList()); _context.SaveChanges(); }