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