internal DataSet GetDeviceId(DeviceTokenBO deviceBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(deviceBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "ReadFromDeviceToken";
sqlHelper.AddParameter(command, "@userId", deviceBO.UserId, ParameterDirection.Input);
return(sqlHelper.ExecuteDataSet(command));
}
/*
* public Task<RegEntity> GetItems()
* {
* lock (locker)
* {
* return (from i in database.Table<RegEntity>() select i).ToListAsync();
* }
* }*/
public Task <int> InsertToken(DeviceTokenBO token)
{
lock (TokenLock)
{
database.DropTableAsync <DeviceTokenBO>();
database.CreateTableAsync <DeviceTokenBO>();
return(database.InsertAsync(token));
}
}
internal int UpdateDeviceToken(DeviceTokenBO deviceBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(deviceBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "InsertToDeviceToken";
sqlHelper.AddParameter(command, "@userId", deviceBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@deviceToken", deviceBO.DeviceId, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
}
