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