//Delete public static void Delete(WordLocation wordLocation) { if (wordLocation.ID != 0) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { WordLocation isExist = db.WordLocation.Single(x => x.ID == wordLocation.ID); if (isExist != null) { try { db.WordLocation.Remove(isExist); db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex); } } } catch (Exception ex) { Console.WriteLine(ex); } } } }
//Update public static void UpdateBook(List <BookPages> book) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { List <BookPages> isExistBook = GetBookByItemId(book.First().ItemId); if (isExistBook != null) { foreach (var page in isExistBook) { try { db.BookPages.AddOrUpdate(page); } catch (Exception ex) { Console.WriteLine(ex); throw; } } db.SaveChanges(); } } catch (Exception ex) { } } }
//Update public static void UpdateLastLocation(LastLocation l) { try { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { LastLocation isExist = db.LastLocation.FirstOrDefault(x => x.UserId == l.UserId); if (isExist != null) { db.LastLocation.AddOrUpdate(l); //db.Entry(l).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } } } catch (Exception ex) { Console.WriteLine(ex); } }
//Delete public static void DeleteKind(Kinds kind) { if (kind?.IdKind != null && kind?.IdKind > 0) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { Kinds isExist = db.Kinds.Single(x => x.IdKind == kind.IdKind); if (isExist != null) { try { db.Kinds.Remove(isExist); db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex); } } } catch (Exception ex) { Console.WriteLine(ex); } } } }
//Delete list public static void DeleteList(List <WordLocation> wordLocations) { if (wordLocations.Count > 0) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { List <WordLocation> oldWordLocations = new List <WordLocation>(); foreach (var wordLocation in wordLocations) { var isExist = db.WordLocation.FirstOrDefault(w => (w.SearchId == wordLocation.SearchId || w.SubjectId == wordLocation.SubjectId) && w.BookSenteceID == wordLocation.BookSenteceID); if (isExist != null) { oldWordLocations.Add(wordLocation); } } try { db.WordLocation.RemoveRange(oldWordLocations); db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex); } } } }
//Add public static void AddSubject(Subjects subject) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { db.Subjects.Add(subject); db.SaveChanges(); } }
//Delete public static void DeleteUser(Users user) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { db.Users.Remove(user); db.SaveChanges(); } }
//Add public static void AddUser(Users user) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { db.Users.Add(user); db.SaveChanges(); } }
//Update public static void UpdateUser(Users user) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } }
public static void UpdateItemsSubject(ItemsSubject itemsSubject) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { // db.Entry(itemsSubject).State = itemsSubject.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(); } }
//Add public static PreSearches AddPreSerch(PreSearches preSearch) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { PreSearches isExist = db.PreSearches.FirstOrDefault(x => x.Id == preSearch.Id); if (isExist == null) { isExist = db.PreSearches.Add(preSearch); db.SaveChanges(); } return(isExist); } }
//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) { } } } }
//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) { } } } }
//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(); } }
//Update public static void UpdateItem(Items item) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { Items isExist = db.Items.FirstOrDefault(x => x.ItemId == item.ItemId); if (isExist != null) { //db.Entry(item).State = EntityState.Modified; db.Items.AddOrUpdate(item); 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) { } } } }
//Add public static void AddKind(Kinds kind) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { Kinds oldKind = db.Kinds.Where(k => k.Kind == kind.Kind).FirstOrDefault(); if (oldKind == null) { db.Kinds.Add(kind); 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); } } }
//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); } }
//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 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); } } }
//Add public static void AddLastLocation(LastLocation l) { try { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { LastLocation isExist = db.LastLocation.FirstOrDefault(x => x.UserId == l.UserId); if (isExist == null) { db.LastLocation.Add(l); db.SaveChanges(); } else { UpdateLastLocation(l); } } } catch (Exception ex) { } }
//Add public static void AddBook(List <BookPages> book) { List <BookPages> isExistBook = GetBookByItemId(book.First().ItemId); if (isExistBook == null) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { foreach (BookPages page in book) { try { db.BookPages.Add(page); } catch (Exception ex) { throw; } } db.SaveChanges(); } } }
//Add public static void AddItem(Items item) { try { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { if (item.CreationDate == default(DateTime)) { item.CreationDate = DateTime.Now; } db.Items.Add(item); db.SaveChanges(); }catch (Exception ex) { } } } catch (Exception ex) { } }