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 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 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 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 <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 List <TripTO> GetTrip()
{
TripTO trip = new TripTO();
trip.name = "Canada";
trip.startDate = "last week";
trip.endDate = "monday";
trip.id = 123;
trip.userId = 234;
List <TripTO> trips = new List <TripTO>();
trips.Add(trip);
return(trips);
}
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 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 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 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()
{
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 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 GetTripName(TripTO trip)
{
return trip.name;
}
public List<TripTO> GetTrip()
{
TripTO trip = new TripTO();
trip.name = "Canada";
trip.startDate = "last week";
trip.endDate = "monday";
trip.id = 123;
trip.userId = 234;
List<TripTO> trips = new List<TripTO>();
trips.Add(trip);
return trips;
}
public String GetTripName(TripTO trip)
{
return(trip.name);
}
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 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 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 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;
}
}
