//Update public static void UpdateUser(Users user) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } }
public static void DeleteItem(int id) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { Items item = GetItemById(id); db.Entry(item).State = EntityState.Modified; db.Items.Remove(item); db.SaveChanges(); } }
//Delete public static void DeleteById(ItemsSubject it) { if (it != null) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { db.Entry(it).State = EntityState.Deleted; //db.ItemsSubject.Remove(it); db.SaveChanges(); } } }
//Delete public static void DeletePreSerch(PreSearches preSearch) { if (preSearch != null) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { db.Entry(preSearch).State = EntityState.Modified; db.PreSearches.Remove(preSearch); db.SaveChanges(); } catch (Exception ex) { } } } }
//Update public static void UpdatePreSerches(PreSearches preSearches) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { PreSearches isExist = db.PreSearches.FirstOrDefault(x => x.Id == preSearches.Id); if (isExist != null) { db.Entry(preSearches).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { } } }
//DeleteBook public static void DeleteBook(List <BookPages> book) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { foreach (var page in book) { try { db.Entry(page).State = EntityState.Modified; db.BookPages.Remove(page); } catch (Exception ex) { Console.WriteLine(ex); } } db.SaveChanges(); } }
//Delete public static void DeleteSubject(Subjects subject) { if (subject?.SubjectId != null && subject?.SubjectId != 0) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { db.Entry(subject).State = EntityState.Deleted; db.Subjects.Remove(subject); db.SaveChanges(); } catch (Exception ex) { } } } }
//Delete public static void DeleteLastLocation(LastLocation l) { if (l.Id != 0) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { //LastLocation isExist = db.LastLocation.FirstOrDefault(x => x == l); //db.LastLocation.Remove(isExist); db.Entry(l).State = EntityState.Deleted; db.LastLocation.Remove(l); db.SaveChanges(); } catch (Exception ex) { } } } }
//Update public static void Update(WordLocation wordLocation) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { WordLocation oldWordLocation = db.WordLocation.Where(w => (w.SearchId == wordLocation.SearchId || w.SubjectId == wordLocation.SubjectId) && w.BookSenteceID == wordLocation.BookSenteceID).FirstOrDefault(); if (oldWordLocation != null) { db.Entry(wordLocation).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } } }
//Update public static void UpdateKind(Kinds kind) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { Kinds oldKind = db.Kinds.Where(k => k.Kind == kind.Kind).FirstOrDefault(); if (oldKind != null) { db.Entry(kind).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } } }
//Delete public static void DeleteItem(Items item) { if (item?.ItemId != null && item?.ItemId > 0) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { db.Entry(item).State = EntityState.Deleted; db.Items.Remove(item); db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex); } } } }
//Update public static void UpdateSubject(Subjects subject) { try { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { //Subjects s = db.Subjects.FirstOrDefault(s1 => s1.SubjectId == subject.SubjectId); //s.Subject = subject.Subject; //s.SearchedCounter = subject.SearchedCounter; //s.Parent = subject.Parent; db.Entry(subject).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); } }