//Get all archived data. public static IList <ArchiveData> GetAll() { using (var database = new ArchiveDataContext()) { var allData = database.Archive.ToList(); return(allData); } }
//Delete a single archived data from the database. public static void DeleteData(ArchiveData data) { using (var database = new ArchiveDataContext()) { database.Archive.Remove(data); database.SaveChanges(); } }
//Add a single archived data. public static void AddData(ArchiveData data) { using (var database = new ArchiveDataContext()) { database.Archive.Add(data); database.SaveChanges(); } }
//Get a many data with a person id. public static IList <ArchiveData> GetManyByPerson(long borrowerId) { using (var database = new ArchiveDataContext()) { var manyData = database.Archive.Where(a => a.BorrowerId == borrowerId).ToList(); return(manyData); } }
//Get a specific data. public static ArchiveData GetSingle(long id) { using (var database = new ArchiveDataContext()) { var data = database.Archive.Where(a => a.Id == id).FirstOrDefault(); return(data); } }
//Get the most recent specific data with ids. public static ArchiveData GetLastByIds(long bookId, long borrowerId) { using (var database = new ArchiveDataContext()) { var manyData = database.Archive.Where(a => a.BookId == bookId).Where(a => a.BorrowerId == borrowerId).ToList(); var data = manyData.OrderByDescending(a => a.BorrowedAt).FirstOrDefault(); return(data); } }