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