public static bool UpdateUserAddress(string username, string updatedAddress) { using (var db = new Model.PoolioEntities()) { var user = db.Users.Where(u => u.Username == username).FirstOrDefault(); user.Address = updatedAddress; return(db.SaveChanges() > 0); } }
public static void CreateUser(string username) { using (var db = new Model.PoolioEntities()) { db.Users.Add(new Model.User() { Username = username }); db.SaveChanges(); } }
public static void BecomeDriver(string username) { using (var db = new Model.PoolioEntities()) { var userId = db.Users.Where(u => u.Username == username).FirstOrDefault().Id; db.Drivers.Add(new Model.Driver() { UserId = userId }); db.SaveChanges(); } }
public static bool UpdateUserAddress(string username, string updatedAddress) { using (var db = new Model.PoolioEntities()) { var user = db.Users.Where(u => u.Username == username).FirstOrDefault(); var latLong = GmapController.GetCoordinates(updatedAddress); user.Address = updatedAddress; user.Latitude = (float)latLong.Item1; user.Longitude = (float)latLong.Item2; return(db.SaveChanges() > 0 && true); } }