public ADMINISTARTOR Read(string username)
{
using (var db = new LibDB())
{
return(db.ADMINISTARTOR.FirstOrDefault(a => a.username.Equals(username)));
}
}
public void CreateNew(AUTHOR author)
{
using (var db = new LibDB())
{
db.AUTHOR.Add(author);
db.SaveChanges();
}
}
public AUTHOR Read(int Aid)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
return(db.AUTHOR.Include(x => x.BOOK).FirstOrDefault(x => x.Aid.Equals(Aid)));
}
}
public List <ADMINISTARTOR> List()
{
using (var db = new LibDB())
{
// May need to use an include
return(db.ADMINISTARTOR.ToList());
}
}
public void CreateNew(ADMINISTARTOR newAdmin)
{
using (var db = new LibDB())
{
db.ADMINISTARTOR.Add(newAdmin);
db.SaveChanges();
}
}
public List <BOOK> ReadAllByIsbn(string isbn)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
var query = db.BOOK.Include(x => x.AUTHOR).Where(b => b.ISBN.Contains(isbn)).OrderBy(b => b.PublicationYear).ToList();
return(query);
}
}
public List <AUTHOR> ReadAll(string name)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
var query = db.AUTHOR.Where(a => a.LastName.Contains(name) || a.FirstName.Contains(name)).OrderBy(a => a.LastName).ToList();
return(query);
}
}
public AUTHOR ReadUninclude(int Aid)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
try { return(db.AUTHOR.FirstOrDefault(x => x.Aid.Equals(Aid))); }
catch { return(null); }
}
}
public List <BOOK> ReadAllByClassi(string classi)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
var query = db.BOOK.Include(x => x.AUTHOR).Where(b => b.CLASSIFICATION.ToString().Contains(classi)).OrderBy(b => b.PublicationYear).ToList();
return(query);
}
}
public List <BOOK> List()
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
var query = db.BOOK.Include(x => x.AUTHOR).ToList();
return(query);
}
}
public void Delete(int Aid)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
db.Database.ExecuteSqlCommand("DELETE FROM dbo.AUTHOR WHERE Aid=@aid", new SqlParameter("@aid", Aid));
db.SaveChanges();
}
}
public List <AUTHOR> List()
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
var query = db.AUTHOR.ToList();
return(query);
}
}
public void Delete(string isbn)
{
using (var db = new LibDB())
{
var book = db.BOOK.SingleOrDefault(b => b.ISBN == isbn);
book.AUTHOR.Clear();
db.BOOK.Remove(book);
db.SaveChanges();
}
}
public void CreateNew(BOOK book)
{
using (var db = new LibDB())
{
db.BOOK.Add(book);
db.ChangeTracker.Entries <AUTHOR>().ToList().ForEach(a => a.State = EntityState.Unchanged);
db.ChangeTracker.Entries <CLASSIFICATION>().ToList().ForEach(a => a.State = EntityState.Unchanged);
db.SaveChanges();
}
}
private void ShowReader_Load(object sender, EventArgs e)
{
LibDB db = new LibDB();
dtgReaders.DataSource = db.Readers.Select(rs => new
{
rs.FirstName,
rs.LastName,
rs.Phono,
rs.Faculty.FacultyName
}).ToList();
}
/*
* TODO:
* Filtering through Combobox
*/
public AnnoWindow(AnnoDB db, MeteoDB mdb)
{
InitializeComponent();
annoDB = db;
meteoDB = mdb;
annoDB.makeList();
libDB = (LibDB)DataFactory.getDataContext(DataFactory.DataType.LibObject);
libDB.makeList(mdb.MeteoTable.ToList());
annoLib = libDB.library;
annoCollection = annoDB.AnnoCol;
AnnoDataGrid.DataContext = annoDB;
AnnoDataGrid.ItemsSource = annoCollection;
AnnoDataGrid.Items.Refresh();
}
public BOOK Read(string isbn)
{
using (var db = new LibDB())
{
db.Configuration.LazyLoadingEnabled = false;
try
{
var query = db.BOOK.Include(b => b.AUTHOR).First(b => b.ISBN.Equals(isbn));
return(query);
}
catch
{
return(null);
}
}
}
public void Edit(AUTHOR newAuthor)
{
using (var db = new LibDB())
{
//Remove author all together from database
db.Configuration.LazyLoadingEnabled = false;
var editedAuthor = db.AUTHOR.FirstOrDefault(x => x.Aid.Equals(newAuthor.Aid));
db.AUTHOR.Remove(editedAuthor);
//this.Delete(oldAuthor.Aid);
editedAuthor.FirstName = newAuthor.FirstName;
editedAuthor.LastName = newAuthor.LastName;
editedAuthor.BirthYear = newAuthor.BirthYear;
db.Entry(editedAuthor).State = EntityState.Modified;
db.SaveChanges();
}
}
internal static object getDataContext(DataType dtype)
{
string connectionString;
switch (dtype)
{
case DataType.Annotation:
connectionString = createConnectionString(ANNOMDFFILENAME);
AnnoDB db = new AnnoDB(connectionString);
{
if (!db.DatabaseExists())
{
createMDF(dtype);
}
return(db);
}
break;
case DataType.Meteorite:
connectionString = createConnectionString(METEOMDFFILENAME);
MeteoDB mdb = new MeteoDB(connectionString);
{
if (!mdb.DatabaseExists())
{
createMDF(dtype);
}
return(mdb);
}
break;
case DataType.LibObject:
connectionString = createConnectionString(LIBRARYFILENAME);
LibDB lib = new LibDB(connectionString);
{
if (!lib.DatabaseExists())
{
createMDF(dtype);
}
return(lib);
}
break;
}
return(null);
}
private static void createMDF(DataType dtype)
{
string connectionString;
switch (dtype)
{
case DataType.Annotation:
connectionString = createConnectionString(ANNOMDFFILENAME);
using (AnnoDB db = new AnnoDB(connectionString))
{
if (db.DatabaseExists())
{
db.DeleteDatabase();
}
db.CreateDatabase();
}
break;
case DataType.Meteorite:
connectionString = createConnectionString(METEOMDFFILENAME);
using (MeteoDB db = new MeteoDB(connectionString))
{
if (db.DatabaseExists())
{
db.DeleteDatabase();
}
db.CreateDatabase();
//db.MeteoTable.InsertOnSubmit(new Meteorite());
}
break;
case DataType.LibObject:
connectionString = createConnectionString(LIBRARYFILENAME);
using (LibDB db = new LibDB(connectionString))
{
if (db.DatabaseExists())
{
db.DeleteDatabase();
}
db.CreateDatabase();
}
break;
}
}
public void Edit(BOOK book, string oldISBN)
{
using (var db = new LibDB())
{
var oldBook = db.BOOK.SingleOrDefault(b => b.ISBN == oldISBN);
if (oldBook != null)
{
//oldBook.ISBN = book.ISBN;
//oldBook.pages = book.pages;
//oldBook.publicationinfo = book.publicationinfo;
//oldBook.Title = book.Title;
//oldBook.AUTHOR = book.AUTHOR;
//db.ChangeTracker.Entries<AUTHOR>().ToList().ForEach(a => a.State = EntityState.Unchanged);
//db.ChangeTracker.Entries<CLASSIFICATION>().ToList().ForEach(a => a.State = EntityState.Unchanged);
//db.BOOK.SqlQuery("UPDATE BOOK SET pages = @pages, publicationinfo",)
Delete(oldISBN);
db.SaveChanges();
CreateNew(book);
db.SaveChanges();
}
}
}
