/// <summary> /// 依行動電話號碼查使用者 /// </summary> /// <param name="PhoneNumber"></param> /// <returns></returns> public AspNetUsers QueryUsersByPhoneNumber(string PhoneNumber) { using (var _db = new BarrierFreeTMSEntities()) { return(_db.AspNetUsers.FirstOrDefault(x => x.PhoneNumber == PhoneNumber)); } }
/// <summary> /// 依照KeyNumber 取得MobilePushKey /// </summary> /// <param name="KeyNumber"></param> /// <param name="UserID"></param> /// <returns></returns> public MobilePushKey GetByParam(string KeyNumber, string UserID) { using (var _db = new BarrierFreeTMSEntities()) { return(_db.MobilePushKey.FirstOrDefault(x => x.KeyNumber == KeyNumber && x.UserId == UserID)); } }
/// <summary> /// 清理 KeyNumber /// </summary> /// <param name="KeyNumber"></param> public void CleanKeyNumber(string KeyNumber) { using (var _db = new BarrierFreeTMSEntities()) { var query = _db.MobilePushKey.Where(x => x.KeyNumber == KeyNumber); if (query.Any()) { var existKeyNumberList = query.ToList(); foreach (var existKeyNumber in existKeyNumberList) { existKeyNumber.KeyNumber = " "; existKeyNumber.MobileType = null; } _db.SaveChanges(); } } }
/// <summary> /// 新增或更新MobilePushKey /// </summary> /// <param name="UserID"></param> /// <param name="KeyNumber"></param> /// <param name="MobileType"></param> /// <returns></returns> public MessageResultViewModel CreateOrUpdate(string UserID, string KeyNumber, int MobileType) { MessageResultViewModel resultViewModel = new MessageResultViewModel(); using (var _db = new BarrierFreeTMSEntities()) { try { var query = _db.MobilePushKey.Where(x => x.UserId == UserID); if (!query.Any()) { var actionItem = new MobilePushKey { KeyNumber = KeyNumber, UserId = UserID, MobileType = MobileType, InsTime = DateTime.Now }; _db.MobilePushKey.Add(actionItem); resultViewModel.Result = true; resultViewModel.Message = "Create MobilePushKey:" + KeyNumber + "success!"; } else { MobilePushKey actionItem = new MobilePushKey(); actionItem.KeyNumber = KeyNumber; actionItem.MobileType = MobileType; actionItem.updTime = DateTime.Now; resultViewModel.Result = true; resultViewModel.Message = "Update MobilePushKey:" + KeyNumber + "success!"; } _db.SaveChanges(); } catch (Exception ex) { resultViewModel.Message = ex.ToString(); resultViewModel.Result = false; } } return(resultViewModel); }
public AspNetUsersService() { this._db = new BarrierFreeTMSEntities(); }
public PutTripService() { this._db = new BarrierFreeTMSEntities(); _aspNetUsersService = new AspNetUsersService(); _usersService = new UsersService(); }
public BookingService() { this._passengerDb = new BarrierFreePassengerEntities(); this._TMSDb = new BarrierFreeTMSEntities(); }
public MobilePushKeyService() { this._db = new BarrierFreeTMSEntities(); }