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 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 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 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 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 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 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.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 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.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 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 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 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 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 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 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 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 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 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 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 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 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 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(); } }