public PotteryBucket readPotteryBucket(Guid id)
{
var retList = new List <PotteryBucket>();
var retVal = new PotteryBucket();
try {
using (var context = new ArchaeologyContext()) {
retList = context.PotteryBucket
.Include(potteryBucket => potteryBucket.GeospatialData)
.Include(potteryBucket => potteryBucket.Locus)
.ThenInclude(locus => locus.Square)
.ThenInclude(square => square.Supervisor)
.Where(potteryBucket => potteryBucket.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public Models.Object readObject(Guid id)
{
var retList = new List <Models.Object>();
var retVal = new Models.Object();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Object
.Include(obj => obj.GeospatialData)
.Include(obj => obj.Locus)
.ThenInclude(locus => locus.Square)
.ThenInclude(square => square.Supervisor)
.Where(obj => obj.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public bool createSite(Site site)
{
try {
using (var context = new ArchaeologyContext()) {
context.Site.Add(site);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool deletePotteryBucket(PotteryBucket potteryBucket)
{
try {
using (var context = new ArchaeologyContext()) {
context.Remove(potteryBucket);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool updateGeospatialData(GeospatialData geospatialData)
{
try {
using (var context = new ArchaeologyContext()) {
context.GeospatialData.Update(geospatialData);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool updateLocus(Locus locus)
{
try {
using (var context = new ArchaeologyContext()) {
context.Locus.Update(locus);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool updateSquare(Square square)
{
try {
using (var context = new ArchaeologyContext()) {
context.Square.Update(square);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool deleteArea(Area area)
{
try {
using (var context = new ArchaeologyContext()) {
context.Remove(area);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool updateSupervisor(Supervisor supervisor)
{
try {
using (var context = new ArchaeologyContext()) {
context.Supervisor.Update(supervisor);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool deleteObject(Models.Object obj)
{
try {
using (var context = new ArchaeologyContext()) {
context.Remove(obj);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public bool updateTeam(Team team)
{
try {
using (var context = new ArchaeologyContext()) {
context.Team.Update(team);
context.SaveChanges();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(true);
}
public List <GeospatialData> readGeospatialData()
{
var retVal = new List <GeospatialData>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.GeospatialData
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <Team> readTeams()
{
var retVal = new List <Team>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.Team
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <Area> readAreas()
{
var retVal = new List <Area>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.Area
.Include(area => area.Site)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <Supervisor> readSupervisors()
{
var retVal = new List <Supervisor>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.Supervisor
.Include(supervisor => supervisor.Team)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <LstArchitecturalMaterial> readArchitecturalMaterials()
{
var retVal = new List <LstArchitecturalMaterial>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.LstArchitecturalMaterial
.OrderBy(l => l.Description)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <Square> readSquares()
{
var retVal = new List <Square>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.Square
.Include(square => square.Area)
.Include(square => square.Supervisor)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <Locus> readLocuss()
{
var retVal = new List <Locus>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.Locus
.Include(locus => locus.Square)
.Include(locus => locus.SeparationClarity)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <PotteryBucket> readPotteryBuckets()
{
var retVal = new List <PotteryBucket>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.PotteryBucket
.Include(potteryBucket => potteryBucket.GeospatialData)
.Include(potteryBucket => potteryBucket.Locus)
.ThenInclude(locus => locus.Square)
.ThenInclude(square => square.Supervisor)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public List <Models.Object> readObjects()
{
var retVal = new List <Models.Object>();
try {
using (var context = new ArchaeologyContext()) {
retVal = context.Object
.Include(obj => obj.GeospatialData)
.Include(obj => obj.Locus)
.ThenInclude(locus => locus.Square)
.ThenInclude(square => square.Supervisor)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
return(retVal);
}
public Site readSite(Guid id)
{
var retList = new List <Site>();
var retVal = new Site();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Site
.Where(s => s.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public Team readTeam(Guid id)
{
var retList = new List <Team>();
var retVal = new Team();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Team
.Where(team => team.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public LstArchitecturalMaterial readArchitecturalMaterial(int id)
{
var retList = new List <LstArchitecturalMaterial>();
var retVal = new LstArchitecturalMaterial();
try {
using (var context = new ArchaeologyContext()) {
retList = context.LstArchitecturalMaterial
.Where(s => s.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public GeospatialData readGeospatialData(Guid id)
{
var retList = new List <GeospatialData>();
var retVal = new GeospatialData();
try {
using (var context = new ArchaeologyContext()) {
retList = context.GeospatialData
.Where(geospatialData => geospatialData.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public Supervisor readSupervisor(Guid id)
{
var retList = new List <Supervisor>();
var retVal = new Supervisor();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Supervisor
.Include(supervisor => supervisor.Team)
.Where(supervisor => supervisor.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public Area readArea(Guid id)
{
// TODO: Figure out Linq query to bring in Team information.
var retList = new List <Area>();
var retVal = new Area();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Area
.Include(area => area.Site)
.Where(area => area.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public Locus readLocus(Guid id)
{
var retList = new List <Locus>();
var retVal = new Locus();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Locus
.Include(locus => locus.Square)
.Include(locus => locus.SeparationClarity)
.Where(locus => locus.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
public Square readSquare(Guid id)
{
var retList = new List <Square>();
var retVal = new Square();
try {
using (var context = new ArchaeologyContext()) {
retList = context.Square
.Include(square => square.Area)
.Include(square => square.Supervisor)
.Where(square => square.Id == id)
.ToList();
}
}
catch (Exception ex) {
throw new Exception(ex.Message, ex.InnerException);
}
if (retList.Count > 0)
{
retVal = retList[0];
}
return(retVal);
}
