public List <FishTO> GetAllFish() { using (var db = new Fish360Project.f360Entities()) { var query = (from fish in db.Fish select fish); List <FishTO> fishes = new List <FishTO>(); foreach (var fsh in query) { FishTO fish = new FishTO(); fish.id = fsh.id; fish.name = fsh.name; fish.species = fsh.species; fish.tripId = (int)fsh.tripId; fish.weight = (double)fsh.weight; fish.length = (double)fsh.length; if (fsh.caughtDate != null) { fish.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd HH:mm:ss tt"); } fish.girth = fsh.girth; fish.spot = fsh.spot; fish.presentation = fsh.presentation; fish.depth = fsh.depth; fish.clarity = fsh.clarity; fish.temperature = fsh.temperature; fishes.Add(fish); } return(fishes); } }
public List<FishTO> GetAllFish() { using (var db = new Fish360Project.f360Entities()) { var query = (from fish in db.Fish select fish); List<FishTO> fishes = new List<FishTO>(); foreach (var fsh in query) { FishTO fish = new FishTO(); fish.id = fsh.id; fish.name = fsh.name; fish.species = fsh.species; fish.tripId = (int)fsh.tripId; fish.weight = (double)fsh.weight; fish.length = (double)fsh.length; if (fsh.caughtDate != null) fish.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd HH:mm:ss tt"); fishes.Add(fish); } return fishes; } }
public void Put([FromBody] FishTO fishTO) { using (var db = new Fish360Project.f360Entities()) { var fishDB = (from fish in db.Fish where fish.id == fishTO.id select fish).FirstOrDefault(); fishDB.name = fishTO.name; fishDB.weight = fishTO.weight; fishDB.notes = fishTO.notes; fishDB.length = fishTO.length; fishDB.tripId = fishTO.tripId; fishDB.species = fishTO.species; fishDB.girth = fishTO.girth; fishDB.spot = fishTO.spot; fishDB.presentation = fishTO.presentation; fishDB.depth = fishTO.depth; fishDB.clarity = fishTO.clarity; fishDB.temperature = fishTO.temperature; fishDB.caughtDate = parseDateTimeExactFromString(fishTO.caughtDate); db.SaveChanges(); } }
public List<FishTO> GetAllFishForTripId(int tripId, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from fish in db.Fish join trip in db.Trips on fish.tripId.Value equals trip.id join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == tripId select fish); List<FishTO> fishes = new List<FishTO>(); foreach (var f in query) { FishTO fish = new FishTO(); fish.id = f.id; fish.tripId = (int)f.tripId; fish.name = f.name; fish.notes = f.notes; fish.weight = (double)f.weight; fish.length = (double)f.length; fish.species = f.species; if (f.caughtDate != null) { fish.caughtDate = ((DateTime)f.caughtDate).ToString("yyyy-MM-dd"); fish.caughtTime = ((DateTime)f.caughtDate).TimeOfDay.ToString("HH:mm:ss tt"); } fishes.Add(fish); } return fishes; } }
public string UpdateFish(FishTO fishTO, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var fishDB = (from fish in db.Fish where fish.id == fishTO.id select fish).FirstOrDefault(); if (fishDB == null) { return(null); } db.Fish.Attach(fishDB); fishDB.name = fishTO.name; fishDB.species = fishTO.species; fishDB.length = fishTO.length; fishDB.weight = fishTO.weight; fishDB.notes = fishTO.notes; string date = fishTO.caughtDate + " " + fishTO.caughtTime; fishDB.caughtDate = DateTime.ParseExact(fishTO.caughtDate, "yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture); db.SaveChanges(); } return(null); }
public FishTO GetFishForId(int fishId, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var fishDB = (from fishLQ in db.Fish where fishLQ.id == fishId select fishLQ).FirstOrDefault(); if (fishDB == null) { return(null); } FishTO fishTO = new FishTO(); fishTO.id = fishDB.id; fishTO.tripId = (int)fishDB.tripId; fishTO.name = fishDB.name; fishTO.weight = (double)fishDB.weight; fishTO.length = (double)fishDB.length; fishTO.species = fishDB.species; // fishTO.notes = System.Text.Encoding.UTF8.GetString(fishDB.notes); fishTO.notes = fishDB.notes; if (fishDB.caughtDate != null) { fishTO.caughtDate = ((DateTime)fishDB.caughtDate).ToString("yyyy-MM-dd"); fishTO.caughtTime = ((DateTime)fishDB.caughtDate).TimeOfDay.ToString("HH:mm:ss tt"); } return(fishTO); } }
public List <FishTO> GetAllFishForTripId(int tripId, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from fish in db.Fish join trip in db.Trips on fish.tripId.Value equals trip.id join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == tripId select fish); List <FishTO> fishes = new List <FishTO>(); foreach (var f in query) { FishTO fish = new FishTO(); fish.id = f.id; fish.tripId = (int)f.tripId; fish.name = f.name; fish.notes = f.notes; fish.weight = (double)f.weight; fish.length = (double)f.length; fish.species = f.species; if (f.caughtDate != null) { fish.caughtDate = ((DateTime)f.caughtDate).ToString("yyyy-MM-dd"); fish.caughtTime = ((DateTime)f.caughtDate).TimeOfDay.ToString("HH:mm:ss tt"); } fishes.Add(fish); } return(fishes); } }
public List<FishTO> GetAllFishForUserId(int id) { using (var db = new Fish360Project.f360Entities()) { var query = (from fish in db.Fish join trip in db.Trips on fish.tripId equals trip.id where trip.id == id select fish); List<FishTO> fishes = new List<FishTO>(); foreach (var fsh in query) { FishTO fish = new FishTO(); fish.id = fsh.id; fish.name = fsh.name; fish.species = fsh.species; fish.tripId = (int)fsh.tripId; fish.weight = (double)fsh.weight; fish.length = (double)fsh.length; if (fsh.caughtDate != null) fish.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd"); fishes.Add(fish); } return fishes; } }
public string CreateFish(FishTO fishTO, string token) { using (var db = new Fish360Project.f360Entities()) { Fish fishDB = new Fish(); fishDB.name = fishTO.name; fishDB.species = fishTO.species; fishDB.length = fishTO.length; fishDB.weight = fishTO.weight; fishDB.caughtDate = DateTime.ParseExact(fishTO.caughtDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); fishDB.tripId = fishTO.tripId; db.Fish.Add(fishDB); db.SaveChanges(); } return null; }
public string CreateFish(FishTO fishTO, string token) { using (var db = new Fish360Project.f360Entities()) { Fish fishDB = new Fish(); fishDB.name = fishTO.name; fishDB.species = fishTO.species; fishDB.length = fishTO.length; fishDB.weight = fishTO.weight; fishDB.notes = fishTO.notes; string date = fishTO.caughtDate + " " + fishTO.caughtTime; fishDB.caughtDate = DateTime.ParseExact(fishTO.caughtDate, "yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture); fishDB.tripId = fishTO.tripId; db.Fish.Add(fishDB); db.SaveChanges(); } return(null); }
public List <FishTO> PostSearch(FishTO search) { List <FishTO> ftos = new List <FishTO>(); if (search.name != null && search.name != "") { using (var db = new Fish360Project.f360Entities()) { var fishes = (from fish in db.Fish where fish.name.Contains(search.name) select fish); foreach (Fish fsh in fishes) { FishTO fishTO = new FishTO(); fishTO.id = fsh.id; fishTO.name = fsh.name; fishTO.species = fsh.species; fishTO.tripId = (int)fsh.tripId; fishTO.weight = (double)fsh.weight; fishTO.length = (double)fsh.length; if (fsh.caughtDate != null) { fishTO.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd HH:mm:ss tt"); } fishTO.girth = fsh.girth; fishTO.spot = fsh.spot; fishTO.presentation = fsh.presentation; fishTO.depth = fsh.depth; fishTO.clarity = fsh.clarity; fishTO.temperature = fsh.temperature; ftos.Add(fishTO); } } } return(ftos); }
public FishTO GetFishForId(int id) { using (var db = new Fish360Project.f360Entities()) { var fsh = (from fish in db.Fish where fish.id == id select fish).FirstOrDefault(); if (fsh == null) { return(null); } FishTO fishTO = new FishTO(); fishTO.id = fsh.id; fishTO.name = fsh.name; fishTO.species = fsh.species; fishTO.notes = fsh.notes; fishTO.tripId = (int)fsh.tripId; fishTO.weight = (double)fsh.weight; fishTO.length = (double)fsh.length; fishTO.girth = fsh.girth; fishTO.spot = fsh.spot; fishTO.presentation = fsh.presentation; fishTO.depth = fsh.depth; fishTO.clarity = fsh.clarity; fishTO.temperature = fsh.temperature; if (fsh.caughtDate != null) { fishTO.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd HH:mm:ss tt"); } return(fishTO); } }
public List<FishTO> PostSearch(FishTO search) { List<FishTO> ftos = new List<FishTO>(); if(search.name != null && search.name != "") { using (var db = new Fish360Project.f360Entities()) { var fishes = (from fish in db.Fish where fish.name.Contains(search.name) select fish); foreach (Fish fsh in fishes) { FishTO fishTO = new FishTO(); fishTO.id = fsh.id; fishTO.name = fsh.name; fishTO.species = fsh.species; fishTO.tripId = (int)fsh.tripId; fishTO.weight = (double)fsh.weight; fishTO.length = (double)fsh.length; if (fsh.caughtDate != null) fishTO.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd HH:mm:ss tt"); fishTO.girth = fsh.girth; fishTO.spot = fsh.spot; fishTO.presentation = fsh.presentation; fishTO.depth = fsh.depth; fishTO.clarity = fsh.clarity; fishTO.temperature = fsh.temperature; ftos.Add(fishTO); } } } return ftos; }
public void Post([FromBody] FishTO fishTO) { using (var db = new Fish360Project.f360Entities()) { Fish newFish = new Fish(); newFish.name = fishTO.name; newFish.species = fishTO.species; newFish.length = fishTO.length; newFish.weight = fishTO.weight; newFish.notes = fishTO.notes; newFish.caughtDate = DateTime.Parse(fishTO.caughtDate);//, "yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture); newFish.tripId = (int)fishTO.tripId; newFish.girth = fishTO.girth; newFish.spot = fishTO.spot; newFish.presentation = fishTO.presentation; newFish.depth = fishTO.depth; newFish.clarity = fishTO.clarity; newFish.temperature = fishTO.temperature; db.Fish.Add(newFish); db.SaveChanges(); } }
public string UpdateFish(FishTO fishTO, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var fishDB = (from fish in db.Fish where fish.id == fishTO.id select fish).FirstOrDefault(); if (fishDB == null) return null; db.Fish.Attach(fishDB); fishDB.name = fishTO.name; fishDB.species = fishTO.species; fishDB.length = fishTO.length; fishDB.weight = fishTO.weight; fishDB.notes = fishTO.notes; string date = fishTO.caughtDate + " " + fishTO.caughtTime; fishDB.caughtDate = DateTime.ParseExact(fishTO.caughtDate, "yyyy-MM-dd HH:mm:ss tt", CultureInfo.InvariantCulture); db.SaveChanges(); } return null; }
public FishTO GetFishForId(int fishId, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var fishDB = (from fishLQ in db.Fish where fishLQ.id == fishId select fishLQ).FirstOrDefault(); if (fishDB == null) return null; FishTO fishTO = new FishTO(); fishTO.id = fishDB.id; fishTO.tripId = (int)fishDB.tripId; fishTO.name = fishDB.name; fishTO.weight = (double)fishDB.weight; fishTO.length = (double)fishDB.length; fishTO.species = fishDB.species; // fishTO.notes = System.Text.Encoding.UTF8.GetString(fishDB.notes); fishTO.notes = fishDB.notes; if (fishDB.caughtDate != null) { fishTO.caughtDate = ((DateTime)fishDB.caughtDate).ToString("yyyy-MM-dd"); fishTO.caughtTime = ((DateTime)fishDB.caughtDate).TimeOfDay.ToString("HH:mm:ss tt"); } return fishTO; } }
public FishTO GetFishForId(int id) { using (var db = new Fish360Project.f360Entities()) { var fsh = (from fish in db.Fish where fish.id == id select fish).FirstOrDefault(); if (fsh == null) return null; FishTO fishTO = new FishTO(); fishTO.id = fsh.id; fishTO.name = fsh.name; fishTO.species = fsh.species; fishTO.tripId = (int)fsh.tripId; fishTO.weight = (double)fsh.weight; fishTO.length = (double)fsh.length; if (fsh.caughtDate != null) fishTO.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd"); return fishTO; } }
public FishTO GetFishForId(int id) { using (var db = new Fish360Project.f360Entities()) { var fsh = (from fish in db.Fish where fish.id == id select fish).FirstOrDefault(); if (fsh == null) return null; FishTO fishTO = new FishTO(); fishTO.id = fsh.id; fishTO.name = fsh.name; fishTO.species = fsh.species; fishTO.notes = fsh.notes; fishTO.tripId = (int)fsh.tripId; fishTO.weight = (double)fsh.weight; fishTO.length = (double)fsh.length; fishTO.girth = fsh.girth; fishTO.spot = fsh.spot; fishTO.presentation = fsh.presentation; fishTO.depth = fsh.depth; fishTO.clarity = fsh.clarity; fishTO.temperature = fsh.temperature; if (fsh.caughtDate != null) fishTO.caughtDate = ((DateTime)fsh.caughtDate).ToString("yyyy-MM-dd HH:mm:ss tt"); return fishTO; } }