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 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 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;
}
}
