//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);
}
}
