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