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 <TripTO> GetAllTripsForUsername(string username) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips join user in db.Users on trip.userId equals user.id where user.username == username select trip); List <TripTO> trips = new List <TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; trip.notes = t.notes; if (t.startDate != null) { trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd HH:mm:ss tt"); } if (t.endDate != null) { trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd HH:mm:ss tt"); } trips.Add(trip); } return(trips); } }
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 <TripTO> GetAllTrips(UserTO userTO) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(userTO.token); var query = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid select trip); List <TripTO> trips = new List <TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; trip.notes = t.notes; if (t.startDate != null) { trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd"); } if (t.endDate != null) { trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd"); } trips.Add(trip); } return(trips); } }
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 TripTO GetTripForId(int id, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == id select trip).FirstOrDefault(); if (query == null) { return(null); } TripTO tripTO = new TripTO(); tripTO.id = query.id; tripTO.name = query.name; tripTO.notes = query.notes; tripTO.startDate = ((DateTime)query.startDate).ToString("yyyy-MM-dd"); tripTO.endDate = ((DateTime)query.endDate).ToString("yyyy-MM-dd"); return(tripTO); } }
public string UpdateTrip(TripTO tripTO, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var tripDB = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == tripTO.id select trip).FirstOrDefault(); if (tripDB == null) { return(null); } tripDB.name = tripTO.name; tripDB.notes = tripTO.notes; tripDB.startDate = parseDateTimeExactFromString(tripTO.startDate); tripDB.endDate = parseDateTimeExactFromString(tripTO.endDate); db.SaveChanges(); } return(tripTO.name); }
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 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<TripTO> GetAllTripsForUserId(int id) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips join user in db.Users on trip.userId equals user.id where user.id == id select trip); List<TripTO> trips = new List<TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; if (t.startDate != null) trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd"); if (t.endDate != null) trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd"); trips.Add(trip); } return trips; } }
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> 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 ValidateUser(UserTO user) { using (var db = new Fish360Project.f360Entities()) { var users = (from t in db.Users where t.username == user.username && t.password == user.password select t).FirstOrDefault(); if (users == null) { return("unknown user"); } if (users.token != null) { user.token = users.token.ToString(); } else { user.token = null; } user.id = users.id; } return("user validated"); }
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 string CreateUser(UserTO user) { using (var db = new Fish360Project.f360Entities()) { Users newUser = new Users(); newUser.username = user.username; newUser.password = user.password; db.Users.Add(newUser); db.SaveChanges(); } return("success"); }
public string CreateUser(UserTO user) { using (var db = new Fish360Project.f360Entities()) { Users newUser = new Users(); newUser.username = user.username; newUser.password = user.password; db.Users.Add(newUser); db.SaveChanges(); } return "success"; }
public void Register([FromBody]UserTO userTO) { using (var db = new Fish360Project.f360Entities()) { Users newUser = new Users(); newUser.username = userTO.username; newUser.password = userTO.password; newUser.token = Guid.NewGuid(); db.Users.Add(newUser); db.SaveChanges(); } }
public void Register([FromBody] UserTO userTO) { using (var db = new Fish360Project.f360Entities()) { Users newUser = new Users(); newUser.username = userTO.username; newUser.password = userTO.password; newUser.token = Guid.NewGuid(); db.Users.Add(newUser); db.SaveChanges(); } }
public void Post([FromBody] TripTO tripTO) { using (var db = new Fish360Project.f360Entities()) { Trips newTrip = new Trips(); newTrip.name = tripTO.name; newTrip.notes = tripTO.notes; newTrip.startDate = DateTime.Parse(tripTO.startDate); //, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.endDate = DateTime.Parse(tripTO.endDate); //, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.userId = tripTO.userId; db.Trips.Add(newTrip); db.SaveChanges(); } }
public void Put([FromBody] TripTO tripTO) { using (var db = new Fish360Project.f360Entities()) { var tripDB = (from trip in db.Trips where trip.id == tripTO.id select trip).FirstOrDefault(); tripDB.name = tripTO.name; tripDB.notes = tripTO.notes; tripDB.startDate = parseDateTimeExactFromString(tripTO.startDate); tripDB.endDate = parseDateTimeExactFromString(tripTO.endDate); db.SaveChanges(); } }
public void Delete(int id) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips where trip.id == id select trip).FirstOrDefault(); if (query != null) { db.Trips.Attach(query); db.Trips.Remove(query); db.SaveChanges(); } } }
public void Delete(int id) { using (var db = new Fish360Project.f360Entities()) { var query = (from fish in db.Fish where fish.id == id select fish).FirstOrDefault(); if (query != null) { db.Fish.Attach(query); db.Fish.Remove(query); db.SaveChanges(); } } }
public string DeleteFishForId(int fishId, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from fish in db.Fish where fish.id == fishId select fish).FirstOrDefault(); if (query == null) return null; db.Fish.Attach(query); db.Fish.Remove(query); db.SaveChanges(); } return null; }
public string CreateTrip(TripTO tripTO, string token) { using (var db = new Fish360Project.f360Entities()) { UserTO userTO = FindUserForToken(token); Trips newTrip = new Trips(); newTrip.name = tripTO.name; newTrip.startDate = DateTime.ParseExact(tripTO.startDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.endDate = DateTime.ParseExact(tripTO.endDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.userId = userTO.id; db.Trips.Add(newTrip); 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.caughtDate = DateTime.ParseExact(fishTO.caughtDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); fishDB.tripId = fishTO.tripId; db.Fish.Add(fishDB); db.SaveChanges(); } return null; }
public string CreateTrip(TripTO tripTO, string token) { using (var db = new Fish360Project.f360Entities()) { UserTO userTO = FindUserForToken(token); Trips newTrip = new Trips(); newTrip.name = tripTO.name; newTrip.notes = tripTO.notes; newTrip.startDate = DateTime.ParseExact(tripTO.startDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.endDate = DateTime.ParseExact(tripTO.endDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.userId = userTO.id; db.Trips.Add(newTrip); 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 string DeleteFishForId(int fishId, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from fish in db.Fish where fish.id == fishId select fish).FirstOrDefault(); if (query == null) { return(null); } db.Fish.Attach(query); db.Fish.Remove(query); db.SaveChanges(); } return(null); }
public UserTO FindUserForToken(string token) { using (var db = new Fish360Project.f360Entities()) { Guid guid = new Guid(token); var users = (from u in db.Users where u.token == guid select u).FirstOrDefault(); if (users != null) { UserTO user = new UserTO(); user.username = users.username; user.password = users.password; user.id = users.id; user.token = users.token.ToString(); return(user); } } return(null); }
public UserTO FindUserForToken(string token) { using (var db = new Fish360Project.f360Entities()) { Guid guid = new Guid(token); var users = (from u in db.Users where u.token == guid select u).FirstOrDefault(); if (users != null) { UserTO user = new UserTO(); user.username = users.username; user.password = users.password; user.id = users.id; user.token = users.token.ToString(); return user; } } return null; }
public string ValidateUsername(UserTO user) { using (var db = new Fish360Project.f360Entities()) { var users = (from t in db.Users where t.username == user.username select t).FirstOrDefault(); if (users == null) { return("username does not exist"); } user.id = users.id; user.token = users.token.ToString(); if (users == null) { return("username does not exist"); } } return("username exists"); }
public UserTO Login(string username, string password) { using (var db = new Fish360Project.f360Entities()) { var usr = (from user in db.Users where user.username == username && user.password == password select user).FirstOrDefault(); if (usr == null) return null; UserTO newUserTO = new UserTO(); newUserTO.id = usr.id; newUserTO.username = usr.username; newUserTO.password = usr.password; newUserTO.token = usr.token.ToString(); return newUserTO; } }
public string DeleteTripForId(int id, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == id select trip).FirstOrDefault(); if (query == null) return null; db.Trips.Attach(query); db.Trips.Remove(query); db.SaveChanges(); } return null; }
public void GetAllTripsJsonp(string callback) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips select trip); List <TripTO> trips = new List <TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; trip.notes = t.notes; if (t.startDate != null) { trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd"); } if (t.endDate != null) { trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd"); } trips.Add(trip); } JavaScriptSerializer serializer = new JavaScriptSerializer(); StringBuilder sb = new StringBuilder(); sb.Append(callback + "("); sb.Append(serializer.Serialize(trips)); // indentation is just for ease of reading while testing sb.Append(");"); Context.Response.Clear(); Context.Response.ContentType = "text/javascript";// "application/json"; Context.Response.Write(sb.ToString()); Context.Response.End(); } }
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 UserTO Login(string username, string password) { using (var db = new Fish360Project.f360Entities()) { var usr = (from user in db.Users where user.username == username && user.password == password select user).FirstOrDefault(); if (usr == null) { return(null); } UserTO newUserTO = new UserTO(); newUserTO.id = usr.id; newUserTO.username = usr.username; newUserTO.password = usr.password; newUserTO.token = usr.token.ToString(); return(newUserTO); } }
public string DeleteTripForId(int id, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == id select trip).FirstOrDefault(); if (query == null) { return(null); } db.Trips.Attach(query); db.Trips.Remove(query); db.SaveChanges(); } return(null); }
public string LoginUser(UserTO user) { string validation = ValidateUser(user); Guid guid; if (validation == "user validated") { using (var db = new Fish360Project.f360Entities()) { var users = (from t in db.Users where t.username == user.username && t.password == user.password select t).FirstOrDefault(); guid = Guid.NewGuid(); users.token = guid; db.SaveChanges(); } return guid.ToString(); } return "unable to login"; }
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<TripTO> GetAllTrips() { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips select trip); List<TripTO> trips = new List<TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; // trip.notes = t.notes; if (t.startDate != null) trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd"); if (t.endDate != null) trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd"); trips.Add(trip); } return trips; } }
public TripTO GetTripForId(int id) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips where trip.id == id select trip).FirstOrDefault(); if (query == null) { return(null); } TripTO tripTO = new TripTO(); tripTO.id = query.id; tripTO.name = query.name; tripTO.notes = query.notes; tripTO.startDate = ((DateTime)query.startDate).ToString("yyyy-MM-dd HH:mm:ss tt"); tripTO.endDate = ((DateTime)query.endDate).ToString("yyyy-MM-dd HH:mm:ss tt"); return(tripTO); } }
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 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 string LoginUser(UserTO user) { string validation = ValidateUser(user); Guid guid; if (validation == "user validated") { using (var db = new Fish360Project.f360Entities()) { var users = (from t in db.Users where t.username == user.username && t.password == user.password select t).FirstOrDefault(); guid = Guid.NewGuid(); users.token = guid; db.SaveChanges(); } return(guid.ToString()); } return("unable to login"); }
public string UpdateTrip(TripTO tripTO, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var tripDB = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == tripTO.id select trip).FirstOrDefault(); if (tripDB == null) return null; tripDB.name = tripTO.name; tripDB.notes = tripTO.notes; tripDB.startDate = parseDateTimeExactFromString(tripTO.startDate); tripDB.endDate = parseDateTimeExactFromString(tripTO.endDate); db.SaveChanges(); } return tripTO.name; }
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 void Post([FromBody]TripTO tripTO) { using (var db = new Fish360Project.f360Entities()) { Trips newTrip = new Trips(); newTrip.name = tripTO.name; newTrip.startDate = DateTime.ParseExact(tripTO.startDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.endDate = DateTime.ParseExact(tripTO.endDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newTrip.userId = tripTO.userId; db.Trips.Add(newTrip); db.SaveChanges(); } }
public string ValidateUser(UserTO user) { using (var db = new Fish360Project.f360Entities()) { var users = (from t in db.Users where t.username == user.username && t.password == user.password select t).FirstOrDefault(); if (users == null) return "unknown user"; if (users.token != null) user.token = users.token.ToString(); else user.token = null; user.id = users.id; } return "user validated"; }
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.id = fishTO.id; fishDB.weight = fishTO.weight; fishDB.length = fishTO.length; fishDB.tripId = fishTO.tripId; fishDB.species = fishTO.species; fishDB.caughtDate = parseDateTimeExactFromString(fishTO.caughtDate); db.SaveChanges(); } }
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.caughtDate = DateTime.ParseExact(fishTO.caughtDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); newFish.tripId = (int)fishTO.tripId; db.Fish.Add(newFish); db.SaveChanges(); } }
public TripTO GetTripForId(int id) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips where trip.id == id select trip).FirstOrDefault(); if (query == null) return null; TripTO tripTO = new TripTO(); tripTO.id = query.id; tripTO.name = query.name; tripTO.startDate = ((DateTime)query.startDate).ToString("yyyy-MM-dd"); tripTO.endDate = ((DateTime)query.endDate).ToString("yyyy-MM-dd"); return tripTO; } }
public void Put([FromBody]TripTO tripTO) { using (var db = new Fish360Project.f360Entities()) { var tripDB = (from trip in db.Trips where trip.id == tripTO.id select trip).FirstOrDefault(); tripDB.name = tripTO.name; tripDB.startDate = parseDateTimeExactFromString(tripTO.startDate); tripDB.endDate = parseDateTimeExactFromString(tripTO.endDate); db.SaveChanges(); } }
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 void GetAllTripsJsonp(string callback) { using (var db = new Fish360Project.f360Entities()) { var query = (from trip in db.Trips select trip); List<TripTO> trips = new List<TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; trip.notes = t.notes; if (t.startDate != null) trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd"); if (t.endDate != null) trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd"); trips.Add(trip); } JavaScriptSerializer serializer = new JavaScriptSerializer(); StringBuilder sb = new StringBuilder(); sb.Append(callback + "("); sb.Append(serializer.Serialize(trips)); // indentation is just for ease of reading while testing sb.Append(");"); Context.Response.Clear(); Context.Response.ContentType = "text/javascript";// "application/json"; Context.Response.Write(sb.ToString()); Context.Response.End(); } }
public List<TripTO> GetAllTrips(UserTO userTO) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(userTO.token); var query = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid select trip); List<TripTO> trips = new List<TripTO>(); foreach (var t in query) { TripTO trip = new TripTO(); trip.id = t.id; trip.name = t.name; trip.notes = t.notes; if (t.startDate != null) trip.startDate = ((DateTime)t.startDate).ToString("yyyy-MM-dd"); if (t.endDate != null) trip.endDate = ((DateTime)t.endDate).ToString("yyyy-MM-dd"); trips.Add(trip); } return trips; } }
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 TripTO GetTripForId(int id, string token) { using (var db = new Fish360Project.f360Entities()) { var guid = new Guid(token); var query = (from trip in db.Trips join user in db.Users on trip.userId.Value equals user.id where user.token == guid && trip.id == id select trip).FirstOrDefault(); if (query == null) return null; TripTO tripTO = new TripTO(); tripTO.id = query.id; tripTO.name = query.name; tripTO.notes = query.notes; tripTO.startDate = ((DateTime)query.startDate).ToString("yyyy-MM-dd"); tripTO.endDate = ((DateTime)query.endDate).ToString("yyyy-MM-dd"); return tripTO; } }