public static void AtendeCarona(User usr, Ride rd) { using (elmatEntities entities = new elmatEntities()) { var ride = (from R in entities.RIDE.Where(x => x.RideID == rd.RideID) select R).FirstOrDefault(); ride.DriverID = usr.UserID; entities.SaveChanges(); } }
public static void DeleteRoutine(User usr, Routine rtn) { using (elmatEntities entities = new elmatEntities()) { var qryRoutines = (from R in entities.ROUTINE where R.UserID == usr.UserID && R.RoutineID == rtn.RoutineID select R).FirstOrDefault(); entities.ROUTINE.Remove(qryRoutines); entities.SaveChanges(); } }
public static Ride CadastraRide(Ride r) { using (elmatEntities entities = new elmatEntities()) { RIDE R = RideToRIDE(r); try { entities.RIDE.Add(R); entities.SaveChanges(); r.RideID = R.RideID; return r; } catch (Exception e) { throw e; } } }
public static void BlockFriend(User usr, User friend, bool isBlocked) { using (elmatEntities entities = new elmatEntities()) { FRIENDS F = (from f in entities.FRIENDS. Where(x => (x.UserID_A == usr.UserID && x.UserID_B == friend.UserID) || (x.UserID_B == usr.UserID && x.UserID_A == friend.UserID)) select f).FirstOrDefault(); if (isBlocked) { F.StatusID = 2; } else { F.StatusID = 1; } entities.SaveChanges(); } }
public static Routine RegisterRoutine(User usr, Routine rtn) { using (elmatEntities entities = new elmatEntities()) { ROUTINE R = new ROUTINE(); R.UserID = usr.UserID; R.Title = rtn.Title; R.Mon = rtn.Mon; R.Tue = rtn.Tue; R.Wed = rtn.Wed; R.Thu = rtn.Thu; R.Fri = rtn.Fri; R.Sat = rtn.Sat; R.Sun = rtn.Sun; R.Hour = rtn.Hour; R.Lat = rtn.Latitude; R.Lon = rtn.Longitude; entities.ROUTINE.Add(R); entities.SaveChanges(); rtn.UserID = R.UserID; rtn.RoutineID = R.RoutineID; return rtn; } }
public static void UpdateRoutine(Routine rtn, User usr) { using (elmatEntities entities = new elmatEntities()) { var qryRoutines = (from R in entities.ROUTINE where R.UserID == usr.UserID && R.RoutineID == rtn.RoutineID select R).FirstOrDefault(); qryRoutines.Title = rtn.Title; qryRoutines.Mon = rtn.Mon; qryRoutines.Tue = rtn.Tue; qryRoutines.Wed = rtn.Wed; qryRoutines.Thu = rtn.Thu; qryRoutines.Fri = rtn.Fri; qryRoutines.Sat = rtn.Sat; qryRoutines.Sun = rtn.Sun; qryRoutines.Hour = rtn.Hour; entities.SaveChanges(); } }
private static void AddFriends(List<User> FriendsToAdd, User usr) { using (elmatEntities entities = new elmatEntities()) { try { foreach (User fr in FriendsToAdd) { FRIENDS f = new FRIENDS(); f.UserID_A = usr.UserID; f.UserID_B = fr.UserID; f.StatusID = 1; entities.FRIENDS.Add(f); } entities.SaveChanges(); } catch (Exception e) { throw e; } } }
public static User RegisterUser( User FbUser ) { using (elmatEntities entities = new elmatEntities()) { USER U = new USER(); U.FacebookID = FbUser.FacebookID; U.Name = FbUser.Name; entities.USER.Add(U); entities.SaveChanges(); FbUser.UserID = U.UserID; return FbUser; } }