/// <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();
}
