//GetById
public static Items GetItemById(int item)
{
using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1())
{
try
{
return(db.Items.Where(i => i.ItemId == item).FirstOrDefault());
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(new Items());
}
}
}
//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) { }
}
}
}
//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) { }
}
}
}
//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);
}
}
}
//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);
}
}
}
//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);
}
}
//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)
{
}
}
//GetByParentId
public static List <Subjects> GeSubjectByParentId(int parentId)
{
try
{
using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1())
{
try
{
return(db.Subjects.Where(sbjct => sbjct.Parent == parentId).ToList());
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw;
}
}
//Add List
public static void AddList(List <WordLocation> wordLocations)
{
using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1())
{
List <WordLocation> newWordLocations = new List <WordLocation>();
foreach (var wordLocation in wordLocations)
{
WordLocation isExist = db.WordLocation.FirstOrDefault(w => (w.SearchId == wordLocation.SearchId || w.SubjectId == wordLocation.SubjectId) && w.BookSenteceID == wordLocation.BookSenteceID);
if (isExist == null)
{
newWordLocations.Add(wordLocation);
}
}
try
{
db.WordLocation.AddRange(newWordLocations);
db.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
}
