public DAL.Location saveInDB() { DAL.Location entity = null; if (this.point.id == 0) { return(null); } // Create, if not existant if (this.id == 0) { entity = MainClass.Instance.db.Location.Add(new DAL.Location() { latLongCoordinateId = this.point.id, name = this.name }); MainClass.Instance.db.SaveChanges(); this.id = entity.id; } else { entity = MainClass.Instance.db.Location.Where(v => v.id == this.id).FirstOrDefault(); if (entity == null) { return(null); } entity.latLongCoordinateId = this.point.id; entity.name = this.name; MainClass.Instance.db.SaveChanges(); } return(entity); }
public bool removeLocation(Location location) { DAL.Location entity = db.Location.Where(v => v.id == location.id).FirstOrDefault(); if (entity == null) { return(false); } // entity.boatToursManagerId = null; db.SaveChanges(); return(this.locations.Remove(location)); }
public void LocationSelectAll(DataGridView locationList) { try { location = new DAL.Location(); PopulateDataLayer(); locationList.DataSource = location.LocationSelectAll().Tables[0]; } catch (Exception ex) { throw ex; } }
public DataTable LocationSelectAll() { try { DataTable dtLocation; location = new DAL.Location(); PopulateDataLayer(); dtLocation = location.LocationSelectAll().Tables[0]; return(dtLocation); } catch (Exception ex) { throw ex; } }
public DataTable LocationSearchByKey() { try { location = new DAL.Location(); DataTable dataResult = new DataTable(); PopulateDataLayer(); dataResult = location.LocationSearchByKey().Tables[0]; return(dataResult); } catch (Exception ex) { throw ex; } }
public DataTable LocationSearchByScheduleCategory() { try { DataTable dtLocation; location = new DAL.Location(); PopulateDataLayer(); dtLocation = location.LocationSearchbyScheduleCategory().Tables[0]; return(dtLocation); } catch (Exception ex) { throw ex; } }
public Location(DAL.Location location) { this.id = location.id; this.point = new LatLongCoordinate(location.LatLongCoordinate); this.name = location.name; foreach (DAL.Boat boat in location.Boat) { this.boats.Add(new Boat(boat)); foreach (DAL.BoatRental rental in boat.BoatRental) { this.boatRentals.Add(new BoatRental(rental)); } } }
public Boolean Save() { try { Boolean status = false; location = new DAL.Location(); PopulateDataLayer(); location.Save(); MessageBox.Show("Location Record Save!", "Record Save"); status = true; return(status); } catch (Exception ex) { throw ex; } }
public Boolean LocationDelete() { try { Boolean status = false; location = new DAL.Location(); PopulateDataLayer(); location.LocationDelete(); MessageBox.Show("Record Successfully Deleted!", "Delete Record"); status = true; return(status); } catch (Exception ex) { throw ex; } }
public bool addLocation(Location location) { if (this.locations.Contains(location)) { return(false); } DAL.Location entity = db.Location.Where(v => v.id == location.id).FirstOrDefault(); if (entity == null && (entity = location.saveInDB()) == null) { return(false); } //entity.boatToursManagerId = this.id; db.SaveChanges(); this.locations.Add(location); return(true); }
private static BusinessEntities.Search.Location ConvertLocation(DAL.Location location) { return(location.toLocation()); }
public static BusinessEntities.Search.Location toLocation(this DAL.Location location) { return(Mapper.Map <DAL.Location, BusinessEntities.Search.Location>(location)); }